How Create New Server Objects

[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

[danilocelic *TMM*]

arusmart,

Take a look at the Check New User server behavior, despite it's name, it
can be used to check for the existance of a value in a column before
going ahead with an insert.

--
Danilo Celic
| Extending Knowledge, Daily [url]http://CommunityMX.com/[/url]

[arusmart]

Danilo Celic,

Thanks for valuable responce, New User server 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.

[danilocelic *TMM*]

arusmart wrote:

> Danilo Celic,
>
> Thanks for valuable responce, New User server 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.

Which server model are you working with?

--
Danilo Celic
| Extending Knowledge, Daily [url]http://CommunityMX.com/[/url]

[arusmart]

Danilo Celic,

I am using ASP.NET VB server model, DWMX 2004 7.0.1

[danilocelic *TMM*]

arusmart wrote:

> Danilo Celic,
>
> I am using ASP.NET VB server model, DWMX 2004 7.0.1

I think that the .NET server models don't have that as an option. What
you'll need to do instead is to write your own query to check for teh
value and then do the insert only when that is true. I don't know .NET
well enough to direct you on that. I'd suggest you ask over in the
Application Dev group:
[url]http://www.macromedia.com/cfusion/webforums/forum/categories.cfm?catid=263[/url]


Also, you can try a couple of .NEt extension sites, but I'm not aware of
if they has such an extension:
[url]http://www.webxel-dw.co.uk/[/url]
[url]http://www.ebconcepts.com/asp/dwmx_extensions.asp[/url]



--
Danilo Celic
| Extending Knowledge Daily : [url]http://CommunityMX.com/[/url]
| Team Macromedia for Dreamweaver : [url]http://macromedia.com/go/team/[/url]

[arusmart]

Thanks Danilo for spending your valuable time for me.