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:
Text vs. Math (2000)
forms and variables (1998)
WebCatalog and WebMerchant reviewed by InfoWorld (1997)
formatting a number (1999)
[WebDNA] exclusivelock (2011)
[WebDNA] A universal version of WebDNA ... (2008)
Separate SSL Server (1997)
GoLive CyberStudio 1.0.1 (1997)
Nested [tags] (2001)
Error 551 in Emailer (2000)
WC Database Format (1997)
Help with Shipping Costs (1997)
Where is f2? (1997)
syntax question, not in online refernce (1997)
Showif with an or (2003)
linetiems in thankyou.tpl (1997)
Sendmail (1999)
Re:WebCatalog f2 Installation (1997)
[sendmail] v. [writefile] (2000)
New Site Announcement (1998)