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=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?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.