Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert Into is not working
Message
De
03/10/2001 14:11:32
 
 
À
03/10/2001 14:03:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Divers
Thread ID:
00563755
Message ID:
00563759
Vues:
18
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform