Ooops, my bad.. at first glance, I thought I saw varchar. Then remembered that you were using mssql. In mySql, there are 3 blob datatypes... which is what I am used to looking at. Anyway...
> -----Original Message----- > From: Archie Campbell [mailto:[EMAIL PROTECTED] > Sent: Monday, December 04, 2006 9:39 PM > To: CF-Newbie > Subject: Re: HowTo store a PDF or JPEG file in a MS SQL 2005 database > > Michael E. Carluen wrote: > > NP. You might want to consider changing TranDataBinary into a blob > datatype > > for better support. > > > > TranDataBinary is defined as varBinary(MAX) > > That is a BLOB, right? > > Anyway, as Bob mentioned earlier, he and probably a good number of > > developers still prefer storing files in a file directory, as there are > > advantages and disadvantages for using either technique. Probably you > can > > do a poll on a different thread to find out the general consensus in the > > community- if you want to find out. > > > > > > > > > >> -----Original Message----- > >> From: Archie Campbell [mailto:[EMAIL PROTECTED] > >> Sent: Monday, December 04, 2006 8:30 PM > >> To: CF-Newbie > >> Subject: Re: HowTo store a PDF or JPEG file in a MS SQL 2005 database > >> > >> Hi Michael > >> > >> My first exposure to <cfqueryparam. > >> Thanks for that. > >> Taking what you said caused I got the right result. > >> > >> What you suggested did not work for me > >> because TranDataBinary is a varBinary(MAX) > >> > >> If it had been varchar(MAX), that would have done it > >> cuz base64 converts binary to char representation. > >> > >> This worked nicely: > >> > >> <cffile action="READBINARY" > >> file="#InPdfFullname#" > >> variable="binPdf"> > >> <cfquery name="updateTransfer" datasource="xxxxx#"> > >> UPDATE fmTransfer > >> SET TranDataBinary = (<cfqueryparam value='#binPdf#' > >> cfsqltype="CF_SQL_BLOB">) > >> WHERE TranFormId = 'AAA158AC' > >> </cfquery> > >> > >> Plus I now know about > >> ToBase64() > >> ToBinary() > >> > >> Many thanks Michael > >> > >> Archie > >> > >> > >> > >> Michael E. Carluen wrote: > >> > >>> Archie, > >>> > >>> > >>> > >>> > >>>> <cffile action="READBINARY" > >>>> file="#InPdfFullname#" > >>>> variable="binPdf"> > >>>> > >>>> > >>> >From here, convert to base64() > >>> > >>> <cfset tempvar = tobase64(binPdf)> > >>> > >>> > >>> Then insert as a blob > >>> > >>> > >>> > >>>> <cfquery name="updateTransfer" datasource="xxxxxxx"> > >>>> UPDATE fmTransfer > >>>> SET TranDataBinary = (<cfqueryparam value="#tempvar#" > >>>> > >>>> > >>> cfsqltype="CF_SQL_BLOB">) > >>> > >>> > >>>> WHERE TranFormId = 'AAA158AC' > >>>> </cfquery> > >>>> > >>>> > >>> HTH > >>> > >>> Michael > >>> > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2306 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
