Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert Into is not working
Message
From
03/10/2001 14:11:32
 
 
To
03/10/2001 14:03:08
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00563755
Message ID:
00563759
Views:
17
It looks like you are misssing a paren, if it is not a typo.

set rsData = connectiontodatabase.execute("INSERT INTO USER (user_no,fname,lname) VALUES("&lc_user_no&",'"&lc_fname&"','"&lc_lname&"')")

>When I run the following code from my localhost, it works fine. However, when I laod it out to the web server, I get the error below:
>
>ASP Code:
>
>set rsData = connectiontodatabase.execute("INSERT INTO USER user_no,fname,lname) VALUES("&lc_user_no&",'"&lc_fname&"','"&lc_lname&"')")
>
>Error:
>
>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>[Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor.
>
>Any ideas?
Thanks,
Dan Jurden
djurden@outlook.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform