What error are you getting?
-joe
----- Original Message -----
From: Chad McCue <[EMAIL PROTECTED]>
Date: Wed, 4 Aug 2004 13:57:56 -0400
Subject: Re: XML and Databases
To: CF-Talk <[EMAIL PROTECTED]>
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
On Wed, 4 Aug 2004 13:40:10 -0400, Chad McCue
<[EMAIL PROTECTED]> wrote:
> this is my code
>
> <CFXML VARIABLE="TemplateXML">
> <templateemail>
> <companyname>#session.FieldStructure["CompanyName"]#</companyname>
> <messagetitle>#session.FieldStructure["Title"]#</messagetitle>
> <logoImage>#session.FieldStructure["LogoImage"]#</logoImage>
> <emailaddress>#session.FieldStructure["EmailAddress"]#</emailaddress>
> <webaddress>#session.FieldStructure["WebAddress"]#</webaddress>
> <comments>#session.FieldStructure["Comments"]#</comments>
> <CFLOOP FROM="1"
to="#ArrayLen(session.FieldStructure['ProductInfo'])#"
index="LoopIndex">
> <products>
> <productname>#session.FieldStructure["ProductInfo"][LoopIndex]["ProductName"]#</productname>
> <productdescr>#session.FieldStructure["ProductInfo"][LoopIndex]["ProductDescr"]#</productdescr>
> <productpricelable>#session.FieldStructure["ProductInfo"][LoopIndex]["productpricelable"]#</productpricelable>
> <productprice>#session.FieldStructure["ProductInfo"][LoopIndex]["productprice"]#</productprice>
> <productimage>#session.FieldStructure["ProductInfo"][LoopIndex]["productimage"]#</productimage>
> <productlinkmessage>#session.FieldStructure["ProductInfo"][LoopIndex]["productlinkmessage"]#</productlinkmessage>
> <productlinkurl>#session.FieldStructure["ProductInfo"][LoopIndex]["productlinkurl"]#</productlinkurl>
> </products>
> </cfloop>
> </templateemail>
> </CFXML>
>
> Is it possible to store "TemplateXML" into a database and then
read it out and be able to parse the XML?
>
>________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
