[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    Re: [PHP-DB] SQL unexpected T_CONSTANT_ENCAPSED_STRING  Error
From:       "Jean-Marc Guillermin" <jm () jmgdev ! net>
Date:       2007-03-22 13:28:53
Message-ID: 003d01c76c86$09050590$0301a8c0 () laptop
[Download RAW message or body]

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. 

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

[prev in list] [next in list] [prev in thread] [next in thread]