perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt Sergeant <m...@sergeant.org>
Subject Re: Coldfusion vs. apache/mod_perl
Date Thu, 06 Jul 2000 07:50:34 GMT
On Wed, 5 Jul 2000, Paul Lindner wrote:

> I've been toying with using the Apache::ASP custom tag feature to
> support cold-fusion like applications.  I don't think it will be too
> hard; reading the spec it appears you need to make a list of named
> queries and then use <cfoutput> tags with #fieldname# entries.

Not to dismiss Joshua's interesting looking extensions to Apache::ASP, but
have you checked out AxKit's SQL taglib stuff?

Here's an XSP to extract rows from a messages table:

<xsp:page
  language="Perl"
  xmlns:sql="http://www.apache.org/1999/SQL"
  xmlns:xsp="http://www.apache.org/1999/XSP/Core"
>
  <page title="SQL Search Results">
        <sql:execute-query>
                <sql:driver>Sybase</sql:driver>
                <sql:username>webboard</sql:username>
                <sql:password>password</sql:password>
                <sql:doc-element>options</sql:doc-element>
                <sql:row-element>option</sql:row-element>
                <sql:tag-case>lower</sql:tag-case>
                <sql:null-indicator>yes</sql:null-indicator>
                <sql:id-attribute>ID</sql:id-attribute>
                <sql:id-attribute-column>msgid</sql:id-attribute-column>
                <sql:query>select * from Messages</sql:query>
                <sql:count-attribute>count</sql:count-attribute>
        </sql:execute-query>
  </page>
</xsp:page>

This is then styled using XSLT in the next part of the pipeline. My box
can deliver 14 hits/sec on this (executed and styled using XSLT on every
hit). Not exactly blazing, but fast enough for a lot of uses.

And don't be put off by the verbosity - all this can be modularised in
external entities and/or taglibs.

-- 
<Matt/>

Fastnet Software Ltd. High Performance Web Specialists
Providing mod_perl, XML, Sybase and Oracle solutions
Email for training and consultancy availability.
http://sergeant.org | AxKit: http://axkit.org


Mime
View raw message