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:

CSS and SSI books (2004) New Cart No. on same page (2003) [WebDNA] HTML [sendmail] revisited (2009) & Aftermath (1999) Searchable list archive (1997) RE: protect tag on NT (1997) WebCat preferences caching problem (2000) Another bug to squash (WebCat2b13 Mac .acgi) (1997) Price + Texte (1999) absolute paths for databases? (1997) WebCat as POP mail client? (2002) Emails are Stuck (2003) MacOS X Server problems (2001) Re:Realtime Transaction Processing (1999) Changing SubTotal (2003) RE: PCS search results page (1998) Help ! Frustrating Problem (1999) WebCat2.0 [format thousands .0f] no go (1997) Email within tmpl ? (1997) RSS Feeds; basic info (2005)