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;
+-+-
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
-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
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
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
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
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
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,
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
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:
>
>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
11 matches
Mail list logo