Hi jacob,
My DB is Oracle 9i. It supports BLOB data type. I also tried with this
data type but the following is the error.
Error Executing Database Query. [Macromedia][Oracle JDBC Driver]The specified
SQL type is not supported by this driver.
But in our production sites this update is working fine using the cfupdate
only with column of LONG data type. But this is not working in our local test.
Thanks
Sunil R
"Munson, Jacob" <[EMAIL PROTECTED]> wrote:
Have you tried using the binary or blob datatype, or whatever your DB
supports? What DB are you using?
> -----Original Message-----
> From: sunil kumar [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 09, 2006 3:58 AM
>
> Hi,
>
> I am getting an error like Invalid Parameter Binding when i
> am using cfupdate. The scenario is as follows:
>
> I am trying to upload a file(word document). First i will
> upload the file name and some parameters associated to it.
> Then i will get the contents of the file using the > action="ReadBinary"> and
> i am trying to insert this into into
> the DB for a column of LONG data type using CFUPDATE. Then i
> am getting an error message like "Invalid Parameter Binding".
>
> Also i tried using the cfstoredproc by passing the the
> argument to a stored proc using the cfprocparam and cfsqltype
> of sql_type_longvarchar. Then i am getting an error like
> "Unimplemented or Unreasonable Conversion Requested".
>
> Can any one please suggest me why i am getting these
> errors? and help me in solving this.
This transmission may contain information that is privileged, confidential
and/or exempt from disclosure under applicable law. If you are not the intended
recipient, you are hereby notified that any disclosure, copying, distribution,
or use of the information contained herein (including any reliance thereon) is
STRICTLY PROHIBITED. If you received this transmission in error, please
immediately contact the sender and destroy the material in its entirety,
whether in electronic or hard copy format. Thank you. A1.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243134
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
