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 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=datenumfound = 0database 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/ 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)
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=datenumfound = 0database 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/ 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)