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:

[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)