[thelist] Coldfusion/SQL:queries:maxrows

[Bimal Shah]

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

Bimal

-----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

</cfquery>


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)

Seamus



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