Help: getting error while running custom controller apex class

[mahendiran jayavarma]

Hi,

I created following custom controller:

<apex:page controller="myController">
   <apex:form>
      <apex:pageBlock title="Congratulations {!$User.FirstName}">
         Account Name: <apex:inputField value="{!account.name}"/>
         <apex:commandButton action="{!save}" value="save"/>
      </apex:pageBlock>
   </apex:form>
</apex:page>

and I used following apex class for that controller:


public class MyController {

      private final Account account;

      public MyController() {
            account = [select id, name, site from Account where id =
                       :ApexPages.currentPage().getParameters().get('id')];
      }

      public Account getAccount() {
            return account;
      }

      public PageReference save() {
            update account;
            return null;
      }
}



While running I am getting error for "System.QueryException: List has no rows for assignment to SObject"


I guess i am not giving access permission for Sobject control.

But i dont know where i have to give grant access permission.

 So Please any one provide me the solution.

and tell me steps i have to follow.


Thanks,
Mahendiran.

[rohit aggarwal]

You are getting error because the account won't exist. this code only works for existing account records. you have to insert the account and have to use conditional if statement like this

public class MyController {

      private final Account account;          
 

       public list<Account> allaccount= new list<Account>(); 
 public MyController() {
            allaccount = [select id, name, site from Account where id =
                       :ApexPages.currentPage().getParameters().get('id') limit 1];
       
        if(!allaccount.isEmpty() ) 
        account = allaccount[0];

        else
         account = new account();
   }

      public Account getAccount() {
            return account;
      }

      public PageReference save() 

{
        if(!allaccount.isEmpty() )

         insert account;
         else
  update account;
            return null;
      }
}

this will defiantly work fine for both new and existing accounts. Let me know if face any other problem

Rohit

[mahendiran jayavarma]

It wont work.. im getting follwoing error.

System.DmlException: Update failed. First exception on row 0; first error: MISSING_ARGUMENT, Id not specified in an update call: []

Class.MyController.save: line 23, column 1 External entry point


Thanks,
Mahendiran.

[rohit aggarwal]

Are you passing the AccountId to vf page?

[mahendiran jayavarma]

no

[rohit aggarwal]

From which page are you calling this account vf page?