Re: Data Type Search Problem
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56003
interpreted = N
texte = 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] 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]. 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=3DT > >Donovan > > > >Justin Carroll wrote: > >> I have a database with an end_date header. This contains >either an actual end date (ie. 03/14/2004) or a 0 for no ending date. >>=20 >> My problem is that when doing a search on the field I use >end_datetype=3Ddate. This ruins the search by pulling every >record of the database when searching for any keyword (ie. lakflsjdfkd - = pulls all records). >>=20 >> I need to have end_datetype=3Ddate in there because the data >table in my html page has clickable headers to sort the database. >>=20 >> Does anyone have any suggestions as to how I can work around this? = Thanks. >>=20 >> Justin Carroll > > >--=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=3Do=3D= o=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:
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] 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]. 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=3DT > >Donovan > > > >Justin Carroll wrote: > >> I have a database with an end_date header. This contains >either an actual end date (ie. 03/14/2004) or a 0 for no ending date. >>=20 >> My problem is that when doing a search on the field I use >end_datetype=3Ddate. This ruins the search by pulling every >record of the database when searching for any keyword (ie. lakflsjdfkd - = pulls all records). >>=20 >> I need to have end_datetype=3Ddate in there because the data >table in my html page has clickable headers to sort the database. >>=20 >> Does anyone have any suggestions as to how I can work around this? = Thanks. >>=20 >> Justin Carroll > > >--=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=3Do=3D= o=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:
Remove from list server (1997)
Paths (1998)
F3 crashing server (1997)
Folder modify times (2003)
Forbidden CGI Error (1997)
OT : Site speed feedback (2002)
WebMerchant crashing and other WebMerchant problem (2000)
Emailer setup (1997)
I'm tired of all this! (2000)
WebCat2b15MacPlugin - [protect] (1997)
shipcost (1997)
Problems problems problems (1997)
emailer (1997)
RE: Fishing: anyone on this group willing to do support? (1998)
Re:no [search] with NT (1997)
2.01 upgrade problems (1997)
db access problem after switching to SSL (2001)
Stat analyzer (1997)
Emailer setup (1997)
Database Options (1997)