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.FileName#">
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]
