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:

Multiple prices (1997) Running 2 two WebCatalog.acgi's (1996) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) [WebDNA] Now: Listfields does not work with tables - Was: [OT] MySQL Users (2011) WebDNA security (2004) Cleaner URLs (2003) PCS Frames-Default page is solution! (1997) Using Webcatalog to write a search engine.... (2001) [authenticate] (2002) locking variables? (2000) Possible Macv2.1b2 Merge Bug (1997) Math problems (1998) Shipping charges (1998) AOL and webcat (1998) Appending a field to itself (2000) Security Question (1997) template not found error (1998) Grep is Broke (2004) RE: boldwords funky (1998) New commands in Final candidate (1997)