Re: SQL unexpected T_CONSTANT_ENCAPSED_STRING Error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Laitha,

And with backslashes before them ??

jm

----- Original Message ----- From: "Lasitha Alawatta" <lasitha_lk@xxxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Sent: Thursday, March 22, 2007 2:06 PM
Subject:  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= 'aind@xxxxxxx;', "; $strSql = $strSql."BranchDBConnection='Server=SLBC05; Database=BackOffice; UID=b0;pwd=sSLap.+05);', "; $strSql = $strSql."SPParams='<pl><ipl><p id="spCustomersAddSLBC" t="VarChar">CustomerName</p><p id="spCustomersAddSLBC" t="TinyInt">CustomerType</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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux