ODBC and Repeating Fields FMSA11
I am using Filemaker Server Adv 11 - connecting to my database via the web using ODBC and ASP.
I am trying to get repeating field values from my database to display on my website using ASP.
I see in the FM11 ODBC guide that:
"Note FileMaker repeating fields are supported like arrays.
Examples:SELECT repField, repField FROM mytable"
Unfortunately there is no detail on how to write the values to screen. I assumed it would be like other fields, so I tried this (but with my real field names of course):
<%= rsInfo("repField") %> <%= rsInfo("repField") %>
However this is the response
"Item cannot be found in the collection corresponding to the requested name or ordinal."
When I change it to:
<%= rsInfo("repField") %>
I just get the data from the 2nd repetition field only.
How do I get it to write each value from each repetition?