Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › Recordset SQL 2 WHERE Expressions not working

Recordset SQL 2 WHERE Expressions not working

Thread began 9/17/2010 3:44 am by jo4koalas392067 | Last modified 9/17/2010 4:03 am by jo4koalas392067 | 481 views | 1 replies

9/17/2010 4:03 amDave BuchholzBeta Tester

How do you store the sold flag in your database ? Is it text ?

If it is text you need to wrap sold in single quotes like so:

$query_WADAitems = "SELECT ItemID, ItemCatID, ItemName, ItemShortDesc, ItemLongDesc, ItemPrice, ItemSKU, ItemThumb, ItemImage, ItemWeight, StockStatus FROM items WHERE ItemCatID = 13 AND StockStatus <> 'Sold' ORDER BY ItemPrice ASC";

Seeing you db table and knowing how you store this would help solve the issue if this is not the answer

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.