Re: Data Type Search Problem
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56006
interpreted = N
texte = No. [txtKeyword] is the textbox for the user's keywords. Then they press = the search button. After that, a data table is created with html and = populated by the search results. My actual search string is a lot longer = than this and acts just fine besides the end_date being of type date. = That is messing everything up because sometimes end_date is zero instead = of an actual date. I need a workaround for end_datetype=3Ddate. If end_date always contained = a date then it would work fine (I tried) but I need to account for end_= date being never. Thanks. Justin Carroll On Wednesday, March 31, 1943, Gary Krockover
= wrote: >Is [txtKeyword] always inputted from the user as a number? > >"&wsmy_heightdata=3D[txtKeyword]" and >"&my_heighttype=3Dnum" > >Should any of those fields be "required" as well, as in=20 >&wsmy_namedataRQ=3D[txtKeyword]? > >GK > > > > >At 12:51 PM 2/10/2004, you wrote: >>An example of my search would be this: >>[search=20 >>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=20 >>start_date works fine because it always has a true date in it (xx/xx/= xxxx)=20 >>but my end_date, like I said, sometimes contains a 0 so end_= datetype=3Ddate=20 >>messes the whole search up - makes it act strange by pulling every = record=20 >>for anything in [txtKeyword]. >> >>Maybe I shouldn't have a zero for no end date. Should it be blank? = Thanks. >> >>Justin Carroll > > >------------------------------------------------------------- >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:
No. [txtKeyword] is the textbox for the user's keywords. Then they press = the search button. After that, a data table is created with html and = populated by the search results. My actual search string is a lot longer = than this and acts just fine besides the end_date being of type date. = That is messing everything up because sometimes end_date is zero instead = of an actual date. I need a workaround for end_datetype=3Ddate. If end_date always contained = a date then it would work fine (I tried) but I need to account for end_= date being never. Thanks. Justin Carroll On Wednesday, March 31, 1943, Gary Krockover = wrote: >Is [txtKeyword] always inputted from the user as a number? > >"&wsmy_heightdata=3D[txtKeyword]" and >"&my_heighttype=3Dnum" > >Should any of those fields be "required" as well, as in=20 >&wsmy_namedataRQ=3D[txtKeyword]? > >GK > > > > >At 12:51 PM 2/10/2004, you wrote: >>An example of my search would be this: >>[search=20 >>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=20 >>start_date works fine because it always has a true date in it (xx/xx/= xxxx)=20 >>but my end_date, like I said, sometimes contains a 0 so end_= datetype=3Ddate=20 >>messes the whole search up - makes it act strange by pulling every = record=20 >>for anything in [txtKeyword]. >> >>Maybe I shouldn't have a zero for no end date. Should it be blank? = Thanks. >> >>Justin Carroll > > >------------------------------------------------------------- >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:
Database Helper (1998)
[WebDNA] Base 64 (2010)
Error -108 (1997)
Logging purchases (1997)
problems with 2 tags (1997)
WebCat2b13MacPlugIn - more [date] problems (1997)
RE: Forcing Paragraph Breaks on Results - Yes you can replace String for String! (1998)
price carry over (1997)
international time (1997)
make updates in a temporary database (2004)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
SSL/Document Contains NO Data (1998)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Date sorting (1997)
Is using [URL] recommended even on an email address? (1999)
Shopping cart problem (2003)
[WebDNA] Integrating with WP and PHP (2011)
Problems with ^ could be solved with [REPLACE CHARACTERS] (1997)
Need help (1998)
dates and hex formatting (1997)