You could then load the HTML into a session or application variable which
would then store the information in memory. Then you only have to issue
one call to the database.
J.
> -----Original Message-----
> From: Michael Slatoff [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 16, 2000 1:42 PM
> To: [EMAIL PROTECTED]
> Subject: Re: SQL Trigger vs. Stored Procdure
>
>
> I want to keep calls to the database to a minimum.
>
> Michael Slatoff
> www.slatoff.com
>
>
> -----Original Message-----
> From: "Gregory Harris" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Date: Wed, 16 Aug 2000 10:23:51 -0700
> Subject: Re: SQL Trigger vs. Stored Procdure
>
> > You could do that I suppose, but why not just store your navigation
> > table information, HTML and all INSIDE the database rather than as a
> > separate file under the guise of SQL....makes more sense to
> me....you
> > can bring up the HTML up through a SQL Statement without a
> problem, so
> > why not?
> >
> > Gregory Harris
> > Los Angeles Information Technology Agency (ITA)
> > [EMAIL PROTECTED]
> >
> >
> > >>> [EMAIL PROTECTED] 08/16 10:10 AM >>>
> > I'm sorry for the lack of info.
> >
> > What I am trying to do is keep all of my navigation items
> in a table.
> > When "the powers that be" want to make a change, they will
> be able to
> > go
> > to a form to update. When the update happens, I want to
> have a trigger
> > write a .csv file that would be CFinclude in my template. What I am
> > wondering is, this worth the trouble?
> >
> >
> > Michael Slatoff
> > www.slatoff.com
> >
> >
> > -----Original Message-----
> > From: "Gregory Harris" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Date: Wed, 16 Aug 2000 09:40:00 -0700
> > Subject: Re: SQL Trigger vs. Stored Procdure
> >
> > > Could you be a little more specific about what you are
> trying to do?
> > > It sounds like a stored procedure and/or a cursor might
> be the better
> > > and faster way out of what you're doing. Why write to a
> .csv file?
> > > Let me know what you're doing and I'll help ya use the right tools
> > for
> > > the right job!
> > >
> > > Gregory Harris
> > > Los Angeles Information Technology Agency (ITA)
> > > [EMAIL PROTECTED]
> > >
> > >
> > > >>> [EMAIL PROTECTED] 08/16 9:29 AM >>>
> > > I am considering using a trigger to write .csv file when a column
> > > changes. I will then include that file and use it to loop over.
> > >
> > > The question is...
> > >
> > > Is this more efficient or less efficient than using a
> cached query?
> > >
> > > Michael Slatoff
> > > www.slatoff.com
> > >
> > >
> > >
> >
> --------------------------------------------------------------
> ---------
> > > -------
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > To Unsubscribe visit
> > >
> >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk
> > or send a message to [EMAIL PROTECTED] with
> > 'unsubscribe' in the body.
> >
> >
> -----------------------------------------------------------------------
> > -------
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> > or send a message to [EMAIL PROTECTED] with
> > 'unsubscribe' in the body.
>
>
> -----------------------------------------------------------------------
> -------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>
> -----------------------------------------------------------------------
> -------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
