Oh yeah. Store the whole wad into a structure, serialize it into a WDDX
packet, and stuff it into a client variable.
Another idea? If your server can handle it, you could dynamically name your
query, appending the CFTOKEN to the end of the query name. Cache the query
result, and when you need the query results again, they are cached so you
won't be double-hitting the SQL server.
It would look like <CFQUERY name="qry_8123456" cachedwithin="20"> or
something like that.
If the cached query got blown out, say because you have such a high traffic
site that the query got washed out during the user session, you'd hit the
SQL server again.
I think this would be an easy way of goin' about it.
Alan McCollough
Web Programmer
Allaire Certified ColdFusion Developer
Alaska Native Medical Center
> -----Original Message-----
> From: Brian P. Doyle [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, October 05, 2000 6:55 AM
> To: Fusebox
> Subject: RE: nwebie: pass lg array between templates
>
> client variables?
>
> -----Original Message-----
> From: Mike Sullivan [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 05, 2000 10:49 AM
> To: Fusebox
> Subject: nwebie: pass lg array between templates
>
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Greetings,
>
> I am adding a "fuse" to a intranet application already in place that
> was written with the fusebox methodology.
>
> I have generated a large array in a query template and want the users
> to be able to page through it in a dsp template. There is a
> dsp_prev_next template that is included in the main dsp template and
> I am trying to mimic that behavior but paging through a large array
> instead of a SQL query.
>
> The array is too large to pass via the URL and I looking for the
> preferred approach to pass it and still keep the fusebox structure in
> tack.
>
> Any suggestions or pointers to other references would be appreciated.
>
> Cheers
> Mike
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>
>
> iQA/AwUBOdyVHHYFmKomMlANEQKuIACghic1FpABOho+1A6wUj8KR+2jQdIAoM52
> PJUw77yHOaa1ywCK6atahTdL
> =2tyJ
> -----END PGP SIGNATURE-----
> --------------------------------------------------------------------------
> --
> --
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --------------------------------------------------------------------------
> ----
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
