Assuming next is required, the following 106 results were found.
-
to the name of your new Joomla 3.0 database (don't change the table prefix for the new Joomla and instead do this as the next step). Rename any instance of "my_new_database.my_prefix_" to the name of your new Joomla 3.0 database (note that we're...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
act as a confirmation page (already holds the parameter passed to it from the previous page and that it will pass to the next page which executes the stored procedure) So this is the 3rd page which will actually execute our stored procedure. Here we...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
'nvarchar', 'text', 'ntext') AND TABLE_SCHEMA='dbo' ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME; OPEN MyCursor FETCH NEXT FROM MyCursor INTO @SqlToExecute WHILE @@FETCH_STATUS = 0 BEGIN PRINT ' union all ' + @SqlToExecute; FETCH NEXT FROM MyCursor...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
MIN(t1.column_source) AS Source, COUNT(t1.column_value) AS Count FROM ( '; -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @SqlToExecute WHILE @@FETCH_STATUS = 0 BEGIN IF @myCounter=0 PRINT @SqlToExecute; ELSE PRINT ' union all ' +...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
(myValue varchar(max), myColumn varchar(max), myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @ColToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + LTRIM(@ColToProcess) + ' COLLATE ' +...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
#CountRecordsPerTablePerCol (myValue int, myTable varchar(max), myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @TableToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + CAST(@p_Value AS...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
@UpdateSqlStatement, N'@UpdateCursor CURSOR OUTPUT', @UpdateCursor OUTPUT SELECT @NumberLeft = SUM(1) FROM #Scramble FETCH NEXT FROM @UpdateCursor INTO @Data WHILE @@FETCH_STATUS = 0 BEGIN -- OPEN RandomID SET @random = CEILING(RAND()*...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
// tranformation exceptions: McDonalds, O'Reilly, D'Artagnan, I'Annon // Match with case a multi-character combo, append the next letter in UPPERCASE and then append the remainder. // NOTE: This will work with "MacDonalds" as well (specify "Mac") but...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
= ''; IF (UPPER(@Text)=@Text Collate Latin1_General_CS_AI) BEGIN -- cycle through each character, -- if non-alpha, uppercase next alpha character. -- if alpha then lowercase subsequent alphas. -- NON-ALPHA EXCEPTIONS ADDED TO REGEXP (eg. apostrophe)...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
in HTML where the first page is a cover page (background image filling the page with a logo floating at the centre) and the next page has a table which is of variable length. Fine when the table was short and didn't have many rows. But the client will...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
%v_ThisWidth%, %v_ThisHeight% And switching desktop? Well considering you cycle (can't jump to) to the previous or next desktop by holding down the Control (CTRL) and Windows Key then the left or right arrow keys as appropriate... the code in AutoHotkey...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
tomorrow's, and the day after's but it has to skip Sundays. Why? Wanting to create a schedule for availability over the next few days which needs to dynamically change. I am aware of the function .addBusinessDay() but that excludes Saturdays which my...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
it will have in Zoho Analytics, a description and then enter in the FTP details as per your configuration, then click on "Next": Step 2 of 2: specify whether first row are headers/column/field names. If necessary, specify the format of the data per...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
As mentioned, we're going to update several fields called: Number of Candidates This Graduation Year Number of Candidates Next Graduation Year Candidates Graduated in the Past Candidates Graduating in the Future Total Number of Candidates I'll flesh...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
of the month" }, { "payment_terms_id": "", "is_mandatory": true, "payment_terms": -3, "payment_terms_label": "Due end of next month" } ] } } Usage: This is just a snippet of usage and obviously not the whole function to generate an invoice. Please...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
name that your ZohoDesk will sync with. Select Data Sources in the left sidebar Add Data Sources > Select Zoho Desk Do "Next" and select the Zoho Desk Portal Ensure that "Tickets" is selected (I'd tick most of the fields this contains) Create a data...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Select the Email field as the primary field to control this rule Set the condition that the email "is empty" > click on the "Next" button Set Mandatory FIelds > and select "Mobile" Repeat these steps to add another rule: Call it "If Mobile Blank then...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
~/.zshrc RuntimeError: Numpy is not available: Which Python Whisper Uses head -n 1 $(which whisper) Note the result for the next command, eg. #!/Library/Developer/CommandLineTools/usr/bin/python3 Install NumPy for That Exact Python...
- Type: Article
- Author: Joel Lipman
- Category: Apple
- Language: *
-
Go to Banking > Selet the active account (click into it) and click the gear icon in the top right of this page (not the one next to your profile as that's global settings but the one next to the "Import Statement" button). There are a couple of options...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Page is "Edit Page (Standard)" Module is "Products" Layout is "Standard" Event Type is "Page Event" Event is "onLoad" Click "Next" Method 1 This includes a function which counts the number of decimals. I didn't need to use this method for my client;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF