Checkbox problems

**mattyd22** · Sep 16, 2002, 07:39

Hi all,

I'm having problems passing values from a form to insert them into a database:

The form checkbox on the form itself is:

------------------------------------
<input type="checkbox" name="expertise_general" value="1">
------------------------------------

This gets passed (posted) to a preview page:

---------------------------------------------
<%
Dim expertise_general

expertise_general = Request.form( "expertise_general" )
%>
<html>
<form method="post" action="send2.asp">
<input type="hidden" name="action" value="register">
<table>
<tr>
<td>Expertise qualities

/td>
<td><%=expertise_general%></td>
<td>
<input type="hidden" name="expertise_general" value="<%=expertise_general%>"></td>
</tr>
<input type="submit" value="Submit" name="submit">
</table>
</html>

----------------------------------------------
The page that adds the info to the database has this at the top:
-------------------------------------------------

<% @LANGUAGE = VBSCRIPT %>
<%
If request("action") = "register" Then
username=trim(request("username"))

<%
set Rs=server.Createobject("ADODB.RECORDSET")
sql="SELECT * FROM table_name WHERE username='"&username&"'"
Rs.Open sql,objConn,1,3
If rs.eof Then
rs.AddNew

If request("expertise_general") Then rs("expertise_general") = 1
rs.Update
rs.close
set rs = nothing
objConn.close
set objConn = nothing
response.Redirect "thankyou_1.asp"
Else
response.Redirect "sorry_password.asp"
End If
Else
%>

-------------------------------------------

I'm getting an error:

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: '[string: ""]'
/
---------------------------------------

^ and this is pointing to the line which handles the entry of the checkbox infor on the page that submits it to the database.

Any ideas anyone?

Matt

**jofa** · Sep 16, 2002, 08:34

Try
If Request("expertise_general") <> "" Then...
or
If Request("expertise_general") = "1" Then...

**JimBolla** · Sep 16, 2002, 08:34

which line is getting the error? btw, if you put [ code ] [ /code ](w/o the spaces) tags around your code, it will format it nicer for those of us trying to help

**mattyd22** · Sep 16, 2002, 08:40

I'm getting an error on the line that's got:

If request("expertise_general") Then rs("expertise_general") = 1

**JimBolla** · Sep 16, 2002, 08:43

ah. request("expertise_general") probably won't evaluate to a boolean expression because it is a string value. try:

Code:

If request("expertise_general") <> "" Then ...

**mattyd22** · Sep 16, 2002, 08:52

Hi Crowdozer and Jofa,

Thanks for your help.....worked fine.. cheers

Matt

User Tag List

Thread: Checkbox problems

Thread Tools

Display

Checkbox problems

Bookmarks

Bookmarks

Posting Permissions