Web Page from DB, CFINCLUDE does not work

[jaymes]

I am working on a dynamically generated Web site with pages that are stored in
a database. When I display a page from the database, the CFINCLUDE tag is not
processed. I see the actual cfinclude tag in the rendered document, not the
text that should be included. I don't know if other CF tags will work or not.
This was the first I noticed not working, and I wanted to try to find an answer
before spending more time on the project. Thanks, Jim

[Ken Ford - *TMM* & PVII]

Are you saving the page as a .cfm page?

--
Ken Ford
PVII Support Team
[url]http://www.projectseven.com[/url]
Team Macromedia Volunteer - Dreamweaver
Certified Dreamweaver MX 2004 Developer


"jaymes" <webforumsuser@macromedia.com> wrote in message news:d1mhvi$3g5$1@forums.macromedia.com...

>I am working on a dynamically generated Web site with pages that are stored in
> a database. When I display a page from the database, the CFINCLUDE tag is not
> processed. I see the actual cfinclude tag in the rendered document, not the
> text that should be included. I don't know if other CF tags will work or not.
> This was the first I noticed not working, and I wanted to try to find an answer
> before spending more time on the project. Thanks, Jim
>

[jaymes]

Yes, the stub page is a .cfm page. It includes this query and display:
<cfquery datasource='myCMS' name='getPage'> select PageText from
Pages where pagePath='#CGI.Script_Name#' </cfquery> <cfoutput
query='getPage'> #PageText# </cfoutput> The text is displayed, so
the page record is retrieved correctly. But one of the lines in the retrieved
text is a CFINCLUDE statement, and that statement shows up as part of the page
(when you view page source), it does not actually do the include. Thanks for
assistance, Jim

[jonwrob]

None of the CFML tags will be processed that way. The only way I can see that
working is if you write the results of the query to the file system using
CFFILE, and then include it with CFINCLUDE.

Is there some reason it is better to store these files in a db instead of the
file system?

JR

[jaymes]

We want to use a DB to manage documents, archive documents, assign expiration
dates, and to allow in-browser editing using ActiveEdit. If we can't store CFM
pages in a database then this is a serious problem. Any other ideas out
there? Thanks, Jim

[jjsand28]

i don't believe you're actually supposed to store the pages themselves but the
content on them. So for instance, you have an article that you want to expire
on such and such a day. so your db would be set up like this: table:articles
cell: article_id cell: article_content cell: article_author cell: expire_date
etc. Then on your cf page you would call that article. The cfincludes, i don't
know what they are for, but you would have to store in a folder in your site.
On example would be that you would have several templates (designs for the
pages, users, whatever) and the cfinclude would query the db and display that
article in that particular layout. You would then use forms or in your case
active edit to create those article. Images included in those articles would be
stored in the db as well so that when you call the data it appears as it would.
This is all obviously a guess since i am not familiar with active edit other
than what I could see on the web. And I am unfamiliar with what you are trying
to do. you might just want to try to find a good cf content management system
to do all the work for you.