INSERT INTO myTABLE(myBinaryField)
VALUES('#myLocalBinaryVariable#')
> -----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]
