General information
Category:
Internet applications
Title:
Writing to a FoxPro table with ASP
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only