Assuming have is required, the following 417 results were found.
-
4294967295 characters (4GB of text) Length of string + 4 bytes String Enum ('value','value2',...) String object that can have only one set of allowed values 1 or 2 bytes String Set ('value','value2',...) String object that can have one or many values of...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
against this database because it involves linking a lot of tables and outputting... just articles and their titles. I have another table holding the audit trail of content approvers on the system. Approvers can e-sign an article (approving it) by...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
2012) The performance of the previous version of this query was pretty abysmal and worse if you want to list users who have no associated activities (outer join but all-in-one query). The DBA responsible for the system asked me to look at ways of...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year for...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
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 these back. How? For demo purposes, I'm...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
only see the users screen. Three Webdevelopers phone in to say their computers can't view a website properly "Can someone have a look at our computers because we recently received the new corporate template for our website and it's not displaying...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
that cover the same topic, but as this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted any person visiting the old domain to be...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
smoothly. Why? At time of print, I couldn't find any clear example demonstrating this so here's my take on it: What I have » Home / Products / Lanterns What I want (on mouseover) // if I hover the mouse over the "Home" link: » Return to Home / Products...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
you hate sites that do not have a search feature? I do. I think it defeats the purpose of cramming information endlessly in cyberspace. So we want to give a search engine to our users. This sounds really simple, we could try: $search_term_esc =...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
// [OPTIONAL] convert it to an array // $array = json_decode($json_result,TRUE); // yields......... Without cURL You'll have seen this all over the Internet as the accepted solution... Doesn't work for me because I'm using cURL but it's a first point...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- What I want: Why? Outputting from SITS:Vision to our staging environment, the application would only output blank values...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
each step of the development as the error messages were somewhat vague. I thought I'd quickly write this article so I don't have to spend so much time on it again. Note that the below examples, demonstrate a script on a Non-SSL-Enabled host. How?...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are in the old column and which ones are new... Why? Consider the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
to each row and increment based on how you copy the formula to other cells. You should end up with something like this (I have added some conditional formatting which colors the cells red or green for demonstration purposes): If you understand this...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
passwords > Show All. This includes a feature to search through your saved password information as well... You can opt to have these protected by a 'Master Password' but by default and without this, Firefox will display them all at a click of a button....
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
produce. Even with most services this nearly always guarantees a happy customer. "So this is all I could fix in the time I have, all your issues have been dealt with and I also did this..." "So this is what I've quickly put together for demo purposes."
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
guy goes to a bar and is served by a robot bartender. The robot says, "What'll you have?" and the guy says, "A martini." He then gets the best martini he's ever tasted. The robot says, "What's your IQ?" The guy says, "167." The robot proceeds to chat...
- Type: Article
- Author: Joel Lipman
- Category: Jokes
- Language: *
-
client script to set the Account field on the Quote from a lookup field on the Deal record. Why? The use-case here is that I have a client who is a supplier. The opportunity (aka Deal) will be in the end customer's name so it is their name in the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
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 "reset" button is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
at this date/time. Can't simply hide an item but can 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:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *