Archive for the ‘update statement’ Category

What sort of mental disorder would you suggest goes with this statement?

September 25, 2009 - 12:18 pm 13 Comments

If you had a family member in a mental hospital for a mental disorder that is still unknown and a nurse said to you,

"You have to be careful. Sometimes she’s too angry, sometimes she’s too sad, and other times she’s too happy. All of her emotions are inappropriate for her situation. But most of the time, she’s just not there, gone."

If a nurse said that to you when giving you an update during a visit, what would you suggest the disorder would be? I’m just looking for any guesses you may have.

Inappropriate emotions are often personality disorders but it impossible to diagnose based on one statement. Could be schizophrenia, schizoid personality disorder, bipolar, or a number of other things. You need more info and to ask her doctor not people on Y!A.

How to create a table with some empty rows in vb.net(in code behind) dynamically at runtime?

September 23, 2009 - 2:25 pm 1 Comment

How to create a table with some empty rows in vb.net(in code behind) dynamically at runtime so that we can directly insert data into the database through the table without using update statement. And i also want to add a row dynamically to the table with a button click

good luck with that first part

SQL UpDate Problem?

September 21, 2009 - 12:08 pm 3 Comments

Hi every one:
i’m kind of new in Sql*plus and Oracle and i have some problem in
Update the value in one of the table.I want a Write an UPDATE
statement to change values of SERVICE.Description from, Mens Shirt
to,
Mens’ Shirt. when i try to do that the error show me that:

SQL> UPDATE Table Service
2 SET Description=’Mens’s Shirt’
3 WHERE Deccription=’Mens Shirt’;

ERROR:
ORA-01756: quoted string not properly terminated

I don’t know how i have to close the quoted string.i have to show the
"Men’s Shirt" in the Table.
is it possibole or not.
any help
Thanks a lot.

Another variant (doubled single quote):

SQL> UPDATE Table Service
2 SET Description=’Mens’’s Shirt’
3 WHERE Deccription=’Mens Shirt’;

(Classic ADO) How to use Named Parameters for Update Query?

September 19, 2009 - 3:08 pm 1 Comment

Hi, I’m trying to use
command.Execute rs
to execute a update statement and return me a rs with the no of rows affected.
then statement goes like this
"UPDATE Team SET Person.Address=@ADDRESS WHERE Person.ID =@PERSONID;"

Of course I’ve use command.Parameters.Append (command.CreateParameter(….)) to assign the parameters

I tried to execute the commands with the parameters passed in manually there is no problem but execution with the codes dont seem to be working.And further more, the command returns an empty result set which means i have no idea the no. of rows affected. I just cant figure out why is the update statement is not working.
Im using Access, with JET 4.0

better you tell the data source being used (SQL Server, Access…)

MySQL insert then update in PHP on submit ? how?

September 17, 2009 - 2:44 pm 3 Comments

i am inserting into a table and want to update a field in another one, how can i add update statement into

$insertSQL = sprintf("INSERT INTO sellbuytable (AccountNo, StockSympol, TraDate, Sell, Buy, Price, Commition, Broker) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['AccountNo'], "text"),
GetSQLValueString($_POST['Symbol'], "text"),
GetSQLValueString($_POST['tradate'], "date"),
GetSQLValueString($_POST['sell'], "double"),
GetSQLValueString($_POST['buy'], "double"),
GetSQLValueString($_POST['Price'], "double"),
GetSQLValueString($_POST['commition'], "double"),
GetSQLValueString($_POST['broker'], "text"));

$sql="INSERT INTO sellbuytable (AccountNo, StockSympol, etc) VALUES(’$_POST[AccountNo]‘,’$_POST['StockSymbol'],etc)";
$res=mysql_query($sql);

$sql2="UPDATE table SET whatever=’whatever’ WHERE whatever=’whatever’";
$res2=mysql_query($sql2);

I am in the middle of a home purchase and it is about to go into copywriting. My question is I need to take a?

September 17, 2009 - 2:00 pm 2 Comments

hardship loan out for the home purchase in order to pay for my closing. Can I safely do that while it is under review with the copywriters? I have already supplied them with my financial statement from last year so they have all of that already but will they request an updated statement? I don’t want to be denied my 100% financing.

I believe the other poster was correct in stating the you mean "underwriting". When a loan is in underwriting, they are looking at all the current information that was provided to them in order to help determine whether or not you are qualified.

If in fact any of the terms changed. Meaning, that rather than showing your 401k balance at 10,000, it is now going to be affected by the loan you are going to hold against it. Then the application, and all other information is going to have to be "updated", to reflect the new changes.

Speak with your loan officer, broker or banker. Explain to them what is going on, so that they can change the paperwork. Otherwise, this will postpone your loan, because underwriting will have to underwrite or review the loan once again.

Also, keep in mind that when you are purchasing a home. Your agent should have written into the offer a condition that the "seller agrees to pay up to 3,000 or 3% of the purchase price for closing costs". If your buyers agent didn’t write that in, then they are not doing a good job of negotiating for you.

Good luck, and let me know if you have any additional questions.

Update cell functions in complicated excel spreadsheet?

September 15, 2009 - 10:15 am 1 Comment

I’m creating a spreadsheet with student marks, grades and percentages but I’m using macros assigned to buttons to carry out tasks and I can’t seem to record a macro that will allow me to insert a new row whilst updating the cells below. Also it wont update any other of the spreadsheets that are linked to the main table with lookup functions and IF statements… any advice ?

If the problem is the formula formerly cover a cell range now need to be updated after you insert new row, there is a few ways to deal with it

Depends on the situation, the following may apply

1. change the cell address of formulas that would be affected by the macro to relative reference

2. add name to cell ranges and use it in formula instead, then if there is delete or insert, the cell range under name update automatically

3. use INDIRECT function in to fix cell range in formula as the argument in the function is text, it won’t affected by insert or delete of rows

4. add vba code to update the formula, the name
Please contact for more info.

Rihanna first Picture after Beating releases a statement

September 14, 2009 - 9:12 pm 25 Comments

UPDATE
Rihanna has released a statement:

At the request of the authorities, Rihanna is not commenting about the incident involving Chris Brown. She wants to ure her fans that she remains strong, is doing well, and deeply appreciates the outpouring of support she has received during this difficult time.

ORIGINAL STORY
Harvey Levin of TMZ outlined the injuries shown in the picture, quoting:
Two huge contusions on either side of her face; swelling, brusing, a busted lip, a bloody nose, bite marks on several of her fingers and her arms. She said Chris Brown struck her with his fists. Reportedly Chris Brown has had some training in tae kwan do.

Duration : 0:0:20

(more…)

Allen Stanford twenty 20 Cricket and the WAGS UPDATE Fraud Charges

September 12, 2009 - 12:16 am 25 Comments

http://wwcricket.blogspot.com/

FBI agents tracked down billionaire R. Allen Stanford at the Virginia home of an acquaintance Thursday and served him with legal papers in a civil case alleging he orchestrated an $8 billion fraud scam.

But there have been no criminal charges filed against him so he remains free, said FBI spokesman Richard Kolko.

Stanford was in Fredericksburg, Va., sitting in a car outside the home of an acquaintance, Kolko said. www.chicagotribune.com

UPDATE FROM THE BBC
Texan billionaire and cricket promoter Sir Allen Stanford has been charged over a $8bn (£5.6bn) investment fraud, US financial regulators say.

The Securities and Exchange Commission said the financier had orchestrated “a fraudulent, multi-billion dollar investment scheme”.

The SEC said the fraud was “based on false promises and fabricated historical return data”.

English cricket bosses have pulled out of sponsorship talks with Sir Allen.

The charges against Sir Allen, three of his companies and two executives of those companies followed a raid by US marshals on the Houston, Texas, offices of Stanford Financial Group.

A US judge has frozen the ets of Sir Allen and the other defendants as well as those of the Stanford Group, its Antigua-based subsidiary Stanford International Bank (SIB) and another subsidiary, investment advisor Stanford Capital Management.

A receiver has been appointed to “preserve ets for investors”, the SEC said.

The SEC said that the Stanford International Bank - the largest in the Caribbean - sold approximately $8bn worth of certificates of deposit to investors, promising “improbable and unsubstantiated high interest rates”.

The bank was “operated by a close circle of Stanford’s family and friends”, the SEC said in a statement.

“We are alleging a fraud of shocking magnitude that has spread its tentacles throughout the world,” said Rose Romero of the SEC.

The SEC began investigating Stanford Group last year and intensified their probe following the arrest of US financier Bernard Madoff in December over an alleged $50bn (£35bn) investment fraud.

In the wake of that scandal, SIB falsely told its investors it had no exposure to the funds involved in the alleged Madoff fraud.

The Stanford Group lists its worth as more than $40bn. Antigua and Barbuda granted Sir Allen citizenship about 10 years ago and knighted him in 2006.

Forbes magazine lists him as the world’s 605th richest man, with ets of $2.2bn.

ORIGINAL STORY
Sir Allen Stanford apologised on Monday October 27 to Kevin Pietersen after he was caught on television flirting with the wives and girlfriends of the England players.
By Nick Hoult–The Telegraph.

Stanford was seen to grab and put Emma Prior, the wife of wicketkeeper Matt, on his lap before putting his arm around Alastair Cook’s girlfriend during England’s match against Middlesex on Sunday evening.

The incident was captured on television by the cameraman who tracks Sir Allen’s every move. It seemed a good natured incident at the time and the players wives smiled and went along with the fun. But it seems the incident caused embarrassment and made them feel uncomfortable. One unnamed England player said last night: If that was my wife and he put her in his lap I would have wanted to punch him.

Stuart Broad, the England bowler, said: There were a few gobsmacked faces. I did not see it because I was bowling at the time but I think Matt Prior had a look of shock on his face.

Stanford moved quickly on Monday to restore good relations with the players, apologising to Prior and Pietersen for his behaviour.

Stanford kept a noticeably lower profile and was rarely featured on television during the match between Middlesex and Trinidad.

Duration : 0:1:26

(more…)

URGENT!HELP!how to update the Database without over writing the data inside?

September 11, 2009 - 4:18 am 2 Comments

I am doing a programming on visual studio.net 2003 using the Asp.net mobile Web form. I am trying to update the Microsoft access database that i have created using the statement : Update.
According to the Update Statement that i had written, It directly replaces the value in the attribute of the table. Which is not what i am looking for. here’s my quote of example for a better explanation:

I have a table name : Pen
Attributes are : ItemID, Color,Quantity,ItemDetails

As such my quantity inside have 10 and when i want to order another 40, i do not want it to replace to 40. i want to replace it to show 50. As such its an addition method.

However in my Update sentence it overwrite it. Is there any other method to make it add?Thanks. Its urgent.
Well, In the Database have an initial value. so in the SQL statement , how to make it read the value in the text box and the value in the database to automatically add it together? It is because the SQL statement should be reading from the database in Microsoft access and then add on the the value in the text box. So is there any method? sub query method is it able? i am not sure how to use the SQL sub query Method even after looking at it. Is there any simpler explanation of how to use it? Thanks.

Chetan is right, except you don’t need the WHERE clause. You just want it to look at whatever the current quantity is and add the new quantity to the old.
So..Set Quantity = Quantity + 40