'Attachment'.
This error says the table "Attachment" doesn't exist in the database.
Does it exist in your DATASOURCE="db"?
-----Original Message-----
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 9:33 AM
To: CF-Talk
Subject: cfx_getImage error! Don't know what's causing it
Hello Everybody, I'm really hoping that someone will help me.
A lot of people have used the cfx_getImage tag to open up office
documents (word,excel, blah). I thought I'll use it to do the same. The
documents are stored on the database table as binary objects.
I registered the cfx tag in the administrator. I'm calling it on the
page like this:
<cfquery name="getAttachmentDetails" datasource="db"> select * from
Attachment where id = '#url.id#'
</cfquery>
<CFX_GETIMAGE
DATASOURCE="db"
USER="dbUserName"
PASSWORD="dbPassword"
SQL="select filename FROM Attachment WHERE id = '#url.id#'"
OUTPUT="E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.Fil
eName#">
I get this error message:
The error occurred in
E:\inetpub\wwwroot\viewattachment.cfm: line 8
6 : <CFX_GETIMAGE
7 : DATASOURCE="db"
8 : USER="dbUserName"
9 : PASSWORD="dbPassword"
10 : SQL="select filename FROM Attachment WHERE id =
'#url.id#'"
(USER="dbUserName" is in bold)
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
Does anybody know why I'm getting this error? I would really appreciate
your help
Regards,
cfcoder
__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
