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:

Moment of Thanks (1997) RE: Tax and ShipCost Problem (1997) Plugin or CGI or both (1997) WebCat2b15MacPlugin - showing [math] (1997) Word-And searches (2000) Installing WebCat under Linux Q (2000) Thanks and new Question on lineitems (2002) [WebDNA] Conditional search (2009) refreshing IE with posted .tmpl (1997) Mac v. NT (1998) Error 11 (1996) Keep away (1997) Sense/Disallow HTML tags during $Append (1997) wc 2 pro users - sites, quotes wanted (1997) categories and subcategories (2004) webdelivery.html and webna (1997) Location of Webcat site in folder hierarchy (1997) carriage returns in data (1997) Have no fear of WebCatalog Builder..... (2000) Dashes and dots in credit card (1998)