Re: [PHP] Retrieving query from MSSQL Table

2005-04-28 Thread Mike Smith
On 4/28/05, Richard Lynch [EMAIL PROTECTED] 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,

Re: [PHP] Retrieving query from MSSQL Table

2005-04-28 Thread Richard Lynch
On Thu, April 28, 2005 5:51 am, Mike Smith said: On 4/28/05, Richard Lynch [EMAIL PROTECTED] 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

Re: [PHP] Retrieving query from MSSQL Table

2005-04-28 Thread Mike Smith
Thanks Richard, That did the trick. That and one query was in another database, that my users didn't have rights to...Doh! Works well. Thanks, Mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Retrieving query from MSSQL Table

2005-04-27 Thread Richard Lynch
On Wed, April 27, 2005 1:29 pm, Mike Smith said: I have a form where I can submit a Query to be run against a MSSQL 2000 Server. The query is stored correctly in a text (DataType) column. I can retrieve it echo it back to the screen, copy-n-paste into Query Analyzer and the query works.