Signup · Login
Stardeveloper.com  
Home · Tutorials · Forums · ASP.NET Newsletter Application · Web Hosting Plans · Faisal Khan's Blog · Contact
Forums : ASP : ASP 3.0 : Database error while inserting data thru ASP Signup · Login
Author Thread
Database error while inserting data thru ASP
Posted in tutorial: An ASP Tutorial to create your own Database driven Search Engine
·  ppscorpio
User
Joined: 8 Feb 2009
Total Posts: 1

Database error while inserting data thru ASP

Posted: 8 Feb 2009
Checked number of solutions, however solution for below is ilusive to me!!!

Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/newshakti/careermap_adddata.asp, line 50

Line 50 is the last line of code:

SQL="insert into calendar_data(ddate,dtime,location,code,technology,level,description,status,mailto,subject)values('" & tdate & "','" & ttime & "','" & tlocation & "','" & tcode & "','" & ttechnology & "','" & tlevel & "','" & tdescription & "','" & tstatus & "','" & tmailto & "','" & tsubject & "')"

cn.Execute SQL

All the variables are defined and no spelling errors!!!

Any help would be much appreciated.
Want to leave a comment? Login or Register for free!

Users Subscribed To This Thread
ppscorpio  

Users Who Have Visited This Thread In Last 24 Hours
4 Visitors

Login to post a comment or start a new thread
UserName Or Email Address:       Password:       Auto-Login:    
· Create New User Account
· Send Forgotten Password by Email
 
© 1999 - 2010 Stardeveloper.com, All Rights Reserved.