Re: cfx_getImage error! Don't know what's causing it

[cf coder]

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]

---