update tblProfiles
set strSelect =         <cfqueryparam value="#No_Access_List#"
cfsqltype="CF_SQL_LONGVARCHAR">,
strShowMe = <cfqueryparam value="#form.dir_access#"
cfsqltype="CF_SQL_LONGVARCHAR">
where strUsername = '#auth#'

:) hth

tw

tony weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
office 410.548.2337
fax 410.860.2337


-----Original Message-----
From: Bushy [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 14, 2003 12:52 PM
To: CF-Talk
Subject: re: MS SQL UPDATE syntax help


Hi,

Could someone tell me where I'm going wrong with the below <cfquery>?

<cfquery name="qUpdateProfile" datasource="prefs">
        UPDATE tblProfiles
        (
        strSelect,
        strShowMe
        )
        VALUES
        (
        <cfqueryparam value="#No_Access_List#"
cfsqltype="CF_SQL_LONGVARCHAR">,
        <cfqueryparam value="#form.dir_access#"
cfsqltype="CF_SQL_LONGVARCHAR">
        )
        WHERE strUsername = '#auth#'
</cfquery>





~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com

Reply via email to