James,
>Hi Dan I did try doing this in cold fusion but it looks like there is a
>limit on how big your script can be as it gets turned in to a class file.
I've run into some huge CF templates and never had a problem, but I can't
for the life of me understand why you'd have a large CF template. You
template only needs to be a few lines:
<cfsilent>
<cfparam name="url.q" type="string" />
<cfquery name="getResults">
select
column1, column2, column3
from
table
where
column1 like <cfqueryparam type="cf_sql_varchar" value="#url.q#%" />
</cfquery>
</cfsilent><cfoutput query="getResults">#column1#|#column2#|#column3#
</cfoutput>
That's basically all you need. Very simple stuff. There's absolute no reason
you should be using any kind of hard code data.
-Dan
