Re: [WebDNA] Question on table search

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107178
interpreted = N
texte = Oh right, 1 items. Problem is it returns: Found 0 items in the products table.=20 On Tue, 09 Aug 2011 13:02:59 +0200, Banahan wrote: > My logic would suggest : >=20 > Found 1 items in the products table. > 1002 Blue Widget >=20 > -Lawrence >=20 >> ------------------------------------------------------------------------ >> >> 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)
Oh right, 1 items. Problem is it returns: Found 0 items in the products table.=20 On Tue, 09 Aug 2011 13:02:59 +0200, Banahan wrote: > My logic would suggest : >=20 > Found 1 items in the products table. > 1002 Blue Widget >=20 > -Lawrence >=20 >> ------------------------------------------------------------------------ >> >> 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:

WebCatalog can't find database (1997) [WebDNA] "Safe Write for Database" setting.... (2016) turning every 5th line red (1998) purchase.log file (1997) Strange intermittent WebDNA problems Workaround (2008) Dummy Form Variables Needed (2000) WebCat2 - Getting to the browser's username/password data (1997) What is WebDNA (1997) RE: PIXO support (1997) Displaying text and populating form fields (2005) writefile - continued (1997) WebCat and AppleShare 6.0 (1998) RE: Clearing orders and database help! (1997) Variable prices and Formulas.db (1997) New Plug-in and Type 11 errors (1997) carriage returns in data (1997) sort problems....bug or brain fart? (1997) Using Plug-In while running 1.6.1 (1997) Security Question (1997) Data Type Search Problem (2004)