Hi
I have a form with user input data and I'm trying to insert this data into a DB. One of my fields doesn't not allow NULL. When the user submits the data and the field with not null is blank I get a DB error like I should. What I'm trying to do is this if the DB gives me an error I would like to display an error page telling the user to input all the data. I'm using asp and IIS5.

I hope I have make my self clear as I'm new to this. If someone has done this please help.

Thanks in advance.
David Verbanatz

Hi,

I don't know your situation
but why don't you use UD's Form Validation
with these rules :
- field may not be empty
- field contains numbers

or you could narrow down the choices
of the user by using a dynamic dropdown menu,
etc ...

greetz

Jezter

Jezter,

Thanks for the reply. Can the UD's Form Validation redirect a user to a new page?

What I have is a form with IdNumber, Name, Address and e-mail. I have the DB set so the IdNumber is the key and it can't be null. What I'm trying to is like udzone did on there sign up form. If a key field is missing I would like to redirect the user to a page telling them they need to input a IdNumber.

I hope this is clear, I will try the Form Validation.

Thanks for the help.
David Verbanatz

The Form validation in UD is a client side check that does not allow redirecting to an other page. There is an extension at www.basic-ultradev.com that does some server side form validation. You could start to play with that one and find out how the code is being build to turn it into your own perfect code.

Waldo Smeets - www.UDzone.com Webmaster
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

Hi,

Just a little remark,
if you input a new user, doesn't the
database automatically creates a unique key ?

Try dropping that field in the form

greetz

Jezter

Hi,

This is a in-house project used by a small set of users. The database key field is coming from a client number list that the user has access to.

You are right I should re-design the DB so the unique key is coming from the DB.

I will look at www.basic-ultradev.com for the server side validation.

Can I get the server side validation udzone is using?

Thanks for all the help
David Verbanatz

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>Can I get the server side validation udzone is using?<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Our is part of the Snitz Forum. You can download it for free at www.snitz.com

Waldo Smeets - www.UDzone.com Webmaster
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>