[PHP-DB] SQL unexpected T_CONSTANT_ENCAPSED_STRING Error

2007-03-22 Thread Lasitha Alawatta 
Hi All,
   
  I have a sql script unable to execute. Because I need to insert double-coats 
(  ) also to one field(SPParams field).
   
  Ones I execuit this using mysql_query($sql), it gives Parse error: parse 
error, unexpected T_CONSTANT_ENCAPSED_STRING  error message.
   
   
 $strSql = ;
   $strSql = $strSql.UPDATE Masters.tblBranches SET FHeadMail= '[EMAIL 
PROTECTED];', ;
   $strSql = $strSql.BranchDBConnection='Server=SLBC05; Database=BackOffice; 
UID=b0;pwd=sSLap.+05);', ;
   $strSql = $strSql.SPParams='pliplp id=spCustomersAddSLBC 
t=VarCharCustomerName/pp id=spCustomersAddSLBC 
t=TinyIntCustomerType/p' ;   
   $strSql = $strSql.WHERE BranchCode=101;
   
  How can I be able to solve this issue..?
   
   
  Thank you very much,
  Lasitha


-
 What kind of emailer are you? Find out today - get a free analysis of your 
email personality. Take the quiz at the Yahoo! Mail Championship.

Re: [PHP-DB] SQL unexpected T_CONSTANT_ENCAPSED_STRING Error

2007-03-22 Thread Jean-Marc Guillermin 

Hi Laitha,

And with backslashes before them ??

jm

- Original Message - 
From: Lasitha Alawatta [EMAIL PROTECTED]

To: php-db@lists.php.net
Sent: Thursday, March 22, 2007 2:06 PM
Subject: [PHP-DB] SQL unexpected T_CONSTANT_ENCAPSED_STRING Error



Hi All,

 I have a sql script unable to execute. Because I need to insert 
double-coats (  ) also to one field(SPParams field).


 Ones I execuit this using mysql_query($sql), it gives Parse error: parse 
error, unexpected T_CONSTANT_ENCAPSED_STRING  error message.



$strSql = ;
  $strSql = $strSql.UPDATE Masters.tblBranches SET FHeadMail= 
'[EMAIL PROTECTED];', ;
  $strSql = $strSql.BranchDBConnection='Server=SLBC05; 
Database=BackOffice; UID=b0;pwd=sSLap.+05);', ;
  $strSql = $strSql.SPParams='pliplp id=spCustomersAddSLBC 
t=VarCharCustomerName/pp id=spCustomersAddSLBC 
t=TinyIntCustomerType/p' ;

  $strSql = $strSql.WHERE BranchCode=101;

 How can I be able to solve this issue..?


 Thank you very much,
 Lasitha


-
What kind of emailer are you? Find out today - get a free analysis of your 
email personality. Take the quiz at the Yahoo! Mail Championship. 


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php