heh
looks like an INSERT query to me ;)
try
UPDATE tblProfiles
Set blah = blah,
blah2 = blah2
where blah = blah
cheers
----- Original Message -----
From: "Bushy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, August 14, 2003 9:51 AM
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
