<blog_addnews>
<xsp:logic>
String id_blog_user = request.getParameter("id_blog_user");
String id_blog_news = request.getParameter("id_blog_news");
if ( id_blog_user == null) {
id_blog_user = <xsp-session-fw:getxml context="authentication" as="string"
path="/authentication/data/id_blog_user"/> ;
}
if (id_blog_news == null) {
<esql:connection>
<esql:pool>mblog_pg</esql:pool>
<esql:execute-query>
<esql:query>
SELECT * FROM blog_news WHERE blog_news.id_blog_user =
'<xsp:expr>id_blog_user</xsp:expr>'
</esql:query>
<esql:results>
<esql:row-results>
<blog_new>
<id_blog_news><esql:get-int column="id_blog_news"/></id_blog_news>
<id_blog_user><esql:get-string
column="id_blog_user"/></id_blog_user>
<news_title><esql:get-string column="news_title"/></news_title>
<news_text><esql:get-string column="news_text"/></news_text>
<news_image><esql:get-string column="news_image"/></news_image>
<news_date_creation><esql:get-string
column="news_date_creation"/></news_date_creation>
<news_date_modify><esql:get-string
column="news_date_modify"/></news_date_modify> </blog_new>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
} else {
<esql:connection>
<esql:pool>mblog_pg</esql:pool> <esql:execute-query>
<esql:query>
SELECT * FROM blog_news WHERE blog_news.id_blog_user =
'<xsp:expr>id_blog_user</xsp:expr>' AND id_blog_news =
'<xsp:expr>id_blog_news</xsp:expr>'
</esql:query>
<esql:results>
<esql:row-results>
<blog_new>
<id_blog_news><esql:get-int column="id_blog_news"/></id_blog_news>
<id_blog_user><esql:get-string
column="id_blog_user"/></id_blog_user>
<news_title><esql:get-string column="news_title"/></news_title>
<news_text><esql:get-string column="news_text"/></news_text>
<news_image><esql:get-string column="news_image"/></news_image>
<news_date_creation><esql:get-string
column="news_date_creation"/></news_date_creation>
<news_date_modify><esql:get-string
column="news_date_modify"/></news_date_modify> </blog_new>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
}
</xsp:logic>
</blog_addnews>
</xsp:page>this one is not ok :
<blog_addnews>
<xsp:logic>
String id_blog_user = request.getParameter("id_blog_user");
String id_blog_news = request.getParameter("id_blog_news");
if ( id_blog_user == null) {
id_blog_user = <xsp-session-fw:getxml context="authentication" as="string"
path="/authentication/data/id_blog_user"/> ;
}
<esql:connection> <esql:pool>mblog_pg</esql:pool>
<esql:execute-query>
<esql:query>
if (id_blog_news == null) {
SELECT * FROM blog_news WHERE blog_news.id_blog_user =
'<xsp:expr>id_blog_user</xsp:expr>'
} else {
SELECT * FROM blog_news WHERE blog_news.id_blog_user =
'<xsp:expr>id_blog_user</xsp:expr>' AND id_blog_news =
'<xsp:expr>id_blog_news</xsp:expr>'
}
</esql:query>
<esql:results>
<esql:row-results>
<blog_new>
<id_blog_news><esql:get-int column="id_blog_news"/></id_blog_news>
<id_blog_user><esql:get-string
column="id_blog_user"/></id_blog_user>
<news_title><esql:get-string column="news_title"/></news_title>
<news_text><esql:get-string column="news_text"/></news_text>
<news_image><esql:get-string column="news_image"/></news_image>
<news_date_creation><esql:get-string
column="news_date_creation"/></news_date_creation>
<news_date_modify><esql:get-string
column="news_date_modify"/></news_date_modify> </blog_new>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
</xsp:logic>
</blog_add>but why cant i just do a simple if just on the esql-query part ?
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
