Hello, my name is Elliott Giles. Im the league president of the Youngstown Flag Football Association. Im new to this forum but I've been working with Dreamweaver for some time to create my website www.yffa.net . What I would like to do for my flag football league is have a Free Agent page for guys who dont have a team and want to post their attributes online for other teams who may be looking for a player can contact them. So what I'm looking to do it to have the free agent fill out his info on the site, hit submit then BAM, it's on the site for everyone to see. I did a little research and found out that I have ASP scripting capabilities and that I have SQL database through godaddy. So can this be done? I'd appreciate any feedback.

Thanks in advance,
Elliott

Hi Elliot

If you are not that familiar with ASP, you could use the built in wizzards in Dreamweaver to help you achieve this.
Firstly what you would need to do is create a table in SQL Server Perhaps called

TblFreeAgent

Example fields
FreeAgentID (Int)
Fname
Surname
PhoneNumber
Postition......

Once this has been created, you will need to create a DSN on both the computer you are building the website and the webserver that points to this database.

Then in the ASP page do the following


Insert
Application Objects
Insert Record
Record Insertion form wizzard

It will ask you for your connection, this will be the DSN you created, you will need to define this, then once you have done that it will ask you to specify the table that you want to insert into.

This is a good way to get started

Thanks