Update has more then one entry..

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

charmed0rz - 30 Sep 2004 14:25 GMT

Could i just do it like this?

update Guild
set guildid = ""
set guildname = ""
set memberfor = ""

or do i need commas or what? also.. how do i set them to a blank field, could
i just do ""'s? i get the error

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Syntax error (missing operator) in query expression '[] set
guildname = [] set memberfor = [] set rank = [].

Reply to this Message

Defuse - 30 Sep 2004 14:29 GMT

update Guild
set guildid = "",
guildname = "",
memberfor = ""

All you need is one SET and then you separate the fields by commas. Be sure
that on the last field do not put a comma after the value - you'll get an
error. To set a blank field you can either use " " or you can just ignore it.
You don't have to update every field at the same time.

HTH

Reply to this Message

charmed0rz - 30 Sep 2004 14:45 GMT

im getting tired of the too few paremeters errors.. *sigh*

<cfquery datasource="userlogin">
update Guild
set guildid = "",
    guildname = "",
    memberfor = "",
    rank = "",
    opiniononguild = ""
    where user_id = '#session.user_id#'
</cfquery>

those fields, plus user_ID are in guild table... why am i getting this :S all
fields are text...

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Too few parameters. Expected 1.

Reply to this Message

Webmaster Forum / ColdFusion / Getting Started / September 2004

Update has more then one entry..