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#
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
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
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
4 matches
Mail list logo