dickersonka 104 Veteran Poster

this is for sql express, but works the same

http://systeminetwork.com/node/26123

on top of that, check your firewall

dickersonka 104 Veteran Poster

did you read my last post?

dickersonka 104 Veteran Poster

if you use fxcop or code analysis in visual studio there is a rule CA1806 to 'do not ignore method results'
http://msdn.microsoft.com/en-us/library/ms244717(VS.80).aspx

ddanbe commented: Thanks for the help +2
dickersonka 104 Veteran Poster

well show what you got then

then we'll go from there

dickersonka 104 Veteran Poster

same lines as i am thinking, don't understand the need for an interface when its not used, and a getter that is void

maybe it is these instructors now days

dickersonka 104 Veteran Poster

if you are calling getArms or getLegs why should that return void? when you call a getter something should be returned, i guess he is just wanting output, but anyway beyond my rant

From i guess what he is wanting you need a list of Limbs in your abstract class and something to add them or add them in the constructor

why are you doing this?
this sort of defeats the purpose of your limb interface

Arm[] arms = new Arm[2];
Leg[] legs = new Leg[2];
dickersonka 104 Veteran Poster

thats what i wrote, he said record, thats why i selected the whole row

dickersonka 104 Veteran Poster

either timestamp or as long as you are doing inserts with an autoincrementing id

select * from table where idcolumn = max(idcolumn)
dickersonka 104 Veteran Poster

hopefully not the first

having trouble posting with post lol

dickersonka 104 Veteran Poster

friend lol, we do seem a bit hostile
i can bet this is the sharekahn app i have saw tons of problems about

just because i am nice, check out this link, the bottom post
http://forums.sun.com/thread.jspa?threadID=776507

VernonDozier commented: +rep for mind reading ability. I had no idea what the OP was talking about. +8
dickersonka 104 Veteran Poster

well your booking records could be broken out, otherwise as you have there are two different lee smith's if you take case into account

dickersonka 104 Veteran Poster
dickersonka 104 Veteran Poster

I am looking for something similiar to dedicated hosting. I plan on my database and web server being shared, but i need an application to run as an import every 10 min and haven't found on hosting providers that will offer this without an expensive dedicated hosting plan.
Also to add this is a .net application, so I need a windows server.

Anyone have any recommendations?

Thanks in advance
Keith

dickersonka 104 Veteran Poster

well how about you start your assignment, and we'll help you out, i know i have told you this before, we do not do the work for you, its not our grade, so show your own work

dickersonka 104 Veteran Poster

yes

populate combo1 with table1
valuemember productid
displaymember description

from combo1 handle event selectedindexchanged

load selectedvalue (which needs to be productid)

the line of code is in c#, but you can see the logic

int selValue = Convert.ToInt32(this.combo1.SelectedValue.ToString());

issue query

select id, category, productid from table2 where productid = selValue;

populate combo2 with results
valuemember = id
displaymember = category

dickersonka 104 Veteran Poster

nice job catching your mistake

also do the the validate before repaint

dickersonka 104 Veteran Poster

the left join is the difference, don't think of it in terms of left join vs where, you were doing an inner join

left join will return all rows from the left table (projects) even if there are no matches in the right table (clients)

where limits the results, joins will combine them, thats the best way to think of them, here is your original statement with a inner join

SELECT p.ProjId, p.ProjName, p.ClientId, c.ClientName 
FROM
Projects_Tbl p 
left join 
Clients_Tbl c
on p.ClientId = c.ClientId
SELECT p.ProjId, p.ProjName, p.ClientId, c.ClientName 
FROM
Projects_Tbl p 
inner join 
Clients_Tbl c
on p.ClientId = c.ClientId

notice the major difference changing from left to inner

dickersonka 104 Veteran Poster
dickersonka 104 Veteran Poster

do supervisors and coordinators exist in different tables?

you can have a fk to two different tables

if they are users, just add a user_type_id to the users table and create a userstype table

with entries of
student
supervisor
coordinator

dickersonka 104 Veteran Poster

what error is it? i'm sure you have a message of some sort

dickersonka 104 Veteran Poster

set identity seed to be able to change the 1 to a different number

the padding with 0's is formatting, do it code side or in query, not store numbers in a database like that

dickersonka 104 Veteran Poster

lol yes get your equals symbols in order

you are try to check its state, not set it

dickersonka 104 Veteran Poster

you can do something like return a boolean

public boolean loadFile(){
boolean readFile = Boolean.FALSE;

try {
  //load file
  readFile = Boolean.TRUE;
} catch (IOException e) {
            e.printStackTrace();
} finally {
        if(in != null)
           in.close();
}

return readFile;
}

//your calling code
if(loadFile()){
 //continue
} else {
  //we need to tell the user that the file couldn't be loaded
}
dickersonka 104 Veteran Poster

hmmm, haven't had experience with it

i see one page they say ship_method_1 and another they have a little different convention

http://code.google.com/apis/checkout/developer/Google_Checkout_HTML_API_Parameter_Reference.html#tag_shipping-type

dickersonka 104 Veteran Poster

abstract classes vs interface, if you can't find that on google, your computer must not be working

http://www.codeproject.com/KB/cs/abstractsvsinterfaces.aspx

gridview paging
http://www.codeproject.com/KB/webforms/GridViewCustomPaging.aspx

dickersonka 104 Veteran Poster
CREATE database databasename;
dickersonka 104 Veteran Poster

show what you don't understand, but here is a quick rundow

1. abstract classes are used for common functionality, but can have implementation, interfaces cannot

2. static does not require you to create an instance of the class to call it

3. select * from table where id >= 501 and id <= 525

dickersonka 104 Veteran Poster

you can pass parameters using

<applet .....
<PARAM name="param" value="value">
</applet>

in your init

String param = getParameter("param");

just do conversion to int, but you are specify width and height already, but thats how pass them

dickersonka 104 Veteran Poster

not so sure about the dreamweaver thing, i normally use visual studio

as far as what you need to do, you need to loop through each selected checkbox for the airport / user

this will prob best be supported in multiple inserts, rather than trying to do it with a single insert

do you have the code where you are populating the values to insert in the database?

dickersonka 104 Veteran Poster

the tablock i referred to is a table lock, the dblock is the entire database lock, if the other select or your insert is trying to do this, then until one releases that lock, the other can't function, you might want to check with the other guy to see what kind of lock he has going

dickersonka 104 Veteran Poster
SELECT p.ProjId, p.ProjName, p.ClientId, c.ClientName 
FROM
Projects_Tbl p 
left join 
Clients_Tbl c
on p.ClientId = c.ClientId
dickersonka 104 Veteran Poster

take a look at tools->internet options->tabs->settings->open links from other programs in : the current tab or window

this might not fix it, but first things first

dickersonka 104 Veteran Poster

1. very easy (mysql_connect)
2. believe you are looking for an insert statement
3. update, delete, and update statements
4. schema/user privileges

dickersonka 104 Veteran Poster

haven't used the first, have used visual source safe and just really didn't care for it

i use subversion, very easy to setup, very robust and the client apps are good as well, the developers are constantly improving it also

dickersonka 104 Veteran Poster

a bootloader starts the os, might want to take a look at the linux kernel

dickersonka 104 Veteran Poster

its not about the mac, its about the browser, safari i assume

try to set this on the table style and see if it corrects it

empty-cells:hide;
dickersonka 104 Veteran Poster

i guess just to be thorough, he is what form2 could be

public class Form2 : Form
{
//all the other code
private int int_a;
public int IntA
{
get { return int_a; }
}
}
dickersonka 104 Veteran Poster

whoaaa, just use a dialog

and i would use that ref, just use, properties in the second form

Form2 form2 = new Form2();
form2.ShowDialog();

if(form2.DialogResult == DialogResult.OK)
{
myClass class = new myClass(form2.IntA, form2.IntB);
}
dickersonka 104 Veteran Poster

what about when you put the class inside the same file?

dickersonka 104 Veteran Poster

make it public

public class classinprac1
dickersonka 104 Veteran Poster

are you holding the lock until all the inserts complete? or doing it on a per insert basis?

also is either trying to do a tablock or dblock?

dickersonka 104 Veteran Poster

yes you can, sorry i added in the alias last and forgot to update order by

dickersonka 104 Veteran Poster

agreed, def looks very good

i don't know if you are wanting to keep track of this though

Some employees are not assigned and perform duties not specifically related to a project. Some employees are part of a labour pool, to be shared by all project team. For example, the company’s executive secretary would not be assigned to any one particular project.

your design matches this statement, minus the labor pool part, do you have separate labor pools that some secretaries aren't part of and need to keep track of this? or just assume that based upon jobclass, whether they need to be assigned or not?

dickersonka 104 Veteran Poster

you'll need to use

Select table3.DocID, sum(table1.Freq + table2.Freq) as Freq
-- your from and where
group by table3.DocID
order by SUM(table1.Freq + table2.Freq) desc

i added the order by for clarity

dickersonka 104 Veteran Poster

i would suggest, not saying this is for sure the answer, using transactions with READ COMMITTED or REPEATABLE READ

this way while changing or selecting data, you ensure that it can't be modified while selecting or read until don't processing

http://msdn.microsoft.com/en-us/library/ms173763.aspx

dickersonka 104 Veteran Poster

yes, find which results you need to update

then loop through the results and create the updates there instead of combining it

here is some pseudo code, something like

select * from participation_score where user_id is null

foreach result {
 $score = //do your calculation that you had, selecting on a participation_score_id

//now update
update participation_score set //......
where participation_score_id = 
}
dickersonka 104 Veteran Poster

ahhh, math junkie then lol


this might be helpful as well, more of the logic side, than the graphical
http://bytes.com/forum/thread645269.html

coveredinflies commented: Thanks +1
dickersonka 104 Veteran Poster

fairly tough assignment to start programming with

here is an example with a single circle
http://www.java2s.com/Code/Java/Swing-JFC/BouncingCircle.htm

you can use that concept, on top of the bounds, you can check the other circles positions

dickersonka 104 Veteran Poster

how about

int myValue = 6000;
Debug.WriteLine(Convert.ToString (myValue, 2));

little less lines of code

ddanbe commented: nice! +2
dickersonka 104 Veteran Poster

concurrency issues won't only be the result of updates, but from what you described what you were worried about, you only described about the amount of load on the system

how many users do you anticipate using your system at once? and is it a shared system, both web and db server?