I have a stream of opportunities coming into the system.

I have a trigger that fires on update event.

 

Now for that I have to pick values for every opportunity from other object and update.

 

trigger Update_AdEntId on Opportunity (before insert) {
opportunity[] opp=trigger.new;
list<opportunity> oppupdate=new list<opportunity>();
// for(user[] uu:[select email from user where id :=opp.ownerid])
for(opportunity oppcount:opp){
user u=[select email from user where id=:oppcount.ownerid];
oppcount.name=u.email;
oppupdate.add(oppcount);
}
update oppupdate;

}

 

 

I am still getting error for two many DML statements. If I am missing somethg. Plz correct the code

I have a web service in SFDC. it is being called by external java app. inputs are sent into web service and output is returned as sobject.

Eg

global class Pipeline {

  WebService static opportunity[] Apptaker(string adid, string Ftype, date Frmdt, date todt, string stype, string sorder) {

opportunity[] opp;

...........

.........

 

return opp;

}

 

 

 

Now I have not handled exceptions. In case there is any exception from web service, how do I return error to the UI java app

opp=[select account.fax, apptaker__c, name, ownerid  from opportunity where apptaker__c=:adid and stagename='Prospecting'and closedate between(frmdt, todt) order by closedate asc];

 

 

I am trying to use this query. I am getting error at between. If apex doesnot support this, what is work around

 

 

Thank in advance.

1) var oc= '{!TestScreen__c.Occupancy__c}';
alert(oc);

2) var oc= {!TestScreen__c.Occupancy__c};
alert(oc);

 

Statement 2) gives error. I am not able to find the error.