Archive for November, 2009

How do I insert multiple rows in MySQL using nested select statements?

November 17, 2009 - 10:29 pm 3 Comments

e.g. insert into lmms.household (id,family_name,location_id,last_update_time,last_update_user_id,creation_time,creation_user_id) values
((select households_id from world.households),(select family_name from world.households),"93469603",(select last_updated from world.households),"1",(select created_date from world.households),"1");
returns an error- "subquery returns more than one row"?
How can this statement be re-written?

select households_id from world.households
select family_name from world.households
select last_updated from world.households

those statements need to be 1 row.
just put a conditional like where whatever = whatever

Can you quit a sport to join another in Arkansas?

November 17, 2009 - 10:28 pm 1 Comment

My friend recently quit football and started going to wrestling practices. One of the coaches told him he was not allowed to wrestle until football season was over. I was wondering if anyone can verify his statement and show me in the rulebook? I live in arkansas and go to a private 5A school.

its an institutional rule, not sport rule…………………………………..

What to write in a christian mission statement ?

November 17, 2009 - 10:28 pm 3 Comments

My friend is applying for teaching jobs in Universities which require a christian mission statement. She is not a Christian. Do you think she stands any chance of even getting through? If so what should she write in such a statement.

Ask her to write something from the heart. I’ve met two non-christian people working within christian missionaries in my life’s journey, and what you believe is only a small part of being a christian. A larger part is how you live your life. You can be christian in nature, without holding their beliefs. Likewise, you can claim to be a christian, pray each day, go to church and still be selfish and unloving. As long as she has an understanding of the christian nature, writing a statement should be easy. Hope this helps…

how to Write a program using switch statement that will examine the value of an integer?

November 14, 2009 - 10:49 pm 1 Comment

Use break statement after every case statement

int value;
switch(value)
{
case 1:
//your code
break;
case 2:
//your code
break;

default:
//your code
break;
}

What is a select case statement in Visual Basic?

November 14, 2009 - 10:48 pm 1 Comment

How is it the same and different as an if/else if statement?

If statements are designed to select one of two branches. While that can be chained to select from more than two branches, it gets complex and hard to read. The select statement chooses from numerous branches.

If calculates the value of a logical expression. This logical expression may be very complex, but will evaluate to true or false.

Select calculates the value of an expression and then compares the result with a set of constants. The matching constant selects the branch to use.

If you have to select one of many branches it’s more efficient to use the select statement. It’s also much easier to read. If you have multiple options it’s better to express that directly rather than chaining if statements.

Writing code that is easy to understand is very important. Everything you can do to make the intention clearer is worthwhile.

The system can often use smarter comparisons rather than something like "is it 1? no. Is it 2? no. Is it 3? no …"

What is important in a personal statement for economics major?

November 14, 2009 - 10:47 pm 1 Comment

I am applying for an economics major which is capped and I need to write a personal statement.

A personal statement should explain who you are, why you want that degree, what experiences you have that have led you to wanting that degree, and then what you have to offer. Here is a great guide to explain how to do this step-by-step: http://www.ehow.com/how_4474711_write-graduate-school-personal-statements.html It is for graduate school admissions, but the process is the same.

How should I start my personal mission statement homework???

November 14, 2009 - 10:47 pm 1 Comment

Ok my homework is to write a personal mission statement.for career class. And I don’t know how I should start it or what to write about.. because i don’t really know what career i want to take .. i just want to go into law …..can u smart people plsz help me with it??
thank u

This is a wonderful web-site that walks you through the process and even gives templates. http://www.timethoughts.com/goalsetting/mission-statements.htm

Good luck!

How to implement switch statement using string?

November 12, 2009 - 2:14 am 2 Comments

I want to implement a switch statement for a string, which varies from time to time (depending on the input) given at runtime. how can i use it using stls?

Give more description avout which language u r using and what actually u want to achive.

Reasons for Australia NOT to join the Vietnam war?

November 12, 2009 - 2:13 am 7 Comments

Basically for an essay I have to "evaluate" the statement: "The decision to become involved in the Vietnam war was a difficult one for the Australian government"… Seems to me they were more forced into it… Help much appreciated =]
I don’t see why it was a difficult decision at all, thats why I want reason why they WOULDN’T want to. It seems like they were totally forced into and no, San Diego is not in Australia… I think thats America.

They were part of SEATO — there was not difficulty. If they wanted the protection of SEATO, they needed to support fellow members.

What were the final statements of the Belmont Debate 08′ for McCain and Obama?

November 12, 2009 - 2:13 am 1 Comment

I just need each of the candidate’s final statements from the Belmont debate, that would be great, thanks.

go to hulu.com you can watch the whole debate or fast forward to the end
enter obama mccain debate in the search engine it will take you to all of them you have to look though some are just excerpts and some are whole debate