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
