elentz Posted November 26, 2008 Share Posted November 26, 2008 I am trying to get a Concat query to add put some text into a mysql field along with adding another field value at the end I have: update vtiger_accountscf Set vtiger_accountscf.cf_700 = CONCAT('localhost/customstuff/statements/ex.php?accountid=',(accountid)) I get localhost/customstuff/statements/ex.php?accountid= and that is all. the last accountid is a field in the vtigeraccounts_cf table. When I run the query I never get the accountid added to the line. Can someone show me where I am going wrong here? Thanks Alot Link to comment https://forums.phpfreaks.com/topic/134416-solved-concat-question/ Share on other sites More sharing options...
bogeyman Posted November 27, 2008 Share Posted November 27, 2008 Is your field's length long enough? Link to comment https://forums.phpfreaks.com/topic/134416-solved-concat-question/#findComment-700060 Share on other sites More sharing options...
elentz Posted November 27, 2008 Author Share Posted November 27, 2008 The field is a VarChar(255) so that should be OK Link to comment https://forums.phpfreaks.com/topic/134416-solved-concat-question/#findComment-700070 Share on other sites More sharing options...
elentz Posted November 27, 2008 Author Share Posted November 27, 2008 I was wrong!! The test DB I was using had that field at50 changing it to 255 like the production system and it works! Thanks for the help! Happy Thanksgiving Link to comment https://forums.phpfreaks.com/topic/134416-solved-concat-question/#findComment-700078 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.