473,473 Members | 1,782 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

SQL 2000 and Frontpage

I am very new to SQL. I am designing a website using Frontpage 2002 and
Microsoft SQL 2000. I have the databse all set up and am able to access the
data from the database using the ASP pages I have created.

The website runs on IIS 5.0 and I am using NTFS authentication with Client
Certificates. I have a database called call_log and this is where all my
salesman enter in their customer call activity.

What I want to happen is when Joe loggs into the website and goes to view
the call_log ASP page, he only sees the call logs that Joe has entered and
not the entire database.

I have been able to accomplish this by creating a seperate page for each
salesman and then having them select their name from a menu to get to this
page. What I would really like to happen is for the database to know whose
call logs to return depending on the userename that is logged in.

I do not know if I am totally way off base in thinking that this can be
done, but it seems to me it should be able to be done with some sort of
permissions. If anyone could give me a few pointers I would appreciate it.
Thanks!
Jul 20 '05 #1
0 1874

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Roxane | last post by:
Im not sure I picked the right newsgroup to put my post... But hoping someone can help me.. I have frontpage 2000.... And I have several websites created in there... One is located in Windows...
2
by: Jerry Sacks | last post by:
I Purchased Visual Studio .Net Enterprise Architect I Have Installed it on my Window 2000 computer with a FAT32 file system. Service Pack 4 installed. However in installing IIS I have been unable...
2
by: mickrourke | last post by:
Hi, Well I'm brand new to frontpage and SQL so I'm probably doing something really stupid.... but here's the problem. I have created a form that saves it's information to an SQL server databse. So...
3
by: Patrick Nolan | last post by:
Hello, When I run my aspx pages with IIS on my own 2000 pro machine the pages display as if the page is a regular asp page. It seems to ignore my CodeBehind code. I can run the same page with...
4
by: Jim Heavey | last post by:
I have a friend that does all of their web page development in FrontPage and she has asked me to create some asp.net pages for here with some db functionality. I know nothing of Frontpage ans she...
0
by: Robert Hanson | last post by:
Hi All, I get the following error when trying to debug an ASP.Net app: Cannot start debugging Unable to find Microsoft Internet Explorer I never had any trouble until after I installed...
2
by: =?Utf-8?B?Smlt?= | last post by:
I currently have three new websites under development and all need ASP.NET 2.0 type functionality such as Membership and data access. I currently use FrontPage 2003 as my preferred website...
1
by: haries.ahmad | last post by:
Hi all.. i'm newbie in aspnet. i kind a confuse which one should i use for my database system. SQL 2000 or 2005, and what is the different. thankyou
14
by: boliches | last post by:
Help please. I have looked everywhere for the answer. I have a form (created in MS Frontpage 2000) FinanceApp.asp which should send the data to an Access 2000 database when the "Submit" button...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.