There would't be one. And how is that? You'd do a one-time query to the DB
when the app is initialized. Cache the query results for a looooooong time.
This should keep it up in RAM and avoid a DB hit.
Alan McCollough
Web Programmer
Allaire Certified ColdFusion Developer
Alaska Native Medical Center
> -----Original Message-----
> From: Brandon Paolin [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, January 12, 2001 11:51 AM
> To: Fusebox
> Subject: Re: passing page name through url
>
> that would be nice, but i wouldn't want an extra hit to the database
>
> ----- Original Message -----
> From: "McCollough, Alan" <[EMAIL PROTECTED]>
> To: "Fusebox" <[EMAIL PROTECTED]>
> Sent: Friday, January 12, 2001 11:51 AM
> Subject: RE: passing page name through url
>
>
> > A more secure solution would be to set up a db table for template
> lookups,
> > with an ID number for reference, and the actual template name as a
> separate
> > field.
> > Which is more secure?
> > index.cfm?fuseaction=admin&template=admin.cfm
> > or...
> > index.cfm?fuseaction=admin&template=3
> >{redacted}
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
