SQL: UPDATE query error value being used for column

Question

I have a PHP sql command that updates a record.

$tsql = "UPDATE cplinktable SET bmsid = $bmsid, autotaskid = $autotaskid, waspdb = $waspdb, cpid = $cpid WHERE id = $id";

I'm getting an error:

Invalid column name 'WaspTrackAsset_SFT'. [message] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'WaspTrackAsset_SFT'. ) )

Is there some reason that the value of waspdb is being used as a column?

thanks,

Jonesy

Andomar · Accepted Answer · 2010-10-19 14:31:59Z

3

If the variable is a string, SQL requires single quotes around it:

waspdb = '$waspdb'

Otherwise, it will look in the source row for a column with the name of the value of $wasdb. The reason why is perhaps most clearly illustrated with an example query:

update YourTable set col1 = 2*col2

This multiplies col2 by 2; it doesn't set col1 to '2*col2' :)

answered Oct 19, 2010 at 14:31

Andomar

239k55 gold badges387 silver badges412 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

John Hartsock · Accepted Answer · 2010-10-19 14:31:02Z

1

Its a string field or varchar probably and you need it in single quotes. Like this:

$tsql = "UPDATE cplinktable SET bmsid = $bmsid, autotaskid = $autotaskid, waspdb = '$waspdb', cpid = $cpid WHERE id = $id"

answered Oct 19, 2010 at 14:31

John Hartsock

87.1k23 gold badges135 silver badges146 bronze badges

Collectives™ on Stack Overflow

SQL: UPDATE query error value being used for column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related