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:

Paths, relative paths, webstar server setup and security (1997) email database file (2005) Emailer Question (1998) tpl pages in dreamweaver (2000) [subtotal] and others (1997) Weird Math and SV (1997) send mail problem? (1997) 404 error page issue (2006) Here's how to kill a Butler Database. (1997) [bug] Technical Support Log Crashes Server (2004) Listfiles (2004) using showpage and showcart commands (1996) suffix mapping for NT? (1997) Listfiles not listing mounted volume (2002) Offer from ClearWay: Accelerate WebCatalog With ClearWay NITROPowerPlug! (1999) won't [sendmail] inside of a [search] (2007) New Command prefs ... (1997) Progress !! WAS: Trouble with formula.db (1997) Limiting user access to .tmpl files (1997) RE: creating writefile data from a nested search (1997)