is the error you are recieving an ODBC/SQL error or is it CF? -----Original Message----- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: 24 June 2003 14:10 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] SQL Server Binary
no, tried everything I can think of. Even using the functions inside and outside the query in case that made any difference. It might be an issue with the Pivotal database content. Since all the identification fields are binary for security reasons..... Need to find a way round it somehow though -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 24 June 2003 14:00 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] SQL Server Binary if you remove the quotes on the insert does that make a difference? -----Original Message----- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: 24 June 2003 14:03 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] SQL Server Binary noticed that neil still not working though, getting the following error message "ByteArray objects cannot be converted to strings" Am setting the var, checking its binary using isBinary(), that comes up as yes. Try inserting it to a field which is binary and get the message above. Have even tried setting it to toBase64, then using toBinary and then inserting it, but getting the same message Every seen that before? -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 24 June 2003 13:29 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] SQL Server Binary 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] -- ** 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]
