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 the date is not valid. Donovan Justin 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:

    
  1. Re: Data Type Search Problem ( Justin Carroll 2004)
  2. Re: Data Type Search Problem ( Glenn Busbin 2004)
  3. Re: Data Type Search Problem ( Justin Carroll 2004)
  4. Re: Data Type Search Problem ( Donovan Brooke 2004)
  5. Re: Data Type Search Problem ( Justin Carroll 2004)
  6. Re: Data Type Search Problem ( Gary Krockover 2004)
  7. Re: Data Type Search Problem ( Justin Carroll 2004)
  8. Re: Data Type Search Problem ( Donovan Brooke 2004)
  9. Re: Data Type Search Problem ( Donovan Brooke 2004)
  10. Data Type Search Problem ( Justin Carroll 2004)
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 the date is not valid. Donovan Justin 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)