ConCat question

[elentz]

I have an update query that I want to use. Here's what I have so far:
update vtiger_accountscf Set vtiger_accountscf.cf_700 = CONCAT('localhost/customstuff/statements/ex.php?accountid=',(accountid))
The accountid field is in the same table.

The problem i am having is that the value of the accountid field isn't appending to the end of the entry, I get
localhost/customstuff/statements/ex.php?accountid=

What have I got wrong?

Thanks

 

[r937]

it shouldn't make a difference, but try it without the parentheses around accountid

r937.com | rudy.ca

 

[elentz]

Well, I removed the () and made sure my field was big enough it was 50 and I changed it to 255 and it works.

Thanks!