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]
