> 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]