function, not a SQL function, so you need to do it in your CF code:
<cfxml variable="tempxml"> ... </cfxml>
<cfquery ... >
INSERT INTO myTable
(xmlCol)
VALUES
('#toString(tempxml)#') -- use CFQUERYPARAM
</cfquery>
<cfquery ... name="get">
SELECT xmlCol
FROM myTable
</cfquery>
<cfset tempxml = xmlParse(get.xmlCol) />
cheers,
barneyb
On Wed, 4 Aug 2004 13:57:56 -0400, Chad McCue
<[EMAIL PROTECTED]> wrote:
> I saved it in my database as ToString(TemplateFields)
>
> How can I apply XML functions to this when I read it from the DB? When I try to do a XxlParse(fieldname) I get an error.
> ----- Original Message -----
> From: Barney Boisvert
> To: CF-Talk
> Sent: Wednesday, August 04, 2004 1:46 PM
> Subject: Re: XML and Databases
>
> Sure, one of the benefits of XML is that its plain text, so you can
> store it just like any other text string, including in a database.
>
> cheers,
> barneyb
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
