Empy Form Fields 1

[JrClown]

Hello fellas...
Can someone point me in the right direction on how to verify that only some fields here are not left blank?.
For this example I only need accnumber and taxid not to be left blank. Any help would be appreciated.


SQL="INSERT INTO vendors (accnumber,company,address1,address2,city,state,zip,paymentdate,terms,vendor1099,taxid) Values ("&_
"'"& request.form("accnumber&quot& "', " &_
"'"& request.form("company&quot& "', " &_
"'"& request.form("address1&quot& "', " &_
"'"& request.form("address2&quot& "', " &_
"'"& request.form("city&quot& "', " &_
"'"& request.form("state&quot& "', " &_
"'"& request.form("zip&quot& "', " &_
"'"& request.form("paymentdate&quot& "', " &_
"'"& request.form("terms&quot& "', " &_
"'"& request.form("vendor1099&quot& "', " &_
"'"& request.form("taxid&quot& "')"

Dim RSvendors
set RSvendors=server.createobject("adodb.recordset&quot
RSvendors.open sql, "dsn=db1"
%>






QUOTE OF THE DAY
Not to know if bad; not to wish to know is worse.
<%
Jr Clown
%>

 

[ecannizzo]

if request(&quot;accnumber&quot = &quot;&quot; then
'do something here to fill it in or send the user back to the form
end if

That's how you can test if its null or not...


Thanks!
Erica

 

[JrClown]

Cool. Thanks Erica QUOTE OF THE DAY
Not to know if bad; not to wish to know is worse.
<%
Jr Clown
%>

 

[JrClown]

Just one more Questions Erica
Where on my page is best to append the code?

if request(&quot;accnumber&quot = &quot;&quot; then
'do something here to fill it in or send the user back to the form
end if
Above my SQL?
After each request.form(&quot;&quot field ?
before my HTML ?


QUOTE OF THE DAY
Not to know if bad; not to wish to know is worse.
<%
Jr Clown
%>

 

[ecannizzo]

Definitly above your sql. You don't want your application to enter this info to the database if its not complete. You should do it on the page containing the sql though. If your gonna send them back to the page to complete the form, you should response.redirect them to a page which tells them their error. Then they should get a link which takes them back to the form to complete and resubmit it. (That's just how I would do it though...)

HTH,
Erica Erica

 

[JrClown]

Thanks again Erica. It worked great! QUOTE OF THE DAY
Not to know if bad; not to wish to know is worse.
<%
Jr Clown
%>