Opportunity[] op=[select <picklist field> from opportunity where name!=null order by <picklist field>  NULLS LAST];

but the SOQL doesnot produce a result where nulls be placed at last.

Please suggest a resoultion to the issue.

Map<ID, Contact> m = new Map<ID, Contact>([select id, lastname from contact])

The key value ID will be the record id for contact.

I want Account ID in the key set for every record of contact returned. How can I pick that.

global class Pipeline {

  WebService static opportunity[] Apptaker(date adid){

.....

....}

static testMethod void apptakertest() {

sobject[] result= pipeline.Apptaker(2008-06-04);

...

}

I am getting error in the apptakertest() at date format. It is not identifying the date.

Thanks in advance

If I have a large XML from other external application.

I have the XML on the server i.e. my local machine. the location is something like

C:\\Documents and Settings\\rahul_arora\\Desktop\\book.xml

Now I want this to be utilised in SFDC. All the examples to read the XML have the XML code converted to string and then instantiate the XMLStreamReader.

How do I do in my case. Kindly suggest the elaborated approach.

HI, I implemented the method to pass parameters from SControl to SFDC.

Still I am facing error. My web service is:

global class DTCTest1 {
global class StatusDetail{
webservice String Zip;
webservice String Occupancy;
webservice String Property;
webservice String Grade;
webservice String MaxLoan; }
WebService static String DTC(StatusDetail sd) {
 ZIP_Status_Mapping__c Zsp=[select Status__C from ZIP_Status_Mapping__c where Name =: sd.Zip];
String Cltv=[select Max_CLTV__c from Status_Details__c where ((Occupancy_Type__c =: sd.Occupancy) and (Property_Type__c =: sd.Property) and (Credit_Grade__c =: sd.Grade) and (Max_Loan_Line__c =: sd.MaxLoan)and (Market__C =: Zsp.Status__C))].Max_CLTV__c;
return Cltv;
}