On 05.Jan.2003 -- 04:44 PM, Yves Vindevogel wrote:
Hi,
I've got a form with one textbox (name) and a combobox (type)
When the user presses submit, a searchpage is called where I execute this
query (on postgres db)
esql:query
select *
Hi,
I've got a form with one textbox (name) and a combobox (type)
When the user presses submit, a searchpage is called where I execute this
query (on postgres db)
esql:query
select * from vwProducts
Yves -
Why not build your select statement as a string variable inside an
xsp:logic block after the root user tag, and then reference it thusly:
esql:query
xsp:exprmyQuery/xsp:expr
/esql:query
I do this all the time and it works perfectly.
Regards,
Lajos
--
galatea.com
Cocoon training,
Hi,
I had tried this:
xsp:page language=java
xmlns:xsp=http://apache.org/xsp;
xmlns:esql=http://apache.org/cocoon/SQL/v2;
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
I can't understand what you are doing w/out seeing the whole XSP.
Typically I do this:
xsp:page language=Java ... /
html !-- This is your root user tag --
xsp:logic
String myQuery = select * from vwProducts;
!-- Or whatever logic you need to build the query string --
/xsp:logic
!--
i use to build queries in in logic too , into a variable this code work
for me:
xsp:logic
int lookup = 0;
String slookup = ;
String lookupstr = ;
String colfilter = ;