consider adding a "dbtype" attribute to your application DSN request as
MSAccess, PostGRES, SQL Server, etc may differ in their interpretation of
SQL commands. Have it dynamic - eg set in the Application.cfm as a
"Request.DBServerType" and have your SQL cased accordingly. Easy with the
open source database servers like MySQL, more difficult to test with
propriety stuff like Access or SQL Server. But I am sure there are ppl
amongst CF-Talk that could test your scripts on your behalf.
What is your CFML environment? CF4x, 5, MX, BlueDragon?
While SQL is supposed to be a "standard" syntax can vary wildly. IBM DB2,
Oracle, Sybase? Isn't web development fun? Especially on a budget. Will your
application work under Linux, Solaris, OS X? Welcome to the web development
world. As with the browser wars, database server, IDE tools, it's all a fact
of life. I'm 35 and am going grey already because of these issues.
You are not alone.
Peter Tilbrook
ColdFusion Applications Developer
ColdGen Internet Solutions
Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com
4/73 Tharwa Road
Queanbeyan, NSW, 2620
AUSTRALIA
Telephone: +61-2-6284-2727
Mobile: +61-0439-401-823
E-mail: [EMAIL PROTECTED]
World Wide Web: http:/www.coldgen.com/
-----Original Message-----
From: Cedric Villat [mailto:[EMAIL PROTECTED]
Sent: Friday, 12 December 2003 4:26 PM
To: CF-Talk
Subject: Selecting consecutive records
In MySQL there is a LIMIT function when selecting records. This allows for
an beginning row and then to select the next N rows. Is there an equivalent
function for MSSQL or Access? It LIMIT a standard SQL function? If not, what
is the best way to select, say 10 rows from the middle of a set of records?
Obviously I don't want to select 1,000,000 records if I only want records
100-200. Any ideas?
Cedric
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
