Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Writing to a FoxPro table with ASP
Message
From
26/02/1998 11:16:39
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Internet applications
Title:
Writing to a FoxPro table with ASP
Miscellaneous
Thread ID:
00081398
Message ID:
00081398
Views:
49
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
Map
View

Click here to load this message in the networking platform