Detecting Blank form field

[www]

Hi there,

I' m getting a (0x80040E2F) error, if I submit my form, with blank textboxes
to my update stored procedure. The stored procedure expect values, so how
can I detect if a form field was empty. I've tried testing to see if the
form field is null, blank and to count the characters, but I can't get it
working. My SQL table allows nulls, so it's not that.

thanks in advance
Charles

[Lasse Edsvik]

www,

i assume you have:

CREATE .....
@a INT = NULL
AS
.......


<%
a = request.form("a")
........
if a<>"" then passthevalueAtoSP

%>

hope it makes sence :)

Best regards
/Lasse



"www" <charles@paltrack.co.za> wrote in message
news:3f5ede91$0$64720@hades.is.co.za...

> Hi there,
>
> I' m getting a (0x80040E2F) error, if I submit my form, with blank

textboxes

> to my update stored procedure. The stored procedure expect values, so how
> can I detect if a form field was empty. I've tried testing to see if the
> form field is null, blank and to count the characters, but I can't get it
> working. My SQL table allows nulls, so it's not that.
>
> thanks in advance
> Charles
>
>

[Dale J. Kovacs]

Whether you are submitting the page back to itself, or to
another page you could simply embed your submit within a
logic structure.

exp:

If Request.Form("form_field1") <> "" AND _
Request.Form("form_field1") <> "" Then
'submit the form
End If

However it's always a good practice to make sure all
values submitted to your database are in the correct
format and then submit.

exp:

b_submit_form = True

'I set all my variables first so I can reuse them later
'or alter them as needed.

d_date = Request.Form("form_field1")
i_value = Request.Form("form_field2")
s_comments = Request.Form("form_field3")

'In this example I want to confirm that the entered value
'is a date.

If IsDate(d_submit_date) = False Then
b_submit_form = False
'you can reset the variable back to blank if you
'refill the form later.
d_submit_date = ""
'you can also set an error message to display to the user
s_error = s_error & "A date must be a valid date. "
End If

'In this example I want to confirm that the entered value
'is a number.

If IsNumeric(i_submit_value) = False Then
b_submit_form = False
s_error = s_error & "FormField2 must be a numeric
value. "
End If

'In this example I want to confirm that the form field is
'not blank.
If s_comments = "" Then
b_submit_form = False
s_error = s_error & "FormField3 must be entered. "
End If

'Each form field Item would be checked to confirm proper
'values then we can submit the form

If b_submit_form Then
'submit the form
If Err.Description <> "" Then
s_return_message = "The following error occurred: " &
Err.Description
Else
s_return_message = "Thank you."
Else
s_return_message = s_error
End If

Of course everyone has there own ways of doing things,
this is just how I do it to make sure everything is in
order prior to submitting it to the database, and to let
the user know when there are problems.

Hope this helps,
- Dale