• Joan
  • NEWBIE
  • 0 Points
  • Member since 2006

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 11
    Questions
  • 22
    Replies
Hello Everyone,
 
I am trying to create a solution that pertains to a SQL problem.
 
Part of the solution includes an example command followed by it's output.  This output is in the form of a table.
 
When the solution, with it's table, were created inside of Word, the columns of the table were all lined up.  First, I had tabs between each of the entries, and I have also tried spaces.  The result is still the same.  We have also tried &nbsp in the actual file, as well as trying to insert a table into the Word file, and copying THAT into the solution.
 
This is what it looks like in Word:
 
DBCC LOGINFO('pubs')
Sample results:
FileID FileSize StartOffset FSeqNo Status Parity CreateLSN
------ -------  ----------- ------ ------ ------ ---------
2      253967   8198        909756 0      46     0
2      261354   1048646     0      0      0      909788564738397000000
Inside of Salesforce Solutions, the columns are 1 space apart, and because they are not
lined up, the explanation that follows does not make sense.  This is what it looks like in
Salesforce:
FileID FileSize StartOffset FSeqNo Status Parity CreateLSN 
------ ------- ----------- ------ ------ ------ ---------
2 253967 8198 909756 0 46 0
2 261354 1048646 0 0 0 909788564738397000000
Anyone can let me know how can I fix this problem?
Thanks a lot
  • December 21, 2006
  • Like
  • 0
Hi guys,
I have very strange problem when I insert double data type value into object:
 
When I insert some fields value into case which is double data type, it works fine, like:
myCase.of_Clients__c = Double.Parse(Trim(clientsN.Text).ToString)
myCase.of_Clients__cSpecified = True
 
When I insert some fields value into Lead & other customer object which is double data type, it  doesn't give me error but the value is blank, any other knid of date type can be inserted fine, like:
myLead.of_FACSys_Servers__c = Double.Parse(Trim(ServerN.Text).ToString)
myLead.of_FACSys_Servers__c = True
 
Any one can help me fix it out?
 
Thanks,
  • December 14, 2006
  • Like
  • 0
Hello all,
 
When I do following retrieve operation, there's no problem:
thisAccount = CType(sfdc.retrieve("Name", "Account", New String() {thisContact.AccountId})(0), Account)
 
But when I add other filelds like following: I got error message:
Value of type 'String' cannot be converted to '1-dimensional array of String'
thisAccount = CType(sfdc.retrieve("Name", "Account", "ParentID", "Parent", New String() {thisContact.AccountId})(0), Account)
 
The fields I added is in red
 
Any idea?
Thanks,
  • December 14, 2006
  • Like
  • 0
Hello everyone,
Our salesforce deveoper have created a new customer object in www.salesfroce.com, I need to update this object to our sandbox site to do the test, anyone can tell me how to do it?
many thanks,
  • December 07, 2006
  • Like
  • 0
Hello,
When I run following coding:
 
Partial Class FACSysUpgrade_UpgradeForm
    Inherits System.Web.UI.Page
    Private Shared sfdc As New SforceService
    Private Shared myOrder As SFDC_Order__c
    Private Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles MyBase.Load, Me.Load
                myOrder = New SFDC_Order__c
                myOrder.Account__c = "001500000ExQNmAAN"
                Dim records(0) As sObject
                records(0) = myOrder
                Try
                    Dim saveResults() As SaveResult = sfdc.create(records)
                    If saveResults(0).success Then
                        Response.Write("Successful<hr>")
                   Else
                        Response.Write(saveResults(0).errors(0).message & "<hr>")
                    End If
                Catch ex As Exception
                    Response.Write(ex.ToString & "<hr>")
                End Try
    End Sub
End Class
I always get error: "Account: id value of incorrect type", the error line is in red. In WSDL file, data type of this field as: <element name="Account__c" nillable="true" minOccurs="0" type="tns:ID" />.
I have done the same thing with other field in other object with no problem
Any help is appreciated
  • December 05, 2006
  • Like
  • 0
Hello,
I got same error as JAre's when I test my following coding (in VB.NET)
 
Partial Class FACSysUpgrade_UpgradeForm
    Inherits System.Web.UI.Page
    Private Shared sfdc As SforceService
    Private Shared myOrder As SFDC_Order__c
    Private Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles MyBase.Load, Me.Load
                myOrder = New SFDC_Order__c
                myOrder.Account__c = "Test Account"
                Dim records(0) As sObject
                records(0) = MyLead
                Try
                    Dim saveResults() As SaveResult = sfdc.create(records)
                    If saveResults(0).success Then
                        Response.Write("Successful<hr>")
                   Else
                        Response.Write("Not Successful<hr>")
                    End If
                Catch ex As Exception
                    Response.Write(ex.ToString & "<hr>")
                End Try
    End Sub
End Class
When I test my simple method at this point I get error;
System.NullReferenceException: Object reference not set to an instance of an object (Same error as JAre got), The error is coming from the  red line, but I think I have initialized the sfdc (show in bold), and SFDC_Order__c is our customer object, so I change to Lead as customer, I still have same error
Any idea?
Thanks,
  • December 04, 2006
  • Like
  • 0
Hello
 
After I do the search as following:
 
binding.search("find {test}in ALL FIELDS returning solution(SolutionName, SolutionNote)")
 
How can I use GridView so that I can display limite records each page?
 
Thanks,
 
 
 
  • November 20, 2006
  • Like
  • 0
Hi
If I can the search useing coding like:

binding.search("find {test}in ALL FIELDS returning solution(SolutionName, SolutionNote, IsPublished, Related_To__c, Publish_to_public__c)")

How can I add condition here, like IsPublished=True

What I want to do is I want to search word 'test' where IsPublished=True

Any help?

Thanks

  • November 17, 2006
  • Like
  • 0
Hello everyone,
 
I found in salesforce.com, if I do the search for solution, I can get a list of solution matched my search and also I can get score (?%), I have done my own application for search solution from salesforce, but how can I get score after search?
 
Any help?
 
Thanks,
  • November 14, 2006
  • Like
  • 0
Hi guys,
I'm developing application for my company with salesforce API, after I log into Self-Service Portal with my application, I can do anything I want, it works fine. But I want my application can remember user's username/password if they check the check box, so next time they don't have to re-enter their username/password, I used cookies to store their informatin, but it's not working properly, I used cookie to do samething before for my other applicatin , works fine, any one knows why it doesn't work with salesforce?
Thanks,
  • November 10, 2006
  • Like
  • 0
Hello
I'm very new in salesforce, I'm trying to connect salesforce DB and our company's web site, can I just use ADO.NET Managed Provider or I have to use API, if so, how can I use it? I know I have to download WDSL file as my Web Reference, but how can I connect to salesforce?
Thanks for any suggestion
  • September 22, 2006
  • Like
  • 0
Hi guys,
I have very strange problem when I insert double data type value into object:
 
When I insert some fields value into case which is double data type, it works fine, like:
myCase.of_Clients__c = Double.Parse(Trim(clientsN.Text).ToString)
myCase.of_Clients__cSpecified = True
 
When I insert some fields value into Lead & other customer object which is double data type, it  doesn't give me error but the value is blank, any other knid of date type can be inserted fine, like:
myLead.of_FACSys_Servers__c = Double.Parse(Trim(ServerN.Text).ToString)
myLead.of_FACSys_Servers__c = True
 
Any one can help me fix it out?
 
Thanks,
  • December 14, 2006
  • Like
  • 0
Hello all,
 
When I do following retrieve operation, there's no problem:
thisAccount = CType(sfdc.retrieve("Name", "Account", New String() {thisContact.AccountId})(0), Account)
 
But when I add other filelds like following: I got error message:
Value of type 'String' cannot be converted to '1-dimensional array of String'
thisAccount = CType(sfdc.retrieve("Name", "Account", "ParentID", "Parent", New String() {thisContact.AccountId})(0), Account)
 
The fields I added is in red
 
Any idea?
Thanks,
  • December 14, 2006
  • Like
  • 0
Hello everyone,
Our salesforce deveoper have created a new customer object in www.salesfroce.com, I need to update this object to our sandbox site to do the test, anyone can tell me how to do it?
many thanks,
  • December 07, 2006
  • Like
  • 0
Hello,
When I run following coding:
 
Partial Class FACSysUpgrade_UpgradeForm
    Inherits System.Web.UI.Page
    Private Shared sfdc As New SforceService
    Private Shared myOrder As SFDC_Order__c
    Private Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles MyBase.Load, Me.Load
                myOrder = New SFDC_Order__c
                myOrder.Account__c = "001500000ExQNmAAN"
                Dim records(0) As sObject
                records(0) = myOrder
                Try
                    Dim saveResults() As SaveResult = sfdc.create(records)
                    If saveResults(0).success Then
                        Response.Write("Successful<hr>")
                   Else
                        Response.Write(saveResults(0).errors(0).message & "<hr>")
                    End If
                Catch ex As Exception
                    Response.Write(ex.ToString & "<hr>")
                End Try
    End Sub
End Class
I always get error: "Account: id value of incorrect type", the error line is in red. In WSDL file, data type of this field as: <element name="Account__c" nillable="true" minOccurs="0" type="tns:ID" />.
I have done the same thing with other field in other object with no problem
Any help is appreciated
  • December 05, 2006
  • Like
  • 0
Hello,
I got same error as JAre's when I test my following coding (in VB.NET)
 
Partial Class FACSysUpgrade_UpgradeForm
    Inherits System.Web.UI.Page
    Private Shared sfdc As SforceService
    Private Shared myOrder As SFDC_Order__c
    Private Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles MyBase.Load, Me.Load
                myOrder = New SFDC_Order__c
                myOrder.Account__c = "Test Account"
                Dim records(0) As sObject
                records(0) = MyLead
                Try
                    Dim saveResults() As SaveResult = sfdc.create(records)
                    If saveResults(0).success Then
                        Response.Write("Successful<hr>")
                   Else
                        Response.Write("Not Successful<hr>")
                    End If
                Catch ex As Exception
                    Response.Write(ex.ToString & "<hr>")
                End Try
    End Sub
End Class
When I test my simple method at this point I get error;
System.NullReferenceException: Object reference not set to an instance of an object (Same error as JAre got), The error is coming from the  red line, but I think I have initialized the sfdc (show in bold), and SFDC_Order__c is our customer object, so I change to Lead as customer, I still have same error
Any idea?
Thanks,
  • December 04, 2006
  • Like
  • 0
Hello everyone,
 
I am new to SalesForce.com. I am working on a simple application that writes a record. I copy the code from the example given on salesforce.com web site. I have try everything it seems with no positive results. My code is as follow;
 

try

{

SalesForce.sObject account;

sObject[] accs = new sObject[2];

for (int j = 0; j < accs.Length; j++)

{

account = new SalesForce.sObject();

System.Xml.XmlElement[] acct = new System.Xml.XmlElement[14];

int index = 0;

if (accounts == null)

acct[index++] = GetNewXmlElement("AccountNumber", "0000000");

else

acct[index++] = GetNewXmlElement("AccountNumber", "000000" + (accounts.Length + 1));

acct[index++] = GetNewXmlElement("BillingCity", "Wichita");

 // more GetNewXmlElement("xx") here

account.Any = acct;

accs[j] = account;

}

 SaveResult[] sr = binding.create(accs);

When I test my simple method at this point I get error; Object reference not set to an instance of an object.

The error is coming from the line in red.

What is it that is wrong with this code and why do I get this error?

Please help...

 

 

Message Edited by JAre on 12-01-2006 06:56 AM

Message Edited by JAre on 12-01-2006 06:57 AM

  • December 01, 2006
  • Like
  • 0
Hi,
 
I want to search only Account name from accounts using sforce API.
 
But in API, the provided search function can have the ability to search in NAME FIELDS or PHONE FIELDS or EMAIL FIELDs or ALL FIELDs.
 
But i want to search only acccount name field. How can i?
 
I tried with query function but got error if i use like operator.
 
Can any one help me urgent.
 
Thanks for your help
MM
Hello
 
After I do the search as following:
 
binding.search("find {test}in ALL FIELDS returning solution(SolutionName, SolutionNote)")
 
How can I use GridView so that I can display limite records each page?
 
Thanks,
 
 
 
  • November 20, 2006
  • Like
  • 0
Hi
If I can the search useing coding like:

binding.search("find {test}in ALL FIELDS returning solution(SolutionName, SolutionNote, IsPublished, Related_To__c, Publish_to_public__c)")

How can I add condition here, like IsPublished=True

What I want to do is I want to search word 'test' where IsPublished=True

Any help?

Thanks

  • November 17, 2006
  • Like
  • 0
Is this search correct? I am getting an error stating it is a MALFORMED_SEARCH
 

Dim sr As sforce.SearchResult

sr = binding.search("find {" & strCallerData & "} in account fields returning " & _

"account(accountnumber)")