Oh wow, I didn't even know that. I jumped on this list when I first
downloaded to torchbox months ago, I didn't know it was just a general
XML/CF resource.
I think most of the people on this list found it the same way I did
though, and that's why there always seems to be torchbox questions.
Point taken! ;)
Kipp
-----Original Message-----
From: Steinhilber, Carl
To: '[EMAIL PROTECTED]'
Sent: 3/27/03 2:09 PM
Subject: RE: RE: [cf-xml] xml query problem
Ehhhh... not quite.
>From http://torchbox.com/xml/list.cfm
"This list is intended to provide a technical resource for ColdFusion
developers who use - who would like to use - XML in their applications."
Notice it says nothing about "CFXML Toolkit"... just using XML in
ColdFusion in general. I've never used the toolkit myself... but still
find this mailing list quite valuable in using XML with ColdFusion MX.
-----Original Message-----
From: Kipp Grose [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 11:17 AM
To: '[EMAIL PROTECTED] '
Subject: RE: RE: [cf-xml] xml query problem
hahaha:
>what's this CFXML toolkit? I don't remember ever looking at anything
>like that?
Odd how you ended up on this mailing list without even knowing what
the
mailing list is about.. ;)
Kipp Grose
Database / Web Developer
Charity.ca / Sentient Inc.
[EMAIL PROTECTED] / [EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 3/26/03 8:27 PM
Subject: Re: RE: [cf-xml] xml query problem
I downloaded it from www.torchbox.com/xml/
________________________________________________________________________
________________
>From Simon Horwith <[EMAIL PROTECTED]> on 26 March 2003 8:22:33 AM
To : "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject : RE: [cf-xml] xml query problem
what's this CFXML toolkit? I don't remember ever looking at anything
like
that?
~Simon
Simon Horwith
Macromedia Certified Instructor
Certified Advanced ColdFusion MX Developer
Certified Flash MX Developer
CFDJList - List Administrator
Fig Leaf Software
1400 16th St NW, # 220
Washington DC 20036
202.797.6570 (direct line)
http://www.figleaf.com
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 March, 2003 11:44 PM
To: [EMAIL PROTECTED]
Subject: [cf-xml] xml query problem
Hi all,
I recently dowloaded CFXML toolkit and encounter a problem using
SQL
or Xpath style to query XML file. The XML file format is something like
this :
<CF_XMLDatasource Name="MyData">
<RecordList>
<Record>
<company_name>Dummy Company</company_name>
<company_size>4</company_size>
<alt_address>test</alt_address>
</Record>
<Record>
<company_name>Dummy Company2</company_name>
<alt_address>test</alt_address>
</Record>
<Record>
<company_name>Dummy Company3</company_name>
<company_size>5</company_size>
</Record>
</RecordList>
</CF_XMLDatasource>
When I run this code :
<CF_XMLQuery Datasource="MyData" Name="test" Type="SQL">
select company_name from MyData
</CF_XMLQuery>
Then I received this error message :
Error Diagnostic Information
An error occurred while evaluating the expression:
valuetoput =
replace(listgetat(attvaluelist,counter,'|'),'_nothing_','','one');
QuerySetCell(xmlq,i,valuetoput);
counter = counter + 1;
Error near line 1, column 94.
------------------------------------------------------------------------
----
----
The column name (Record_company_size) that you have specified is
invalid.
Either this query does not have a column
with that name, or you have specified one of the reserved column names,
e.g., RecordCount
The error occurred while processing an element with a general identifier
of
(CFSCRIPT),
occupying document position (1:10415) to (1:10424) in the template file
C:\CFusion\CustomTags\xml\XMLQuery.cfm.
Please advice. Thanks in advance.
-----------------------+
cf-xml mailing list
http://torchbox.com/xml/list.cfm
-----------------------+
cf-xml mailing list
http://torchbox.com/xml/list.cfm
-----------------------+
cf-xml mailing list
http://torchbox.com/xml/list.cfm
-----------------------+
cf-xml mailing list
http://torchbox.com/xml/list.cfm
-----------------------+
cf-xml mailing list
http://torchbox.com/xml/list.cfm
-----------------------+
cf-xml mailing list
http://torchbox.com/xml/list.cfm
