Hi,

I have a SOSL with where condition. The conditiion works great for small numbers, when I use 16 digit number which I need in the where condition, it gives me error. I used it directly or convert to a double variable and use it in SOSL I get the error either way.

the numberfield__c is of Number type with 16 digits.

String searchquery ='FIND \' 4827557037571070 \' IN ALL FIELDS RETURNING CustomObject__c(field1__c, field2__c, numberfield3__c   where numberfield__c = 4827557037571070)';

List< List<SObject> >searchList=search.query(searchquery);

another one I tried is 

double dvar= double.valueof(' 4827557037571070 ');

String searchquery ='FIND \' 4827557037571070 \' IN ALL FIELDS RETURNING CustomObject__c(field1__c, field2__c, numberfield3__c   where numberfield__c = '+dvar+')';

List< List<SObject> >searchList=search.query(searchquery);

SOQL works great. How to make it works with SOSL?

Hi,

I need to put a custom related list on the account detail page and put the Hover link on the top of the page for the custom related list.

I was able to do the custom related list displayed on the bottom of the Account detail page wiring a standard controller extension and visula force page.

Now the problem is How do I place the Hover link on the top of the page for the custom list? I saw couple of threads for the above, but the hover links issue was never discussed?.

Can any one please guide me how can I do this.

Thank you.

Hi,

I need to put a custom related list on the account detail page and put the Hover link on the top of the page for the custom related list.

I was able to do the custom related list displayed on the bottom of the Account detail page wiring a standard controller extension and visula force page.

Now the problem is How do I place the Hover link on the top of the page for the custom list? I saw couple of threads for the above, but the hover links issue was never discussed?.

Can any one please guide me how can I do this.

Thank you.

I have been following the cookbook and want to display a list using visualforce of all the accounts that are applying and awaiting 2 screenings. I have tested the code using apex explorer and this apex returns a list of sobjects. But when I try to move through them using visual force I get the following error. How can I rewrite this code to display all the names?

<apex:pageBlock title="Select a Candidate">
<apex:dataTable value="{!account}" var="u" cellPadding="4" border="1">
<apex:column >{!u.name}</apex:column>
<apex:column >{!u.id}</apex:column>
</apex:dataTable>
</apex:pageBlock>

public Account getaccount() {
return [select id, name from Account where Recruitment_status__pc = 'Applying' AND Application_sub_stage__pc = 'Awaiting 2 screenings'];
}