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.
2. Make sure your pool, xsp, and esql setup is correct; can you do a simple
SELECT query successfully in place of the INSERT?
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.
4. Is the code below copied from your source? There is a missing left
parenthesis on your column list.
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
SQL statement.
-Christopher
|---------+---------------------------->
| | olivier demah |
| | <[EMAIL PROTECTED]|
| | com> |
| | |
| | 03/30/2004 11:22 |
| | AM |
| | Please respond to|
| | users |
| | |
|---------+---------------------------->
>--------------------------------------------------------------------------------------------------------------|
|
|
| To: [EMAIL PROTECTED]
|
| cc:
|
| Subject: Re: ESQL INSERT
|
>--------------------------------------------------------------------------------------------------------------|
Christopher Painter-Wakefield a e'crit :
>
>
>Are you not seeing any error messages coming through? I suspect the
>problem is that you have a SQL error, and if you look, you'll find it.
You
>should have gotten a SQL error previously. What output are you seeing in
>your <blog_addingnews> element?
>
>
its empty ...
i made another fix about the primary key.
<esql:query>
INSERT INTO blog_news
id_blog_user,news_title,news_text,news_image,news_date_creation,news_date_modify)
VALUES (<esql:parameter
type="string"><xsp:expr>id_blog_user</xsp:expr></esql:parameter>,
<esql:parameter
type="string"><xsp:expr>news_title</xsp:expr></esql:parameter>,
<esql:parameter
type="string"><xsp:expr>news_text</xsp:expr></esql:parameter>,
<esql:parameter
type="string"><xsp:expr>news_image</xsp:expr></esql:parameter>,
'TODAY()',NULL);
</esql:query>
if i do it by hand its working... but not with ESQL
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
