Default value in SQL - new at this :-)

Tee88 · October 19th, 2004, 08:11 AM

I am sending values from a web form to a SQL database. Most of the values are coming from radio buttons. If a radio button option is not selected, how do I get the value in the SQL table to default to Zero? I tried setting the value in Enterprise Manager in the table to default to zero, but that did not work. It returns the results with blank spaces in the table, if no radio option is selected.

If anyone could tell me how to get this to default to zero I would greatly appreciate it.

Thanks,
Tee

ChrisScott · October 19th, 2004, 10:43 AM

Hi Tee,

Can you post the code you are using to update the database?

Cheers,

Chris

Tee88 · October 19th, 2004, 11:21 AM

Code is below:

<%@ Language="VBScript" %>
<% Option Explicit %>

<%Response.Buffer=True%>

<html>
<head>
<title>Call Dispisition Tool</title>
</head>
<body>
<div align="center">
<table width=600 border="0">

<%
dim conn, rs, sql

Set Conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Conn.Open "File Name=d:\_dbconn\DropShip_HRD.UDL"
SQL = "SELECT * FROM CallTool"

    rs.LockType = 3
    rs.CursorLocation = 3
    rs.CursorType = 3 'Set Static Cursor

    rs.Open SQL, Conn

rs.AddNew
rs("CallType") = Request("calltype")
rs("Services") = Request("services")
rs("Video") = Request("video")
rs("Phone") = Request("phone")
rs("Sales") = Request("sales")
rs("Billing") = Request("billing")
rs("General") = Request("general")
rs("Actions") = Request("actions")
rs("Comments") = Request("comments")
rs("Resolved") = Request("resolved")
rs("CSAP") = Request("CSAP")

rs.MoveFirst
DO WHILE NOT rs.EOF
%>

<%
rs.MoveNext
Loop

%>

<%
    rs.Close
    Conn.Close
    %>

<tr>
<td>
<p align="center">Thanks for your response.

</tr>

</table>
</div>
</body>
</html>

ChrisScott · October 19th, 2004, 11:40 AM

Hi Tee,

I guess one or more of the fields in your code is the one you are having trouble with, as you are explicitly setting the field in the db to the Request value, the code is setting the db field to blank, this will override the default value set in the db.

You need to validate the Request value, as you have set a default value already, you could just do:

Code:

If Trim(Request("calltype")) <> "" Then
    rs("CallType") = Request("calltype")
End If

You may however want to check that the all field values are valid, as it is very easy for someone to create a form & target your page with it to add bogus data to your db.

Kind regards,

Chris

Tee88 · October 19th, 2004, 01:05 PM

Thanks!