Reading from Progress db

[jorgepino]

I need to read from a progress db put i ma having problems reading fields with special chars like in Element1% and flux-ecd (% and -)
how should i read them

thanks

[jorgepino]

I need to read from a progress db put i ma having problems reading fields named with special chars like in Element1% and flux-ecd (% and -)
how should i read them

thanks

[mxstu]

I don't know about Progress, but in most databases you can use square brackets
[ ] to escape the column name in your CFQUERY. You could then use array
syntax in your cfoutput. There may be other methods as well.



<cfquery name="test" datasource="#DSN#">
SELECT ID, [Element1%]
FROM yourTableName
</cfquery>

<cfoutput query="test">
#test["ID"][CurrentRow]# | #test["Element1%"][CurrentRow]#<br>
</cfoutput>

[jorgepino]

thanks I tryed the [] with no luck i keep getting this error
[ODBC PROGRESS driver][PROGRESS]Syntax error (7587)

any idea or direction on where i could find some answeres

thanks

[mxstu]

I wish I knew the correct character(s) for Progress db with ODBC... maybe back
tic's? `Element1%`

If not, you might want to try looking in the ODBC documentation or maybe
posting the question to the [url]www.progress.com[/url] forums? If you do find the answer,
definitely to post it here as well :-)

[jorgepino]

thanks
I got was able to get it to work
it was simple but painful

thanks all

<cfquery name="test" datasource="SMDcustom" maxrows="100">
SELECT Element1,"Element1%" as elem1prcnt //// i had to user "" and to
assigned it to some thing else
FROM PUB.PartMaster //// must use
the PUB.
</cfquery>

[jorgepino]

Got It...