> We are working with a customer who has a legacy application > written in a Progress Database that uses SQL-89 query > language. In their customer table the address field (which > has a column heading of ADDR) is an array field. If we use > CFDump to output the query structure <CFDUMP > var="qryCustomer"> we can see the column name information. > And it shows the array field elements as having an @ symbol > in its column heading: > > NAME [EMAIL PROTECTED] [EMAIL PROTECTED] > CITY .... > XYZ Company 111 Main Street [empty string] New York > > But, we can't figure out the correct syntax for a CFoutput > statement for the individual elements of the ADDR array. The > PROGRESS SQL-89 user guide says it should be > #qryCustomer.addr__1#, but that causes an "element undefined" > error. Does anyone have an example of a select statement for > a Progress SQL-89 array field that they can share? Is it > possible to use an @ symbol as a field name using some sort > of escape sequence? Thank you in advance! Dawn
Did you try array notation? #qryCustomer["[EMAIL PROTECTED]"][CurrentRow]# I know that works with spaces, not sure about invalid characters, though. Andy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260524 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
