Assuming another is required, the following 151 results were found.
-
(RDBMS) where deleting some erroneous rows in one table will cause errors because the existence of those rows 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...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to switch...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? If you're confined to use this product then this is how to do it. Personally, even a web-based app such as...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
= 0; SET PASSWORD for 'youruser' = PASSWORD('yourpassword'); Method #2 (useless fix - unlikely to change anything): Another solution has been advised that you have to tell MySQL WorkBench 6.0 to "use the old authentication protocol": • For versions...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
I don't usually write an article on another site but I came across it and rather than just add it to my weblinks section, I thought I'd give it a little more credit. "Motive is a web design and development agency based in Wellington, New Zealand...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
on an access_token which is generated from an OAuth 2.0 process. I want to display to the user how much time is left before another access token will be generated and how long ago was the last token created. How? So almost pure JS. I'm working out the...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
a record with a value that already exists in the table, you will get an error in which case you could probably add another trigger like above but with BEFORE UPDATE ON my_table_name. Source(s): Online regex tester and debugger: PHP, PCRE, Python, Golang...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache MySQL and PHP (LAMP) setups. Why? A customer wanted to connect their Mobile...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
use parentheses? Then it wouldn't be evaluated as an expression and perhaps Excel will be forced to treat it as a string: Another alternative to round brackets, square brackets! Additional: I have made this work with the parentheses but only after...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
#VALUE! How? The problem is that I have a column which includes the currency symbol as per the following image: I create another column with the symbol omitted using the formula: =SUBSTITUTE(B3, "₱", "") Which leaves the value as a literal string... Now...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
database (inaccessible via other users). How? I want to list 2 methods here. One to create a .sql file of the backup but another to copy the contents to a copy of the database accessible only by root and and this database "backuper" user. For both...
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
workstation upgrade running Windows 7 So another year gone and our workstations running Windows 7 are somewhat lagging when opening too many apps. The recent release of Windows 8 has led to a review of our developer's equipment and the verdict is that...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
I have an Account Name field (the end customer), and a "Distributor" (lookup to the Accounts) as well as a "Reseller" (another lookup to Accounts) field. EITHER the Distributor or Reseller field will be populated but this will be the company the quote...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
from the AutoHotkey forums: AddCommas(val) { val:= RegExReplace(val, "(\d)(?=(?:\d{3})+(?:\.|$))", "$1,") Return val } Another not tested: AddCommas(val) { val:= RegExReplace(val, "(?(?
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
the 90s - MS-DOS v6.22). The example wants to loop through a directory and then loop through the line it finds. Why? I use another technology for automation but sometimes the simpler solution is the one I make for other people to use. Explaining MS-DOS...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
So another quick note as I couldn't find a solution on the forums. This is to hide the reset button on a non-stateless form (state form?). I have posted this on the Zoho forums as well but here goes: Why? Because I can. And because as someone said, a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
A quick reminder on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected item and filtering the options available for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
for the Create Page (Standard), Edit Page (Standard), and Details Page (Standard). My use-case has a requirement that another dropdown called "Order Type" has to be set to "Supplier". My file upload field is called "Order Confirmation". v_OrderType =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
hide a menu (of course the menu could have been created with just one item with no title and positioned at the bottom of another menu; this would look like it was all part of one menu). toubkal wrote: This cannot be done by joomla administration but can...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
on having access to the database of your Joomla website. Method #1: Quickest way I know This is based on if you have another user account (registered or administrator, any) with a password known to you (create a new joomla user if necessary). The gist:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB