[thelist] Coldfusion/SQL:queries:maxrows

Bimal Shah bimal.shah at venus.co.uk
Mon Sep 17 07:18:03 CDT 2001

I'm getting an error - is "TOP" supported in MySQL?


-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Seamus Campbell
Sent: 17 September 2001 13:09
To: thelist at lists.evolt.org
Subject: Re: [thelist] Coldfusion/SQL:queries:maxrows

<cfquery name="test" datasource="#request.DSN#">

SELECT TOP 1 (productID), ProductDesc

FROM    tblproduct


Above is sql - this is quicker I believe
I think it is because the sql only searches the top 1 row
while CF searches the whole database then returns 1 row (I think)


For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt ! 

More information about the thelist mailing list