JavaScript AJAX Functions - Revision history

Philip Lacey at 10:34, 7 October 2016

2016-10-07T10:34:45Z

Philip Lacey at 09:24, 20 April 2016

2016-04-20T09:24:27Z

Philip Lacey at 13:10, 18 April 2016

2016-04-18T13:10:02Z

Meabh Landers at 15:32, 5 June 2015

2015-06-05T15:32:02Z

Philip Lacey at 20:43, 9 November 2014

2014-11-09T20:43:10Z

Philip Lacey at 01:52, 22 March 2014

2014-03-22T01:52:35Z

Philip Lacey at 18:56, 19 March 2014

2014-03-19T18:56:08Z

Philip Lacey at 18:52, 19 March 2014

2014-03-19T18:52:33Z

Philip Lacey: Created page with " ~~ New Ajax function - "Populate_AltList" New Ajax function - "LiveSearchTable" New Ajax function - "InsertCount" ~ "Po..."

2014-03-19T18:51:41Z

Created page with " ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ New Ajax function - "Populate_AltList" New Ajax function - "LiveSearchTable" New Ajax function - "InsertCount" ~~~~~~~~~~~~~~~~~~~~~~~~~~~ "Po..."

New page

12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)[[User:Philip Lacey|Philip Lacey]] ([[User talk:Philip Lacey|talk]])

New Ajax function - "Populate_AltList"
New Ajax function - "LiveSearchTable"
New Ajax function - "InsertCount"

12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)~~

"Populate_AltList"

This function allows you retrieve two values from another record in a database and using the two values populate both the text and value of drop down list options limited to 200 records

Worked example

<source lang="javascript" collapse="true" first-line="1">

aryAjax_Settings[0] = 'client_demo'; //Your system name
aryAjax_Settings[1] = ''; //The CMI API Username
aryAjax_Settings[2] = ''; //The CMI API User password
aryAjax_Settings[3] = '1'; //The campaign which contains the product list
aryAjax_Settings[4] = 'strCDA_1_field_0_0'; //The field which contains the limiting / grouping factor
aryAjax_Settings[5] = document.getElementById('strCDA_2_field_0_59').value; //The value to limit the responses by, in this case only yes items
aryAjax_Settings[13] = -1; //Limit responses -1 do not limit
aryAjax_Settings[14] = 'false'; //Draw a table
aryAjax_Settings[15] = 'divWarning'; //Where to draw error messages if any
aryAjax_Settings[16] = 'Populate_AltList'; //Engine to use i.e. Populate

aryAjax_Settings[6] = 'intCDA_1_Id,strCDA_1_field_0_1'; //The field in the other campaign to be returned order = value, text
aryAjax_Settings[12] = 'id,Name of cust'; //Headings for xml troubleshooting
aryAjax_Settings[17] = 'strCDA_2_field_0_60'; //The field in the current campaign into which the products will be inserted.

aryAjax_Settings[22] = document.getElementById('intSystemGenerated_CompanyId').value; //Auto Login - System
aryAjax_Settings[23] = document.getElementById('intSystemGenerated_UserId').value; //Auto Login - User
aryAjax_Settings[24] = document.getElementById('intSystemGenerated_LoginKey').value; //Auto Login - SessionId

fn_Ajax_BE_Process();

</source>
12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)~~

"Populate_AltList"

This function allows you retrieve two values from another record in a database and using the two values populate both the text and value of drop down list options limited to 200 records

Worked example

<source lang="javascript" collapse="true" first-line="1">
aryAjax_Settings[0] = 'client_demo';
aryAjax_Settings[1] = '';
aryAjax_Settings[2] = '';
aryAjax_Settings[3] = 1;
aryAjax_Settings[4] = 'strCDA_1_field_0_0';
aryAjax_Settings[5] = document.getElementById('strCDA_2_field_0_59').value;
aryAjax_Settings[13] = '-1'
aryAjax_Settings[14] = 'true';
aryAjax_Settings[15] = 'HospitalListPrivate';
aryAjax_Settings[6] = 'intCDA_1_Id,strCDA_1_field_0_1,strCDA_1_field_0_3,strCDA_1_field_0_6';
aryAjax_Settings[12] = 'Id,Hospital Name,Post Code,AMH';

aryAjax_Settings[16] = 'Table';
aryAjax_Settings[17] = 'intCDA_1_Id,strCDA_1_field_0_1,strCDA_1_field_0_3,strCDA_1_field_0_6';

aryAjax_Settings[22] = document.getElementById('intSystemGenerated_CompanyId').value; //Auto Login - System
aryAjax_Settings[23] = document.getElementById('intSystemGenerated_UserId').value; //Auto Login - User
aryAjax_Settings[24] = document.getElementById('intSystemGenerated_LoginKey').value; //Auto Login - SessionId
aryAjax_Settings[11] = '../inboundsales/userInbound-details.asp?intCampaign_Id=1&ID=';

fn_Ajax_BE_Process();
</source>
12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)~~

"InsertCount"

This function counts the amount of records in the database chosen that matchs the criteria entered

<source lang="javascript" collapse="true" first-line="1">
aryAjax_Settings[0] = 'client_demo'; //Your system name
aryAjax_Settings[1] = ''; //The CMI API Username
aryAjax_Settings[2] = ''; //The CMI API User password
aryAjax_Settings[3] = '292'; //The campaign which contains the product list
aryAjax_Settings[4] = 'strCDA_292_field_0_5'; //The field which contains the limiting / grouping factor
aryAjax_Settings[5] = document.getElementById('strCDA_495_field_0_2').value;//The value to limit the responses by, in this case only yes items
aryAjax_Settings[13] = -1; //Limit responses -1 do not limit
aryAjax_Settings[14] = 'false'; //Draw a table
aryAjax_Settings[15] = 'divWarning'; //Where to draw error messages if any
aryAjax_Settings[16] = 'InsertCount'; //Engine to use i.e. Populate

aryAjax_Settings[6] = 'intCDA_X_Id'; //The field to count
aryAjax_Settings[12] = 'id,Name'; //Headings for xml troubleshooting
aryAjax_Settings[17] = 'strCDA_495_field_0_7'; //The field in the current campaign into which the products will be inserted.

aryAjax_Settings[22] = document.getElementById('intSystemGenerated_CompanyId').value; //Auto Login - System
aryAjax_Settings[23] = document.getElementById('intSystemGenerated_UserId').value; //Auto Login - User
aryAjax_Settings[24] = document.getElementById('intSystemGenerated_LoginKey').value; //Auto Login - SessionId

fn_Ajax_BE_Process();
</source>

@@ Line 145: / Line 145: @@
 "InsertFromClient"
-This function allows you to transfer user information from the client database into database fields in the form. In the following example, the value of the clients id and first name is transferred into strCDA_883_field_0_1,strCDA_883_field_0_1.
+This function allows you to transfer user information from the client database into database fields in the form. In the following example, the value of the clients id and first name is transferred into strCDA_883_field_0_0,strCDA_883_field_0_1.
 Worked example

@@ Line 4: / Line 4: @@
 * New Ajax function - "InsertCount"
 * New Ajax function - "dbInsertRecord"
@@ Line 139: / Line 140: @@
 </source>
 [[Category:Topic:bxp API]]
 [[Category:Topic:JavaScript]]

@@ Line 3: / Line 3: @@
 * New Ajax function - "LiveSearchTable"
 * New Ajax function - "InsertCount"
@@ Line 96: / Line 97: @@
              fn_Ajax_BE_Process();
 </source>

← Older revision		Revision as of 20:43, 9 November 2014
Line 99:		Line 99:


−	[[Category:~~BEAPI~~:~~InScript JavaScript~~]]	+	[[Category:Topic:bxp API]]
	[[Category:Topic:JavaScript]]		[[Category:Topic:JavaScript]]

← Older revision		Revision as of 01:52, 22 March 2014
Line 97:		Line 97:
	fn_Ajax_BE_Process();		fn_Ajax_BE_Process();
	</source>		</source>
		+
		+
		+	[[Category:BEAPI:InScript JavaScript]]
		+	[[Category:Topic:JavaScript]]

@@ Line 150: / Line 150: @@
 <source lang="javascript" collapse="true" first-line="1">
+if (typeof aryAjax_Settings=='undefined'){
 	aryAjax_Settings[0] 	= 'client_demo';               						//Your system name
 	aryAjax_Settings[1] 	= '';                      								//The CMI API Username
@@ Line 171: / Line 173: @@
 	fn_Ajax_BE_Process();
-−
+}
 </source>

@@ Line 8: / Line 8: @@
 "Populate_AltList"
-	This function allows you retrieve two values from another record in a database and using the two values populate both the text and value of drop down list options limited to 200 		records
+This function allows you retrieve two values from another record in a database and using the two values populate both the text and value of drop down list options limited to 200 records
-	Worked example
+Worked example
 <source lang="javascript" collapse="true" first-line="1">
-	    aryAjax_Settings[0] = 'client_demo';               							//Your system name
+	    aryAjax_Settings[0] = 'client_demo';               						//Your system name
-             aryAjax_Settings[1] = '';                      									//The CMI API Username
+             aryAjax_Settings[1] = '';                      						//The CMI API Username
-             aryAjax_Settings[2] = '';                      									//The CMI API User password
+             aryAjax_Settings[2] = '';                      						//The CMI API User password
-             aryAjax_Settings[3] = '1';                       								//The campaign which contains the product list
+             aryAjax_Settings[3] = '1';                       						//The campaign which contains the product list
-             aryAjax_Settings[4] = 'strCDA_1_field_0_0';      								//The field which contains the limiting / grouping factor
+             aryAjax_Settings[4] = 'strCDA_1_field_0_0';      						//The field which contains the limiting / grouping factor
-             aryAjax_Settings[5] = document.getElementById('strCDA_2_field_0_59').value; 	//The value to limit the responses by, in this case only yes items
+             aryAjax_Settings[5] = document.getElementById('strCDA_2_field_0_59').value; 		//The value to limit the responses by, in this case only yes items
-             aryAjax_Settings[13] = -1;                         								//Limit responses -1 do not limit
+             aryAjax_Settings[13] = -1;                         						//Limit responses -1 do not limit
-             aryAjax_Settings[14] = 'false';                    								//Draw a table
+             aryAjax_Settings[14] = 'false';                    						//Draw a table
-             aryAjax_Settings[15] = 'divWarning';               								//Where to draw error messages if any
+             aryAjax_Settings[15] = 'divWarning';               						//Where to draw error messages if any
-             aryAjax_Settings[16] = 'Populate_AltList';                 						//Engine to use i.e. Populate
+             aryAjax_Settings[16] = 'Populate_AltList';                 					//Engine to use i.e. Populate
-             aryAjax_Settings[6] = 'intCDA_1_Id,strCDA_1_field_0_1';      					//The field in the other campaign to be returned order = value, text
+             aryAjax_Settings[6] = 'intCDA_1_Id,strCDA_1_field_0_1';      				//The field in the other campaign to be returned order = value, text
              aryAjax_Settings[12] = 'id,Name of cust';                       				//Headings for xml troubleshooting
-             aryAjax_Settings[17] = 'strCDA_2_field_0_60';   								//The field in the current campaign into which the products will be inserted.
+             aryAjax_Settings[17] = 'strCDA_2_field_0_60';   						//The field in the current campaign into which the products will be inserted.
-             aryAjax_Settings[22] = document.getElementById('intSystemGenerated_CompanyId').value;	//Auto Login - System
+             aryAjax_Settings[22] = document.getElementById('intSystemGenerated_CompanyId').value;       //Auto Login - System
-			aryAjax_Settings[23] = document.getElementById('intSystemGenerated_UserId').value;			//Auto Login - User
+            aryAjax_Settings[23] = document.getElementById('intSystemGenerated_UserId').value;          //Auto Login - User
-			aryAjax_Settings[24] = document.getElementById('intSystemGenerated_LoginKey').value;		//Auto Login - SessionId
+            aryAjax_Settings[24] = document.getElementById('intSystemGenerated_LoginKey').value;        //Auto Login - SessionId
              fn_Ajax_BE_Process();
 </source>
-:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)12:51, 19 March 2014 (MDT)~~
 "Populate_AltList"
-	This function allows you retrieve two values from another record in a database and using the two values populate both the text and value of drop down list options limited to 200 		records
+This function allows you retrieve two values from another record in a database and using the two values populate both the text and value of drop down list options limited to 200 records
-	Worked example
+Worked example
 <source lang="javascript" collapse="true" first-line="1">
@@ Line 60: / Line 60: @@
 		aryAjax_Settings[17] 		= 'intCDA_1_Id,strCDA_1_field_0_1,strCDA_1_field_0_3,strCDA_1_field_0_6';
-		aryAjax_Settings[22] 		= document.getElementById('intSystemGenerated_CompanyId').value;					//Auto Login - System
+		aryAjax_Settings[22] 		= document.getElementById('intSystemGenerated_CompanyId').value;		//Auto Login - System
-		aryAjax_Settings[23] 		= document.getElementById('intSystemGenerated_UserId').value;						//Auto Login - User
+		aryAjax_Settings[23] 		= document.getElementById('intSystemGenerated_UserId').value;			//Auto Login - User
-		aryAjax_Settings[24] 		= document.getElementById('intSystemGenerated_LoginKey').value;						//Auto Login - SessionId
+		aryAjax_Settings[24] 		= document.getElementById('intSystemGenerated_LoginKey').value;			//Auto Login - SessionId
 		aryAjax_Settings[11] 		= '../inboundsales/userInbound-details.asp?intCampaign_Id=1&ID=';
@@ Line 76: / Line 76: @@
 <source lang="javascript" collapse="true" first-line="1">
-	  aryAjax_Settings[0] = 'client_demo';               							//Your system name
+            aryAjax_Settings[0] = 'client_demo';               						//Your system name
-             aryAjax_Settings[1] = '';                      								//The CMI API Username
+             aryAjax_Settings[1] = '';                      						//The CMI API Username
-             aryAjax_Settings[2] = '';                      								//The CMI API User password
+             aryAjax_Settings[2] = '';                      						//The CMI API User password
-             aryAjax_Settings[3] = '292';                       							//The campaign which contains the product list
+             aryAjax_Settings[3] = '292';                       						//The campaign which contains the product list
-             aryAjax_Settings[4] = 'strCDA_292_field_0_5';      							//The field which contains the limiting / grouping factor
+             aryAjax_Settings[4] = 'strCDA_292_field_0_5';      						//The field which contains the limiting / grouping factor
-             aryAjax_Settings[5] = document.getElementById('strCDA_495_field_0_2').value;//The value to limit the responses by, in this case only yes items
+             aryAjax_Settings[5] = document.getElementById('strCDA_495_field_0_2').value;		//The value to limit the responses by, in this case only yes items
-             aryAjax_Settings[13] = -1;                         							//Limit responses -1 do not limit
+             aryAjax_Settings[13] = -1;                         						//Limit responses -1 do not limit
-             aryAjax_Settings[14] = 'false';                    							//Draw a table
+             aryAjax_Settings[14] = 'false';                    						//Draw a table
-             aryAjax_Settings[15] = 'divWarning';               							//Where to draw error messages if any
+             aryAjax_Settings[15] = 'divWarning';               						//Where to draw error messages if any
-             aryAjax_Settings[16] = 'InsertCount';                 						//Engine to use i.e. Populate
+             aryAjax_Settings[16] = 'InsertCount';                 					//Engine to use i.e. Populate
-             aryAjax_Settings[6] = 'intCDA_X_Id';      									//The field to count
+             aryAjax_Settings[6] = 'intCDA_X_Id';      							//The field to count
              aryAjax_Settings[12] = 'id,Name';                       					//Headings for xml troubleshooting
-             aryAjax_Settings[17] = 'strCDA_495_field_0_7';   							//The field in the current campaign into which the products will be inserted.
+             aryAjax_Settings[17] = 'strCDA_495_field_0_7';   						//The field in the current campaign into which the products will be inserted.
              aryAjax_Settings[22] = document.getElementById('intSystemGenerated_CompanyId').value;	//Auto Login - System
-			aryAjax_Settings[23] = document.getElementById('intSystemGenerated_UserId').value;		//Auto Login - User
+            aryAjax_Settings[23] = document.getElementById('intSystemGenerated_UserId').value;		//Auto Login - User
-			aryAjax_Settings[24] = document.getElementById('intSystemGenerated_LoginKey').value;	//Auto Login - SessionId
+            aryAjax_Settings[24] = document.getElementById('intSystemGenerated_LoginKey').value;	//Auto Login - SessionId
              fn_Ajax_BE_Process();
 </source>