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:

Webcat 4.0.1b2 on ftp - what does it fix? (2000) What am I missing (1997) Hello??? (1997) A little syntax help (1997) Sku numbers (1997) WC Database Format (1997) TCP Connect over SSL? (2000) WebCat2b12 forgets serial # (1997) Runnaway Trigger (2007) [WriteFile] problems (1997) quitting (1997) mySQL or MS SQL (2000) Databases (2000) Search/sort in URL Was: GuestBook example (1997) Locking up with WebCatalog... (1997) [WebDNA] How to NOT remove the dot via grep ... (2009) Feedback on new features (2000) Bug Report, maybe (1997) Price recalc based on quantity (1997) OT: need bad code (2005)