Classic ASP Discussion - Form submission to database

Print Page | Close Window

Form submission to database

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=7326
Printed Date: 29 March 2026 at 10:52am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Form submission to database

Posted By: eden24
Subject: Form submission to database
Date Posted: 17 November 2003 at 6:01am

Hi.

I have created a database, a page to view the results and a form page. However I cannot submit the form details to my database, I have been getting the following error;

"Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'Bookingspage_form'
/example/Bookings_process.asp, line 18"

I actually created the form before the database but everything else works apart from this vital stage, can anyone help?

Regards,

Replies:

Posted By: stevem2003
Date Posted: 17 November 2003 at 9:53am

What's on line 18?

-------------
There's no point running if you're on the wrong road!

Posted By: eden24
Date Posted: 17 November 2003 at 2:07pm

Line 18 is:

Firstname=request.Bookingspage("Firstname")

After which I have the various other field names, Secondname etc.

Thanks for responding.

Regards,

Posted By: Mart
Date Posted: 17 November 2003 at 2:19pm

request.Bookingspage("Firstname") What language are you using??? I think you mean request.querystring(key) or request.form(key)

Posted By: eden24
Date Posted: 17 November 2003 at 3:16pm

I am using ASP. I thought I had to use the actual form file name of "Bookingspage"?

Posted By: stevem2003
Date Posted: 18 November 2003 at 10:15am

Sorry, I'm I little confused , what are you trying to do?
Are you saying you have an input form to save items to a database, and then a page to view the database entries?

-------------
There's no point running if you're on the wrong road!

Posted By: eden24
Date Posted: 18 November 2003 at 3:12pm

Hi.

Just to clarify, I am trying to create a form page which will save details to the database, so far I have completed a form and a display page listing all items within the database.

However I am having a problem with my "process" page, as a result when I submit the form I am getting an error. The error at the moment is:

"Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/example/Bookings_process.asp, line 74"

Although the script on line 74 is: Connection.execute(sql) the script relating to the "INSERT" statement is earlier on the page and basically relates to all the input fields in the form.