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.=20On 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 toreturn>> 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:
Oh right, 1 items.Problem is it returns:Found 0 items in the products table.=20On 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 toreturn>> 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)