2. ASPRunnerPro General questions
  3. Trial of AspRunner
This topic is locked

Trial of AspRunner

 		11/22/2006 9:25:59 PM
ASPRunnerPro General questions
V
 vlree author

I am trying to test AspRunner to see if it can help me set up a website module.

I have these tables:

tbl Member

tblContact

tblMemberContact

tblUser
tblUser stores the UserName and passwords for the MemberContacts. Upon Login I only want that person to see information for their company.
tblMember.MemberID is FK in tblMemberContact

tblContact.ContactID is FK in tblMemberContact
tblMemberContact.MemberContID is FK in tblUser
Can I accomplish this?

ie:

Joe Smith works for Smithville Apple Company

he would have a contactID and a MemberContID
if he logs in I would like him to only be able view, edit update the Member record for Smithville Apple Company. So far the log in allows login with viewing all records possible.
Thanks for your help - if this would work I would def buy this product. Thank you.
Sergey Kornilov admin 11/23/2006

You need to use User can see and edit their own data only security mode.
Use this mode for all tbl Member, tblContact and tblMemberContact tables choosing correct owner id field.
For more info see http://www.xlinesoft.com/asprunner/docs/ad...ty_settings.htm
V
 		vlree author 11/24/2006

You need to use User can see and edit their own data only security mode.

Use this mode for all tbl Member, tblContact and tblMemberContact tables choosing correct owner id field.
For more info see http://www.xlinesoft.com/asprunner/docs/ad...ty_settings.htm


2. Users can see and edit their own data only

This option allows to restrict users to view and edit their own records only. To use this option you need to set a relationship between table that holds usernames and passwords and main data table.


The problem I have is there is no relationship between the table that holds usernames and passwords(tblUser) and the main data table(tblMemberCompany or tblContact). the relationship is between tblMemberCompanyContact and tblUser.
So if I was to create a login restricting use to tblMemberCompanyConact I am successfull - however to then proceed and update just that one Contact record - I have not been successful.

I can give you a link and can PM you a password.
J
 		Jane 11/24/2006

You can send it to the [email=support@xlinesoft.com]support@xlinesoft.com[/email].
V
 		vlree author 11/24/2006

You can send it to the [email=support@xlinesoft.com]support@xlinesoft.com[/email].


sent thank you
V
 		vlree author 11/27/2006

Ok I am still trying and not successful -

i have this query

SELECT dbo.tblMemberContact.MemberContId, dbo.tblMemberContact.MemberId, dbo.tblMemberContact.ContactId, dbo.tblMemberContact.PrimaryContact, dbo.tblMemberContact.Board, dbo.tblMemberContact.Emergency, dbo.tblMemberCompany.MemberID AS m, dbo.tblMemberCompany.CompanyName AS companyname, dbo.tblContact.ContactID AS contactID, dbo.tblContact.FirstName, dbo.tblContact.LastName

FROM dbo.tblMemberContact

INNER JOIN

dbo.tblMemberCompany ON dbo.tblMemberContact.MemberId = dbo.tblMemberCompany.MemberID

INNER JOIN

dbo.tblContact ON dbo.tblMemberContact.ContactId = dbo.tblContact.ContactID

WHERE (dbo.tblMemberCompany.MemberID = 467)



and in trying to update a member contact i get this error:

Item cannot be found in the collection corresponding to the requested name or ordinal.


I have tried writing the query in a variety of ways to no avail.
Sergey Kornilov admin 11/27/2006

You cannot update multitable join query. There is no need to use join query in this scenario.
Use "Users can see and edit their own data only" security mode to link tblMemberContact

and tblUser tables.
Create a master-details relationships betwen tblMemberContact and tblMember and between tblMemberContact and tblContact tables.
This is it.
V
 		vlree author 11/28/2006

You cannot update multitable join query. There is no need to use join query in this scenario.

Use "Users can see and edit their own data only" security mode to link tblMemberContact

and tblUser tables.
Create a master-details relationships betwen tblMemberContact and tblMember and between tblMemberContact and tblContact tables.
This is it.



thank you for the reply - and i took your advice and set it up exactly as you suggested. However - I guess I am just not understanding - I apologize. I set up the query used in previous query - because tblMemberContacts is just a table of ID's - so for a person to be able to update their info - its quite confusing.

Here is a link to the login

http://69.56.155.162/mycompany/Project2/output/login.asp
I will pm the password.
Thank you for your time, I must compliment you on your support - I have not purchased the software yet and you have been most willing to help. I am very impressed with what it does do!
Sergey Kornilov admin 11/28/2006

Send your password to support@xlinesoft.com.
V
 		vlree author 11/28/2006

Send your password to support@xlinesoft.com.



done
Sergey Kornilov admin 11/28/2006

Answered to your personal email.