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 saysWindows EXE version 6.2.0On 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=20wrote:>>> 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 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:
My statistics page saysWindows EXE version 6.2.0On 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=20wrote:>>> 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 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:
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)