Re: why won't this work, please tell me???
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37410
interpreted = N
texte = okay so it had nothing to do with reserved words, it still won't work.Why is it so hard to do something so simple all i want to do is geteverything from the database from between two dates.< 2002 and > 2000 how hard could it be.the date format is correct and the data passed in the query is correct, whatam i missing???query:[search db=/db/tracking.db&neMWEB_IDdatarq=underfined[showif [f_use_date]=usedate]&geTHE_DATEdatarq=[v_datefrom]&leTHE_DATEdatarq=[v_dateto]&THE_DATEtype=date[/showif]][numfound][/search]on screen results:search db=/db/tracking.db&neMWEB_IDdatarq=underfined&geTHE_DATEdatarq=01/01/2001&leTHE_DATEdatarq=01/01/2005&THE_DATEtype=datenumfound = 0database contains:203.109.252.015 14:07:57 26/07/2001 nz 9014210.086.000.199 14:11:05 26/07/2001 nz 9014064.012.102.046 13:58:29 26/07/2001 nz 9007024.129.108.084 14:06:06 26/07/2001 nz 9007210.086.000.199 14:12:05 26/07/2001 nz 9014203.109.230.026 13:52:03 26/07/2001 nz 9016210.086.000.199 14:10:41 26/07/2001 nz 9014203.109.230.026 13:51:59 26/07/2001 nz 9002210.086.000.199 14:11:41 26/07/2001 nz 9014199.174.164.161 13:58:49 26/07/2001 nz 9007203.109.230.026 13:51:56 26/07/2001 nz 9019024.163.205.048 14:13:34 26/07/2001 nz 9007203.109.230.026 13:52:00 26/07/2001 nz 9001063.173.234.125 14:04:45 26/07/2001 nz 9007063.205.185.125 14:25:15 26/07/2001 nz 9007somebody help...on 26/7/01 1:43 PM, Brian Boegershausen at brian@orderbywire.com wrote:> Try moving your &s around like this. Also, what OS are you usnig... I seem> to remember a problem with setting / as a way to go to the root on one> version.> Maybe try ../../ to get back to the root.> > [search db=/db/tracking.db[showif> [f_max_simple]!NA]&max=[f_max_simple][/showif][showif> [f_country]!ALL]&eqCOUNTRYdatarq=[f_country][/showif][showif> [f_use_date]=usedate]&geDATEdatarq=[v_datefrom]&leDATEdatarq=[v_dateto]&DATE> type=date[/showif]&neMWEB_IDdatarq=underfined]> > Brian> ----- Original Message -----> From: Andrew Simpson
> To: WebCatalog Talk > Sent: Wednesday, July 25, 2001 9:06 PM> Subject: why won't this work, please tell me???> > >> [search db=/db/tracking.db&[showif>> [f_max_simple]!NA]max=[f_max_simple]&[/showif][showif>> [f_country]!ALL]eqCOUNTRYdatarq=[f_country]&[/showif][showif>> > [f_use_date]=usedate]geDATEdatarq=[v_datefrom]&leDATEdatarq=[v_dateto]&DATEt>> ype=date&[/showif]neMWEB_IDdatarq=underfined]>> >> the date part is the problem, when i tell it to use the dates as>> comparisions nothing turns up...any idea's??>> >> >> ------------------------------------------------------------->> 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://search.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://search.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
|
- Re: why won't this work, please tell me??? (Anup Setty 2001)
- Re: why won't this work, please tell me??? (Kenneth Grome 2001)
- Re: why won't this work, please tell me??? (Sam Lewis 2001)
- Re: why won't this work, please tell me??? (Andrew Simpson 2001)
- Re: why won't this work, please tell me??? (Sam Lewis 2001)
- Re: why won't this work, please tell me??? (Andrew Simpson 2001)
- Re: why won't this work, please tell me??? (Gary J. Krockover 2001)
- Re: why won't this work, please tell me??? (Andrew Simpson 2001)
- Re: why won't this work, please tell me??? (Andrew Simpson 2001)
- Re: why won't this work, please tell me??? (Brian Boegershausen 2001)
- why won't this work, please tell me??? (Andrew Simpson 2001)
|
okay so it had nothing to do with reserved words, it still won't work.Why is it so hard to do something so simple all i want to do is geteverything from the database from between two dates.< 2002 and > 2000 how hard could it be.the date format is correct and the data passed in the query is correct, whatam i missing???query:[search db=/db/tracking.db&neMWEB_IDdatarq=underfined[showif [f_use_date]=usedate]&geTHE_DATEdatarq=[v_datefrom]&leTHE_DATEdatarq=[v_dateto]&THE_DATEtype=date[/showif]][numfound][/search]on screen results:search db=/db/tracking.db&neMWEB_IDdatarq=underfined&geTHE_DATEdatarq=01/01/2001&leTHE_DATEdatarq=01/01/2005&THE_DATEtype=datenumfound = 0database contains:203.109.252.015 14:07:57 26/07/2001 nz 9014210.086.000.199 14:11:05 26/07/2001 nz 9014064.012.102.046 13:58:29 26/07/2001 nz 9007024.129.108.084 14:06:06 26/07/2001 nz 9007210.086.000.199 14:12:05 26/07/2001 nz 9014203.109.230.026 13:52:03 26/07/2001 nz 9016210.086.000.199 14:10:41 26/07/2001 nz 9014203.109.230.026 13:51:59 26/07/2001 nz 9002210.086.000.199 14:11:41 26/07/2001 nz 9014199.174.164.161 13:58:49 26/07/2001 nz 9007203.109.230.026 13:51:56 26/07/2001 nz 9019024.163.205.048 14:13:34 26/07/2001 nz 9007203.109.230.026 13:52:00 26/07/2001 nz 9001063.173.234.125 14:04:45 26/07/2001 nz 9007063.205.185.125 14:25:15 26/07/2001 nz 9007somebody help...on 26/7/01 1:43 PM, Brian Boegershausen at brian@orderbywire.com wrote:> Try moving your &s around like this. Also, what OS are you usnig... I seem> to remember a problem with setting / as a way to go to the root on one> version.> Maybe try ../../ to get back to the root.> > [search db=/db/tracking.db[showif> [f_max_simple]!NA]&max=[f_max_simple][/showif][showif> [f_country]!ALL]&eqCOUNTRYdatarq=[f_country][/showif][showif> [f_use_date]=usedate]&geDATEdatarq=[v_datefrom]&leDATEdatarq=[v_dateto]&DATE> type=date[/showif]&neMWEB_IDdatarq=underfined]> > Brian> ----- Original Message -----> From: Andrew Simpson > To: WebCatalog Talk > Sent: Wednesday, July 25, 2001 9:06 PM> Subject: why won't this work, please tell me???> > >> [search db=/db/tracking.db&[showif>> [f_max_simple]!NA]max=[f_max_simple]&[/showif][showif>> [f_country]!ALL]eqCOUNTRYdatarq=[f_country]&[/showif][showif>> > [f_use_date]=usedate]geDATEdatarq=[v_datefrom]&leDATEdatarq=[v_dateto]&DATEt>> ype=date&[/showif]neMWEB_IDdatarq=underfined]>> >> the date part is the problem, when i tell it to use the dates as>> comparisions nothing turns up...any idea's??>> >> >> ------------------------------------------------------------->> 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://search.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://search.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://search.smithmicro.com/
Andrew Simpson
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:
WebCatalog NT beta 18 problem (1997)
Help with Shipping Costs (1997)
WebCat2b12 - nesting [tags] (1997)
Quotes inside alt tags (2008)
OFF TOPIC: Sendmail problem (2003)
Modifying order output (1997)
Mac System Experience (1998)
Requiring that certain fields be completed (1997)
SV: Mass Mail (2000)
Download Question (1997)
WebMerchant -- Sweeping WebDelivery < 24 hrs (2000)
OFF-TOPIC: For Gary Krockover ... (2003)
form crasehes server (1997)
Just a thought (1998)
Keyword search (2004)
Integration with SQL (1997)
WC2.0 Memory Requirements (1997)
Re:quit command on NT (1997)
encryption madness (2003)
WCS Newbie question (1997)