Re: ESQL INSERT

[olivier demah]

Christopher Painter-Wakefield a e'crit :

1. Check your logs, perhaps the error message in one of them.  You might
also try removing your <esql:error-results> element; perhaps it is masking
an exception that you'd otherwise see.
 

i always see nothing in logs. :-/

2. Make sure your pool, xsp, and esql setup is correct; can you do a simple
SELECT query successfully in place of the INSERT?
 

the select work ; so the pool is correct.

3. You say the query works by hand; are you logging in using the same
account as your pool user?  Otherwise you might have a permissions problem.
 

yes i use the same user.

4. Is the code below copied from your source?  There is a missing left
parenthesis on your column list.
 

i made a mistake the copy/paste.

5. Is TODAY() a function?  You appear to be trying to insert the String
'TODAY()' into a date field.  Just use bare TODAY() as you would in your
 

Today() is a postgresql function.

SQL statement.

-Christopher
 

i even tested to execute this query ; but nothing went well.

<esql:query>
INSERT INTO blog_news 
(id_blog_user,news_title,news_text,news_image,news_date_creation,news_date_modify)
VALUES (2,'foo,'bar','','TODAY()',NULL);
</esql:query>

By hand ; on psql server:
mblog=# INSERT INTO blog_news 
(id_blog_user,news_title,news_text,news_image,news_date_creation,news_date_modify) 
VALUES (2,'foo','bar','','TODAY()',NULL);
INSERT 17466 1
mblog=# select * from blog_news order by id_blog_news desc limit 1;
id_blog_news | id_blog_user | news_title | news_text | news_image | 
news_date_creation | news_date_modify
--------------+--------------+------------+-----------+------------+--------------------+------------------
9 | 2 | foo | bar | | 2004-03-31 |
(1 ligne)

i will check again the ESQL syntax
its impossible that this syntax works like that ...
regards.



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]