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 Quote Link to comment Share on other sites More sharing options...
bogeyman Posted November 27, 2008 Share Posted November 27, 2008 Is your field's length long enough? Quote Link to comment 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 Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.