|
-
May 29th, 2001, 10:48 PM
#1
Thread Starter
Junior Member
Adding a record to a Database?
Hi I'v been trying to insert a record to a database using this code:
Set editCmd = Server.CreateObject("ADODB.Command")
editCmd.ActiveConnection = "dsn=Message;"
editCmd.CommandText = "insert into Posts (Date_added,Name,Email,Subject,Text) values ('5/29/2001 8:00:24 PM','Stephen',' [email protected]','Test','Testing.') "
editCmd.Execute
editCmd.ActiveConnection.Close
to create a Message Board, but I always get this error :
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/syt/BillBoard/Index.asp, line 91
I'm totaly clules why this is happening
Help!!!!!!!!!!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|