hello -

i'm working on an sControl using beta 3 of the ajax toolkit. when i execute the following query:

var qr = sforceClient.Query("Select Id, ProductId, TotalPrice from OpportunityLineItem where OpportunityId = '" + oppId + "'");

it fails in firefox. however, when i try the exact same query in internet explorer it works fine. the query also works fine using firefox or internet explorer with beta 1 and beta 2 of the ajax toolkit.

any idea as to why this fails for beta 3 on firefox?

hello -

i've developed an sControl to automatically populate information on a custom object (calle CAR) from information on the the CASE object. everything is working well, except one of the fields i'm trying to populate is a lookup to another custom object (called CAR owners).

i am passing the proper ID to the lookup but it still won't take. my question is - is it even possible to update lookups from an sControl? if so, any tricks to doing so?

thanks!

hello -

i'm trying to create a case w/ the ajax toolkit and having some issues. Here is the javascript function:

//create case from asset using contact id and record type info
function createCase() {
//check that all required variables are set
if (assetId != "" && conId != "" && proTypeId != "" && proType != "") {
//create case dynabean
var _case = new DynaBean("Case");
_case.set("AssetId", assetId);
_case.set("ContactId", conId);
_case.set("RecordTypeId", proTypeId);
_case.set("Type", proType);
//create 1 new case
var saveResult = sforceClient.Create(_case);

alert("Here is the save result:"+saveResult.toString());

}
else {
alert("Error: Information required to create a Case directly from this Asset is missing.");
//return to asset page
frameNav(assetUrl);
}
}

saveResult.toString() is being returned as a null so i'm not getting any feedback. the variables being set are correct. any ideas/suggestions are much appreciated! thanks!

Hi -

I'm working on an S-Control using the AJAX toolkit to update the AssetId on a Case. My query is returning the correct Case Id and I have the correct AssetId to update with but my update is not working. My javascript function is below. This is my first time working with the AJAX toolkit and Case object so my syntax is probably incorrect. Any suggestions are appreciated:

function IsChecked(form, element_name, value)
{
//query sforce for current Case and current AssetId
var queryResult2 = sforceClient.Query("Select Id, CaseNumber, AssetId from Case Where CaseNumber = '" + caseId + "'");
//new array to hold results of updates
var updateObjects = new Array();
for (i = 0; i < form.elements.length; i++) {
if ((form.elements[i].name == element_name) && (form.elements[i].checked)) {
var aid = form.elements[i].value;
var _case = queryResult2.records[0];
//set case AssetId to checked value
_case.set("AssetId", aid);
//push updated AssetId to update array
updateObjects.push(_case);
}
}

if (updateObjects.length > 0) {
var x = window.confirm("Are you sure you want to update "+ updateObjects.length +" record(s) ?");
if (x) {
var sr = sforceClient.Update(updateObjects);
//window.parent.parent.location.href = retUrl;
window.close();
}
} else {
alert("No Records will be updated");
//window.parent.parent.location.href = retUrl;
window.close();
}
}

Message Edited by msimonds on 11-07-2006 07:44 AM

Message Edited by msimonds on 11-07-2006 07:51 AM

Maybe I'm missing something obvious here, but it sure is frustrating.  I'm using OSX 10.4.7 and Eclipse 3.1.  I have java 1.4.2 and 1.5 loaded (which might be a problem, but I wouldn't think so).  I can successfully create an AppExchange project and successfully download all current scontrols.  I can update them and save changes and they work.

#1
Problem comes in when I try to create a NEW scontrol using Eclipse.  I create a new file and immediately get "An unexpected error was thrown while trying to open the S-Control." along with a java.lang.NullPointerException.  This is a new scontrol, doesn't exist in salesforce yet.  Is there another way I'm supposed to create them?

#2
Then it actually does create the file locally to the workspace.  Great, I'll build it anyway.  I added a simple html tag and one word, test, updated the properties with the scontrol name and try to save.  "Field integrity exception occurred, check your merge field definitions." and another NullPointerException.  I didn't use any merge fields!

#3
Fine.  I'll just create what I need in a text editor and create the scontrol the old fashioned way by pasting it into the salesforce UI.  Then I can refresh the AppExchange project and at least maintain it with Eclipse, right?  Well the context menu "Refresh" does absolutely nothing.  I have to create a new project and start all over, and then I have the new scontrol available in Eclipse.

So what's going on?  BTW I've tried 3.2 with the latest beta version of the plugin, but that just flat doesn't even allow a connection to the soap endpoint.

I want to use this.  It's very cool.  Help!

Mark

Message Edited by dotneteric on 06-01-2006 08:34 PM

I'm creating a query to do a bulk update on a set of records. The QueryResult size property is 561, but the records array is only of length 200. Is this a known bug, and is there any workaround for it?

-Eric Hawthorne

I want to know what is the best way to call a web service from Salesforce.

The process involves
From an Contact SF page...
1.Call a webservice that I host in my webserver
2.Creating a task associated with the contact based on the webservice result

Also
What the best way to authenticate in my web service
1 - Should I create a UsernameWs/PasswordWs Field in the User Object and pass it
or
2 - pass the sessionId

Any thoughts on how to create a PDF page from an scontrol.  The best option I've seen so far is manual - create HTML, save (IE only), and use an online service that generates the PDF.  Checking to see if there is another way...
Thanks.

hello -

i'm working on an sControl using beta 3 of the ajax toolkit. when i execute the following query:

var qr = sforceClient.Query("Select Id, ProductId, TotalPrice from OpportunityLineItem where OpportunityId = '" + oppId + "'");

it fails in firefox. however, when i try the exact same query in internet explorer it works fine. the query also works fine using firefox or internet explorer with beta 1 and beta 2 of the ajax toolkit.

any idea as to why this fails for beta 3 on firefox?

hello -

i've developed an sControl to automatically populate information on a custom object (calle CAR) from information on the the CASE object. everything is working well, except one of the fields i'm trying to populate is a lookup to another custom object (called CAR owners).

i am passing the proper ID to the lookup but it still won't take. my question is - is it even possible to update lookups from an sControl? if so, any tricks to doing so?

thanks!

hello -

i'm trying to create a case w/ the ajax toolkit and having some issues. Here is the javascript function:

//create case from asset using contact id and record type info
function createCase() {
//check that all required variables are set
if (assetId != "" && conId != "" && proTypeId != "" && proType != "") {
//create case dynabean
var _case = new DynaBean("Case");
_case.set("AssetId", assetId);
_case.set("ContactId", conId);
_case.set("RecordTypeId", proTypeId);
_case.set("Type", proType);
//create 1 new case
var saveResult = sforceClient.Create(_case);

alert("Here is the save result:"+saveResult.toString());

}
else {
alert("Error: Information required to create a Case directly from this Asset is missing.");
//return to asset page
frameNav(assetUrl);
}
}

saveResult.toString() is being returned as a null so i'm not getting any feedback. the variables being set are correct. any ideas/suggestions are much appreciated! thanks!

Hi -

I'm working on an S-Control using the AJAX toolkit to update the AssetId on a Case. My query is returning the correct Case Id and I have the correct AssetId to update with but my update is not working. My javascript function is below. This is my first time working with the AJAX toolkit and Case object so my syntax is probably incorrect. Any suggestions are appreciated:

function IsChecked(form, element_name, value)
{
//query sforce for current Case and current AssetId
var queryResult2 = sforceClient.Query("Select Id, CaseNumber, AssetId from Case Where CaseNumber = '" + caseId + "'");
//new array to hold results of updates
var updateObjects = new Array();
for (i = 0; i < form.elements.length; i++) {
if ((form.elements[i].name == element_name) && (form.elements[i].checked)) {
var aid = form.elements[i].value;
var _case = queryResult2.records[0];
//set case AssetId to checked value
_case.set("AssetId", aid);
//push updated AssetId to update array
updateObjects.push(_case);
}
}

if (updateObjects.length > 0) {
var x = window.confirm("Are you sure you want to update "+ updateObjects.length +" record(s) ?");
if (x) {
var sr = sforceClient.Update(updateObjects);
//window.parent.parent.location.href = retUrl;
window.close();
}
} else {
alert("No Records will be updated");
//window.parent.parent.location.href = retUrl;
window.close();
}
}

After creating a web-integration (Sforce Control) link, all seems to be working properly, however when navigating to the page, the user is prompted asking them whether or not they would like to accept NON-Secure Items.

I realize, this can be stopped on a per-user basis, by changing the IE Options to Accpet Non-Secure Items and not prompt, however is there any other way to avoid this message other than changin the Explorer Options?

Thank You.