|
Member 9142936 wrote: The user/member that enter the data thru the Default.aspx will be the "Owner", That means that he doesn't need to "own" the data; he just needs access.
Member 9142936 wrote: I want that same data to be shown to other Users/Members, on a global basis but they can not edit the information, There's still no need to mess around with ownerships. Simply don't provide an update-page if the user is viewing a record that he didn't enter.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
I agree if we look at from that point, the question I need to ask is since the default.aspx is the actual membership/user profile to start his family tree. Would it cause a problem since it is not classified on a ownership basis to the User/Member? The next step would be adding to the tree, (example: mother, father, maternal Grandfather and etc), I just want to make sure that the first data entry of the User/membership has a ownership and all other user/member will be able this data record can added on to another User/Member as part of their family tree profile. The procedures for the User/member to start, are as follow:
Step1: User/Member register. Register.aspx - done
Step2: Email sent to new user/member, Confirm.aspx - done
Step3: New User/Member confirm the link thru email confirmLink.aspx - done
Step4: New User/Member login in to website, login.aspx - done
Step5: New user/member starts building his Genealogy Tree, (user/member profile begins), default.aspx - done, this is user/member actual information.
Step6: Add to the genealogy tree, search the genealogy data table, aspnet_Genealogy, for instant Macdonald, a list of macdonald as a result, SearchResults.aspx, not done, with a select link, the User/Member takes ownership of the data record as part of his/her profile, but at the time the record can be claimed by another User/member.
This is what I am trying to accomplish, will that cause problems with the ownership of my user/members in future data record entries and data ownership for other user/member.
Thanks for your quick response and look forward to hearing from you in the future.
regards
|
|
|
|
|
Member 9142936 wrote: Would it cause a problem since it is not classified on a ownership basis to the User/Member? You'd really need to explain what you mean with ownership; it's an ambiguous term, and it sounds more complicated than need be.
Some user enters "data" on a public website. Fine - who is the owner? And is the owner actually "owner" in terms of system administration?
FWIW, it sounds as if you're simply talking about a user and his data; like you'd be with a FaceBook account. The one who stores his/her info has read/write access, and there's some public view.
Member 9142936 wrote: the User/Member takes ownership of the data record No. You do not "own" the records of the database of your local bank or your doctor. It's their data. Yes, you may be given a read-only view of their data - with some rights to personalize things like your password and your avatar, but that's it. Having you as a physical "owner" of the record would complicate things significantly.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
I am sorry that I was not clear, what I am trying to do is I have a register user who is building a personal family tree, when the user registers, (this is complete), the user creates a password and username, after the user register he taken to a default page where the user starts entering data to build his tree. At this point in time the user can enter the data but he can not save it to his personal tree, that what I mean by ownership.
I want the user to be able to build the family tree by entering, saving and search the information in the database, it is a genealogy database. The Username and password is his personal genealogy tree in the database, that is what I call ownership of the personal genealogy tree.
Can you help me with this ownership part, I look forward to hearing from you and thank you for your patience, I am fairly new to this.
Thanks
|
|
|
|
|
how to set automatice data backup in sql server 2005
|
|
|
|
|
|
You could always setup a SQL Job to run:
BACKUP DATABASE MyDB TO DISK = N'G:\SQLBackup\MyDB_Backup.bak'
WITH INIT, NAME = N'MyDB Backup', SKIP, NOFORMAT, COMPRESSION
|
|
|
|
|
It's a good site or not ? plz tell me any code project link
thanks
|
|
|
|
|
Do you want us to tell you how to carry out a sql injection attack, or how to prevent it?
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
|
Hi,
what is the best way to present a report, showing the dollar value per month for each salesperson in a certain region? Suppose we have Eastern and Western regions. Salesperson Sam, Sammantha, Roger,will
Should I use SSIS package for this purpose, or would a stored proc be able to create this same type of layout?
The report should look like, in an excel spreadsheet:
Region Salesperson Month(Total)
Eastern Sam $1050.00
Roger $100.00
Will $100.00
Total $1250.00
Western Sammantha $2000.00
Total $2000.00
Grand total $3250.00
Any ideas is appreciated!
thanks.
|
|
|
|
|
The UI (report layout) has absolutely NOTHING to do with the database. Use the stored proc to prepare the data for you.
Use the UI (excel or a reporting tool) to do the formatting and layout. You sub/grand totalling should be done in the reporting app, the pretty currency format belongs in the reporting app as well.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello everyone! My name is Emmanuel. Please, I wrote a name dictionary program with visualbasic 6.0 using ms access 2003 as my database. I linked the database with the visual basic program using adodc control. In my system, the application runs fine. But when I installed the application in other systems and tried to run it, an error message will occur saying that the C:\Name dictionary\NameDict.mdb is not a valid path. Please help. Thanks in advance!
|
|
|
|
|
When you install it you must also provide the database file.
Depending on your app either it is a empty file or with some pre-existing data.
The file should installed relative to your code. And I suspect in the same directory is probably going to be best for you.
Then the way you connect must specify that. If you are using ODBC then you need to research the connection string/parameters to discover how to specify the file specifically.
|
|
|
|
|
You are in Switzerland, that is not a 3rd world country (you don't have the excuse that you cannot afford/access .Net tech), why the hell are you developing in VB6, the language is dead and is no longer supported. You should be using VB.Net express which is FREE and supported.
[edit] sorry I seem to be repeating myself [/edit]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I'm fed up of my Ms SQL databases keeps on Disapearing from SMS ,and then keeps on coming back ..it is really frustrating ,is there any other database similar to ms sql which does not have any problem like this?
|
|
|
|
|
Well thats a new one, I have never heard this complaint about SSMS before, I suspect it is your environment rather than SSMS.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
chdboy wrote: I'm fed up of my Ms SQL databases keeps on Disapearing from SMS [..],is there any other database similar to ms sql which does not have any problem like this? The IDE and the Database server are two distinctly different applications. What is dissapearing exactly? The alias as defined in SMS, the database (how? is it simply not visisble in the IDE, or is the actual physical file gone?)
MSAccess doesn't have this problem, but that's hardly a good replacement for Sql Server. Switching db-server will have more impact than simply a different IDE. FWIW, you can always download and use another IDE if you dislike SMS.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Are you using a SQL Express User Instance[^] (AttachDBFilename in your connection string)? These databases will automatically be closed and removed after a period of inactivity, which is why you can't see them in SQL Server Management Studio.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Dear Friends,
I am new to struts2 concept, can any one help me in creating a grid. While displaying the grid it should contain one column which fetches the data from database and another two columns of textfield and dropdown list.
Note:The database connectivity is done with the help of Hibernate
|
|
|
|
|
Wrong forum, you need web development, this is not a database problem.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
This is the error
com.microsoft.sqlserver.jdbc.SQLServerException: The conversion of the nvarchar value '8737383838' overflowed an int column.
I'm putting the value integer into bank account number column.
statement.setString(10,acnotxtfield.getText());
Using prepared Statement.
|
|
|
|
|
the value that you are trying to convert is larger than the int can handle. I would suggest that you change the type to Big Int
int, bigint, smallint, and tinyint (Transact-SQL)[^]
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|