Well, even though ignoring the error's (which is actually just an
informational message), you could call the error_reporting function
right above the line throwing the message, and then again below that
line, turning error_reporting back to the default level.
On Thu, 2004-02-19 at 16:38, Michael Flanagan wrote:
> Adam, Thanks for the suggestions. I don't want to ignore all error
> handling. Later, I might get an error that I really don't want php to
> swallow due to either of your suggestions.
> Has anyone else run into this and solved it?
> Any idea why the following lines in the php.ini file don't work?
> mssql.min_error_severity = 11
> mssql.min_message_severity = 11
> -----Original Message-----
> From: Adam Voigt [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 19, 2004 12:44 PM
> To: Michael Flanagan
> Cc: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] MS SQL 'Changed database context' error
> Try putting the error suppressor (@) before the query, eg:
> Or, try setting the error reporting:
> On Thu, 2004-02-19 at 14:38, Michael Flanagan wrote:
> > Thanks, Adam.
> > I don't get the error in Enterprise manager. MS has a KB article out that
> > says that this message is informational. I seem to remember that the
> > article also says the message comes out some times, and not other times,
> > that you should just forget it.
> > The particular SELECT statement I'm getting the message on is the second
> > query in my script. The other query is to the same db; in fact, it uses
> > exact same $db connection object.
> > Any ideas on getting PHP to ignore this info message?
> > Thanks again.
> > Michael
> > -----Original Message-----
> > From: Adam Voigt [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, February 19, 2004 12:13 PM
> > To: Michael Flanagan
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [PHP-DB] MS SQL 'Changed database context' error
> > This may not be the case, but I've seen this before when the PHP library
> > didn't know how to express MS SQL's error, so it simply returns the last
> > message sent which was the informational context change. If it is infact
> > an error, you should be able to plug the query directly into Enterprise
> > Manager to see MS SQL's take on the problem, so to speak. =)
> > But again, this is all just in my past experience's, yours may differ
> > greatly.
> > On Thu, 2004-02-19 at 14:08, Michael Flanagan wrote:
> > > I'm getting the error "Changed database context" from MS SQL. I see
> > > where this is supposedly just an informational message. I've tried
> > > setting
> > >
> > > mssql.min_error_severity = 11
> > > mssql.min_message_severity = 11
> > >
> > > but to no avail. What am I missing? I don't mind the message so much,
> > > but php treats this as an error, and doesn't execute my query.
> > >
> > > I'm running php 4.3.3 for Windows; the SQL Server and web server are on
> > the
> > > same machine. I'm using PEAR:DB for the database access.
> > >
> > > Thanks.
> > >
> > > Michael Flanagan
> > > voice: (1) 303-674-2691
> > > fax: (1) 603-963-0704 (note '603' area code)
> > > mailto:[EMAIL PROTECTED]
> > --
> > Adam Voigt
> > [EMAIL PROTECTED]
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> Adam Voigt
> [EMAIL PROTECTED]
> 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