Check record before Inserting

[arusmart]

Hi,

I have troble in inserting new records into database, I have a unique date
field it should not repeate again, i.e. one record per single day, the insert
record form from DW MX2004 ASP Application is working fine but it is not
checking the date. If the date already exists in the database it shoul redirect
to error page. If the date is not in the database, can be inserted as new
record.

Please help me in this issue. Your great help is highly appreciated

Regards
Arvind Gundet

[Paul Whitham TMM]

There is a behaviour built in called "Check User" which is designed to do
something similar and can be used in this case. All you need to do it map
the field holding the date value on the form with the date field in the
database.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"arusmart" <webforumsuser@macromedia.com> wrote in message
news:d71d1g$m8c$1@forums.macromedia.com...

> Hi,
>
> I have troble in inserting new records into database, I have a unique

date

> field it should not repeate again, i.e. one record per single day, the

insert

> record form from DW MX2004 ASP Application is working fine but it is not
> checking the date. If the date already exists in the database it shoul

redirect

> to error page. If the date is not in the database, can be inserted as new
> record.
>
> Please help me in this issue. Your great help is highly appreciated
>
> Regards
> Arvind Gundet
>

[arusmart]

Paul,

Thanks for valuable responce, New User server (Check User) behavior is not
exists in my Application Panel/Server Behaviors? I am afraid about this , why I
doesn't have this option in my Server Behaviors.

Please suggest me.

[Paul Whitham TMM]

In Application Panel/Server Behaviours click the + option. Then go down to
User Authentication and you will see the "Check New User" option

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"arusmart" <webforumsuser@macromedia.com> wrote in message
news:d73s8a$dm2$1@forums.macromedia.com...

> Paul,
>
> Thanks for valuable responce, New User server (Check User) behavior is

not

> exists in my Application Panel/Server Behaviors? I am afraid about this ,

why I

> doesn't have this option in my Server Behaviors.
>
> Please suggest me.
>