Retrive data from attribute spaced attribute.

[kruse]

Hi.

I'm retrieving data from an excel sheet.
But one of the attributes is name "Phone private".

This is a problem when I want to write out the value.

Of cause it fails if I do this #Data. Phone private#.

How can I retrieve that value? Is it possible.

I would prefer not to rename the attribute in the excel sheet.

Best regards,
Morten

[reenaroy]

Try this...

<cfquery datasource="xyz" name="Data">
select [phone private] as phone from testTable
</cfquery>

<cfoutput>
#Data.phone #
</cfoutput>

[kruse]

Originally posted by: reenaroy
Try this...

<cfquery datasource="xyz" name="Data">
select [phone private] as phone from testTable
</cfquery>

<cfoutput>
#Data.phone #
</cfoutput>

I guess that that would work.
But for me it is not possible to do so because I dont know what data the sheet
will contain.

I retrieve the data like this.

<cfquery name="GetImportData" datasource="Excel">
SELECT *
FROM [sheet1$]
IN '#Form.FileName#' 'EXCEL 5.0;'
</cfquery>
The sheet can be 5 differet type and therfore I waunt use use your example
because I then had to make 5 different queryes and if a field in the sheet was
altered i had to change the query too.

Any other ideas?

[reenaroy]

Hi Kruse

Use QoQ for this. Full code will look like this

<cfquery name="GetImportData" datasource="Excel">
SELECT * FROM [sheet1$] IN '#Form.FileName#' 'EXCEL 5.0;'
</cfquery>

<cfquery dbtype="query" name="Data">
select [phone private] as phone from GetImportData
</cfquery>

<cfoutput>
#Data.phone #
</cfoutput>