Help us test the new Databridge BETA with MySQLi support

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Search Behavior WHERE question.

View all replies to this thread

Search Behavior WHERE question.

Thread began 2/14/2011 12:32 am by troyd | Last modified 2/15/2011 5:34 am by troyd | 1723 views | 14 replies

2/14/2011 5:36 pmJason ByrnesWebAssist

no big deal, troubleshooting code is always a learning process.

The space I had you add was to force a literal space between the default where clause and the WHERE statement.

the default where clause will automatically add the where statement if it is not present, but if you dont have the space, it will become:
WHEREstatus = 0

instead of:
WHERE status = 0

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.