I am completely new to ASP but I am trying to build a DB that has update/delete/add forms. It is just about ready, but I got stuck at queries. In order to build a query I need one of the values entered as radio button or checkbox. One of the value would be "Sales Tools" the other would leave the field empty in the "YN_Sales_Tools" coloumn.

I need to leave it empty to avoid empty urls, and to cloak long URLs that are built as:
<a href="<%=rs("Sales_Tools")%>" target="_blank"><%=rs("YN_Sales_Tools")%></a></td>
The field "Sales_Tools" won't always contain a url, only if the radio button/checkbox passes the value "Sales Tools"

However, I can't seem to be able to pass a value into the DB at all. Can you please help me with some sample code both for the form as well as action code?
Thank you,
M

post all the code form that page.

Radio buttons have either a yes/no or on/off value, so depending on how you have your radio button setup, your SQL statement will be of the format:

SalesTools = on

or

SalesTools = yes

Hope this helps. :)

Pat Wong
http://www.napathon.net/ - Music Around The World
For collecting tips, trade and want lists, album reviews and more.

If the checkbox is called "SalesTools" on the first page (form), you may need to request it on the second page (processing page). Also, I'm not sure what your db is. If it is MsSql then you can use a DataType of "bit", where a value of 1 = true and 0 = false. In your second page try this...

<%
SalesTools = request("SalesTools")
if SalesTools = "" then SalesTools = null
%>