Re: [WebDNA] Question on table search
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 107181
interpreted = N
texte = Hm I must be missing something but,=20 if i do this: [table name=3Dproducts&fields=3DSKU,NAME] 1001 Red Widget=20 1002 Blue Widget 1003 Green Widget [/table] [search table=3Dproducts&neSKUdata=3D1002] Found [numfound] items in the products table. [founditems] [SKU] - [NAME] [/founditems] [/search] the result is: Found 3 items in the products table. 1001 Red Widget - 1002 Blue Widget - 1003 Green Widget -=20 Now, To me, that looks like it thinks Red Widget is part of the SKU. /Tommy On Tue, 09 Aug 2011 13:38:06 +0200,
wrote: > My statistics page says > Windows EXE version 6.2.0 >=20 > 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] > --------------------------------------------------------- > 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
Associated Messages, from the most recent to the oldest:
Hm I must be missing something but,=20 if i do this: [table name=3Dproducts&fields=3DSKU,NAME] 1001 Red Widget=20 1002 Blue Widget 1003 Green Widget [/table] [search table=3Dproducts&neSKUdata=3D1002] Found [numfound] items in the products table. [founditems] [SKU] - [NAME] [/founditems] [/search] the result is: Found 3 items in the products table. 1001 Red Widget - 1002 Blue Widget - 1003 Green Widget -=20 Now, To me, that looks like it thinks Red Widget is part of the SKU. /Tommy On Tue, 09 Aug 2011 13:38:06 +0200, wrote: > My statistics page says > Windows EXE version 6.2.0 >=20 > 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] > --------------------------------------------------------- > 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
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:
Emailing html (1998)
Search/sort in URL Was: GuestBook example (1997)
webcat2b12 CGI -- Date comparisons (1997)
mailhost-check (1999)
searching by date (1998)
WebCat2b13MacPlugIn - [include] (1997)
Number of Feilds Passed to [append] (2000)
Date Formats (1997)
WebCat2b15MacPlugin - showing [math] (1997)
I've been thinking (2002)
No answers by SM? (2000)
using cookies to prevent access (2000)
Search String (2003)
Talk List Admin Page? (2000)
Test (2002)
Date fun with MySQL (2004)
Problems with WebDNA-Talk list (1998)
Problem (1997)
[WebDNA] SiteBuilder Help (2008)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)