asp with mysql

**sharpinfosys** · 12th December 2005, 11:06 AM

How to insert a records from a text field into a mysql database table in asp.
What is the coding for insert records from text field into a mysql database table in asp.

Is my sql switable for asp.

I make a coding for insert a record in a database table from text field in asp given as followes
After compilation server gives some error.

<%@ Language=VBScript %>

<%

Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString="DSN=sharp.dsn"
objConn.open
category_name=Request.Form("category")
classified=Request.Form("classified")
name=Request.Form("company")
location=Request.Form("location")
country=Request.Form("country")
website=Request.Form("website")
contact_no=Request.Form("contact_no")

mySQL=" Insert into order_details(category_name,classified,name,locati on,country,website,contact_no) values('"& category_name &"','"& classified &"','"& Name &"','"& location &"','"& country &"','"& website &"','"& contact_no &"')"

Set RS = objConn.Execute(mySQL)

%>

**RFH Reseller: nick** · 12th December 2005, 11:29 AM

there appears to be a space in the first instance of the word location (the field name). so try:

Code:

mySQL="	INSERT INTO order_details
			(	category_name,
				classified,
				name,
				location,
				country,
				website,
				contact_no	)
		VALUES
			(	'"& category_name &"',
				'"& classified &"',
				'"& Name &"',
				'"& location &"',
				'"& country &"',
				'"& website &"',
				'"& contact_no &"'	);"

Is the contact_no field definitiely a string in mysql rather than a integer? If it was a number you would want to loose the quotes around it I would think.

Code:

    '"& website &"',
    "& contact_no &"	);"

Warn you now though, I'm not an ASP man, so I might be missing something obvious that is specific to that. Also, I hope you are escaping/validating the user input before the variables go into the SQL.