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:
Frames and WebCat (1997)
Re:Searching for ALL / empty form field *the FINAL answer* (1997)
[WebDNA] Fresh Snow Leopard install (2009)
Credit Card Checking?? (1998)
Search in 2 or more catalogs (1997)
Sandbox DB permissions (2005)
Setting up shop (1997)
Parameter Passing Value (2002)
Toronto area? (1999)
Re1000001: Setting up shop (1997)
FW: Shipping calculations (1997)
I need Typhoon Pro Tonight! (1999)
File Upload (1997)
Possible Bug in 2.0b15.acgi (1997)
user flush db (2002)
WebCatalog2 Feature Feedback (1996)
Showing unopened cart (1997)
OH CRAP!!!!!- Template not found error!!! (1999)
emailer w/F2 (1997)
Test ... (2003)