Assuming create is required, the following 217 results were found.
to the web browser object (Internet Explorer). Here is a simple script for creating one: Code: ; AutoHotkey_L: pwb := ComObjCreate( "InternetExplorer.Application" ) ; Create an IE object pwb.Visible := True ; Make the IE object visible pwb.Navigate(...
' ') AS ActivityID, t.TeamName AS Team, CONCAT(u.Firstname, ' ', u.Lastname) AS StaffName, CASE WEEKDAY(s.DateTimeCreated) WHEN 0 THEN 'Monday' WHEN 1 THEN 'Tuesday' WHEN 2 THEN 'Wednesday' WHEN 3 THEN 'Thursday' WHEN 4 THEN 'Friday' WHEN 5 THEN...
to list all the details. On the last report, the one to execute the stored procedure, we use an account specifically created to run the stored procedure. This requires using 2 data sources in SSRS. A user will specify the student reference in the...
the folder that contains the file (or use full path in path reference). This example assumes the file is in C drive (C:\). Create an empty text file (Type "ECHO > TEMP.TXT") Type "FC /N /LB 300 c:\original_file.txt c:\temp.txt > c:\results_file.txt" The...
7: Open the system registry (Start > Run... > Type "REGEDIT" > OK) Navigate to My Computer\HKEY_CLASSES_ROOT\Folder\shell Create a new key with the action name (eg. "Print Directory Contents To File" - replace spaces with underscores if you are unsure...
- Sorna Kumar IF OBJECT_ID('usp_SearchDB','P') IS NOT NULL DROP PROCEDURE usp_SearchDB GO CREATE PROCEDURE usp_SearchDB @Tablenames VARCHAR(500) ,@SearchStr NVARCHAR(60) ,@GenerateSQLOnly Bit = 0 AS /* Parameters and usage @Tablenames -- Provide a...
run against your database. Step 1 of 2 The following stored procedure will generate the full query to your output panel: CREATE PROCEDURE [usp_GenerateSearchbySoundexQuery] ( @p_SearchString VARCHAR(max), @p_TableSchema VARCHAR(max) ) AS...
available to my client: Copy all files of your main website to another folder. Setup an FTP account to the new folder created in the previous step. Copy the database of your main site to another database. Setup a database user account that can access...
> Preferences > Database > Third Party JDBC Drivers and click on Add Entry... Select the JAR file you downloaded earlier Create a new database connection (or click on the plus sign in the connections tab), select the mySQL tab and complete the login...
your Joomla Admin Panel Navigate to Extensions > Language Manager Click on the “Overrides” label Click on “New” (but don’t create a new one – we’re just checking something) In the right pane, type “COM_USERS_EMAIL_PASSWORD_RESET_BODY” without the quotes...
file as a SQL file (data & structure), Open it using a text editor Modify the order of the columns, for example: -- From CREATE TABLE IF NOT EXISTS `Table1` ( `Column1` int(11) NOT NULL AUTO_INCREMENT, `Column3` int(11) NOT NULL, `Column2` varchar(100)...
despite the fact that I don't change anything. How? Add the following line to the XML installation file: script.php Now create a script.php file in the root folder of your component (ie. same as the XML installation file) Add the install script...
right click on a empty area, click on New > DWORD (32-bit) Value > type NoDrives > Enter. Right click on the DWORD you just created and click on Modify. Type in the drive option hex or decimal number from the list below you want to set as restricted,...
a short batch process but to save time on the different ways of doing this, the example below uses a command prompt to a) create a batch file b) use it to rename the files c) delete the batch file. Open a command prompt: Method #1 Open windows explorer...
{ @Override public void onClick(DialogInterface dialog, int which) { dialog.cancel(); } }); // create and show the alertDialog b.create().show(); } The key mistake I was doing was trying to recalculate which view the main activity item was in.
to: Wordpress CMS v4.1.1 What? A note to myself on how to create a development/test version of a production/live Wordpress CMS site. Why? I have a website sitting at a domain (eg. www.myexample.com), and I want to create an exact copy at a subdomain...
Why? We have a page describing the company that we would want entitled "about" or "about-us" but these were already created along the way and then deleted. The system is still storing the offending menu items somewhere. How? The fix that I use involves...
function duplicates a CRM invoice Parameters: p_InvoiceID (CRM ID of the invoice) Returns: Nothing Author: Joel Lipman Date Created: 2020-03-17 */ // get all field names for the Invoices module via API l_FieldApiNames = List(); r_Fields = invokeurl [...
A very quick article on how to push a multi-select picklist from CRM to Creator. Why? We're trying to create a record in Creator off a button on the CRM Potential/Deal record. The CRM module has a multi-select picklist which will use commas to delimit...
which was not to try to update the form at all but instead to prevent the user from applying for leave in the first place: Create a validation custom function: Login to ZohoPeople as an admin, Go to Settings > Customization > Forms > Leave Under "Form...