Stivn .. wrote: > 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
That depends on your database. With MS databases you need to use "TOP", with Oracle "rownum", with MySQL and PostgreSQL "LIMIT". The syntax specific to the database you are using will be described in the manual. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290729 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4