Re: Data Type Search Problem
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56008
interpreted = N
texte = Hi Justin,couple of things.you always want to URL any values coming from a form input.I would do some checking for the right date format.You can hide the date format or direct the user back if thedate is not valid.DonovanJustin Carroll wrote:> An example of my search would be this:> [search db=database.db&wsmy_namedata=[txtKeyword]&wsmy_heightdata=[txtKeyword]&wsend_datedata=[txtKeyword]&my_heighttype=num&my_heightsdir=de&end_datetype=date&end_datesdir=de]> > I actually have two headers for a date, start_date and end_date. The start_date works fine because it always has a true date in it (xx/xx/xxxx) but my end_date, like I said, sometimes contains a 0 so end_datetype=date messes the whole search up - makes it act strange by pulling every record for anything in [txtKeyword].> > Maybe I shouldn't have a zero for no end date. Should it be blank? Thanks.> > Justin Carroll> > On Wednesday, March 31, 1943, Donovan Brooke
wrote:> >>Lets see your search...>>>>I'm guessing you need a:>>FieldNameBLNK=T>>>>Donovan-- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------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:
Hi Justin,couple of things.you always want to URL any values coming from a form input.I would do some checking for the right date format.You can hide the date format or direct the user back if thedate is not valid.DonovanJustin Carroll wrote:> An example of my search would be this:> [search db=database.db&wsmy_namedata=[txtKeyword]&wsmy_heightdata=[txtKeyword]&wsend_datedata=[txtKeyword]&my_heighttype=num&my_heightsdir=de&end_datetype=date&end_datesdir=de]> > I actually have two headers for a date, start_date and end_date. The start_date works fine because it always has a true date in it (xx/xx/xxxx) but my end_date, like I said, sometimes contains a 0 so end_datetype=date messes the whole search up - makes it act strange by pulling every record for anything in [txtKeyword].> > Maybe I shouldn't have a zero for no end date. Should it be blank? Thanks.> > Justin Carroll> > On Wednesday, March 31, 1943, Donovan Brooke wrote:> >>Lets see your search...>>>>I'm guessing you need a:>>FieldNameBLNK=T>>>>Donovan-- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------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/
Donovan Brooke
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:
[LOOKUP] (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Searching multiple Databases (1997)
PIXO support (1997)
Support ?? (1997)
Exclamation point (1997)
sorting by date (1999)
[group] ? (1997)
Configuring E-mail (1997)
[WebDNA] Error: Can't open order file. Ignoring [OrderFile] (2011)
Thanks ! (1997)
Pithy questions on webcommerce & siteedit (1997)
[SendMail] from a form? (1998)
Nesting FoundItem Context (1997)
[defined]ish (1997)
WCS Newbie question (1997)
fresh eyes needed. Append won't work. (2000)
Escape the Root! (2002)
[SQL] - COUNT, SUM retrieval (2000)
Pager notification of completed orders (1998)