FYI : if you use ToBase64() that will convert it into a string representation....it needs to be converted back to binary!
-----Original Message----- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: 24 June 2003 13:29 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] SQL Server Binary another quicky Once its stored in a variable (i'm storing it as a session variable), whats the best way to input it into a different SQL Server DB through cfquery? I've played around with tobase64 and also the convert function, but can't seem to tie down the syntax/function needed and have little time to spend on the issue. If someones got something handy, would be grateful mark -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 23 June 2003 14:33 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] SQL Server Binary > this. CFSET is > not working. <cfquery name="myQry"> SELECT myBinaryField FROM myDB </cfquery> <cfif myQry.recordcount> <cfset myLocalBinaryVariable = myQry.myBinaryField[1]> </cfif> will do it. > -----Original Message----- > From: Mark Smyth [mailto:[EMAIL PROTECTED] > Sent: 23 June 2003 14:34 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] SQL Server Binary > > > Guys > > I'm pulling information out from a SQL Server Binary field > and then need to > assign the data to a variable, anyone the easiest way to do > this. CFSET is > not working. > > > > Kind Regards > Mark Smyth > > Internet Systems Developer > REDtechnology.com > +44 (01865) 880800 > www.REDtechnology.com > > Email Disclaimer: "This e-mail is for the use of the intended > recipient(s) > only. Any views or opinions presented are solely those of > the author and do > not necessarily represent those of REDtechnology.com or any of it's > Affiliates. If you are not the intended recipient, be advised > that you have > received this email in error and that any use, dissemination, > forwarding, > printing, or copying of this email is strictly prohibited. We > have taken > precautions to minimize the risk of transmitting software > viruses, but we > advise you to carry out your own virus checks on any > attachment to this > message. We cannot accept liability for any loss or damage caused by > software viruses." > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
