>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.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]
