James,
My code is converting the data into Base64 first and then only trying to
insert it into the DB for LONG data type. This is working perfectly fine in our
production sites But not in our local test sites. I am not able to get this
behaviour with CFUPDATE?
Thanks
Sunil R
James Holmes <[EMAIL PROTECTED]> wrote:
First, good luck getting the binary back on one piece, since putting
binary directly into a character datatype is asking for trouble. If
you must use LONG in the DB, convert the binary data to Base64 first.
Then you can use LONG or CLOB or whatever you like.
If you are using CF Enterprise, use the CF_SQL_BLOB type for this and
insert the binary in there directly. If you are not, perhaps the above
Base64 conversion will fix things.
On 6/10/06, sunil kumar wrote:
> 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" 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.
--
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243165
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
