function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
sfdc-Lsfdc-L 

I am unable to access the records from account object

Hi all,

 

i am fetching records from account by using ajax in salesforce, but i am unable to get it so here i am giving the code so pls make the changes and let me know asap .

 

<apex:page>
<script type="text/javascript">
var __sfdcSessionId = '{!GETSESSIONID()}';
</script>
<script src="/soap/ajax/24.0/connection.js" type="text/javascript">
</script>
<script type="text/javascript">
window.onload= setupPage;

function setupPage()
{
var result = sforce.connection.query("select name, id from account where limit:=1");
var queryMore = true;
var output = "";
while (queryMore) {
var records = result.getArray("records");
for (var i = 0; i < records.length; i++) {
var account = records[i];

output += account.Id + " " + account.Name + "<br>";
}
if (result.getBoolean("done")) {
queryMore = false;
} else {
result = sforce.connection.queryMore(result.queryLocator);
}
}
}
</script>
<div id="output"> </div>
</apex:page>

 

Thanks

Best Answer chosen by Admin (Salesforce Developers) 
Navatar_DbSupNavatar_DbSup

Hi,

 

Try the below code snippet.

<apex:page >

 

<script type="text/javascript">

var __sfdcSessionId = '{!GETSESSIONID()}';

// alert("SESSION ID IS    ="+__sfdcSessionId);

</script>

<script src="/soap/ajax/24.0/connection.js" type="text/javascript">

</script>

<script type="text/javascript">

window.onload= setupPage;

 

function setupPage()

{

    var result = sforce.connection.query("select name, id from account  limit 10");

    var queryMore = true;

    var output = "";

        while (queryMore)

        {

            var records = result.getArray("records");

            for (var i = 0; i < records.length; i++)

            {

                var account = records[i];

                output += account.Id + " " + account.Name + "<br>";

            }

            if (result.getBoolean("done"))

            {

                queryMore = false;

            }

            else

            {

                result = sforce.connection.queryMore(result.queryLocator);

            }

        }

      //  alert('___queryMore___'+queryMore);

      //  alert(document.getElementById('output'));

        document.getElementById('output').innerHTML=output;

}

</script>

<div id="output"> </div>

 

</apex:page>

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 

All Answers

Navatar_DbSupNavatar_DbSup

Hi,

 

Try the below code snippet.

<apex:page >

 

<script type="text/javascript">

var __sfdcSessionId = '{!GETSESSIONID()}';

// alert("SESSION ID IS    ="+__sfdcSessionId);

</script>

<script src="/soap/ajax/24.0/connection.js" type="text/javascript">

</script>

<script type="text/javascript">

window.onload= setupPage;

 

function setupPage()

{

    var result = sforce.connection.query("select name, id from account  limit 10");

    var queryMore = true;

    var output = "";

        while (queryMore)

        {

            var records = result.getArray("records");

            for (var i = 0; i < records.length; i++)

            {

                var account = records[i];

                output += account.Id + " " + account.Name + "<br>";

            }

            if (result.getBoolean("done"))

            {

                queryMore = false;

            }

            else

            {

                result = sforce.connection.queryMore(result.queryLocator);

            }

        }

      //  alert('___queryMore___'+queryMore);

      //  alert(document.getElementById('output'));

        document.getElementById('output').innerHTML=output;

}

</script>

<div id="output"> </div>

 

</apex:page>

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 

This was selected as the best answer
sfdc-Lsfdc-L

Thanks a lot navatar,

 

I have same scenairo like,i want to fetch a records from deletagated adimstrators so how can i do that by using same code so pls do let me know asap.