Re: [WebDNA] Question on table search

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107180
interpreted = N
texte = My statistics page says Windows EXE version 6.2.0 On Tue, 09 Aug 2011 13:37:10 +0200, Banahan wrote: > strange, what version of WC are you using? >=20 > -Lawrence >=20 >> ------------------------------------------------------------------------ >> >> tommy@enkelthed.dk >> 9 ao=C3=BBt 2011 13:33 >> >> >> Oh right, 1 items. >> >> Problem is it returns: >> >> Found 0 items in the products table. >> >> On Tue, 09 Aug 2011 13:02:59 +0200, Banahan=20 wrote: >>> My logic would suggest : >>> >>> Found 1 items in the products table. >>> 1002 Blue Widget >>> >>> -Lawrence >>> >> ------------------------------------------------------------------------ >>>> tommy@enkelthed.dk >>>> 9 ao=C3=BBt 2011 12:59 >>>> >>>> >>>> Hello >>>> >>>> I ran into a problem with our search functions that do not seem to >> return >>>> consistent results from a db. So i decided to test it, using known >>>> values, >>>> however I cannot get this to work. >>>> >>>> [code] >>>> >>>> [table name=3Dproducts&fields=3DSKU,NAME] >>>> 1001 Red Widget >>>> 1002 Blue Widget >>>> 1003 Green Widget >>>> [/table] >>>> >>>> [search table=3Dproducts&eqSKUdata=3D1002] >>>> Found [numfound] items in the products table. >>>> >>>> [founditems] >>>> [SKU] [NAME] >>>> >>>> [/founditems] >>>> [/search] >>>> >>>> [/code] >>>> >>>> As far as my logic suggests, this should return >>>> Found 0 items in the products table. >>>> 1002 Blue Widget >>>> >>>> So what am I doing wrong? >>>> >>>> /Tom >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list. >>>> To unsubscribe, E-mail to: >>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>> Bug Reporting: support@webdna.us >>>> >> ------------------------------------------------------------------------ >>>> Banahan >>>> 4 ao=C3=BBt 2011 17:21 >>>> >>>> >>>> Hi >>>> I have this code that is no running. >>>> I can't understand whats wrong... >>>> If somebody have an idea. >>>> >>>> Lawrence >>>> >>>> [text show=3DF]host=3D[ListMIMEHeaders >>>> name=3Dhost][value][/ListMIMEHeaders][/text] >>>> [text show=3DF]path_to_jpg=3D[host]/[mypath][/text] >>>> [tcpconnect host=3D[host]] >>>> [writefile file=3D[SKU]][tcpsend skipheader=3DT]GET /[path_to_jpg] >>>> HTTP/1.0[unurl]%0D%0A[/unurl][!] >>>> [/!]Host:[host][unurl]%0D%0A%0D%0A[/unurl][!] >>>> [/!][/tcpsend][/writefile] >>>> [/tcpconnect] >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list. >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >> ------------------------------------------------------------------------ >> >> Banahan >> 9 ao=C3=BBt 2011 13:02 >> >> >> My logic would suggest : >> Found 1 items in the products table. >> 1002 Blue Widget >> -Lawrence >> >> ------------------------------------------------------------------------ >> >> tommy@enkelthed.dk >> 9 ao=C3=BBt 2011 12:59 >> >> >> Hello >> >> I ran into a problem with our search functions that do not seem to return >> consistent results from a db. So i decided to test it, using known >> values, >> however I cannot get this to work. >> >> [code] >> >> [table name=3Dproducts&fields=3DSKU,NAME] >> 1001 Red Widget >> 1002 Blue Widget >> 1003 Green Widget >> [/table] >> >> [search table=3Dproducts&eqSKUdata=3D1002] >> Found [numfound] items in the products table. >> >> [founditems] >> [SKU] [NAME] >> >> [/founditems] >> [/search] >> >> [/code] >> >> As far as my logic suggests, this should return >> Found 0 items in the products table. >> 1002 Blue Widget >> >> So what am I doing wrong? >> >> /Tom >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >> ------------------------------------------------------------------------ >> >> Banahan >> 4 ao=C3=BBt 2011 17:21 >> >> >> Hi >> I have this code that is no running. >> I can't understand whats wrong... >> If somebody have an idea. >> >> Lawrence >> >> [text show=3DF]host=3D[ListMIMEHeaders=20 >> name=3Dhost][value][/ListMIMEHeaders][/text] >> [text show=3DF]path_to_jpg=3D[host]/[mypath][/text] >> [tcpconnect host=3D[host]] >> [writefile file=3D[SKU]][tcpsend skipheader=3DT]GET /[path_to_jpg]=20 >> HTTP/1.0[unurl]%0D%0A[/unurl][!] >> [/!]Host:[host][unurl]%0D%0A%0D%0A[/unurl][!] >> [/!][/tcpsend][/writefile] >> [/tcpconnect] Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Question on table search (Govinda 2011)
  2. Re: [WebDNA] Question on table search ( 2011)
  3. Re: [WebDNA] Question on table search (Govinda 2011)
  4. Re: [WebDNA] Question on table search ("Terry Wilson" 2011)
  5. Re: [WebDNA] Question on table search ( 2011)
  6. Re: [WebDNA] Question on table search ( 2011)
  7. Re: [WebDNA] Question on table search ( 2011)
  8. Re: [WebDNA] Question on table search (Banahan 2011)
  9. Re: [WebDNA] Question on table search ( 2011)
  10. Re: [WebDNA] Question on table search (Banahan 2011)
  11. [WebDNA] Question on table search ( 2011)
My statistics page says Windows EXE version 6.2.0 On Tue, 09 Aug 2011 13:37:10 +0200, Banahan wrote: > strange, what version of WC are you using? >=20 > -Lawrence >=20 >> ------------------------------------------------------------------------ >> >> tommy@enkelthed.dk >> 9 ao=C3=BBt 2011 13:33 >> >> >> Oh right, 1 items. >> >> Problem is it returns: >> >> Found 0 items in the products table. >> >> On Tue, 09 Aug 2011 13:02:59 +0200, Banahan=20 wrote: >>> My logic would suggest : >>> >>> Found 1 items in the products table. >>> 1002 Blue Widget >>> >>> -Lawrence >>> >> ------------------------------------------------------------------------ >>>> tommy@enkelthed.dk >>>> 9 ao=C3=BBt 2011 12:59 >>>> >>>> >>>> Hello >>>> >>>> I ran into a problem with our search functions that do not seem to >> return >>>> consistent results from a db. So i decided to test it, using known >>>> values, >>>> however I cannot get this to work. >>>> >>>> [code] >>>> >>>> [table name=3Dproducts&fields=3DSKU,NAME] >>>> 1001 Red Widget >>>> 1002 Blue Widget >>>> 1003 Green Widget >>>> [/table] >>>> >>>> [search table=3Dproducts&eqSKUdata=3D1002] >>>> Found [numfound] items in the products table. >>>> >>>> [founditems] >>>> [SKU] [NAME] >>>> >>>> [/founditems] >>>> [/search] >>>> >>>> [/code] >>>> >>>> As far as my logic suggests, this should return >>>> Found 0 items in the products table. >>>> 1002 Blue Widget >>>> >>>> So what am I doing wrong? >>>> >>>> /Tom >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list. >>>> To unsubscribe, E-mail to: >>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>> Bug Reporting: support@webdna.us >>>> >> ------------------------------------------------------------------------ >>>> Banahan >>>> 4 ao=C3=BBt 2011 17:21 >>>> >>>> >>>> Hi >>>> I have this code that is no running. >>>> I can't understand whats wrong... >>>> If somebody have an idea. >>>> >>>> Lawrence >>>> >>>> [text show=3DF]host=3D[ListMIMEHeaders >>>> name=3Dhost][value][/ListMIMEHeaders][/text] >>>> [text show=3DF]path_to_jpg=3D[host]/[mypath][/text] >>>> [tcpconnect host=3D[host]] >>>> [writefile file=3D[SKU]][tcpsend skipheader=3DT]GET /[path_to_jpg] >>>> HTTP/1.0[unurl]%0D%0A[/unurl][!] >>>> [/!]Host:[host][unurl]%0D%0A%0D%0A[/unurl][!] >>>> [/!][/tcpsend][/writefile] >>>> [/tcpconnect] >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list. >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >> ------------------------------------------------------------------------ >> >> Banahan >> 9 ao=C3=BBt 2011 13:02 >> >> >> My logic would suggest : >> Found 1 items in the products table. >> 1002 Blue Widget >> -Lawrence >> >> ------------------------------------------------------------------------ >> >> tommy@enkelthed.dk >> 9 ao=C3=BBt 2011 12:59 >> >> >> Hello >> >> I ran into a problem with our search functions that do not seem to return >> consistent results from a db. So i decided to test it, using known >> values, >> however I cannot get this to work. >> >> [code] >> >> [table name=3Dproducts&fields=3DSKU,NAME] >> 1001 Red Widget >> 1002 Blue Widget >> 1003 Green Widget >> [/table] >> >> [search table=3Dproducts&eqSKUdata=3D1002] >> Found [numfound] items in the products table. >> >> [founditems] >> [SKU] [NAME] >> >> [/founditems] >> [/search] >> >> [/code] >> >> As far as my logic suggests, this should return >> Found 0 items in the products table. >> 1002 Blue Widget >> >> So what am I doing wrong? >> >> /Tom >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >> ------------------------------------------------------------------------ >> >> Banahan >> 4 ao=C3=BBt 2011 17:21 >> >> >> Hi >> I have this code that is no running. >> I can't understand whats wrong... >> If somebody have an idea. >> >> Lawrence >> >> [text show=3DF]host=3D[ListMIMEHeaders=20 >> name=3Dhost][value][/ListMIMEHeaders][/text] >> [text show=3DF]path_to_jpg=3D[host]/[mypath][/text] >> [tcpconnect host=3D[host]] >> [writefile file=3D[SKU]][tcpsend skipheader=3DT]GET /[path_to_jpg]=20 >> HTTP/1.0[unurl]%0D%0A[/unurl][!] >> [/!]Host:[host][unurl]%0D%0A%0D%0A[/unurl][!] >> [/!][/tcpsend][/writefile] >> [/tcpconnect]

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:

Discount - Reserved Word? (2001) Nested tags count question (1997) pc (1997) THANKS!!! ShipCosts.db and debugging (1997) Listserver problem (1997) Re:Emailer and encryption (1997) formula inside database to calculate weights (1997) WC2b12: Yes, Formulas.db is for real (1997) in string ??? (2001) Processing all html files through WebCat or Typhoon (1998) Trouble with formula.db (1997) Web DNA rates (2000) Blank orders after update to 5.1 (2003) WebCat2b13MacPlugIn - [include] (1997) [WebDNA] I got v7 running on 64-bit Ubuntu 11.04 ... (2012) Sending mail (was forms and variables) (1998) Crediting money back to a customer (2000) # fields limited? (1997) Nesting format tags (1997) Help name our technology! I found it (1997)