Re: Retrieving query from MSSQL Table
| From: | Mike Smith | Date: | Thu, 28 Apr 2005 12:51:23 +0000 |
| Subject: | Re: Retrieving query from MSSQL Table | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-214085@lists.php.net to get a copy of this message | ||
On 4/28/05, Richard Lynch <ceo@l-i-e.com> wrote:
> I'm betting dollars to doughnuts that you've got a newline at the end of
> $sql1 which is messing you up.
You're right! Give that man a doughnut! When I tested the query in
Query Analyzer. I hit [Enter] to format the query and make it
readable, then copy-and-paste into the form. I have tried:
str_replace("\n","",$sql1);
and
preg_replace("\n","",$sql1);
to pull the new line out plus a few other variations. Those failed.
I'll keep at, but any pointers are always appreciated.