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]
