Can you help me determine what this error might mean?
Thanks.

"Microsoft OLE DB Provider for SQL Servererror '80040e14'
Line 1: Incorrect syntax near '='. /Mhome1/_register_2.asp, line 60"

Here are lines 56 through 70:

SQL = "SELECT * FROM mms_tbl_membershipType WHERE ID = " & Trim( request( "MType" ) )
    Set RS = Server.CreateObject("ADODB.Recordset")
    RS.LockType   = 1
    RS.CursorType = 0
    RS.Open SQL, MyConn
      IF NOT RS.EOF THEN
      MMS_PP_ALLOW = 1
      MMS_PP_G_ID  = trim(RS("fldPPMemberID"))
      MMS_PP_CUR = trim(RS("fldCurrency"))
      MMS_PP_NAME = trim(RS("fldMName"))
      MMS_PP_ID = trim(RS("ID"))
      MMS_PP_COST = trim(RS("fldCost"))
      END IF
    RS.Close
    Set RS = Nothing

write the actual value of SQL to screen and you'll probably see where the error is.

Thank you for your reply/assistance.

I don't know how to "write the actual value of SQL to screen". Can you tell me how, please?

Thanks again.

debugging101

response.write SQL
response.end

will print the concatenated string value to screen and stop the script from processing the error line

It means that request("MType") is null.

You really should make sure that request("MType") is a number. You'll end up with some problems (such as this one) if you don't. The best way to do that is to assign Request ("MType") to a variable and then convert it to a number.