[thelist] huge MySQL query in ASP without stored procedures

Matt Warden mwarden at gmail.com
Mon May 8 14:01:55 CDT 2006


On 5/8/06, Canfield, Joel <JCanfield at pacadvantage.org> wrote:
> our call record db is on MySQL 4.1 so as far as I know we can't use
> stored procedures. any tips on running a 400-line query in an ASP page?
> It was originally a Crystal Reports query provided by the vendor.
>
> I've started trying to concatenate the lines or break it up various
> ways, but nothing elegant or happy is happening. I feel like there
> should be a simple obvious answer, but google and thelist archives
> haven't returned anything I think I can use.

Defining the query in JScript seems like it would be the least hassle:

var sql = '\
select ... \
from ... \
... \
... \
etc.';


--
Matt Warden
Miami University
Oxford, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.


More information about the thelist mailing list