Re: why won't this work, please tell me???
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37421
interpreted = N
texte = With little changes to your code it will work fine,change all datarq to data and use groupfield forthe_date field when you are doing le [search db=/db/tracking.db&neMWEB_IDdata=underfined [showif [f_use_date]=usedate]&geTHE_DATEdata=[v_datefrom]&GROUPFIELD=THE_DATE&leGROUPFIELDdata=[v_dateto]&THE_DATEtype=date[/showif]][numfound][/search]the following is the actual code I used to test it and it worked fine.[search db=db/tracking.db&neMWEB_IDdata=underfined&geTHE_DATEdata=01/01/2001&GROUPFIELD=THE_DATE&leGROUPFIELDdata=01/01/2005&THE_DATEtype=date]Good luckAnup Setty----- Original Message -----From: Andrew Simpson
To: WebCatalog Talk Sent: Wednesday, July 25, 2001 10:28 PMSubject: Re: why won't this work, please tell me???> 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 get> everything 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,what> am 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&le> THE_DATEdatarq=01/01/2005&THE_DATEtype=date>> numfound = 0>> database contains:>> 203.109.252.015 14:07:57 26/07/2001 nz 9014> 210.086.000.199 14:11:05 26/07/2001 nz 9014> 064.012.102.046 13:58:29 26/07/2001 nz 9007> 024.129.108.084 14:06:06 26/07/2001 nz 9007> 210.086.000.199 14:12:05 26/07/2001 nz 9014> 203.109.230.026 13:52:03 26/07/2001 nz 9016> 210.086.000.199 14:10:41 26/07/2001 nz 9014> 203.109.230.026 13:51:59 26/07/2001 nz 9002> 210.086.000.199 14:11:41 26/07/2001 nz 9014> 199.174.164.161 13:58:49 26/07/2001 nz 9007> 203.109.230.026 13:51:56 26/07/2001 nz 9019> 024.163.205.048 14:13:34 26/07/2001 nz 9007> 203.109.230.026 13:52:00 26/07/2001 nz 9001> 063.173.234.125 14:04:45 26/07/2001 nz 9007> 063.205.185.125 14:25:15 26/07/2001 nz 9007>>> somebody 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... Iseem> > 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/-------------------------------------------------------------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)
|
With little changes to your code it will work fine,change all datarq to data and use groupfield forthe_date field when you are doing le [search db=/db/tracking.db&neMWEB_IDdata=underfined [showif [f_use_date]=usedate]&geTHE_DATEdata=[v_datefrom]&GROUPFIELD=THE_DATE&leGROUPFIELDdata=[v_dateto]&THE_DATEtype=date[/showif]][numfound][/search]the following is the actual code I used to test it and it worked fine.[search db=db/tracking.db&neMWEB_IDdata=underfined&geTHE_DATEdata=01/01/2001&GROUPFIELD=THE_DATE&leGROUPFIELDdata=01/01/2005&THE_DATEtype=date]Good luckAnup Setty----- Original Message -----From: Andrew Simpson To: WebCatalog Talk Sent: Wednesday, July 25, 2001 10:28 PMSubject: Re: why won't this work, please tell me???> 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 get> everything 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,what> am 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&le> THE_DATEdatarq=01/01/2005&THE_DATEtype=date>> numfound = 0>> database contains:>> 203.109.252.015 14:07:57 26/07/2001 nz 9014> 210.086.000.199 14:11:05 26/07/2001 nz 9014> 064.012.102.046 13:58:29 26/07/2001 nz 9007> 024.129.108.084 14:06:06 26/07/2001 nz 9007> 210.086.000.199 14:12:05 26/07/2001 nz 9014> 203.109.230.026 13:52:03 26/07/2001 nz 9016> 210.086.000.199 14:10:41 26/07/2001 nz 9014> 203.109.230.026 13:51:59 26/07/2001 nz 9002> 210.086.000.199 14:11:41 26/07/2001 nz 9014> 199.174.164.161 13:58:49 26/07/2001 nz 9007> 203.109.230.026 13:51:56 26/07/2001 nz 9019> 024.163.205.048 14:13:34 26/07/2001 nz 9007> 203.109.230.026 13:52:00 26/07/2001 nz 9001> 063.173.234.125 14:04:45 26/07/2001 nz 9007> 063.205.185.125 14:25:15 26/07/2001 nz 9007>>> somebody 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... Iseem> > 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/-------------------------------------------------------------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/
Anup Setty
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:
method of payment (1997)
LetterRip and WebCat (1998)
Webcat2, WebCommerce, Mod 10 etc. (1997)
Re:Has this happened to you? (was:Emailer Chokes on bad address) (1997)
New Installation (1998)
More on the email templates (I like it) (1997)
Emailer port change (1997)
EMail Problem (2000)
RequiredFields template (1997)
summ=T (2003)
WebCat.acgi from /cgi-bin/? (1997)
WebCatalog/WebMerchant bug? (1999)
WebCatalog for Postcards ? (1997)
Error.html (1997)
MORE: Is it possible to pause or wait a process (2000)
Client-side Image Maps and WebCat? (1998)
[WebDNA] detailed description of what [sendmail] does - repost please (2012)
Form Submition (2003)
Appending current [date] to a database (1997)
New Weird Behavior (bug report) (2000)