Hi,

I have a web site with MySQL database.

I also have some data in Salesforce that i want to use updating a MySQL table in my web site database.

Please... How can i make it?

Thanks

Emmanuel

Hello,

I am looking for an appexchange quiz maker.

With the possibility to manage questions in a quiz, by giving them a level and a theme (in the same quiz) ?

By level, I mean that a question could have a coefficient.

For exemple :

Question number 1 ; coefficient = 100 (/100)

Question number 2 ; coefficient = 50 (/100)

Question number 3 ; coefficient = 50 (/100)

If I answer correctly the question number 1, I will get 1 point.

If I answer correctly the question number 3, I will get only 0.5 point.

Thank you,

Best regards

Emmanuel Bouf

Hello,

I am trying to make my first unit test code.

Here is the code. The result is ... 0%. How can i make it more efficient ?

Thank you!

Emmanuel

@isTest 
public class Requete_Calendrier_FF_TestClass2 {
    static testMethod void validateRequete_Calendrier_FF2() {

// Initialisation des variables 
  String DataRessources='';
  String DataEvents;
  String testeurRessource;
  String testeurCategory;  
  String addrequete;
  //public String newpicklistvalue{get; set;}
  String monFiltre;    

    String qryString = 'Select nom__c, id__c, Tache__c, Ressource__c, Name, Id, Heure_Fin__c, Heure_Debut__c, Date__c, Categorie__c From Calendrier__c order by categorie__c asc,Ressource__c asc'; 
     
     for (Calendrier__c resultQuery : Database.query(qryString)){   
     if(testeurRessource==resultQuery.Ressource__c && testeurCategory==resultQuery.Categorie__c){}else{
    DataRessources+='{Id: "'+resultQuery.Ressource__c+'-'+resultQuery.Categorie__c+'", Name: "'+resultQuery.Ressource__c+'", Category : "'+resultQuery.Categorie__c+'", Type:"'+ resultQuery.Tache__c+'"},';
     }
     
     DataEvents+='{ResourceId: "'+resultQuery.Ressource__c+'-'+resultQuery.Categorie__c+'", Type : "'+resultQuery.Categorie__c+'", Title : "'+resultQuery.Tache__c+'", Ip : "'+resultQuery.Ressource__c+'",  NBapprenants : "10", StartDate : "'+resultQuery.Date__c+' '+resultQuery.Heure_Debut__c+'", EndDate : "'+resultQuery.Date__c+' '+resultQuery.Heure_Fin__c+'"},';
     
         
     testeurRessource=resultQuery.Ressource__c;
     testeurCategory=resultQuery.Categorie__c;
         
     } 
   
    }
}

Hello,

My request is on the title. It seems to be simple, but I don't find a simple explanation to do that:

How do I pass data, from controller to javascript?

The situation is:

I have a controller which get some data from the database :

public with sharing class recup_donnees_test_Controller {
    
    Public LIST<Calendrier__c> GetCalendriers(){
            return Calendriers_Interne;
    }
    
    Public void SetCalendriers(LIST<Calendrier__c>Calendriers){
            Calendriers_Interne = Calendriers;
    }   

    Private LIST<Calendrier__c>Calendriers_Interne = new LIST<Calendrier__c>();

    Public recup_donnees_test_Controller (){
        
        Calendriers_Interne = [Select c.nom__c, c.id__c, c.Tache__c, c.SystemModstamp, c.Ressource__c, c.OwnerId, c.Name, c.LastModifiedDate, c.LastModifiedById, c.LastActivityDate, c.IsDeleted, c.Id, c.Heure_Fin__c, c.Heure_Debut__c, c.Date__c, c.CreatedDate, c.CreatedById, c.Categorie__c From Calendrier__c c WHERE c.Ressource__c = 'FRANCO-IDRISS Béatrice'];

    }
   

}

And then i have a Visual Force page, in which would like to get the data

Visual force page:

<apex:page Controller="recup_donnees_test_Controller" >

    <apex:pageBlock title="Calendrier">
    <apex:pageBlockTable value="{!Calendriers}" var="c">
        <apex:column headerValue="nom" value="{!c.nom__c}"/>
        <apex:column headerValue="Tâche" value="{!c.Tache__c}"/>
        <apex:column headerValue="Ressource" value="{!c.Ressource__c}"/>
        <apex:column headerValue="Date" value="{!c.Date__c}"/>
        <apex:column headerValue="Heure Début" value="{!c.Heure_Debut__c}"/>
        <apex:column headerValue="Heure Fin" value="{!c.Heure_Fin__c}"/>
 
    </apex:pageBlockTable>
</apex:pageBlock>



</apex:page>

if someone could help me?

Thank you

Emmanuel

Hello,

I would like to know how to store data, after a database query, for using this data in a Ajax script?

I have a custom object. Called "Calendar". I need to store, to collect data from this custom object "Calendar", but i don't know how?

I need to have my data in this 'format' :

{ResourceId: 'LastName FirstName', Type : 'Type_1', Title : 'Type_title', Ip : 'LastName FirstName',  NBapprenants : '10', StartDate : '2011-08-15 09:00:00', EndDate : '2011-08-15 18:00:00'},

I can display this data with a Controller and a Visualforce using apex tags, but i need to store this data for an ajax application.

If somebody can help me?

regards

Emmanuel



Hello,

how to store data , after a database query, for using this data in a Ajax script.

I have a custom object. Called "Calendar".

I need to store, to collect data from this custom object "Calendar", but i don't know how ???

I need to have my data in this 'format' :

{ResourceId: 'LastName FirstName', Type : 'Type_1', Title : 'Type_title', Ip : 'LastName FirstName',  NBapprenants : '10', StartDate : '2011-08-15 09:00:00', EndDate : '2011-08-15 18:00:00'},

I can display this data with a Controller and a Visualforce using apex tags, but i need to store this data for an ajax application.

If somebody would help ?

regards

Emmanuel

France (sorry if my english is limited)

Hi,

I have a web site with MySQL database.

I also have some data in Salesforce that i want to use updating a MySQL table in my web site database.

Please... How can i make it?

Thanks

Emmanuel

Hello,

I am trying to make my first unit test code.

Here is the code. The result is ... 0%. How can i make it more efficient ?

Thank you!

Emmanuel

@isTest 
public class Requete_Calendrier_FF_TestClass2 {
    static testMethod void validateRequete_Calendrier_FF2() {

// Initialisation des variables 
  String DataRessources='';
  String DataEvents;
  String testeurRessource;
  String testeurCategory;  
  String addrequete;
  //public String newpicklistvalue{get; set;}
  String monFiltre;    

    String qryString = 'Select nom__c, id__c, Tache__c, Ressource__c, Name, Id, Heure_Fin__c, Heure_Debut__c, Date__c, Categorie__c From Calendrier__c order by categorie__c asc,Ressource__c asc'; 
     
     for (Calendrier__c resultQuery : Database.query(qryString)){   
     if(testeurRessource==resultQuery.Ressource__c && testeurCategory==resultQuery.Categorie__c){}else{
    DataRessources+='{Id: "'+resultQuery.Ressource__c+'-'+resultQuery.Categorie__c+'", Name: "'+resultQuery.Ressource__c+'", Category : "'+resultQuery.Categorie__c+'", Type:"'+ resultQuery.Tache__c+'"},';
     }
     
     DataEvents+='{ResourceId: "'+resultQuery.Ressource__c+'-'+resultQuery.Categorie__c+'", Type : "'+resultQuery.Categorie__c+'", Title : "'+resultQuery.Tache__c+'", Ip : "'+resultQuery.Ressource__c+'",  NBapprenants : "10", StartDate : "'+resultQuery.Date__c+' '+resultQuery.Heure_Debut__c+'", EndDate : "'+resultQuery.Date__c+' '+resultQuery.Heure_Fin__c+'"},';
     
         
     testeurRessource=resultQuery.Ressource__c;
     testeurCategory=resultQuery.Categorie__c;
         
     } 
   
    }
}

Hello,

My request is on the title. It seems to be simple, but I don't find a simple explanation to do that:

How do I pass data, from controller to javascript?

The situation is:

I have a controller which get some data from the database :

public with sharing class recup_donnees_test_Controller {
    
    Public LIST<Calendrier__c> GetCalendriers(){
            return Calendriers_Interne;
    }
    
    Public void SetCalendriers(LIST<Calendrier__c>Calendriers){
            Calendriers_Interne = Calendriers;
    }   

    Private LIST<Calendrier__c>Calendriers_Interne = new LIST<Calendrier__c>();

    Public recup_donnees_test_Controller (){
        
        Calendriers_Interne = [Select c.nom__c, c.id__c, c.Tache__c, c.SystemModstamp, c.Ressource__c, c.OwnerId, c.Name, c.LastModifiedDate, c.LastModifiedById, c.LastActivityDate, c.IsDeleted, c.Id, c.Heure_Fin__c, c.Heure_Debut__c, c.Date__c, c.CreatedDate, c.CreatedById, c.Categorie__c From Calendrier__c c WHERE c.Ressource__c = 'FRANCO-IDRISS Béatrice'];

    }
   

}

And then i have a Visual Force page, in which would like to get the data

Visual force page:

<apex:page Controller="recup_donnees_test_Controller" >

    <apex:pageBlock title="Calendrier">
    <apex:pageBlockTable value="{!Calendriers}" var="c">
        <apex:column headerValue="nom" value="{!c.nom__c}"/>
        <apex:column headerValue="Tâche" value="{!c.Tache__c}"/>
        <apex:column headerValue="Ressource" value="{!c.Ressource__c}"/>
        <apex:column headerValue="Date" value="{!c.Date__c}"/>
        <apex:column headerValue="Heure Début" value="{!c.Heure_Debut__c}"/>
        <apex:column headerValue="Heure Fin" value="{!c.Heure_Fin__c}"/>
 
    </apex:pageBlockTable>
</apex:pageBlock>



</apex:page>

if someone could help me?

Thank you

Emmanuel

Hello,

I would like to know how to store data, after a database query, for using this data in a Ajax script?

I have a custom object. Called "Calendar". I need to store, to collect data from this custom object "Calendar", but i don't know how?

I need to have my data in this 'format' :

{ResourceId: 'LastName FirstName', Type : 'Type_1', Title : 'Type_title', Ip : 'LastName FirstName',  NBapprenants : '10', StartDate : '2011-08-15 09:00:00', EndDate : '2011-08-15 18:00:00'},

I can display this data with a Controller and a Visualforce using apex tags, but i need to store this data for an ajax application.

If somebody can help me?

regards

Emmanuel