Re: Problem with insert data

[Rafal Kedziorski]

At 15:09 28.10.2003 -0600, gerald_clark wrote:

Rafal Kedziorski wrote:

hi,

I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow). And I 
have problems with this query:

insert into user(class_id, retail_id, mandant_id, language_id, 
user_data_id, nickname, login_name, password, status, creation_date, 
last_login_date) values ('35F7A660096411D89BC0D1907F000001', '1234', 2, 
1, null, null, '[EMAIL PROTECTED]', 'demo', 8, '2003-10-28 17:31:36', null)
This is incorrect.
This query will be generated by JBoss 3.2.2. It's also a JBoss problem?

but the same query with space after user

insert into user (class_id, retail_id, mandant_id, language_id, 
user_data_id, nickname, login_name, password, status, creation_date, 
last_login_date) values ('35F7A660096411D89BC0D1907F000001', '1234', 2, 
1, null, null, '[EMAIL PROTECTED]', 'demo', 8, '2003-10-28 17:31:36', null)

works.
This is corerect.



Regards,
Rafal
user() is a function.
o.k.

Rafal 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]