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 ?
UPDATE tblProfiles
(
strSelect,
strShowMe
)
> Hi,
>
> Could someone tell me where I'm going wrong with the below
> ?
>
>
> UPDATE tblProfiles
> (
> strSelect,
> strShowMe
> )
> VALUES
> (
>cfsqltype="CF_SQL_LONGVARCHAR">, value="#form.dir_access#" cfsqltype="CF_SQL_LONGVARCHAR"> ) WHERE
> strUsername = '#auth#'
>
For MS SQ
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:
Hi,
Could someone tell me where I'm going wrong with the below ?
UPDATE tblProfiles
(
strSelect,
strShowMe
)
VALUES
(
,
)
WHERE strUsername = '#auth#'
~~~
4 matches
Mail list logo