Re: [WebDNA] Question on table search

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107177
interpreted = N
texte = This is a multi-part message in MIME format. --------------050702080408040301000705 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable 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 retu= rn > consistent results from a db. So i decided to test it, using known valu= es, > 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] --------------050702080408040301000705 Content-Type: multipart/related; boundary="------------010709090902030503050507" --------------010709090902030503050507 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable My logic would suggest = :
Found 1 items in the products table.=201002 Blue Widget
=C2=A0-Lawrence


= tommy@enkelthed.dk
9 ao=C3=BBt 2011 12:59

Hello

I ran into a problem with ou= r 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=20 get this to work.

[code]

[table=20 name=3Dproducts&fields=3DSKU,NAME]
1001 Red Widget
1002 Blue=20 Widget
1003 Green Widget
[/table]

[search=20 table=3Dproducts&eqSKUdata=3D1002]
Found [numfound] items in the=20 products table.

[founditems]
[SKU] [NAME]

[/founditems]<= br>[/search]

[/code]

As far as my logic suggests, this should return
Found 0 items in the=20 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=20 list &l= t;talk@webdna.us>.
To unsubscribe, E-mail to:=20 &= lt;talk-leave@webdna.us>
archives:=20 http://mail.webdna.us/list/talk@webdna.us
Bug Reporti= ng:=20 s= upport@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]
--------------010709090902030503050507 Content-Type: image/jpeg; x-apple-mail-type=stationery; name="compose-unknown-contact.jpg" Content-Transfer-Encoding: base64 Content-ID: Content-Disposition: inline; filename="compose-unknown-contact.jpg" /9j/4AAQSkZJRgABAQEARwBHAAD/2wBDAAEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEC AQEBAQEBAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/2wBDAQEBAQEBAQICAgICAgIC AgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/wAAR CAAZABkDAREAAhEBAxEB/8QAGAAAAwEBAAAAAAAAAAAAAAAABgcICQr/xAA0EAABAwMCAgUK BwAAAAAAAAACAQMEBQYRABITIQcUMUF2CBUXIjI2N0JRtVRWkZOV0dL/xAAYAQEAAwEAAAAA AAAAAAAAAAADAAEEAv/EACQRAAICAAQGAwAAAAAAAAAAAAABAhEDMrHREyExM0FxgfDx/9oA DAMBAAIRAxEAPwDuEt+gW/ULet6oVC3rfqNQqFv0OfPn1GhUqfOmzZtKZlS5UqZMaNwzNwiJ VIl7eXLCaZIGwBl3TY8epPx2+jy2ZNPjvkwc9uhW8j7nCPhvOsQliYIeS7cvCpp8o50qwrC4 v3lsNSDbdmTEhvs2tahxpfV3WnmbbozJEw/gwdadbYExVRXKEKoSdvJcaOSqxE7/AAiX0gXx +a69/JSf9alIlste0VzaNpeFrcT9KKymotyiaZ0KRCnzacoE7Kjzn4gi2KqUh3jqDHDHv4mR UfruTWlMzlVUKIVNp9GguEJnAh0+IZjyAiisgyRDnu5azS8miKqjOTVkKqS/psG37fo1Fbab eg25b8eZPeFJBBJSjMG5HjMeyihnaauZwe4OGiju13GAcpOwBeN+U8/IkGbsiS8b7ryogmbz hbyc9REROfZhERO5ETShjPtvpGqTUyLErytS4siSwx5x2tRH4hPOI0DkjZtaJtFxuVEbIUUi yeNujlBUJGbJN6nM/Cyf2Hf60YgjvKA+NPSP4gT7axpcPtr51YWJnYn9dnAQWl722p4ot37y zqnlfp6FrqbwawG8/9k= --------------010709090902030503050507-- --------------050702080408040301000705-- 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)
This is a multi-part message in MIME format. --------------050702080408040301000705 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable 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 retu= rn > consistent results from a db. So i decided to test it, using known valu= es, > 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] --------------050702080408040301000705 Content-Type: multipart/related; boundary="------------010709090902030503050507" --------------010709090902030503050507 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable My logic would suggest = :
Found 1 items in the products table.=201002 Blue Widget
=C2=A0-Lawrence


= tommy@enkelthed.dk
9 ao=C3=BBt 2011 12:59

Hello

I ran into a problem with ou= r 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=20 get this to work.

[code]

[table=20 name=3Dproducts&fields=3DSKU,NAME]
1001 Red Widget
1002 Blue=20 Widget
1003 Green Widget
[/table]

[search=20 table=3Dproducts&eqSKUdata=3D1002]
Found [numfound] items in the=20 products table.

[founditems]
[SKU] [NAME]

[/founditems]<= br>[/search]

[/code]

As far as my logic suggests, this should return
Found 0 items in the=20 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=20 list &l= t;talk@webdna.us>.
To unsubscribe, E-mail to:=20 &= lt;talk-leave@webdna.us>
archives:=20 http://mail.webdna.us/list/talk@webdna.us
Bug Reporti= ng:=20 s= upport@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]
--------------010709090902030503050507 Content-Type: image/jpeg; x-apple-mail-type=stationery; name="compose-unknown-contact.jpg" Content-Transfer-Encoding: base64 Content-ID: Content-Disposition: inline; filename="compose-unknown-contact.jpg" /9j/4AAQSkZJRgABAQEARwBHAAD/2wBDAAEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEC AQEBAQEBAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/2wBDAQEBAQEBAQICAgICAgIC AgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/wAAR CAAZABkDAREAAhEBAxEB/8QAGAAAAwEBAAAAAAAAAAAAAAAABgcICQr/xAA0EAABAwMCAgUK BwAAAAAAAAACAQMEBQYRABITIQcUMUF2CBUXIjI2N0JRtVRWkZOV0dL/xAAYAQEAAwEAAAAA AAAAAAAAAAADAAEEAv/EACQRAAICAAQGAwAAAAAAAAAAAAABAhEDMrHREyExM0FxgfDx/9oA DAMBAAIRAxEAPwDuEt+gW/ULet6oVC3rfqNQqFv0OfPn1GhUqfOmzZtKZlS5UqZMaNwzNwiJ VIl7eXLCaZIGwBl3TY8epPx2+jy2ZNPjvkwc9uhW8j7nCPhvOsQliYIeS7cvCpp8o50qwrC4 v3lsNSDbdmTEhvs2tahxpfV3WnmbbozJEw/gwdadbYExVRXKEKoSdvJcaOSqxE7/AAiX0gXx +a69/JSf9alIlste0VzaNpeFrcT9KKymotyiaZ0KRCnzacoE7Kjzn4gi2KqUh3jqDHDHv4mR UfruTWlMzlVUKIVNp9GguEJnAh0+IZjyAiisgyRDnu5azS8miKqjOTVkKqS/psG37fo1Fbab eg25b8eZPeFJBBJSjMG5HjMeyihnaauZwe4OGiju13GAcpOwBeN+U8/IkGbsiS8b7ryogmbz hbyc9REROfZhERO5ETShjPtvpGqTUyLErytS4siSwx5x2tRH4hPOI0DkjZtaJtFxuVEbIUUi yeNujlBUJGbJN6nM/Cyf2Hf60YgjvKA+NPSP4gT7axpcPtr51YWJnYn9dnAQWl722p4ot37y zqnlfp6FrqbwawG8/9k= --------------010709090902030503050507-- --------------050702080408040301000705-- Banahan

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:

Country & Ship-to address & other fields ? (1997) Secure server question (1997) RE: Error -108 (1997) Displays by Categories (2000) [WebDNA] in principle, can we [setcookie] in a [spawn] ? (2009) Help Encrypt/Decrypt eMail (2003) Capturing the referring site (1999) I think WebDNA-Talk died ... :( (1997) WebCat2 - Getting to the browser's username/password data (1997) Where is Typhoon 3.x? (2000) Multiple Merchant Accounts? (1997) Tax Moratorium Expiring (2001) Sorting by number (2001) Reload adding to cart (2001) Not really WebCat (1997) I'm tired of all this! (2000) [WebDNA] PCI Vulnerability testing (2009) Digital Postcards (1999) Summing a field full of numbers ... (1997) Template not found error messages (1997)