[ic] Perl/SQL

[Mark Johnson]

MANY options, but the main ones:

In embedded perl, use the %Db object's query method

http://interchange.redhat.com/cgi-bin/ic/dev/icconfig_30.html

As its own tag, use the [query] tag.

[query list=1 sql="select * from foobar"]
Field		Value
-----		-----
code		[sql-code]
foocol		[sql-param foocol]
barcol		[sql-param barcol]
[/query]

Russ Mann wrote:
> 
> Hello,
> 
> How do I execute an SQL statement from within a [perl] bock?
> 
> Or, how do I execute an arbitrary SQL statement from a regular page?
> 
> Thanks,
> 
> Russ
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users

-- 
Mark Johnson
Senior Systems Architect - Professional Services
Red Hat, Inc.
E-Business Solutions
markj@redhat.com
703-456-2912