Re: Query runs fine on Console but not in PHP

Thanks for your response. My script is running on Linux. I am trying to retrieve simple data such as text and numbers. I am not sure what the TDS protocol setting should be. What are the typical settings and how can I check it? Would appreciate any tips for debugging. Thanks. ----- Original Message ----- From: "Robert Twitty" <rtwitty@neutron.ushmm.org> To: "vish.kohli" <vish.kohli@attbi.com> Cc: <php-db@lists.php.net> Sent: Monday, August 18, 2003 8:28 AM Subject: Re: [PHP-DB] Query runs fine on Console but not in PHP > What platform are you using? Since it appears that the script is > crashing, you are probably on Linux or some other UNIX flavor. If this is > the case, the TDS protocol setting may not be correct. What type of date > are you retrieving with this stored procedure? > > -- bob > > On Sun, 17 Aug 2003, vish.kohli wrote: > > > Hi, > > > > I am trying to execute a stored procedure in PHP via mssql_query () > > function. I pass 8 parameters to it. > > The query runs fine in SQL Query Analyzer but when I run it thru PHP, it > > behaves strangely. I can get number of rows (mssql_num_rows()) and number of > > fields (mssql_num_fields()) in PHP, but when I try to execute > > mssql_fetch_object() or mssql_fetch_array() on the same result identifier, I > > get a "Page could not be displayed" (standard internet error page). > > > > Please help. > > Thanks in advance. > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >