Re: [WebDNA] Question on table search
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 107183
interpreted = N
texte =
You can use a tab between fields; that's what I use. Were you = not using a tab either? In that case, SKU was the only field with data.
On Tue, 09 Aug 2011 13:51:50 +0200
<tommy@enkelthed.dk> wrote:
Okay, the example is flawed.
WHile I should have caugt that there is no , in the table description
- I
pulled it directly from the dokumentation. I got it working b= y adding
a ,
to the products table
/Tommy
On Tue, 09= Aug 2011 13:38:06 +0200, <tommy@enkelthed.dk> wrote:
> My statist= ics page says
> Windows EXE version 6.2.0
>
> On Tue, = 09 Aug 2011 13:37:10 +0200, Banahan <banahan.l@gmail.com>
>wrot= e:
>> strange, what version of WC are you using?
>>
>> -Lawrence
>>
>>>
> -------------= -----------------------------------------------------------
>>&g= t;
>>> tommy@enkelthed.dk <mailto:tommy@enkelthed.dk>
>>> 9 a= o=C3=BBt 2011 13:33
>>>
>>>
>>> Oh ri= ght, 1 items.
>>>
>>> Problem is it returns:
>>= >
>>> Found 0 items in the products table.
>>>
>>> On Tue, 09 Aug 2011 13:02:59 +0200= , Banahan<banahan.l@gmail.com>
> wrote:
>>>> = My logic would suggest :
>>>>
>>>> Found 1 ite= ms in the products table.
>>>> 1002 Blue Widget
>>>>
>>>> -Lawrence
>>>&= gt;
>>>
> ------------------------------------------------------------------------<= br>>>>>> tommy@enkelthed.dk<mailto:tommy@enkelthed.dk&= gt;
>>>>> 9 ao=C3=BBt 2011 12:59
>>>>>
>>>>>>>>>> Hello
>>>>>
>>>>&g= t; I ran into a problem with our search functions that do not seem to
>>&= gt; return
>>>>> consistent results from a db. So i dec= ided to test it, using known
>>>>> values,
>>>&g= t;> however I cannot get this to work.
>>>>>
>>>>> [code]
>>&= gt;>>
>>>>> [table name=3Dproducts&fields=3DSKU,NAME]
>>>>> 1001 Red W= idget
>>>>> 1002 Blue Widget
>>>>> 10= 03 Green Widget
>>>>> [/table]
>>>>>
>&g= t;>>> [search table=3Dproducts&eqSKUdata=3D1002]
>>= >>> Found [numfound] items in the products table.
>>>>>
= >>>>> [founditems]
>>>>> [SKU] [NAME]
>>>>>
>>>>> [/founditems]
&= gt;>>>> [/search]
>>>>>
>>>>= > [/code]
>>>>>
>>>>> As far as my logi= c suggests, this should return
>>>>> Found 0 items in t= he products table.
>>>>> 1002 Blue Widget
>>>&= gt;>
>>>>> So what am I doing wrong?
>>>>>
>>>>> /Tom
>>&g= t;>> ---------------------------------------------------------
&= gt;>>>> This message is sent to you because you are subscribed to
>>>= >> the mailing list<talk@webdna.us>.
>>>>> = To unsubscribe, E-mail to:<talk-leave@webdna.us>
>>>>&g= t; archives: http://mail.webdna.us/list/talk@webdna.us
>>>>= ;> Bug Reporting: support@webdna.us
>>>>>
>>><= br>> -----------------------------------------------------------------= -------
>>>>> Banahan<mailto:banahan.l@gmail.com>
>>>>> 4 ao=C3= =BBt 2011 17:21
>>>>>
>>>>>
>&g= t;>>> Hi
>>>>> I have this code that is no running.
>&g= t;>>> I can't understand whats wrong...
>>>>> = If somebody have an idea.
>>>>>
>>>>> La= wrence
>>>>>
>>>>> [text show=3DF]host=3D[ListMIMEHeaders
>>>>> name=3Dhost][val= ue][/ListMIMEHeaders][/text]
>>>>> [text show=3DF]path_to_jpg=3D[host]/[mypath][/text]
>>>>> [tc= pconnect 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<talk@webdna.us>.
>>> To unsubscribe, E= -mail to:<talk-leave@webdna.us>
>>> archives: http://mail.webdna.us/list/talk@webdna.us
>>> Bug Reporting: = support@webdna.us
>>>
> ------------------------------------------------------------------------<= br>>>>
>>> Banahan <mailto:banahan.l@gmail.com>
>>> 9 ao=C3=BBt 2011 13:02=
>>>
>>>
>>> My logic would suggest :
>>> Found 1 items in the products table.
>>> 10= 02 Blue Widget
>>> -Lawrence
>>>
>>>
> -----------------------= -------------------------------------------------
>>>
>= >> tommy@enkelthed.dk <mailto:tommy@enkelthed.dk>
>>> 9 a= o=C3=BBt 2011 12:59
>>>
>>>
>>> Hello
>>>
>>> I ran into a problem with our searc= h functions that do not seem to
> return
>>> consistent results from a db. So i decided to test it, using known
>>> v= alues,
>>> however I cannot get this to work.
>>>
>>> [code]
>>>
>>&= gt; [table name=3Dproducts&fields=3DSKU,NAME]
>>> 1001 Re= d Widget
>>> 1002 Blue Widget
>>> 1003 Green Widget=
>>> [/table]
>>>
>>> [search table=3Dproducts&eqSKUdata=3D1002]
>>> Found [numfound] i= tems 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
>>>
>>> S= o what am I doing wrong?
>>>
>>> /Tom
>>= > ---------------------------------------------------------
>>>= This message is sent to you because you are subscribed to
>>>= ; the mailing list <talk@webdna.us>.
>>> To unsubscribe, = E-mail to: <talk-leave@webdna.us>
>>> archives: http://mail.webdna.us/list/talk@webdna.us
>>> Bug Reporting: = support@webdna.us
>>>
> ------------------------------------------------------------------------<= br>>>>
>>> Banahan <mailto:banahan.l@gmail.com>
>>> 4 ao=C3=BBt 2011 17:21=
>>>
>>>
>>> Hi
>>> I hav= e this code that is no running.
>>> I can't understand whats wrong..= .
>>> If somebody have an idea.
>>>
>>&g= t; Lawrence
>>>
>>> [text show=3DF]host=3D[ListMIMEH= eaders
>>> name=3Dhost][value][/ListMIMEHeaders][/text]
&= gt;>> [text show=3DF]path_to_jpg=3D[host]/[mypath][/text]
>>> [tcpc= onnect 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][!]<= br>>>> [/!][/tcpsend][/writefile]
>>> [/tcpconnect]
> --------= -------------------------------------------------
> This message is sent to you because you are subscribed to
> the mailing list <ta= lk@webdna.us>.
> To unsubscribe, E-mail to: <talk-leave@webdna.us>
> archives: http://mail.webdna.us/list= /talk@webdna.us
> Bug Reporting: support@webdna.us
---------------------------------------------------------
This messag= e is sent to you because you are subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@web= dna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bu= g Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
You can use a tab between fields; that's what I use. Were you = not using a tab either? In that case, SKU was the only field with data.
On Tue, 09 Aug 2011 13:51:50 +0200
<tommy@enkelthed.dk> wrote:
Okay, the example is flawed.
WHile I should have caugt that there is no , in the table description
- I
pulled it directly from the dokumentation. I got it working b= y adding
a ,
to the products table
/Tommy
On Tue, 09= Aug 2011 13:38:06 +0200, <tommy@enkelthed.dk> wrote:
> My statist= ics page says
> Windows EXE version 6.2.0
>
> On Tue, = 09 Aug 2011 13:37:10 +0200, Banahan <banahan.l@gmail.com>
>wrot= e:
>> strange, what version of WC are you using?
>>
>> -Lawrence
>>
>>>
> -------------= -----------------------------------------------------------
>>&g= t;
>>> tommy@enkelthed.dk <mailto:tommy@enkelthed.dk>
>>> 9 a= o=C3=BBt 2011 13:33
>>>
>>>
>>> Oh ri= ght, 1 items.
>>>
>>> Problem is it returns:
>>= >
>>> Found 0 items in the products table.
>>>
>>> On Tue, 09 Aug 2011 13:02:59 +0200= , Banahan<banahan.l@gmail.com>
> wrote:
>>>> = My logic would suggest :
>>>>
>>>> Found 1 ite= ms in the products table.
>>>> 1002 Blue Widget
>>>>
>>>> -Lawrence
>>>&= gt;
>>>
> ------------------------------------------------------------------------<= br>>>>>> tommy@enkelthed.dk<mailto:tommy@enkelthed.dk&= gt;
>>>>> 9 ao=C3=BBt 2011 12:59
>>>>>
>>>>>>>>>> Hello
>>>>>
>>>>&g= t; I ran into a problem with our search functions that do not seem to
>>&= gt; return
>>>>> consistent results from a db. So i dec= ided to test it, using known
>>>>> values,
>>>&g= t;> however I cannot get this to work.
>>>>>
>>>>> [code]
>>&= gt;>>
>>>>> [table name=3Dproducts&fields=3DSKU,NAME]
>>>>> 1001 Red W= idget
>>>>> 1002 Blue Widget
>>>>> 10= 03 Green Widget
>>>>> [/table]
>>>>>
>&g= t;>>> [search table=3Dproducts&eqSKUdata=3D1002]
>>= >>> Found [numfound] items in the products table.
>>>>>
= >>>>> [founditems]
>>>>> [SKU] [NAME]
>>>>>
>>>>> [/founditems]
&= gt;>>>> [/search]
>>>>>
>>>>= > [/code]
>>>>>
>>>>> As far as my logi= c suggests, this should return
>>>>> Found 0 items in t= he products table.
>>>>> 1002 Blue Widget
>>>&= gt;>
>>>>> So what am I doing wrong?
>>>>>
>>>>> /Tom
>>&g= t;>> ---------------------------------------------------------
&= gt;>>>> This message is sent to you because you are subscribed to
>>>= >> the mailing list<talk@webdna.us>.
>>>>> = To unsubscribe, E-mail to:<talk-leave@webdna.us>
>>>>&g= t; archives: http://mail.webdna.us/list/talk@webdna.us
>>>>= ;> Bug Reporting: support@webdna.us
>>>>>
>>><= br>> -----------------------------------------------------------------= -------
>>>>> Banahan<mailto:banahan.l@gmail.com>
>>>>> 4 ao=C3= =BBt 2011 17:21
>>>>>
>>>>>
>&g= t;>>> Hi
>>>>> I have this code that is no running.
>&g= t;>>> I can't understand whats wrong...
>>>>> = If somebody have an idea.
>>>>>
>>>>> La= wrence
>>>>>
>>>>> [text show=3DF]host=3D[ListMIMEHeaders
>>>>> name=3Dhost][val= ue][/ListMIMEHeaders][/text]
>>>>> [text show=3DF]path_to_jpg=3D[host]/[mypath][/text]
>>>>> [tc= pconnect 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<talk@webdna.us>.
>>> To unsubscribe, E= -mail to:<talk-leave@webdna.us>
>>> archives: http://mail.webdna.us/list/talk@webdna.us
>>> Bug Reporting: = support@webdna.us
>>>
> ------------------------------------------------------------------------<= br>>>>
>>> Banahan <mailto:banahan.l@gmail.com>
>>> 9 ao=C3=BBt 2011 13:02=
>>>
>>>
>>> My logic would suggest :
>>> Found 1 items in the products table.
>>> 10= 02 Blue Widget
>>> -Lawrence
>>>
>>>
> -----------------------= -------------------------------------------------
>>>
>= >> tommy@enkelthed.dk <mailto:tommy@enkelthed.dk>
>>> 9 a= o=C3=BBt 2011 12:59
>>>
>>>
>>> Hello
>>>
>>> I ran into a problem with our searc= h functions that do not seem to
> return
>>> consistent results from a db. So i decided to test it, using known
>>> v= alues,
>>> however I cannot get this to work.
>>>
>>> [code]
>>>
>>&= gt; [table name=3Dproducts&fields=3DSKU,NAME]
>>> 1001 Re= d Widget
>>> 1002 Blue Widget
>>> 1003 Green Widget=
>>> [/table]
>>>
>>> [search table=3Dproducts&eqSKUdata=3D1002]
>>> Found [numfound] i= tems 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
>>>
>>> S= o what am I doing wrong?
>>>
>>> /Tom
>>= > ---------------------------------------------------------
>>>= This message is sent to you because you are subscribed to
>>>= ; the mailing list <talk@webdna.us>.
>>> To unsubscribe, = E-mail to: <talk-leave@webdna.us>
>>> archives: http://mail.webdna.us/list/talk@webdna.us
>>> Bug Reporting: = support@webdna.us
>>>
> ------------------------------------------------------------------------<= br>>>>
>>> Banahan <mailto:banahan.l@gmail.com>
>>> 4 ao=C3=BBt 2011 17:21=
>>>
>>>
>>> Hi
>>> I hav= e this code that is no running.
>>> I can't understand whats wrong..= .
>>> If somebody have an idea.
>>>
>>&g= t; Lawrence
>>>
>>> [text show=3DF]host=3D[ListMIMEH= eaders
>>> name=3Dhost][value][/ListMIMEHeaders][/text]
&= gt;>> [text show=3DF]path_to_jpg=3D[host]/[mypath][/text]
>>> [tcpc= onnect 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][!]<= br>>>> [/!][/tcpsend][/writefile]
>>> [/tcpconnect]
> --------= -------------------------------------------------
> This message is sent to you because you are subscribed to
> the mailing list <ta= lk@webdna.us>.
> To unsubscribe, E-mail to: <talk-leave@webdna.us>
> archives: http://mail.webdna.us/list= /talk@webdna.us
> Bug Reporting: support@webdna.us
---------------------------------------------------------
This messag= e is sent to you because you are subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@web= dna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bu= g 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:
japanese characters (1997)
Test (2001)
remotely add + sign (1997)
[append] (1997)
BR (1997)
[Announce] Newest Commerce Site based on WebCatalog (1997)
difference between v.6 and v.7, WAS: [WebDNA] v7 thisurl has different behavour (2012)
RE: type 2 errors with ssl server (1997)
Server crashes when user saves or views html source (1998)
[WebDNA] Duplicate emails from list anyone? (2009)
RE: [WebDNA] Hmmm ... (2008)
PCS Customer submissions ? (1997)
[WebDNA] Grep (2009)
Updating Prices in Online Database (1999)
standard vs intertwined multithreading (1999)
Format of Required fields error message (1997)
Exclamation point (1997)
ShowIf variables (1997)
TCPConnect/Send (2003)
WebCat2b15MacPlugin - showing [math] (1997)