Sitestepper

Can you show us the result of the response.write sql statement

Try the following code from my AspLib-library of general asp-classes and asp-functions: [code=asp] sub SendMail( byval psTo, byval psSubject , byval psBody ) '______________________________________________________________________________ ' ' 'Send Mail' '______________________________________________________________________________} Dim iMsg Dim iConf,Flds if psTo = "" then Exit sub Set iMsg = CreateObject("CDO.Message") Set iConf = CreateObject("CDO.Configuration") Set Flds …

So you can create tables, but not the triggers of these tables ? How do you create tables ? Using MSSql is really of no use if you cannot use triggers or stored procedures.

ActiveConnection should be assigned a Connection object, not a string ? [code=asp] Set objConn = Server.CreateObject("ADODB.Connection") Set objRec = Server.CreateObject("ADODB.Recordset") strConn = TheCorrectConnectionString objConn.Open(strConn) objCmd.ActiveConnection = objConn [/code]

As far as I know asp is enabled by default on a @in 2K server. Try to refrain from using ocx-s, since they can only be loaded in IE.

Of course, a readio button is just a representation of a kind of input. When you press submit the selected value is assigned to the name of the radio button, and that information is send to the next asp-page. There you have to retrieved using request.querystring or request.form.