instead of
use wrote:
> >Thanks for this, it is really a great help, I may get a good nights
> >sleep now!
> >
> >-Original Message-
> >From: Taco Fleur [mailto:[EMAIL PROTECTED]
> >Sent: 18 November 2004 19:50
> >To: CF-Talk
> >Sub
> 'Document root element is missing' any idea why?
I think the xml should be something like this,
something1
something2
something3
something4
which it doesn't look like it is... Ie the only element is the root one
something1
something2
>Thanks for this, it is really a great help, I may get a good nights
>sleep now!
>
>-Original Message-
>From: Taco Fleur [mailto:[EMAIL PROTECTED]
>Sent: 18 November 2004 19:50
>To: CF-Talk
>Subject: RE: SQL Query using 'FOR XML' & Coldfusion
Rob,
Thanks for this, it is really a great help, I may get a good nights
sleep now!
-Original Message-
From: Taco Fleur [mailto:[EMAIL PROTECTED]
Sent: 18 November 2004 19:50
To: CF-Talk
Subject: RE: SQL Query using 'FOR XML' &a
This is excellent, can't believe it could be so simple! Why didn't I
think of that? Many thanks.
-Original Message-
From: Rob [mailto:[EMAIL PROTECTED]
Sent: 18 November 2004 19:14
To: CF-Talk
Subject: Re: SQL Query using 'FOR XML' & Coldfusion
http:/
Thanks for this, it is really a great help, I may get a good nights
sleep now!
-Original Message-
From: Taco Fleur [mailto:[EMAIL PROTECTED]
Sent: 18 November 2004 19:50
To: CF-Talk
Subject: RE: SQL Query using 'FOR XML' & Coldfusi
-
> From: Andy Mcshane [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 18 November 2004 11:08 PM
> To: CF-Talk
> Subject: RE: SQL Query using 'FOR XML' & Coldfusion
>
>
> Thanks, I am definitely interested! This would be of a great
> help to me.
>
> Andy M
u know we're getting old when we forget the time...
LOL
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184801
Archives
916B'.
> >
> > -Original Message-
> > From: Rob [mailto:[EMAIL PROTECTED]
> > Sent: 17 November 2004 17:42
> > To: CF-Talk
> > Subject: Re: SQL Query using 'FOR XML' & Coldfusion
> >
> > Yes, you have to loop over the query column
er at all how you handled the column names? i.e.
>
>
> 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'.
>
> -Original Message-
> From: Rob [mailto:[EMAIL PROTECTED]
> Sent: 17 November 2004 17:42
> To: CF-Talk
> Subject: Re: SQL Query using 'FOR XML&
Email: mailto:[EMAIL PROTECTED]
Website: www.scout7.com
-Original Message-
From: Taco Fleur [mailto:[EMAIL PROTECTED]
Sent: 18 November 2004 12:58
To: CF-Talk
Subject: RE: SQL Query using 'FOR XML' & Coldfusion
The only way I found to do this is actually get an ADO stream,
Thursday, 18 November 2004 8:27 PM
> To: CF-Talk
> Subject: RE: SQL Query using 'FOR XML' & Coldfusion
>
>
> Can you remember at all how you handled the column names?
> i.e. 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'.
>
>
> -Original Me
Can you remember at all how you handled the column names? i.e.
'XML_F52E2B61-18A1-11D1-B105-00805F49916B'.
-Original Message-
From: Rob [mailto:[EMAIL PROTECTED]
Sent: 17 November 2004 17:42
To: CF-Talk
Subject: Re: SQL Query using 'FOR XML' & Coldfusion
Yes, y
Yes, you have to loop over the query columns and build a new string
with the columns data.
The way you go about it is pretty wacky and I forget the syntax, but I
(and others) have posted how to do it to the list at one point so it
should be in the archive (it was like a year ago though)
On Wed, 1
Hi all. I am trying to utilise the SQL2000 'FOR XML' functionality to return
the results of a stored procedure, called from Coldfusion using 'CFStoredProc',
as an XML string to my Coldfusion app. I am having a few problems;
When I run the query in the SQL query window the results are exactly as
15 matches
Mail list logo
