Assuming like is required, the following 180 results were found.
-
is not a silver bullet. It was created to take away the hours I know I would spend without it. This is not an upgrade; it is likely that your client may reconsider the template they are using or may want to add new 3rd-party components. If asked: "how...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
-- Assets SET @maxAssetContentID = (SELECT COUNT(*) FROM `v34_db`.`v34_assets` WHERE `name` LIKE 'com_content.article.%'); SET @nextAssetContentID = @maxAssetContentID; SET @assetParentID = (SELECT `id` FROM `v34_db`.`v34_assets` WHERE `name` LIKE...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
rb.[Room] , rb.[BookingNotes] FROM roombookings rb WHERE rb.[GivenDate] BETWEEN @GivenDate AND @ToDate AND rb.[ContactName] LIKE '%@GivenName%' -- WARNING: 0 matching rows This returns nothing. Took me a while to figure why but it's the parameter that's...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
space allocated on your website and RocketTheme templates would create a style that was hard to customize. Remository Really liked this and used for the best of 2 years. But 1000 downloads in 10 days caused it to crash my Joomla! website. It was very...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on my computer" and me replying "why would you want to do that?". Anyway, I was looking for...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
ON (' . $db->quoteName('u.id') . ' = ' . $db->quoteName('p.user_id') . ')') $query->where($db->quoteName('u.real_name') . ' LIKE '. $db->quote('\'%smith%\'')); $query->order('u.real_name ASC'); // Reset the query using our new query object...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
of ZohoBooks but realised the word "Incoming" is the operative word as the response cannot be configured in ZohoBooks like we need to in this solution; namely the webhook response needs to have a header and a body. The 2nd caveat is a concern around...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Regular Expressions in SQLhttps://joellipman.com/articles/database/regular-expressions-in-sql.html
Looking for abnormal data, note the circumflex to exclude the clean alphanumeric rows: SELECT * FROM STUDENTS WHERE REGEXP_LIKE(S_SURNAME, '[^a-zA-Z0-9]') -- returns all rows where the student surname contains non-alphanumeric characters -- eg. O'Brien...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
picture of whatever that section of the screen is displaying. I made this program stay on top of all the other windows, much like the start menu/task bar (only this program is beneath the task bar). It's currently set to 15 seconds between each photo...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
@stringtoFind, @stringtoReplaceWith) AS newText, `content_column` as oldText FROM `MYTABLE_content` WHERE `content_column` LIKE CONCAT('%',@stringtoFind,'%') -- yields id title OldFoundInOld NewFoundInOld OldFoundInNew newText oldText 1 Article 1 yes no...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Studio (BIDS) Visual Studio 2008 Microsoft Windows 7 Microsoft .NET Framework 3.5 Microsoft Visual C# 2008 What? So like lots of people on the net, I've been given a datasource with names and addresses all in UPPERCASE. Initially, no one seemed bothered...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
TOP 100 Reference, Forenames, Surname, DOB FROM PersonsTable WHERE (Reference = @GivenRef OR @GivenRef ='') AND (Forenames LIKE @GivenForenames + '%' OR @GivenForenames = '') AND (Surname LIKE @GivenSurname OR @GivenSurname = '') AND...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
-alias androiddebugkey - storepass android -keypass android (replace with your windows login) Should be something like: To get the App SHA1 code: You have to add the correct SHA1 to the Google APIs console for release purposes. This is the SHA1 from the...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
(ZET) via command line interface (CLI) In the terminal, type: npm install –g zoho-extension-toolkit If you get errors like “Missing write access to/usr/local/lib/node_modules” then type the following instead: sudo npm install –g zoho-extension-toolkit...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
name "Grouping" in a list item column. The standard code you used to use even for REST API v2.0 would have been something like the following: // // init l_CrmLineItems = List(); // // some sample values v_CrmProductID = "123456789012345678"; // // build...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
of code. For any other field that needs to update this preview, I tell it to update the "Audit_Change" field with something like: input.Audit_Change = "Title: " + input.Title; Method #1: (do not use) Previously I have tried adding a field called...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
is a posted (and sanitized) variable SET @ThisSearch:="Brains"; SELECT columnID, columnFullName, CASE WHEN columnFirstName LIKE @ThisSearch THEN 20 WHEN columnFullName LIKE @ThisSearch THEN 10 WHEN columnLastName LIKE @ThisSearch THEN 10 WHEN...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
it to the styles folder. Now return to your phpBB3 Administration Control Panel (ACP), which should be located at something like http://www.mysite.com/phpBB3/adm/. Select the "Styles" tab. You should see a row with "Affinity" at the bottom. Click on...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
To Full Name] ,_SMDBA_.Incident.[Incident Type] FROM _SMDBA_.Incident WHERE _SMDBA_.Incident.[Group Name] LIKE @GroupName Based on the assumption that "Series1" displays on my chart because of values that are not matched (not assigned to a current...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
= @weekNumber AND tt.[SiteId] = @siteId AND tt.[Status] 3 -- Remove cancelled bookings AND upper(sd.[Descrip]) not like 'ADDITIONAL TIMETABLE%' ORDER BY Date ASC, Room ASC, tt.[StartTime] ASC, tt.[FinishTime] ASC I even separated off the @GivenDate and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB