UPDATING the last field in a table?

[maverik59]

Easyone for u SQL guys, how do i update the last record in a table?
I have this but it doesn't work
UPDATE usertrack SET heading_to = "123" WHERE unique_id=max(unique_id)

 

[DaPi]

Should be something like:

UPDATE usertrack SET heading_to = "123" WHERE unique_id=
(select max(unique_id) from usertrack)

 

[DaPi]

OOPS - should be single NOT double quotes to delimit the string: '123'

 

[maverik59]

It still doesn't work??
Error Executing Database Query.
Syntax error or access violation: You have an error in your SQL syntax near ' UPDATE usertrack SET heading_to = '/images/orgcharts/busimprovement.jpg' WHERE unique_id= (select max(unique_id) from usertrack)
DATASOURCE luthor
VENDORERRORCODE 1064
SQLSTATE 42000

 

[DaPi]

"Syntax error" - looks OK to me, but . . . . .

"or access violation" - do you have update rights on the table?

 

[maverik59]

I have worked out that my database (mascon) or server (coldfusion) does not support subqueries. Perhaps I can split the SQL and store them in variables.
Many Thanks for your help.