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

For MS SQL, the format for an update statement is, in general,
UPDATE tablename
SET col1=value1, col2=value2...
WHERE keycolumn=value3

Stephen
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Reply via email to