Re: database search help

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 51040
interpreted = N
texte = thanks all, works now. Don, that is good point of the date name. I changed.thank you!----- Original Message ----- From: Donovan home EHG To: WebDNA Talk Sent: Tuesday, June 10, 2003 7:51 PM Subject: Re: database search help > WebDNA has 3 types of data num text and date. In a search you have > to define them to get appropriate results. > > &Datetype=date > > However, I don't think it is a good Idea to have a field name named > date as it is a reserved word in WebDNA. I would rename the field > to theDATE or something and call it by that. > > HTH, > Donovan > > > > Li Yang wrote: > > > hi, > > > > I need search from a database Orders.db which contence Name, Date, so on. I > > want to display all records which the Date after a perior as 12/2/02, but > > after i did this below, it display the date after 12/2/02 and the year of > > 2001's, also did not show the next years record because the month is smaller > > than 12. > > > > [search db=Orders.db&grDatedata=12/02/2002 &Datesort=1] > > > > any help? thanks!!!!!! > > > > Li > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: database search help (Li Yang 2003)
  2. Re: database search help (Donovan home EHG 2003)
  3. Re: database search help (Andrew Simpson 2003)
  4. database search help (Li Yang 2003)
thanks all, works now. Don, that is good point of the date name. I changed.thank you!----- Original Message ----- From: Donovan home EHG To: WebDNA Talk Sent: Tuesday, June 10, 2003 7:51 PM Subject: Re: database search help > WebDNA has 3 types of data num text and date. In a search you have > to define them to get appropriate results. > > &Datetype=date > > However, I don't think it is a good Idea to have a field name named > date as it is a reserved word in WebDNA. I would rename the field > to theDATE or something and call it by that. > > HTH, > Donovan > > > > Li Yang wrote: > > > hi, > > > > I need search from a database Orders.db which contence Name, Date, so on. I > > want to display all records which the Date after a perior as 12/2/02, but > > after i did this below, it display the date after 12/2/02 and the year of > > 2001's, also did not show the next years record because the month is smaller > > than 12. > > > > [search db=Orders.db&grDatedata=12/02/2002 &Datesort=1] > > > > any help? thanks!!!!!! > > > > Li > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Li Yang

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Multiple fields on 1 input (1997) Installer AppleScript (2000) Number of Feilds Passed to [append] (2000) redirect with frames (1997) problems with 2 tags shakur (1997) Problem (1997) How to get shownext to just shownext once (1997) all records returned. (1997) [listfiles] (1998) Sendmail Woes (2002) forming a SKU (1999) Image maps/Webcat (1997) EIMS Problems (1997) ooops...WebCatalog [FoundItems] Problem - LONG - (1997) Major Security Hole (1998) Database Helper missing? (2000) Location of Browser Info.txt file (1997) CR's (2003) Quit revisited (1997) Funny Chars (1999)