var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how do i use multiple lines with SET @var =
Just hit the problem in a procedure that LIMIT only takes constants and not variables. So having to resort to a workaround being to put the query in a statement.
set @q = 'select * from t1 limit ?,?';
set @l1=10, @l2=1;
prepare q from @q;
execute q using @l1,@l2;
Problem is my actual query is 20 lines long so how do i put that in the set @ = without having to put the whole thing on one line.
set @q =
keeps giving me errors, what's the syntax for this ?
set @q = "select *";
set @q = concat( @q , " from t1");
set @q = concat( @q , " limit ?,?");
Not very elegant is it... no nicer way ?