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 for the_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 PM Subject: 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... 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/ ------------------------------------------------------------- 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:

    
  1. Re: why won't this work, please tell me??? (Anup Setty 2001)
  2. Re: why won't this work, please tell me??? (Kenneth Grome 2001)
  3. Re: why won't this work, please tell me??? (Sam Lewis 2001)
  4. Re: why won't this work, please tell me??? (Andrew Simpson 2001)
  5. Re: why won't this work, please tell me??? (Sam Lewis 2001)
  6. Re: why won't this work, please tell me??? (Andrew Simpson 2001)
  7. Re: why won't this work, please tell me??? (Gary J. Krockover 2001)
  8. Re: why won't this work, please tell me??? (Andrew Simpson 2001)
  9. Re: why won't this work, please tell me??? (Andrew Simpson 2001)
  10. Re: why won't this work, please tell me??? (Brian Boegershausen 2001)
  11. 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 for the_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 PM Subject: 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... 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/ ------------------------------------------------------------- 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)