AnsweredAssumed Answered

ODBC and Repeating Fields FMSA11

Question asked by jcrossfield on May 6, 2010
Latest reply on Aug 23, 2010 by IwaoAVE!

Title

ODBC and Repeating Fields FMSA11

Your post

Hi All,

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[1], repField[2] 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[1]") %>  <%= rsInfo("repField[2]") %>


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?

 

Thanks!

Outcomes