Assuming after is required, the following 130 results were found.
-
transform) // debugString = string.Format("ProcessInput - SUCCESSFUL Transform: Column: {0} - Value Before: {1} - Value After: {2}", x, inputValue, outputValue); debugString = ""; // blanking because I only need to know when it fails // set input value...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
fastest browser I have. Here are some ways to do this: Method: MySQL ALTER TABLE table_name MODIFY COLUMN misplaced_column AFTER other_column; NOTE that annoyingly the column doesn't retain the default properties it had before the move so I guess this...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
is stored in another table, how do we delete from all the related tables as well? How? You need to refer to the tables just after the DELETE clause (so instead of DELETE FROM myTable WHERE myValue=givenValue): DELETE s, ssf, sst FROM `Session` s LEFT...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
all the rows get re-adjusted to fit the data and lose that consistency. A Workaround: New line inserted before and after So this is where I am at the moment without VBCode and other suggestions. Instead I add a newline in front of and after the smallest...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165
a violation is, you may be issued a warning first Muting - Muting for 10 days Temporary ban - People who cause more problems after being muted for 10 days will be banned for a month, and for 2 months for the next offense. Permanent ban - At this point,...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
and (b) permanently, if the copyright holder fails to notify you of the violation by some reasonable means prior to 60 days after the cessation. Moreover, your license from a particular copyright holder is reinstated permanently if the copyright holder...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
page isn't loaded more than 100,000 times a month. I don't understand, one website visitor can generate 1000 hits, so thereafter I have to pay every time someone sees that picture through my site; when I could just go to each website and press the print...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
get away with generating a million images for FREE! Error on first install? If you get something like the following error after upgrading/installing this module: Warning: in_array() [function.in-array]: Wrong datatype for second argument in...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
as I have other templates that work fine. How? The error is one of those that you wouldn't consider relevant in this case, after all, all styling was removed... Here are two screenshots to demonstrate the issue: Screenshot #1: This screenshot is of the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
block; width: 200%; margin-left: -100%; transition: margin 0.3s ease-in 0s; } .onoffswitch-inner:before, .onoffswitch-inner:after { display: block; float: left; width: 50%; height: 30px; padding: 0; line-height: 30px; font-size: 14px; color: white;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
we need the code to search for other requests with these dates, we're going to use a range of 1 month before and 1 month after the requested date (so this works as long as no one books longer than a month in one go - increase the submonth/addmonth...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
when the form was loaded. Then I would tell Audit_Change to only trigger the workflow if it had waited about 5 seconds till after this datetime to allow auto-updates to happen. This method is fine for 1 or 2 fields and if your workflows only trigger...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
level, create another folder called "Profile Photos". Navigate into the "_Global" folder and note the last hash in the URL (after "/folders/") For this function, I have a connection called "zworkdrive" which has the scopes as specified in the function...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Settings" Click on any page in the left sidebar (eg. Plan Details), your Org ID is in the URL as the last number after the slash (eg. "20012345678") Note this down for later use Create a connection to Zoho Analytics: ZohoDesk > Setup > Developer Space >...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
= "https://analyticsapi.zoho.com"; // // to get workspace ID, look at the URL in ZohoAnalytics and take the number straight after the word "workspace/" v_WorkspaceID = "12345000001234567"; // // to get the Analytics Org ID, login to Zoho Analytics,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
span label span{width:14px;height:14px;margin-right:2px;border:1px solid #eee !important;}"; // create a new row after every 10 boxes (1 box = choice-table-row + choice-table-cell + choice-table-row = 3 divs) v_CssStyle = v_CssStyle + ".zc-Color_Picker...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
website. Access the page from a browser and you should get all your users listed... For security reasons, delete the file after you have used it. IT IS A SERIOUSLY BAD IDEA TO LEAVE THIS FILE ON YOUR WEBSITE FOR ANYONE TO ACCESS!!! DELETE IT AFTER USE.
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
-- First let us copy over all the weblinks, we will deal with categories -- and assets afterwards: -- ********************************************************************* -- Clear the weblinks table DELETE FROM `v34_db`.`v34_weblinks`; ALTER TABLE...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
sense as I need to parse the string to extrapolate the date, month and year. How? I used two "Derived Column" tasks for this after giving up with a "Data Conversion" task. I then parse the date, month and year out using SUBSTRING: -- Assuming...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
that executes a query at report execution time and populates/assigns the local variable ID (@StudentReference) everytime. So after an hour or so I came across "Cascading Parameters" (http://technet.microsoft.com/en-us/library/dd255197.aspx). Maybe the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB