I need the following asp (vbscript) function that uses parameters to pass data to an sql stored procedure converted into a function that will pass parameters to a mysql stored procedure. I don't want to use any inline sql statements.
Function AddResponse (strResponse)
Dim cmd
Set cmd = [login to view URL]("[login to view URL]")
[login to view URL] = "[login to view URL]"
[login to view URL] = adCmdStoredProc
[login to view URL] = GetDBConnection
[login to view URL] [login to view URL]("@response", adVarChar, adParamInput, 8000, strResponse)
[login to view URL] ,,adExecuteNoRecords
Set cmd = Nothing
AddResponse = strErrors
End Function
Function GetDBConnection()
Dim strServer, strDB, strUser, strPassword
strServer = "localhost:3306"
strDB = "referdb1"
strUser = "root"
strPassword = "sa"
GetDBConnection = "Provider={MySQL ODBC 5.1 Driver};" _
& "Data Source=" & strServer & ";" _
& "Initial Catalog=" & strDB & ";" _
& "User ID=" & strUser & ";" _
& "Password=" & strPassword & ";"
End Function