Hi Peter, I know exactly what you mean. I have suggested a publish function which would write out all static pages, as well as the creation of a temp page. Both ideas were shot down. I may end up doing the temp page if I cannot find a better solution. Thanks for the input.
Brendan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Bell Sent: Monday, July 17, 2006 10:03 AM To: [email protected] Subject: RE: [CFCDev] Coldfusion and XSLT Transformation Hi Brendan, Probably not a very helpful suggestion, but is there any way you can get around this approach? It sucks!!! Are you really going to be importing data and exporting data using XML as frequently as you will be serving up page views (i.e. hopefully hundreds to tens of thousands of times a day)?! If not, why use XML within the application? It would be much easier to write a simple XML import/export engine in CF for porting data when required - exposable as a web service if necessary. One approach to processing returned CF commands from queries is saving them to file and then running the file (not as bad as it sounds if you're running a caching mechanism so you're not creating the file for every page request). I've got to say though, with no knowledge of your specific use cases the approach of storing data as XML native objects just seems like it's going to cause you a world of pain. Sorry. I usually don't like people that, when asked "how do I do X" say "Don't do X", but unless you've got a really special use case I'd think it over a few times and see if I could get away from this approach. Best Wishes, Peter -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brendan Ganning Sent: Monday, July 17, 2006 10:55 AM To: [email protected] Subject: [CFCDev] Coldfusion and XSLT Transformation We have just started using a SQL Server 2005 database with our CF MX 7 server. I have been instructed to set up an application that uses the native XML datatype in SQL Server so that we will be able to port information when needed to other platforms. Here is the question. In our xml field we have an element named reference. <reference refId="1" refType="activity"></reference> If the reference is of refType text, or image, it is quite easy to have the sql server return the generated html that is required. However, when I have a refType of activity, I need to cfinclude a page, or run a custom tag. If I have sql return the tag to be put into the html ie(<cf_getReference id="1" type="activity">), the coldfusion server will not process the tag since it is contained in the query return. If I have coldfusion do the transformation, I have a feeling that the coldfusion server will produce a longer load time and would then be needed in all platforms to do the transformation. Any suggestions? Thanks, Brendan ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
