If i were you i'd create a template with just the cfdirectory, cfquery QofQ, and a cfdump and take it from there, twaeking bits till you get to the root cause.
eg :
Replace the cfdirectory with a dummy hand made recordset using queryNew() etc - does the QofQ still break?
Try "SELECT *..." in the QofQ?
Does the error go away if you replace the QofQ with a dummy made query (using QueryNew(), QueryAddRow() etc)?
I suppose this highlights the problems f developing on one version and deploying on another...
Bert
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: 19 July 2004 20:30
To: CF-Talk
Subject: Re: Problem with SQL Server and CF5
Gave me the same error. Strange it works on my machine.
----- 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>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
