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:

Page Expiring again... (2006) CronoTask & WebCat (2000) listfiles bug(s) (2000) RE: WebCat and image maps (1997) no global [username] or [password] displayed ... (1997) When stuck, re-install. Thanks Guys. (2000) Confused about Grep Syntax (2004) Email Set-Up? (1997) User/pass with tcpconnect (2000) ConverChars (1999) [quantity] solved (1997) taxrate - off by 1 cent (1997) Emailer port change (1997) Appending with +1 ... (1997) update on wn searching (1997) Template Not Found (1998) absolute paths for databases? (1997) [WebDNA] [BULK] Securing WebCatalog login (2017) Some Questions (1997) Rhapsody? (1997)