You need to sign in to do that
Don't have an account?
Abraham kumar 4
Compile Error: unexpected token: 'public with sharing class
Hi all,
Can you pls help me with the below errors i am getting. I am just trying to replace a field with a different field in the VF page. I have made all the necessary changes in Controller and helper class but i get this error in the first line :- Compile Error: unexpected token: 'public with sharing class at line 1 column 0 both controller and helper classs pls help.
Pls Help.. Thanks in advance.Any help is highly appreciated
Thanks!!
Can you pls help me with the below errors i am getting. I am just trying to replace a field with a different field in the VF page. I have made all the necessary changes in Controller and helper class but i get this error in the first line :- Compile Error: unexpected token: 'public with sharing class at line 1 column 0 both controller and helper classs pls help.
Pls Help.. Thanks in advance.Any help is highly appreciated
Thanks!!
public static String[] strArray;
public static set<String> fieldNames = new Set<String>();
public ITV_AddGuestToEventHelperClass(){
}
public static String[] getViewExistingOptions(){
strArray = new String[]{};
strArray = getContactSearchFieldset().View_Existing_Fields__c.split(',');
system.debug('custom settings value'+getContactSearchFieldset().View_Existing_Fields__c);
system.debug('strArray'+strArray);
return strArray;
}
public static String[] getFieldSet(){
// Contact_Search_Fieldset__c fieldSet = Contact_Search_Fieldset__c.getValues('SearchFields');
strArray = new String[]{};
strArray = getContactSearchFieldset().Fields__c.split(',');
return strArray;
}
public static String[] getOperators(){
strArray = new String[]{};
strArray = getContactSearchFieldset().Operators__c.split(',');
return strArray;
}
public static Contact_Search_Fieldset__c getContactSearchFieldset(){
Contact_Search_Fieldset__c fieldSet = Contact_Search_Fieldset__c.getValues('SearchFields');
return fieldSet;
}
public static set<String> getContactFields(){
Map<String, SobjectField> fieldMap = Contact.getsObjectType().getDescribe().Fields.getMap();
for(String f : fieldMap.keySet()){
fieldNames.add(fieldMap.get(f).getDescribe().getLabel());
}
return fieldNames;
}
public static List<Guest_New__c> getGuestDetails(Id eventId){ List<Guest_New__c> guestDisplayList = [Select Name,Email__c, Status__c, FirstName__c,LastName__c,Patch_Controller1__c,CompanyOrAccount__c,Event__c, , Title__c, Contact__c, CreatedBy.Name, LastModifiedBy.Name, CreatedDate, LastModifiedDate
FROM Guest_New__c where Event__c =: eventId];
return guestDisplayList;
}
public static String getWhereClause(String sOperator){
String whereClause;
if(sOperator == 'Equals')
whereClause = ' = ';
else if(sOperator == ' Not Equal to')
whereClause = ' != ';
/* else if(sOperator == 'Contains')
whereClause = '% Like %';
else if(sOperator == ' Starts with')
whereClause = ' Like %';
else if(sOperator == 'Less than')
whereClause = ' <= ';
else if(sOperator == 'Greater than')
whereClause = ' >= ';
*/
system.debug('>>>>> whereClause '+whereClause);
return whereClause;
}
/* public static List<sObject> getQuerySobj(String sObj, String sField1, String sOperator1, String sVal1, String sField2, String sOperator2, String sVal2, String sField3, String sOperator3, String sVal3, String sField4, String sOperator4, String sVal4, String sField5, String sOperator5, String sVal5){
String queryString;
if(sObj == 'Guest_New__c') queryString = 'Name,Email__c, Status__c, FirstName__c,LastName__c,CompanyOrAccount__c,Event__c, Patch_Controller1__c, Title__c, CreatedBy.Name, LastModifiedBy.Name, CreatedDate, LastModifiedDate from ' + sObj + ' where ';
else
queryString = 'Select FirstName, LastName, Name, ITV_Patch_Controller__c, Email from ' + sObj + ' where ';
String whereString = '';
//1
if((sField1 != 'None' && sOperator1 != 'None' || (sVal1 != '') ) &&
(sField2 == 'None' || sOperator2 == 'None' || sVal2 == '') &&
(sField3 == 'None' || sOperator3 == 'None' || sVal3 == '') &&
(sField4 == 'None' || sOperator4 == 'None' || sVal4 == '') &&
(sField5 == 'None' || sOperator5 == 'None' || sVal5 == '')){
whereString = sField1 + getWhereClause(sOperator1) + 'sVal1';
}//2
else if((sField1 == 'None' && sOperator1 == 'None' && sVal1 == '') &&
(sField2 != 'None' && sOperator2 != 'None' && sVal2 != '') &&
(sField3 == 'None' && sOperator3 == 'None' && sVal3 == '') &&
(sField4 == 'None' || sOperator4 == 'None' || sVal4 == '') &&
(sField5 == 'None' || sOperator5 == 'None' || sVal5 == '')){
whereString = sField2 + getWhereClause(sOperator2) + 'sVal2' ;
}//3
else if((sField1 == 'None' && sOperator1 == 'None' && sVal1 == '') &&
(sField2 == 'None' && sOperator2 == 'None' && sVal2 == '') &&
(sField3 != 'None' && sOperator3 != 'None' && sVal3 != '') &&
(sField4 == 'None' || sOperator4 == 'None' || sVal4 == '') &&
(sField5 == 'None' || sOperator5 == 'None' || sVal5 == '')){
whereString = sField3 + getWhereClause(sOperator3) + 'sVal3' ;
}//4
else if((sField1 == 'None' && sOperator1 == 'None' && sVal1 == '') &&
(sField2 == 'None' && sOperator2 == 'None' && sVal2 == '') &&
(sField3 == 'None' && sOperator3 == 'None' && sVal3 == '') &&
(sField4 != 'None' || sOperator4 != 'None' || sVal4 != '') &&
(sField5 == 'None' || sOperator5 == 'None' || sVal5 == '')){
whereString = sField4 + getWhereClause(sOperator4) + 'sVal4' ;
}//5
else if((sField1 == 'None' && sOperator1 == 'None' && sVal1 == '') &&
(sField2 == 'None' && sOperator2 == 'None' && sVal2 == '') &&
(sField3 == 'None' && sOperator3 == 'None' && sVal3 == '') &&
(sField4 == 'None' || sOperator4 == 'None' || sVal4 == '') &&
(sField5 != 'None' || sOperator5 != 'None' || sVal5 != '')){
whereString = sField5 + getWhereClause(sOperator5) + 'sVal5';
}//1,2
else if((sField1 != 'None' && sOperator1 != 'None' && sVal1 != '') &&
(sField2 != 'None' && sOperator2 != 'None' && sVal2 != '') &
(sField3 == 'None' && sOperator3 == 'None' && sVal3 == '') &&
(sField4 == 'None' || sOperator4 == 'None' || sVal4 == '') &&
(sField5 == 'None' || sOperator5 == 'None' || sVal5 == '')){
whereString = sField1 + getWhereClause(sOperator1) + 'sVal1' + ' AND ' + sField2 + getWhereClause(sOperator1) + 'sVal2';
}//1,3
else if((sField1 != 'None' && sOperator1 != 'None' && sVal1 != '') &&
(sField2 == 'None' && sOperator2 == 'None' && sVal2 == '') &&
(sField3 != 'None' && sOperator3 != 'None' && sVal3 != '') &&
(sField4 == 'None' || sOperator4 == 'None' || sVal4 == '') &&
(sField5 == 'None' || sOperator5 == 'None' || sVal5 == '')){
whereString = sField1 + getWhereClause(sOperator1) + 'sVal1' + ' AND ' + sField3 + getWhereClause(sOperator3) + 'sVal3';
}//1,4
else if((sField1 != 'None' && sOperator1 != 'None' && sVal1 != '') &&
(sField2 == 'None' && sOperator2 == 'None' && sVal2 == '') &&
(sField3 == 'None' && sOperator3 == 'None' && sVal3 == '') &&
(sField4 != 'None' || sOperator4 != 'None' || sVal4 != '') &&
(sField5 == 'None' || sOperator5 == 'None' || sVal5 == '')){
whereString = sField1 + getWhereClause(sOperator1) + 'sVal1' + ' AND ' + sField4 + getWhereClause(sOperator4) + 'sVal4';
}//1,5
else if((sField1 != 'None' && sOperator1 != 'None' && sVal1 != '') &&
(sField2 == 'None' && sOperator2 == 'None' && sVal2 == '') &&
(sField3 == 'None' && sOperator3 == 'None' && sVal3 == '') &&
(sField4 == 'None' || sOperator4 == 'None' || sVal4 == '') &&
(sField5 != 'None' || sOperator5 != 'None' || sVal5 != '')){
whereString = sField1 + getWhereClause(sOperator1) + 'sVal1' + ' AND ' + sField5 + getWhereClause(sOperator5) + 'sVal5';
}//2,3
else if((sField1 == 'None' && sOperator1 == 'None' && sVal1 == '') &&
(sField2 != 'None' && sOperator2 != 'None' && sVal2 != '') &&
(sField3 != 'None' && sOperator3 != 'None' && sVal3 != '') &&
(sField4 == 'None' || sOperator4 == 'None' || sVal4 == '') &&
(sField5 == 'None' || sOperator5 == 'None' || sVal5 == '')){
whereString = sField2 + getWhereClause(sOperator2) + 'sVal2' + ' AND ' + sField3 + getWhereClause(sOperator3) + 'sVal3';
}//2,4
else if((sField1 == 'None' && sOperator1 == 'None' && sVal1 == '') &&
(sField2 != 'None' && sOperator2 != 'None' && sVal2 != '') &&
(sField3 == 'None' && sOperator3 == 'None' && sVal3 == '') &&
(sField4 != 'None' || sOperator4 != 'None' || sVal4 != '') &&
(sField5 == 'None' || sOperator5 == 'None' || sVal5 == '')){
whereString = sField2 + getWhereClause(sOperator2) + 'sVal2' + ' AND ' + sField4 + getWhereClause(sOperator4) + 'sVal4';
}//2,5
else if((sField1 == 'None' && sOperator1 == 'None' && sVal1 == '') &&
(sField2 != 'None' && sOperator2 != 'None' && sVal2 != '') &&
(sField3 == 'None' && sOperator3 == 'None' && sVal3 == '') &&
(sField4 == 'None' || sOperator4 == 'None' || sVal4 == '') &&
(sField5 != 'None' || sOperator5 != 'None' || sVal5 != '')){
whereString = sField2 + getWhereClause(sOperator2) + 'sVal2' + ' AND ' + sField5 + getWhereClause(sOperator5) + 'sVal5';
}
queryString = queryString + whereString ;
system.debug(database.query(queryString)+' queryString >>>>>>>>> '+queryString);
return database.query(queryString);
}
*/
public static string getFilterQueryString(String sObj, String sField1, String sOperator1, String sVal1, String sField2, String sOperator2, String sVal2, String sField3, String sOperator3, String sVal3, String sField4, String sOperator4, String sVal4, String sField5, String sOperator5, String sVal5, String EventId){
String queryString;
if(sObj == 'Guest_New__c'){
queryString = 'Select Event__c, FirstName__c, LastName__c, Name, Patch_Controller1__c, Email__c, CompanyOrAccount__c, Title__c, Contact__c, Status__c, CreatedBy.Name, LastModifiedBy.Name, CreatedDate, LastModifiedDate from ' + sObj + ' where Event__c = \''+ EventId +'\' AND ';
}
else{
queryString = 'Select FirstName, LastName, Name, ITV_Patch_Controller__c, Email, Account.name, Title from ' + sObj + ' where ';
}
@TestVisible String whereString = '';
system.debug('Field******' + sField1 + sOperator1 + sField2 + sField3 )
whereString = null;
if(sField1 != 'None' && sOperator1 != 'None' && sField1 != 'None__c'){
System.debug('checkoperator'+sOperator1);
if(sOperator1 == ' Contains'){
whereString = sField1 + ' Like ' +'\''+'%'+sVal1+'%'+'\'';
}
else
whereString = sField1 + getWhereClause(sOperator1) + '\''+sVal1+'\'';
}
if(sField2 != 'None' && sOperator2 != 'None' && sField2 != 'None__c'){
if(whereString != NULL){
if(sOperator2 == ' Contains'){
whereString += ' AND '+ sField2 + ' Like ' +'\''+'%'+sVal2+'%'+'\'';
}
else
whereString += ' AND '+ sField2 + getWhereClause(sOperator2) + '\''+sVal2+'\'';
}
else{
if(sOperator2 == ' Contains'){
whereString = sField2 + ' Like ' +'\''+'%'+sVal2+'%'+'\'';
}
else
whereString = sField2 + getWhereClause(sOperator2) + '\''+sVal2+'\'';
}
}
if(sField3 != 'None' && sOperator3 != 'None' && sField3 != 'None__c'){
if(whereString != NULL){
if(sOperator3 == ' Contains'){
whereString += ' AND '+ sField3 + ' Like ' +'\''+'%'+sVal3+'%'+'\'';
}
else
whereString += ' AND '+ sField3 + getWhereClause(sOperator3) + '\''+sVal3+'\'';
}
else{
if(sOperator3 == ' Contains'){
whereString = sField3 + ' Like ' +'\''+'%'+sVal3+'%'+'\'';
}
else
whereString = sField3 + getWhereClause(sOperator3) + '\''+sVal3+'\'';
}
}
if(sField4 != 'None' && sOperator4 != 'None' && sField4 != 'None__c'){
if(whereString != NULL){
if(sOperator4 == ' Contains'){
whereString += ' AND '+ sField4 + ' Like ' +'\''+'%'+sVal4+'%'+'\'';
}
else
whereString += ' AND '+ sField4 + getWhereClause(sOperator4) + '\''+sVal4+'\'';
}
else{
if(sOperator4 == ' Contains'){
whereString = sField4 + ' Like ' +'\''+'%'+sVal4+'%'+'\'';
}
else
whereString = sField4 + getWhereClause(sOperator4) + '\''+sVal4+'\'';
}
}
if(sField5 != 'None' && sOperator5 != 'None' && sField5 != 'None__c'){
if(whereString != NULL){
if(sOperator5 == ' Contains'){
whereString += ' AND '+ sField5 + ' Like ' +'\''+'%'+sVal5+'%'+'\'';
}
else
whereString += ' AND '+ sField5 + getWhereClause(sOperator5) + '\''+sVal5+'\'';
}
else{
if(sOperator5 == ' Contains'){
whereString = sField5 + ' Like ' +'\''+'%'+sVal5+'%'+'\'';
}
else
whereString = sField5 + getWhereClause(sOperator5) + '\''+sVal5+'\'';
}
}
system.debug(' whereString >>>>>>>>> '+whereString);
if(whereString != null){
queryString = queryString + whereString ;
}
else {
/* ApexPages.Message message = new ApexPages.message(ApexPages.severity.ERROR,'Please specify Field, Operator and Value');
ApexPages.addMessage(message);
*/
if(queryString.containsAny(' AND ')) {
queryString = queryString.replace(' AND ','');
}
if(sObj != 'Guest_New__c'){
if(queryString.containsAny(' where ')) {
queryString = queryString.replace(' where ','');
}
}
}
system.debug(' queryString >>>>>>>>> '+queryString);
return queryString;
}
}
What changes you have made in the class.
Can you paste them here and let us know the field which you are adding in VF
I have just changed the standard phone field and replaced it with ITV_Patch_Controller__c which is a picklist field
Thanks
Abraham
Also when you will be pasting code use the tool bar
I have just replaced one field with anonather field and this error comes up. Even in the queries.
So im not sure why Compile error comes in line 1
The only difference is that the new field is a custom and pickilst field whereas old one was a standard phone field, other than that its the same
thanks