Hyphen in XML row name causing problems

[weezerboy]

I have an xml file that I am trying to turn into a qury object so I can have the query interact with my SQL database

The XML file has 15 rows and I have successfully got 13 of them into a query.

The problem is that the remaining 2 fields have hyphens  or dashes -  in the row names. Like (WORK_E-MAIL)..See the - between E-Mail

So when I go to set the value in the query with this code

   <cfset temp = QuerySetCell(orderquery,"WORK_E_MAIL",

   #mydoc.rowset.ROW.WORK_E-MAIL.XmlText#, #i#)>  

I get this error message

Error Occurred While Processing Request

Invalid construct: Either argument or name is missing.

Is there some way to alias the row name with the hypen, maybe like this {WORK_E-MAIL}  or like this [WORK_E-MAIL]

I need to ge these 2 hypenated named rows into my query.

Any ideas?

[Steve Sommers]

Try:

<cfset temp = QuerySetCell(orderquery,"WORK_E_MAIL",

mydoc.rowset.ROW.WORK_E-MAIL.XmlText, i)>

or:

<cfset temp = QuerySetCell(orderquery,"WORK_E_MAIL",

"#mydoc.rowset.ROW.WORK_E-MAIL.XmlText#", i)>

If either of these work, I'm not sure how your code worked for the first 13 rows.

[Aegis_Kleais · Accepted solution]

Have you attempted to use an assosicative array syntax?

mydoc.rowset.row[ i ][ 'WORK_E-MAIL' ].XMLText