Hi All,

I am using an insert query, viz.

        objConn.Execute ("insert into empmaster values(" & Request.Form("empid") & ",'"& Request.Form("fname") & "','"& Request.Form("lname") & "',#"& Request.Form("doj") & "#,#"& Request.Form("dob") & "#,'"& Request.Form("mobile") & "','"& Request.Form("phoneno") & "','"& Request.Form("email") & "','1'," & Request.Form("TeamList") & ",'"& Request.Form("designation") & "','password','" & Request.Form("rollno") & "'," & Request.Form("Manger") & ",#" & Request.Form("Ldate") & "#" & ")")

Now problem comes when some values are left blank, i.e. say doj or dob, it give error in that case, what if I want to permit the as blank?

Thanks in advance.:)

Rupen Anjaria.
We CAN'T avoid problems, but of course can solve it.

Check the field in your database to see if it allows zero length

DO as g2000 has said. When you say it gives an error, what error would be helpfull. IMO if you do not need to address a field, dont. Are you aware you can set no nulls and a default value?

Wind is your friend
Matt

Try to insert like this.

set cn=server.CreateObject("adodb.connection")
cn.ConnectionString="....."
cn.Open

isql1="insert into emp (empno,name,dept) values ("
isql2="'" & empno & "',"
isql3="'" & name & "',"
isql4="'" & dept & "')"

sql=isql1+isql2+isql3+isql4

cn.Execute sql


it will more easy.
for blank record, ie.

if Isdate(date_Recd) then
    isql3="'" & date_recd & "',"
else
    isql3="NULL,"
end if


Your coding may be some syntax error.

Mateen

Hi All,

I have set to allow zero leng in db. or say it is allowing null in db.

Mateen: Your solution is worknig fine.

Thanks..

Rupen Anjaria.
We CAN'T avoid problems, but can solve it.

u can create a function which will convert the blank values to zero