• smelick
  • NEWBIE
  • 0 Points
  • Member since 2004

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 5
    Questions
  • 4
    Replies

Is there an issue with the search SOQL? I have a record: "lphillips@ingenium-corp.com" that is returning a "MALFORMED QUERY" because there is a hyphen in the domain name. Is there something special I should have to do to handle this or is this a bug?

Thanks,

Scott

OK, I have been quiet until now...

I have done significant development for our corporate website to integrate items such as campaign landing pages, subscriptions, lead forms, whitepapers etc... SFDC has a great API but, I am VERY reluctant to place this in production. We are a supplier of fault tolerant computing equipment and to have our primary conduit for our prospects and customers hinged on the recent performance is unacceptable. I refuse to base our reputation on SFDC performance and quite frankly this would fly directly in the face of what we stand for.

I will now have to re-think my approach and possibly use an interface table to batch data into SFDC. This is crazy, a part time API....

What the hell is going on?

-Scott

Where can I post a technical question regarding a web-to-lead/lead configuration? I am looking to see the best practice for setting up custom fields to accept answers to questions that may vary. For example: we have specific questions for campaigns that we want to capture, these questions will vary based on campaign. I don't want to add 100 custom fields for each campaign to capture these questions. My first thought would be to create generic fields:

Question1, Answer1, Question2 Answer2 etc...

We also use multiple check boxes for our forms, what is the best way to capture this information? Is it to combine the values in to one field? I know multiple values can be combined into the "description" field, but this is not the case with custom fields.

Thanks,

-Scott

Message Edited by smelick on 11-18-2004 06:37 PM

Anybody out there have code to share that updates data? I have query(), queryMore() and getDeleted() working but was wondering if there was anyone that has the updates working?

-Scott

  • September 16, 2004
  • Like
  • 0

Hi I am using GetDeleted successfully (With ColdFusion) BUT I am unable to find the method to check for the rcord count, resulting in a NullPointerExeption when no records are returned.

Query has "getSize()" which I can test for, is there an equivelant for GetDeleted? The Java Examples refrence a "getDeletedRecords().length" but there is no length in a NULL record set.

 

My code is:

 

<cfset gdr = sfdc.getDeleted("#attributes.job#", "#DateFormat(DateAdd("d","-1", Now()),"MM/DD/YYYY")#", "#DateFormat(DateAdd("d","1", Now()),"MM/DD/YYYY")#")>


 <cfset nRecords = arrayLen(gdr.DeletedRecords) />
 
 <cfloop index="i" from="1" to="#nRecords#">
    <cfquery name="SetFlag" datasource="#request.DSN#">
  update  Sforce_#attributes.job#
  set     RECORD_UPDATED = SYSDATE
  ,  DELETED_FLAG = 'Y'
  where   ID = '#gdr.DeletedRecords[i].id#'
  </cfquery>
 </cfloop>

  • September 14, 2004
  • Like
  • 0

Is there an issue with the search SOQL? I have a record: "lphillips@ingenium-corp.com" that is returning a "MALFORMED QUERY" because there is a hyphen in the domain name. Is there something special I should have to do to handle this or is this a bug?

Thanks,

Scott

OK, I have been quiet until now...

I have done significant development for our corporate website to integrate items such as campaign landing pages, subscriptions, lead forms, whitepapers etc... SFDC has a great API but, I am VERY reluctant to place this in production. We are a supplier of fault tolerant computing equipment and to have our primary conduit for our prospects and customers hinged on the recent performance is unacceptable. I refuse to base our reputation on SFDC performance and quite frankly this would fly directly in the face of what we stand for.

I will now have to re-think my approach and possibly use an interface table to batch data into SFDC. This is crazy, a part time API....

What the hell is going on?

-Scott

Where can I post a technical question regarding a web-to-lead/lead configuration? I am looking to see the best practice for setting up custom fields to accept answers to questions that may vary. For example: we have specific questions for campaigns that we want to capture, these questions will vary based on campaign. I don't want to add 100 custom fields for each campaign to capture these questions. My first thought would be to create generic fields:

Question1, Answer1, Question2 Answer2 etc...

We also use multiple check boxes for our forms, what is the best way to capture this information? Is it to combine the values in to one field? I know multiple values can be combined into the "description" field, but this is not the case with custom fields.

Thanks,

-Scott

Message Edited by smelick on 11-18-2004 06:37 PM

Hi I am using GetDeleted successfully (With ColdFusion) BUT I am unable to find the method to check for the rcord count, resulting in a NullPointerExeption when no records are returned.

Query has "getSize()" which I can test for, is there an equivelant for GetDeleted? The Java Examples refrence a "getDeletedRecords().length" but there is no length in a NULL record set.

 

My code is:

 

<cfset gdr = sfdc.getDeleted("#attributes.job#", "#DateFormat(DateAdd("d","-1", Now()),"MM/DD/YYYY")#", "#DateFormat(DateAdd("d","1", Now()),"MM/DD/YYYY")#")>


 <cfset nRecords = arrayLen(gdr.DeletedRecords) />
 
 <cfloop index="i" from="1" to="#nRecords#">
    <cfquery name="SetFlag" datasource="#request.DSN#">
  update  Sforce_#attributes.job#
  set     RECORD_UPDATED = SYSDATE
  ,  DELETED_FLAG = 'Y'
  where   ID = '#gdr.DeletedRecords[i].id#'
  </cfquery>
 </cfloop>

  • September 14, 2004
  • Like
  • 0