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 says Windows EXE version 6.2.0 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] 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)
My statistics page says Windows EXE version 6.2.0 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]

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:

WebCat2b13MacPlugIn - syntax to convert date (1997) WC2.0 Memory Requirements (1997) [WebDNA] Storing time data in a database (2016) WebCommerce Security Alert! (1996) dates as search criteria (2000) Mac Os X and WebCat (1999) Pacific Coast Software responsiveness (was WebMerchant - MacAuthorize) (1999) Quit revisited (1997) [WebDNA] Anyone using CODA ?? (2012) No Data Results (1997) No luck with taxes (1997) change the number format (1997) A few questions... (1999) Problems getting parameters passed into email. (1997) writing db to disk (1997) Math with Time (1997) What is WebDNA (1997) Error (1997) WebCatalog 2.1 for NT (1998) Help name our technology! (1997)