SQL LIMIT Conflict In DMX

[grobermatica]

Hi,

I'm using Dreamweaver to create a list from a MySQL table, however I want to limit the list using the SQL syntax "1,999" (so that I can start at the second record and go from there.)

However when I load the page on the server I get an 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

I'm assuming that this must mean that there is some sort of conflict and that Dreamweaver is setting its own LIMIT on the recordset.

Question is how cna I influence the LIMIT that DMX puts on the recordset? It works fine when I take out my LIMIT clause form the query.

Any Help Appreciated

Craig

 

[lebisol]

what is tha actual SQL statement for both recordsets....doesn't sound like DW problem more of a sql logic being processed before DW tried to spit it out into its sql/gui/rs tools.
All the best!


:--------------------------------------:

All around in my home town,
They tryin' to track me down...

 

[johnwm]

To save other posters a lot of time this appears to be a continuation of thread436-1285210.

grobermatica, please don't cross post without a reference to the previous thread. Read faq222-2244 for forum usage guidelines

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller