RE: [PHP-WIN] Re: or die problem

Guys, A comment: updates and inserts does not return anything particular. I suspect that an update then always will be iterpreted as false by "or die()" independet of the result of the query. I suggest testing this hypothesis by doing as somebody sugegsted: EXECTUTE QUERY TEST FOR ERRORS IF ERROR DETECTED THEN DIE Secondly, I wonder why not some kind of error recovering is atempted if the query fails, or at least a bit more informative error message is prompted. -----Original Message----- From: Stephen To: Charles P. Killmer Cc: Windows Helplist (PHP) Sent: 2003-06-27 19:34 Subject: Re: [PHP-WIN] Re: or die problem No, it is exactly the problem. || is only used in evaluation statements such as if, while, etc etc. Or is used when something must return a value to work, Or if it returns false (nothing), then to do the other section. "Do This Query and Return True / a value" OR "Do this if the query returns false"; Stephen ----- Original Message ----- From: "Charles P. Killmer" <charlesk@netgaintechnology.com> To: <php-windows@lists.php.net> Sent: Friday, June 27, 2003 6:10 PM Subject: RE: [PHP-WIN] Re: or die problem If you notice he has it commented out. I doubt that that was the problem. I read somewhere a while ago about a difference in operator precedence between || and or. Perhaps the die is being invooked first? Charles Killmer -----Original Message----- From: Stephen [mailto:stephen.edmonds5@btinternet.com] Sent: Friday, June 27, 2003 12:01 PM To: Croskerry, Dan Cc: Windows Helplist (PHP) Subject: Re: [PHP-WIN] Re: or die problem Dan, mssql_query($sql); // or die ("insert failed") When you use or die, you must NOT have a ; on the end of the mssql_query eg mssql_query( $MyQuery ) OR die( 'Error' ); Notice the ; only goes on to the end of the or die command. Stephen ----- Original Message ----- From: "Croskerry, Dan" <dcrosker@hpl.ca> To: <php-windows@lists.php.net> Sent: Friday, June 27, 2003 5:43 PM Subject: RE: [PHP-WIN] Re: or die problem > It's a straight forward update statement. Like I said, it works, the > data is > written to the DB even with the or die so I'm not sure why the die is > invoked. > > $sql = "UPDATE Helpline SET > morn_pers='".$FV['morn_pers']."', > aft_pers='".$FV['aft_pers']."', > eve_pers='".$FV['eve_pers']."', "; > $sql .= " notes='".$FV['notes']."' WHERE > help_date='".$FV['insertDate']."' "; $result = > mssql_query($sql); // > or die ("insert failed") > > -----Original Message----- > From: Shaffin Bhanji [mailto:Shaffin.Bhanji@novell.com] > Sent: Friday, June 27, 2003 12:39 PM > To: dcrosker@hpl.ca; cristic@iakt.rdsnet.ro; php-windows@lists.php.net > Subject: RE: [PHP-WIN] Re: or die problem > > > It might help if you can post your code snippet! > > >>> "Croskerry, Dan" <dcrosker@hpl.ca> 27/06/2003 12:28:13 pm > >>> >>> > There is no error message. It happens mostly when I am doing an update > or insert statement. There is no problem with the sql because the data > gets written to the db. If I use or die it still writes to the db but > the or die > kills the processing. It's strange. > > -----Original Message----- > From: Cristian MARIN [ mailto:cristic@iakt.rdsnet.ro] > <mailto:cristic@iakt.rdsnet.ro]> > Sent: Friday, June 27, 2003 10:18 PM > To: php-windows@lists.php.net > <mailto:php-windows@lists.php.net> > Subject: [PHP-WIN] Re: or die problem > > > Maybe not the query is the problem, maybe the connection or the > authentication ... Try executing the sql without the die part and then print > out the > mysql_error() if the mysql_errno()!=0 > > mysql_query($your_query_here); > if (mysql_errno()!=0){ > die (mysql_error()); > } > > > -- > ------------------------------------------------- > Cristian MARIN - Developer > InterAKT Online ( www.interakt.ro > <http://www.interakt.ro> ) > Tel: +4021 312.53.12 > Tel/Fax: +4021 312.51.91 > cristic@interakt.ro <mailto:cristic@interakt.ro> > "Dan Croskerry" < dcrosker@hpl.ca > <mailto:dcrosker@hpl.ca> > wrote in > message > > news:944AF5792FE8D411A7810002A5070498084172C7@corvus.hamilton.ca > <mailto:news:944AF5792FE8D411A7810002A5070498084172C7@corvus.hamilton.ca > > ... > > I'm new to the windows platform for php development and I have been > > having problems with the or die function when running sql queries. > > It is being called even when I run a valid query. I have tested it > > with valid queries and it is always triggered. I have had to stop > > using it which is not good. > I > > never had problems with or die when I was working in a linux > > environment. > > > > Does anyone know if there is a setting in the php.ini file that I > > have to set for or die to work? My DB is MS SQL 2000. > > > > Thanks in advance, > > Dan > > > > > > -- > PHP Windows Mailing List ( http://www.php.net/ <[™¬Â7äʲ=( > º-=9http://www.php.net/> ) > To unsubscribe, visit: http://www.php.net/unsub.php > <http://www.php.net/unsub.php> > > > -- > PHP Windows Mailing List ( http://www.php.net/ > <http://www.php.net/> ) > To unsubscribe, visit: http://www.php.net/unsub.php > <http://www.php.net/unsub.php> > > > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php