Posted by Mike Smith on 04/28/05 15:51

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.

[Back to original message]