----- Original Message -----
From: Bert Dawson
To: CF-Talk
Sent: Monday, July 19, 2004 2:10 PM
Subject: Re: Problem with SQL Server and CF5
just a guess as i haven't got access to a CF5 box this second, but try changing it to:
<cfquery name="qry_MakeThumbnailList" dbtype="query">
SELECT [name] AS filename
FROM imagelist
</cfquery>
It might not like the "name" column
(i would expect MX to complain about it but it doesn't seem to mind either way...)
Cheers
Bert
________________________________
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: 19 July 2004 19:02
To: CF-Talk
Subject: Re: Problem with SQL Server and CF5
Here is what the lines around the error say.
<cfdirectory action="" directory="#thisDirectory##qry_GetDirectoryNames.GalleryDirectory#" name="imagelist" filter="*.jpg">
<cfquery name="qry_MakeThumbnailList" dbtype="query">
Select name from imagelist
</cfquery>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
