Hi,

I thought I had a nested repeat region working perfectly, until it hit a facilitators name which had a single quote:

O'Conner-Sherry, Connie

This is my code:

-------------------------------

<%
FilterParam = RS_facilitator.Fields.Item("name".Value
RS_fac.Filter = "name = '" & FilterParam & "'"
While (NOT RS_fac.EOF)
%>
<font face="Verdana, Arial, Helvetica, sans-serif" size="1"><%=(RS_fac.Fields.Item("name".Value)%></font>
<%
RS_fac.MoveNext()
Wend
%>

-------------------------------

The name is initially pulled by the "RS_facilitator" recordset and then sent to the "RS_fac" recordset.

Any idea how I can maybe catch the single quote and do something with it?

Help.

Mitch

Mitch

If you are still needing help let me know and I can show you an easy way doing nested repeat regions... I actually created for the first time nested/nested repeat region.

ump32

Hi,

I figured it out, but I would like to see how you are doing it, perhaps it easier.

Thanks!!!

Mitch

When in doubt...reboot!

Mitch

The easiest way to do it and this is how I do it. I create my first recordset and the table holding that information with the extra row for nested region. I then open a new page and remove all html tags from the code window and then create the new recordest refing the other recordset. Create your table with the needed fields in it and then add your repeat region but remember when you add the repeat region you need to change the number of the region from 1 to 2 or whatever. (I do that manually.) Then I copy all the code and past into the original table row.


As long as everything is setup right I can normally do this in about 5 minutes.

Hope this helps....

Hi,

Could you post a sample of the final code, I'd like to see it?

Thanks!

Mitch



When in doubt...reboot!