------------------------------------------------------------------------

Provbinding.QueryOptionsValue = New QueryOptions()

Provbinding.QueryOptionsValue.batchSize = 500

Provbinding.QueryOptionsValue.batchSizeSpecified = True

Dim Qresult As QueryResult

Qresult = Nothing

strSOQL = "SELECT sfLma__Install_Date__c, sfLma__Proxy_User__c FROM sfLma__License__c"

Qresult = Provbinding.query(strSOQL)

Dim enddate() As String

if Qresult.size = 0 Then

Me.TotalLicense = Qresult.records.Length

Return 2

end if

------------------------------------------------------------------------

It return queryresult set with 0 value which is not true as I have 1 record in this object sfLma__License__c

and I faced one more problem in above query when I am using created custom field in a downloaded package custom oobject

it throw err like

NVALID_FIELD:
RecordType.Name,sfLma__Expiration__c, Organization_Id__c,PackageExpiryDate__c
                                      ^
ERROR at Row:1:Column:91
No such column 'Organization_Id__c' on entity 'sfLma__License__c'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
------------------------------------------------------------------------

please anybody suggest me any solution on both of the above problem

  1. Complete date plus hours and minutes:
      YYYY-MM-DDThh:mmTZD (eg 1997-07-16T19:20+01:00)
  2. Complete date plus hours, minutes and seconds:
      YYYY-MM-DDThh:mm:ssTZD (eg 1997-07-16T19:20:30+01:00)
  3. Complete date plus hours, minutes, seconds and a decimal fraction of a
     second
      YYYY-MM-DDThh:mm:ss.sTZD (eg 1997-07-16T19:20:30.45+01:00)

but it gives me error when i try to use above format.

--------------------------------------------------------------------------------------------------- 
Exception : 
{faultcode:'soapenv:Client', faultstring:''2007-12-25T00:00:00+05.5:30' is not a valid value for the type xsd:dateTime', } 
--------------------------------------------------------------------------------------------------- 

I am trying to set the value in this datetime field by using following code 
+++++++++++++++++++++++++++++ 
var strReminderDate = document.getElementById("ReminderDateTime").value;//strReminderDate = yyyy/mm/dd

var strTime = document.getElementById("cboReminderDateTime").value //strTime = 00:00(hh:mm)
var remdateArr = new Array(); 
remdateArr = strReminderDate.split("/"); 
var remnewDate = remdateArr[2]+"/"+remdateArr[0]+"/"+remdateArr[1]+" "+strTime+"Z"; 
task.ReminderDateTime = new Date(remnewDate); 
+++++++++++++++++++++++++++++ 

So how do I assign the selected date & time in the ReminderDateTime field 
of Activity Object through javaScript. 

Thanks & Regards

Rameshwar

------------------------------------------------------------------------

Provbinding.QueryOptionsValue = New QueryOptions()

Provbinding.QueryOptionsValue.batchSize = 500

Provbinding.QueryOptionsValue.batchSizeSpecified = True

Dim Qresult As QueryResult

Qresult = Nothing

strSOQL = "SELECT sfLma__Install_Date__c, sfLma__Proxy_User__c FROM sfLma__License__c"

Qresult = Provbinding.query(strSOQL)

Dim enddate() As String

if Qresult.size = 0 Then

Me.TotalLicense = Qresult.records.Length

Return 2

end if

------------------------------------------------------------------------

It return queryresult set with 0 value which is not true as I have 1 record in this object sfLma__License__c

and I faced one more problem in above query when I am using created custom field in a downloaded package custom oobject

it throw err like

NVALID_FIELD:
RecordType.Name,sfLma__Expiration__c, Organization_Id__c,PackageExpiryDate__c
                                      ^
ERROR at Row:1:Column:91
No such column 'Organization_Id__c' on entity 'sfLma__License__c'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
------------------------------------------------------------------------

please anybody suggest me any solution on both of the above problem

  1. Complete date plus hours and minutes:
      YYYY-MM-DDThh:mmTZD (eg 1997-07-16T19:20+01:00)
  2. Complete date plus hours, minutes and seconds:
      YYYY-MM-DDThh:mm:ssTZD (eg 1997-07-16T19:20:30+01:00)
  3. Complete date plus hours, minutes, seconds and a decimal fraction of a
     second
      YYYY-MM-DDThh:mm:ss.sTZD (eg 1997-07-16T19:20:30.45+01:00)

but it gives me error when i try to use above format.

--------------------------------------------------------------------------------------------------- 
Exception : 
{faultcode:'soapenv:Client', faultstring:''2007-12-25T00:00:00+05.5:30' is not a valid value for the type xsd:dateTime', } 
--------------------------------------------------------------------------------------------------- 

I am trying to set the value in this datetime field by using following code 
+++++++++++++++++++++++++++++ 
var strReminderDate = document.getElementById("ReminderDateTime").value;//strReminderDate = yyyy/mm/dd

var strTime = document.getElementById("cboReminderDateTime").value //strTime = 00:00(hh:mm)
var remdateArr = new Array(); 
remdateArr = strReminderDate.split("/"); 
var remnewDate = remdateArr[2]+"/"+remdateArr[0]+"/"+remdateArr[1]+" "+strTime+"Z"; 
task.ReminderDateTime = new Date(remnewDate); 
+++++++++++++++++++++++++++++ 

So how do I assign the selected date & time in the ReminderDateTime field 
of Activity Object through javaScript. 

Thanks & Regards

Rameshwar