insert values into a MySQL DB from a drop down men

ChrisScott · January 20th, 2005, 08:48 AM

Yes, it will only work on the next page - you haven't submitted the form yet!

crmpicco · January 20th, 2005, 08:49 AM

Error Type:
Microsoft VBScript compilation (0x800A03EE)
Expected ')'
/mackenzie/asp/agency_admin.asp, line 405, column 107
Dim myQuery: myQuery = ("INSERT INTO company(adv_book_time) VALUES('" & Replace(myValue, "'", "''" & "');")
----------------------------------------------------------------------------------------------------------^

crmpicco · January 20th, 2005, 08:53 AM

<%
adv_book_time = Trim(Request.Form(adv_book_time))
If adv_book_time <> "" Then ("INSERT INTO company(adv_book_time) VALUES('" & adv_book_time &, "'", "''" & "');")
End If
%>

Whats wrong with that syntax? Why does it give me this error................

Error Type:
Microsoft VBScript compilation (0x800A0400)
Expected statement
/mackenzie/asp/agency_admin.asp, line 404, column 28
If adv_book_time <> "" Then ("INSERT INTO company(adv_book_time) VALUES('" & adv_book_time &, "'", "''" & "');")

It is pointing at adv_book_time in the mysql string

Santhi · January 20th, 2005, 09:26 AM

Change the below line
If adv_book_time <> "" Then ("INSERT INTO company(adv_book_time) VALUES('" & adv_book_time &, "'", "''" & "');")
to
If adv_book_time <> "" Then ("INSERT INTO company(adv_book_time) VALUES('" & adv_book_time &, "');")

crmpicco · January 20th, 2005, 09:59 AM

Error Type:
Microsoft VBScript compilation (0x800A0400)
Expected statement
/mackenzie/asp/agency_admin.asp, line 403, column 28
If adv_book_time <> "" Then ("INSERT INTO company(adv_book_time) VALUES('" & adv_book_time &, "');")
--------------------------------------------------^

crmpicco · January 20th, 2005, 10:01 AM

<%
adv_book_time = Trim(Request.Form(adv_book_time))
If adv_book_time <> "" Then ("INSERT INTO company(adv_book_time) VALUES('" & adv_book_time & "');")
End If
%>

The ASP above is directly below the <select> tags (drop down menu)

Should it still work?

Picco

ChrisScott · January 20th, 2005, 10:08 AM

What exactly are you trying to do with this section of code?

crmpicco · January 20th, 2005, 10:10 AM

Once a value is selected from the drop-down menu it is taken and added to the database table.

crmpicco · January 20th, 2005, 10:12 AM

do i have to submit the form first?

ChrisScott · January 20th, 2005, 10:15 AM

Quote:

quote:Originally posted by crmpicco
do i have to submit the form first?

Yes, that way you can access it's fields from the Request object.

You can then build an insert query based on those values, then create a connection to your database & execute the query using that connection.