Re: update ... where col is null problem.

2005-04-14 Thread Chris Knipe
t: Thursday, April 14, 2005 11:19 AM Subject: update ... where col is null problem. Hi... I have problem with update query. Select query with the same "where" is OK. mysql> select AcctStartTime,AcctSessionTime from radacct where AcctStopTime is null; +-+-

update ... where col is null problem.

2005-04-14 Thread Emil Wilmanski
Hi... I have problem with update query. Select query with the same "where" is OK. mysql> select AcctStartTime,AcctSessionTime from radacct where AcctStopTime is null; +-+-+ | AcctStartTime | AcctSessionTime | +-+-+ | 20

Re: Cannot be null problem

2004-08-15 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Schalk Neethling wrote: | When sending form data via a form I get the following SQL error | | ERROR:-- SQLException - Message: The url cannot be null | SQLState: 08001 | ErrorCode :0 | | What does this mean? The row url, is not set to be not nul

RE: Cannot be null problem

2004-08-14 Thread Schalk Neethling
When sending form data via a form I get the following SQL error ERROR:-- SQLException - Message: The url cannot be null SQLState: 08001 ErrorCode :0 What does this mean? The row url, is not set to be not null. -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volu

Re: NULL problem

2004-07-19 Thread Pete Harlan
It might help if you say what version of MySQL you're using, give the table schema, etc. I couldn't reproduce the behavior you describe here. --Pete On Mon, Jul 19, 2004 at 12:13:47PM -0500, Deepak Vishwanathan wrote: > Hi, > > > > I have a table with a column that has the Unique key constr

RE: NULL problem

2004-07-19 Thread Sommerfield, Thomas P
27;where col is null', but should at least be of some use. Hope that helps, -Tom -Original Message- From: Deepak Vishwanathan [mailto:[EMAIL PROTECTED] Sent: Monday, July 19, 2004 11:14 AM To: [EMAIL PROTECTED] Subject: NULL problem Hi, I have a table with a column that has the

NULL problem

2004-07-19 Thread Deepak Vishwanathan
Hi, I have a table with a column that has the Unique key constraint on it. In the table definition that column has a default NULL specification too. So, when I ran the query select * from table where col is NULL; I get only 1 row returned, when I have 23 such rows with NULL values. This

RE: Null problem with SELECT

2003-06-03 Thread Mike Hillyer
bmysql.com -Original Message- From: Sparky Kopetzky [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 3:24 PM To: My Sql List Subject: Null problem with SELECT Greetings! I have a query for a report that accesses columns that could possibly be null. Here's an example: SELECT blah, blah,

Null problem with SELECT

2003-06-03 Thread Sparky Kopetzky
Greetings! I have a query for a report that accesses columns that could possibly be null. Here's an example: SELECT blah, blah, blah FROM bite bite, person agency WHERE bite.bite_id = "AC-2003-0004" AND agency.person_id = bite.bite_agency_id; bite.bite_agency_id and other fields like this could

re: IS NULL problem with dates; confirmed on 3.23.x && 4.09

2003-02-09 Thread Victoria Reznichenko
On Wednesday 05 February 2003 02:07, aah at volunteermatch dot org wrote: > >Description: > > Multiple IS NULL tests in a WHERE clause appear to be broken > when testing NOT NULL date fields. Queries work fine against > varchar and int, probably(?) others. > > >How-To-Repeat: >

IS NULL problem with dates; confirmed on 3.23.x && 4.09

2003-02-05 Thread aah
>Description: Multiple IS NULL tests in a WHERE clause appear to be broken when testing NOT NULL date fields. Queries work fine against varchar and int, probably(?) others. >How-To-Repeat: create temporary table test (a date not null, b date not null); inser