Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › I want to exclude the first record

I want to exclude the first record

Thread began 5/14/2012 6:21 am by vanroojdotcom | Last modified 5/15/2012 9:17 am by vanroojdotcom | 1316 views | 3 replies

5/14/2012 6:21 amvanroojdotcom

I want to exclude the first record

I wish to exclude the first record results from dataAssist - I am trying to use,

"SELECT stockID, title, image, description, price, Dcreated, Dmodified, cat01, cat02, cat03 FROM main LIMIT 1, 2"

But when I add the LIMIT 1, 2 I get the error

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 5' at line 1"

Although this works when using the "Test" feature in Dreamweaver (from the Recordset dialogue box) it errors when uploaded. Removing the LIMIT 1,2 code and the page works.

Any work around / other SQL code to exclude the first row from the results?

Many thanks
Vanrooj

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.