>I am experimenting with Active Server Pages and trying to
>READ and WRITE to a Visual FoxPro free table.
>
>I can READ from the table just fine and I can WTITE
>hard coded strings to the table.
>
>However, I am having trouble writting variable information
>to the table.
>
>In my ASP page, I open the table up alright, and I capture
>form information and store it to variables alright, but I can't
>write the variable information to ny table.
>
>Below are 2 examples. Example 1 works in my Active Server Page.
>Example 2 returns an error message.
>
>Example 1. Works.
>sql = "INSERT INTO ROSTER (last, first) VALUE ('John', 'Doe')"
>
>Example 2. Error.
>sql = "INSERT INTO ROSTER (last, first) VALUE ('&<%=l_last%>&', '&<%=l_first%>&')"
>
>How should I format example 2 to make it work?
>
>Thanks,
>
>Jerry Tovar
Try sql = "INSERT INTO ROSTER (last, first) VALUE ('" + <%=l_last%>+"','" + <%=l_first%>+"')"