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
