Pull up and edit records!!!

R

Ramkay

Hello,

I am running Win2k Active directory. I am also running IIS that is connecting to SQL2k. I am putting together a Website using frontpage 2000. I am able to settup forms that would insert records into the Database, I am able to pull up records from the database in read only mode. Here are my questions: How would I be able to do searchs on specific records, and how would I be able to, through the the proper authentication, allow user to pull up only their own records and update those records. The IIS server is curently running the Server extensions. If you know of any microsoft or third party templates that would help or if you the answers I would really appreciate it.

Thank you
 
J

Jim Buyens

Howdy.

To get this level of control, especially allowing users
to pull up and update their own records only, you would
have to write some custom ASP or ASP.NET pages.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------


-----Original Message-----
Hello,

I am running Win2k Active directory. I am also running
Click to expand...
IIS that is connecting to SQL2k. I am putting together a
Website using frontpage 2000. I am able to settup forms
that would insert records into the Database, I am able to
pull up records from the database in read only mode. Here
are my questions: How would I be able to do searchs on
specific records, and how would I be able to, through the
the proper authentication, allow user to pull up only
their own records and update those records. The IIS
server is curently running the Server extensions. If you
know of any microsoft or third party templates that would
help or if you the answers I would really appreciate it.
 
A

Andrew Murray

in the database results connection wizard you can put in custom sql queries.

Ramkay said:
Hello,

I am running Win2k Active directory. I am also running IIS that is connecting
Click to expand...
to SQL2k. I am putting together a Website using frontpage 2000. I am able to
settup forms that would insert records into the Database, I am able to pull up
records from the database in read only mode. Here are my questions: How would I
be able to do searchs on specific records, and how would I be able to, through
the the proper authentication, allow user to pull up only their own records and
update those records. The IIS server is curently running the Server extensions.
If you know of any microsoft or third party templates that would help or if you
the answers I would really appreciate it.
 
A

Andrew Murray

in frontpage the Database Interface Wizard allows adding, deleting and editing
records. as always, the frontpage extensions, Access and IIS for these features
must be supported by your host.

Ramkay said:
Hello,

I am running Win2k Active directory. I am also running IIS that is connecting
Click to expand...
to SQL2k. I am putting together a Website using frontpage 2000. I am able to
settup forms that would insert records into the Database, I am able to pull up
records from the database in read only mode. Here are my questions: How would I
be able to do searchs on specific records, and how would I be able to, through
the the proper authentication, allow user to pull up only their own records and
update those records. The IIS server is curently running the Server extensions.
If you know of any microsoft or third party templates that would help or if you
the answers I would really appreciate it.
 
Top