[filename] from dbo.[Attachment] where id = '01057870'
I don't know if that would make any difference, but I know I've had
trouble in the past with using reserved words.
John Burns
-----Original Message-----
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 11:52 AM
To: CF-Talk
Subject: Re: cfx_getImage error! Don't know what's causing it
I changed the code a select statement a bit. I appended 'dbo.' before
the table name.
<CFX_GETIMAGE
DATASOURCE="db"
USER="dbUserName"
PASSWORD="dbPassword"
SQL="select filename FROM dbo.Attachment WHERE id = '#url.id#'"
OUTPUT="E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.Fil
eName#">
This was the error I was getting before I made the above change:
SQL:select filename FROM Attachment WHERE id = '01057870'
SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg =
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'Attachment'.
pcbErrorMsg = 93
And this is what I get now:
SQL:select filename FROM Attachment WHERE id = '01057870'
SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg =
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'dbo.CallComments_attachment'.
pcbErrorMsg = 97
Notice the difference in the pcbErrorMsg value. Does that tell you
anything?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
