cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcus Crafter <craft...@dresdnerbank.de>
Subject [C2] xsp in esql ? (was Re: [C2] esql connections diff)
Date Sat, 04 Nov 2000 12:51:07 GMT
Hi Donald (and others),

	What are your thoughts about being able to parameterize the queries
	with your suggested syntax, perhaps with xsp ? For example:

<esql:connection>

	<esql:driver>...</esql:driver>

	<xsp:logic>
		for (int i=0; i &lt; sz; i++) {
			<esql:execute-query>
				<esql:query>
					INSERT INTO mytable VALUES
					('<xsp:expr>field[i]</xsp:expr>');
				</esql:query>
			</esql:execute-query>
		}
	</xsp:logic>

</esql:connection>

	This is something we've done here in C1 using the SQL processor (xsp
	is done first, then the sql processor). Such abilities in esql would
	also be very useful.
	
	I guess it's a general question about using xsp within esql.
	What do you think ? (or is this already possible ?)

	Cheers,

	Marcus

-- 
        .....
     ,,$$$$$$$$$,      Marcus Crafter
    ;$'      '$$$$:    Computer Systems Engineer
    $:         $$$$:   Open Software Associates GmbH
     $       o_)$$$:   82-84 Mainzer Landstrasse
     ;$,    _/\ &&:'   60327 Frankfurt Germany
       '     /( &&&
           \_&&&&'     Email : Marcus.Crafter@osa.de
          &&&&.        Business Hours : +49 69 9757 200
    &&&&&&&:           After Hours    : +49 69 49086750


Mime
View raw message