Posts by dickersonka

you should do this code side, rather than database side

34 = 00034 as far as numeric terms

if you want it display that way in a query use leading zeros

here's how to do it in sql server
http://www.sqlusa.com/bestpractices2005/padleadingzeros/

same thing as in the forum PreparedStatements

http://java.sun.com/docs/books/tutorial/jdbc/basics/prepared.html

PreparedStatements

here's how
http://java.sun.com/docs/books/tutorial/jdbc/basics/prepared.html

yes, do a google search on c# impersonation

or use regedit to view permissions

manipulate the filename before creating the saveFile

string newFile = FileUpload1.FileName;
newFile = "myfilename_" + newFile;
saveFile = Path.Combine(savePath, newFile);

you either can check permissions in regedit and grant the user, or if you impersonate the local system account that should work as well

and tcpip is available?

if so, make sure your connection string is correct

inline sql

how many times have you said when using a computer, wouldn't it be easier if.....

thats a place to start, make all your would be's happen, you will learn a lot along the way

either a path or a url to the image file

exactly as you said, they are private, make them protected

that constraint won't be in the database either, it will be in the query

you can do a select on the parts you need, join to the supplies and find out how many suppliers offer it, if 2 then you can allow ordering or whatever it is

the sql server machine needs to be configured with that because it is the "remote" machine

Well that depends, what type of driver are you communicating with?

Also how much data are you trying to send it? Like a variable or two, or like pages worth of information?

And also how frequently?

You need to configure it to allow remote connections

http://www.linglom.com/2007/08/31/enable-remote-connection-to-sql-server-2005-express/

I have ran into this before, when trying to communicate between drivers and applications.

If you are running on Vista with sp1 this is a no no, and it will give you this error.

I would recommend changing your code to either use registry or file to communicate between the app and driver to eliminate your protected memory issue.

here is a little easier

public void initializeColor() {		
if(Math.random() <= 0.7){
     color=normal;
}
else {
     color= abnormal;
}
}

what is not working properly

also i think you want

a <= 7.0

Briefly looking over it, it looks much better than your first post

if you have a specific problem with part of this let us know, but we can't test the entire program for you

this is asking for disaster

Player temp = new Player(dataFile.nextLine(), dataFile.nextLine(), dataFile.nextFloat(), dataFile.nextFloat(), dataFile.nextInt(), dataFile.nextInt());

separate that out and find out where its messing up
example

String str1 = dataFile.nextLine();
String str2 = dataFile.nextLine();
//....
Player temp = new Player(str1, str2, ...);

and as i said before....the admin is just the database adminstrator and there is no individual admin.

hmmm, still not perfectly clear to me, maybe tim understands a little more

are you meaning admin is a database user(windows / sql user account) or there is a table you are wanting called admin that has user credentials for an administrator?

Lol lizr i saw your textbox comment the other day, and thought you must have been a little preoccupied.

Ans as Lizr said, its in the helpfile along with the example i gave you.

sorry forgot the thread part

private void DownloadData()
{
//your code in here that downloads your values
}

private void GetDropDownValues()
{
 Thread t= new Thread(new ThreadStart(DownloadData));
            t.Start();

            while (t.IsAlive)
            {
                UpdatePb();
                System.Threading.Thread.Sleep(50);
            }
}

also, i wouldn't recommend it, but you can call UpdatePb() from anywhere in the code, because it will invoke itself if it is a cross thread call

the concept is right, i gave you an example with a button, you can do the same with a progress bar

this assumes you have progressbar name pbStatus

private delegate void UpdatePbDelegate();
        private void UpdatePb()
        {
            if (this.pbStatus.InvokeRequired)
            {
                UpdatePbDelegate updateCount = new UpdatePbDelegate(this.UpdatePb);
                this.pbStatus.Invoke(updateCount);
            }
            else
            {
                if(this.pbStatus.Value == 100)
		{
			this.pbStatus.Value = 1;
		}
                this.pbStatus.PerformStep();
                this.pbStatus.Refresh();
            }
        }

When you say there is a relationship between the admin and the other entities, what do you mean?

They are allowed to edit as far as UPDATES, INSERTS, and DELETES or do you mean the admins are the owners of the movie hall? And just to be sure, hall means movie hall?

i would say to do it like this

admin -> hall -> branch -> movie -> seat -> customer

check out these

http://pagebox.net/soft.html

http://www.boost.org/doc/libs/1_36_0/libs/graph/doc/johnson_all_pairs_shortest.html

sure, a mouse driver and video drivers are good examples

they aren't removed from memory and stay resident, because they are essential to the operating system's workings

a non resident example would be a program you would code and execute, the only time it needs to be in memory is when you are running it, then it is cleared(at least should be)

might want to try a hashtable

store the item identifier as the key, and the price as the value

then just make a call to hashtable to add they key if not present, or if present update its value

you can do the same thing if you needed to store a class rather than a single value

LizR you sure you are meaning pinvoke?

i do it by invokerequired

this example here, is setting a button enabled

private delegate void UpdateBtnContinueDelegate();
        private void UpdateBtnContinue()
        {
            if (this.InvokeRequired)
            {
                UpdateBtnContinueDelegate updateCount = new UpdateBtnContinueDelegate(this.UpdateBtnContinue);
                this.Invoke(updateCount);
            }
            else
            {
                this.btnContinue.Text = "Continue";
                this.btnContinue.Enabled = true;
            }
        }

from your code you would just call UpdateBtnContinue() and let the method take care of the invoke

i don't really know of an exact calculation, test it out for your needs and try it

Agree with timothy, don't let that 2 confuse you, its place is not in an er diagram

for some reason the file doesn't start with a eof character does it?

try recreating the file and make sure its closed

just by chance, try moving the bracket after the while loop first comment, to be on the same line as the while statement

also did you initialize your array thePlayers?
trying taking everything out, and in the while loop just do a println on dataFile.nextLine()

think there might be something with player in there possibly affecting it

very true

thanks so much for making everything clear and being extremely helpful

and is an exception caught or no?

yeh i am fine with the coding side or database side, just running into this payment thing from multiple people, that may be different people monthly, and percentages that was driving me up the wall

could use a trigger to create the amounts in the transactions table, but i would probably just do it code side, so they can be adjusted if one member does need to pay more

i just don't want to find myself in a bind down the road, because a roommate left or different ones pay different bills

i see what you are saying, sort of one of those things where it seems like it can go either way

the only reason i would be against splitting it out on a bill type, would be if one of the roommates left, but i guess there could be an active flag or something similar on billpeople

You were the one I was hoping would help me out, you have excellent schema designs on about evreything

have one more small issue with this
lets say you have 2 other people as roommates, but only 2 of those people are required to pay the amount and 3rd has no part in it

would the bill members table make sense then?

billmembers
BILL_MEMBER_ID
BILL_ID
MEMBER_ID

also i think this would add the flexibility to store a percentage amount, if the amount is not always 50 50

then pull from this table before creating the transactions to reflect appropriate amounts

what are your thoughts on this?

its not open from another application is it?

also wrap a try catch around and check and make sure it is accessing it properly

i use gmail, not my isp's email

no other problems with gmail, instant receival except from here

i am working on a home project for basically multiple members to share payments, or for one member to pay and the other members pay them back
the concept is sort of like if you have a roommate and you pay all the bills, then he would pay half and i need to keep track of which bills that the roommates have paid

i am leaving a lot of the non critical pieces out for clarity

please advise on my schema

bills
BILL_ID
AMOUNT
PAID
PAID_BY_MEMBER_ID

billmembers
BILL_MEMBER_ID
BILL_ID
MEMBER_ID

billpaymentrequired
BILL_PAYMENT_REQUIRED_ID
BILL_ID
MEMBER_ID
CREATE_DATE
REQUIRED_AMOUNT

billpaymentsmade
BILL_PAYMENT_MADE_ID
BILL_PAYMENT_REQUIRED_ID
PAYMENT_AMOUNT
PAYMENT_DATE

members
MEMBER_ID
MEMBER_FIRST
MEMBER_LAST

Have some experience in it.

Some of the places you will run into trouble are events, arrays, and derived classes (inheritance)

i agree, would also add clientpets to bookings / volunteers

lol well thats a plus

love the zebrahead

Whewww, that you were gonna have to get a new wife lol

Sorry, somehow my exists didn't make it in

try with this

System.out.println("File: " + path + " canonical path: " + f.getAbsolutePath() + " exists:" + f.exists() " can write:" + f.canWrite() + " can read" + f.canRead());

Show us some effort that you can make that you can separate all these elements into a logical design and we can help.

We don't do the work for you.

Agree with jbennett. A lot of the time when you see intermittent periods where the system will be on then just shut off, means the cpu is overheating. Especially, if you hear everything spin up.

I will help, not do assignments, what specific pieces are you having trouble with?

Also what is background and skills in the volunteers table?
One more, where did the relationships table go? ClientChild table means only children and not other relationships? Client table has a next of kin column, what is this?

you can just use this post here, so everyone can benefit from it and be able to offer you advice