php-windows Digest 29 Jun 2003 19:47:01 -0000 Issue 1800
Topics (messages 20612 through 20613):
Re: or die problem
20612 by: Svensson, B.A.T. (HKG)
Survey question of sorts - "editors" and "development environments" have been
generically mentioned in various emails to this list ... I'm interested in
20613 by: Rob E
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
> Sent: Friday, June 27, 2003 12:39 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: [PHP-WIN] Re: or die problem
>
>
> It might help if you can post your code snippet!
>
> >>> "Croskerry, Dan" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>
> Sent: Friday, June 27, 2003 10:18 PM
> To: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> 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
> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> "Dan Croskerry" < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote in
> message
> news:[EMAIL PROTECTED]
>
<mailto:news:[EMAIL PROTECTED]
>
> ...
> > 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/ <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/ <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
--- End Message ---
--- Begin Message ---
specific mention of what you folks use when developing PHP code. I am a
newbie; have been using notepad to create small php scripts while
learning syntax, etc. I am curious what you folks use and recommend for
us who are starting out. I, per se, have no problem with notepad, but
am wondering what you're experiences have been with various IDE software
that I have found while googling, i.e., phpide, PHPEdit, et al.
Thanks in advance,
Rob E.
--- End Message ---
