[thelist] Coldfusion/SQL:queries:maxrows

Jon Haworth jhaworth at witanjardine.co.uk
Mon Sep 17 09:35:54 CDT 2001


Try 

SELECT ProductID, ProductDesc FROM tblProduct LIMIT 1

HTH
Jon


-----Original Message-----
From: Bimal Shah [mailto:bimal.shah at venus.co.uk]
Sent: 17 September 2001 13:14
To: thelist at lists.evolt.org
Subject: RE: [thelist] Coldfusion/SQL:queries:maxrows


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>


**********************************************************************
'The information included in this Email is of a confidential nature and is 
intended only for the addressee. If you are not the intended addressee, 
any disclosure, copying or distribution by you is prohibited and may be 
unlawful. Disclosure to any party other than the addressee, whether 
inadvertent or otherwise is not intended to waive privilege or confidentiality'

**********************************************************************





More information about the thelist mailing list