Re: Data Type Search Problem
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56009
interpreted = N
texte = I'm sorry. In my example I didn't [url] them but I do have them urled in = the search. I'm not all that sure I communicated my problem well enough. I have a database of strings, integers, and dates. I want the user to be = able to search through all of this by typing in whatever word, number, or = special character they want into a textbox and pressing a search button. = Basically a typical search here. If the user types in "56" then it finds "56" wherever it can and displays = that record. My problem is that when the initial [search] is done on the keyword(s) the = end_datetype=3Ddate is jacking everything up because end_date in the = database, isn't always a date. Sometimes it's zero to represent that it = has no end date. And since they all aren't a date (xx/xx/xxxx) it = completely messes up the search and returns all records in the database by = default no matter what the user typed into the keyword textbox. Literally = the user could type "lkasflkjasf" and it will return every record in the = database. Justin Carroll On Wednesday, March 31, 1943, Donovan Brooke
wrote: >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=3Ddatabase.db&wsmy_namedata=3D[txtKeyword]&wsmy_heightdata=3D[= txtKeyword]&wsend_datedata=3D[txtKeyword]&my_heighttype=3Dnum&my_= heightsdir=3Dde&end_datetype=3Ddate&end_datesdir=3Dde] >>=20 >> 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=3Ddate messes the whole >search up - makes it act strange by pulling every record for anything in [= txtKeyword]. >>=20 >> Maybe I shouldn't have a zero for no end date. Should it be blank? = Thanks. >>=20 >> Justin Carroll >>=20 >> On Wednesday, March 31, 1943, Donovan Brooke wrote: >>=20 >>>Lets see your search... >>> >>>I'm guessing you need a: >>>FieldNameBLNK=3DT >>> >>>Donovan > > >--=20 > = =3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3D= o=3Do=3Do=3Do=3Do=3Do=3Do > 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 > =3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3D= o=3Do=3Do=3Do=3Do=3Do=3Do=3Do > > >------------------------------------------------------------- >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/ > ------------------------------------------------------------- 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:
I'm sorry. In my example I didn't [url] them but I do have them urled in = the search. I'm not all that sure I communicated my problem well enough. I have a database of strings, integers, and dates. I want the user to be = able to search through all of this by typing in whatever word, number, or = special character they want into a textbox and pressing a search button. = Basically a typical search here. If the user types in "56" then it finds "56" wherever it can and displays = that record. My problem is that when the initial [search] is done on the keyword(s) the = end_datetype=3Ddate is jacking everything up because end_date in the = database, isn't always a date. Sometimes it's zero to represent that it = has no end date. And since they all aren't a date (xx/xx/xxxx) it = completely messes up the search and returns all records in the database by = default no matter what the user typed into the keyword textbox. Literally = the user could type "lkasflkjasf" and it will return every record in the = database. Justin Carroll On Wednesday, March 31, 1943, Donovan Brooke wrote: >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=3Ddatabase.db&wsmy_namedata=3D[txtKeyword]&wsmy_heightdata=3D[= txtKeyword]&wsend_datedata=3D[txtKeyword]&my_heighttype=3Dnum&my_= heightsdir=3Dde&end_datetype=3Ddate&end_datesdir=3Dde] >>=20 >> 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=3Ddate messes the whole >search up - makes it act strange by pulling every record for anything in [= txtKeyword]. >>=20 >> Maybe I shouldn't have a zero for no end date. Should it be blank? = Thanks. >>=20 >> Justin Carroll >>=20 >> On Wednesday, March 31, 1943, Donovan Brooke wrote: >>=20 >>>Lets see your search... >>> >>>I'm guessing you need a: >>>FieldNameBLNK=3DT >>> >>>Donovan > > >--=20 > = =3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3D= o=3Do=3Do=3Do=3Do=3Do=3Do > 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 > =3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3D= o=3Do=3Do=3Do=3Do=3Do=3Do=3Do > > >------------------------------------------------------------- >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/ > ------------------------------------------------------------- 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/
Justin Carroll
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:
Trouble with formula.db (1997)
Shell traceroute (2001)
Search design (1997)
latest version? (1998)
Random/Odd/Even Listings (2005)
WebCat vs. ASP (1999)
[WebDNA] read database from other domain (2015)
[math] show=F exists? (1997)
No luck with taxes (1997)
Erotic Sites (1997)
Count how many items in a summ total (2003)
One more time (1997)
Whats going on with my SERIAL NUMBER??? (1998)
RAM problems, [appendfile] problems (1998)
Deleting Orders (1997)
I'm new be kind (1997)
international time (1997)
Windows 95/NT tip of the month (1998)
Emailer again (1997)
WebMerchant 1.6 and https (1997)