|
You'd always want in in a different language and with some additional fields, but a good starting point for a good model
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Eddy Vluggen wrote: You'd always want in in a different language
With decades of experience with munging data from one format to another using perl that is never a problem.
Especially versus trying to get any actual business requirements out of anyone which is much harder.
|
|
|
|
|
No such thing as simple for modeling a hospital. I suggest you design out what you need and then perhaps look at examples, as posted in the first answer.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
|
Richard Deeming wrote: nobody here is going to do your work for you
Per the link above somebody did do the work although not specifically for him.
|
|
|
|
|
Hi,
I would like to ask how can I encrypt a datatype in MySQL?
I have an employees database and need to encrypt the salary field?
Thanks,
Jassim[^]
Technology News @ www.JassimRahma.com
|
|
|
|
|
Encrypt inside the database? Why?
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
because it's auditor requirement to have the salary field encrypted
Technology News @ www.JassimRahma.com
|
|
|
|
|
Jassim Rahma wrote: because it's auditor requirement to have the salary field encrypted
Certainly not the stupidest thing I have heard but it certainly ranks up there
|
|
|
|
|
|
Hi All,
I have a database in Prod as DbX, and its a live database each time we deploy some schema changes on the Database we Post fix the date, which is working good so far. Its good so far, but to not to change the Connection Strings can I alias database with a particular name to keep the Connection String same but inside database they point to the different times different databases according to the newest version.
Why we are keeping different versions every time is, if we keep the same name and restore multiple times from local backup then the Server backup we do, the local backup restore is influencing on the Server backup with SQL Safe Backup.
So the question is can we have an Alias of the database which points to the different active database for every new release and still can be access from UI with the same Alias name so that UI team doesn't have to change their connection strings for every new release of the database?
Any help, a link, a code snippet or even a suggestion would be very very helpful.
Thanks in advance.
Thanks,
Abdul Aleem
"There is already enough hatred in the world lets spread love, compassion and affection."
|
|
|
|
|
You are doing this completely wrong, do it the same as you would do a branch, leave your latest version with the original name and change your archive database name before deploy a new version.
Your production database should never change its connection string.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Makes sense thanks man.
Thanks,
Abdul Aleem
"There is already enough hatred in the world lets spread love, compassion and affection."
|
|
|
|
|
|
And you are telling me this for a reason!!!
Also while the answer is technically correct it is the wrong solution, the archives need to be changed but the production database.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Notice the site-driving spam link at the bottom of the message.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
i created an event on one of my db to kill process using root as the definer.
DELIMITER $$
CREATE DEFINER='root'@'localhost' EVENT `db`.`kill_processes`
ON SCHEDULE EVERY 5 SECOND
ENABLE
DO
BEGIN
DECLARE process_to_kill VARCHAR(25);
DECLARE done BOOLEAN DEFAULT FALSE;
DECLARE find_process CURSOR FOR
SELECT CONCAT('KILL ', `ID`, ';') FROM `information_schema`.`PROCESSLIST`
WHERE `information_schema`.`PROCESSLIST`.`USER` = 'some_user' AND
`information_schema`.`PROCESSLIST`.`COMMAND` = 'Sleep' AND
`information_schema`.`PROCESSLIST`.`TIME` > 90;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
OPEN find_process;
loop_process : LOOP
FETCH find_process INTO process_to_kill;
IF done THEN
CLOSE find_process;
LEAVE loop_process;
END IF;
SET @f_p = find_process;
PREPARE stmt FROM @f_p;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
END LOOP loop_process;
END$$
DELIMITER ;
but unfortunately it is not working, the event is executing every 5 seconds but it doesnt kill any process that is runnig more than 90 seconds.
any help will be appreciated.
thanks
|
|
|
|
|
anyone please
|
|
|
|
|
I am do dumb to to write this and didn't figure it out quickly
SET @f_p = find_process;
BTW it is working now
|
|
|
|
|
how are you all.
i am new to asp.net and c#. i need help.
well my question is, i have a textbox in which a user have to enter a float value in the webform.
and i want to manipulate that value in a calculation.
so have created a class for the calculation which is Sales class. in that class i have declared Price as a float value,the value which should be obtained from the textbox.ie public float Price {get;set;}
Now my problem is with binding/linking the Price variable with the textbox in the button_click method.
initially i had done it this way:
in my .aspx.cs file i have created an object of the class in this case :
Sales s = new Sales ();
protected void button_Click (object sender EventArgs e)
{
s.Price =Convert.ToInt32(Textbox1.Text);
s.Save();
}
i want the Price value to be saved in my database after a user clicks the SAVE button from the webform.
Now the problem is when i run the application there is an error (
An exception of type 'System.NullReferenceException' occurred in Version1.dll but was not handled in user code )
on the line :
s.Price = Convert.ToInt32(Textbox1.Text);
could i have done something wrong in the code?
|
|
|
|
|
Member 12287337 wrote: could i have done something wrong in the code?
Possibly, but you have definitely done something wrong by pasting this in the Database forum - It probably belongs in the C# forum[^]
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
|
When you get a NullReferenceException you have to look at the line where it occurs and ask yourself: What could be null here that shouldn't be null? There are two variables involved: TextBox1 and s . TextBox1 could be null but you probably have let it "set up" for you by the designer so it's unlikely. That leaves s. Have you initialized s with an instance of its class Sales, something like Sales s = new Sales(); ?
Edit: Yes, you have. Sorry, I completely missed it.
So then run your App in debug mode and when you hit that line where the exception occurs inspect all variables on that line to find out which one is null.
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
modified 2-Feb-16 7:17am.
|
|
|
|
|
Sascha Lefèvre wrote: Have you initialized s with an instance of its class Sales, something like Sales s = new Sales(); ?
He states so in the OP.
Member 12287337 wrote: in my .aspx.cs file i have created an object of the class in this case :
Sales s = new Sales ();
|
|
|
|
|
My bad :/
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|