[WebDNA] Question on table search

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107176
interpreted = N
texte = 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=20 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=20 Found 0 items in the products table.=20 1002 Blue Widget So what am I doing wrong? /Tom 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)
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=20 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=20 Found 0 items in the products table.=20 1002 Blue Widget So what am I doing wrong? /Tom

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:

WebCat2 several catalogs? (1997) can WC render sites out? (1997) Sendmail problem (2002) WebCat2b13MacPlugIn - syntax to convert date (1997) sendmail for email (was Netforms) (1998) Running _every_ page through WebCat ? (1997) [shippingtotal] & Formulas.db prob (2003) Running 2 two WebCatalog.acgi's (1996) Special delete ... (1997) Date search - yes or no (1997) WebCatalog2 Feature Feedback (1996) shipCost not working v2.1b4 (1997) Grep Question (2003) Product Name Fields and the Ampersand (1999) Explorer 3.0/ Access Denied! (1997) $flushdatabases question ... (1998) Formating Tables w/[founditems] (1998) Math Context (1998) WebCat Admin access w/ClearlyHome p.i. (1997) How to stop WebCat services on NT? (2000)