| Jean-Marc Guillermin 2007-03-22, 6:57 pm |
| Hi Laitha,
And with backslashes before them ??
jm
----- Original Message -----
From: "Lasitha Alawatta" <lasitha_lk@yahoo.co.uk>
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=
> 'aind@abc.net;', ";
> $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.
|