Pascal
> -----Original Message-----
> From: Garcia Freddys [mailto:[EMAIL PROTECTED]
> Sent: 08 September 2004 16:07
> To: CF-Talk
> Subject: [Spam?] memo (varbinary) update using CFMX 6.1
>
> Hi everybody,
> I'm having some difficulty using CFMX 6.1 to do an update on a table
> because the field I'm trying to update happens to be what MSQL calls a
> "memo" field. That particular column shows up as a varbinary in
> Dreamweaver. Below is the code I was hoping was going to work, but no
> luck so far. Any links or guidance would be greatly appreciated.
> Thanks,
> Freddys
>
> <cftry>
> <cfquery name="updatebio" datasource="CLIPdb">
> UPDATE LegBio
> SET FormerPoliticalExp = <cfqueryparam
value="#form.FormerPoliticalExp#"
>
> cfsqltype="CF_SQL_VARBINARY">
> WHERE NameID = #form.NameID#;
> </cfquery>
> <cfcatch type="Database">There was a database error!</cfcatch>
</cftry>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
