<% strMake = session("EditMake") ' Create a recordset object to store specific table information Set conn = Server.CreateObject("ADODB.Recordset") 'Establish what records you want selected for the SQL query string SQL = "Select * From CDMakes where CDMake = '" + strMake + "'" 'Set the recordset object equal to the SQL query string conn.Open SQL, objADO, 1, 3 strVehicleMake = conn("CDMake") strVehicleMake2 = request("Make") If Request.form <> "" Then if strVehicleMake2 = "" then strWarningErrMsg = "
All fields are required." end if if strWarningErrMsg = "" then conn("CDMake") = strVehicleMake2 'conn("Sizeof1") = strSizeOf1 'conn("Sizeof2") = strSizeOf2 'conn("TextUnder") = strTextUnder Conn.update Response.Redirect "menu.asp" end if end if %> <% if strWarningErrMsg <> "" then %> <% end if %>
EDIT VEHICLE MAKE - STEP 2
Error(s):<%= strwarningErrMsg %>


Edit the vehicle make below.
Vehicle Make: <% if request.form <> "" then %> <% else %> <% end if %>