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:

Listserver problem (1997) WebCat2b12 - nesting [tags] (1997) problems with 2 tags shakur (1997) Forms Search Questions (1997) Tax Rates (1998) Domain-wide prefs... WAS Multiple transactions per cart (2000) MacFinder -- a new WebDNA web site (1998) [WebDNA] Ubuntu 14.04 & WebDNA (2017) FCKeditor (2008) # of real domains on 1 web server (1997) RE: format problem on NT? (1997) RE: IIS4b2 and WebCatalog b19 (1997) Summing fields (1997) [format 40s]text[/format] doesn't work (1997) Conversion Database Blues (2001) WebDNA vs PHP (2003) Erotic Sites (1997) Wireless WebDNA available today! (2000) Multiple Pulldowns (1997) WebCatalog Mac and cgi-bin (WebSTAR 2.0) (1997)