Hi all, i want to create a SQL query with a LIMIT option but it will produce an error.
What is the correct syntax for a SQL query with LIMIT option, i tryed it like this: "SELECT LABEL FROM table.name WHERE (STATUS = '1') AND (XY = 'AB') LIMIT 1,3" Thanks in advance for your help & with best regards nic. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290721 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4