[WebDNA] Question on table search
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 107176
interpreted = N
texte = HelloI ran into a problem with our search functions that do not seem to returnconsistent 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=201002 Blue Widget1003 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=20Found 0 items in the products table.=201002 Blue WidgetSo what am I doing wrong?/Tom
Associated Messages, from the most recent to the oldest:
HelloI ran into a problem with our search functions that do not seem to returnconsistent 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=201002 Blue Widget1003 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=20Found 0 items in the products table.=201002 Blue WidgetSo 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:
WC1.6 to WC2 date formatting (1997)
RequiredFields template (1997)
Mass Mail (2000)
WebCat2: Items xx to xx shown, etc. (1997)
I found a bug ... (1997)
The Form authentication trick (2000)
How to Sort Summ data ? (1997)
I give up!! (1997)
[WebDNA] CORRECTION: 60% failure rate using replace in a loop (2010)
Nesting format tags (1997)
WCS Newbie question (1997)
WC2.0 Memory Requirements (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Initiating NewCart (1997)
Help! (2000)
Summing fields (1997)
Commitdatabase tag (1998)
[OT] See Flash? (2003)
Three Guesses? (2004)
Success Stories (1997)