Assuming where is required, the following 228 results were found.
-
{ $this_value=trim($row['column1']); $this_value_num=mysql_num_rows(mysql_query("SELECT column1 FROM table1 WHERE column1='$this_value'")); if (($this_value!="") && ($this_value_num>5)) { $this_value_num=sprintf("%010d",$this_value_num);...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
'utf8'"; $db->setQuery( $sql_utf8 ); $temp_result = $db->query(); $sql = 'SELECT '.$modulescancontentsql.' FROM #__content WHERE state=1'; $db->setQuery( $sql ); $rows = $db->loadObjectList(); foreach( $rows as $row ) { $id = $row->id; $title =...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
other fix (for Croatian characters and Western languages): // insert after database connection and prior to database query (where $db_conn is your mysqli connection) mysqli_set_charset($db_conn,"utf8"); // decode and display in HTML-safe $my_description...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Staging environment. Why? Let's take the country of birth of a person as an example as it is expected to be a long list and where just using the parameter &S is not workable. Instead I want to use &G[] and get both the code and the lookup value: -- What...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
screens. Check/ensure the "In Use?" is ticked. Store/save your SMG Setting up the DataChange Out Rule (DOR) This is where we can link to other entities and create the rules on changes to the relevant fields Run DOR from the menu system Enter a DOR code...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
CMS. - All params prefixed with JQW to avoid conflicts. - Parameter: Use preview images (name format is LinkID.fileExtension where LinkID is the 'id' of the weblink). - Parameter: Display preview images inline or on mouseover. - Parameter: Number of...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
projects down the left (in the first column) and the days of the week along the top. Why? The excel report would hit a bug where it couldn't work out that 10 (Wednesday) happened after 8 (Monday). How? See the following screenshot and note the dates for...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
should be supported. I tend to use Excel to reduce the decimal point to only 7 decimal places (for importing to a database where DECIMAL(10,7) ). Merging the lot If B1 contains the coordinates and there is a space after the first letter (N or S): // for...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
The formula to paste in column B of Sheet1 is as follows: =SUMPRODUCT(--ISNUMBER(SEARCH(Sheet2!$A$1:$A$4,Sheet1!A1)))>0 Where: SumProduct( is a function to multiply two ranges together (must be the same size) and return the total of these results. -- is...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible via...
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
use here, so several challenges: No FPV: Keep the quadcopter pointed at the car. I treat it like a First-Person-Shooter game where I strafe right moving forwards in an arc to go round corners. Then I learnt there were so many different angles and routes...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *
-
to another printer? Can you print from any other applications to that printer? When did you last print successfully? How/where to advertise: Word of mouth Yellow pages Local business directories Local newspapers Local colleges/universities Local...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
Get business cards made. Pass them out where ever you go. Don’t rent a storefront yet. Go to people’s businesses/homes and do the repairs there. Ask local businesses if you can post a flyer in their window or on their cash wrap. Initially, charge a...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
CRM Ultimate To do this, we will need a specific workflow that picks up the change in status at the sales order level and where the sales order has been completed (fulfilled or invoiced). This will then see if any other opportunities were won against...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Add, Picture, x600 y70 w90 h90 vSearchButton gSearch, %A_ScriptDir%\images\program\search_button.png Add the input field where you type the text: Gui, Add, Edit, x55 y95 r1 w550 vSearchTextInput, Search... Add the submit button with a hidden attribute:...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
So I thought I'd write an article to help me resolve the particular issue where the organization details and the header of the product line items table would display on the first page, the product line items would then print on the second page, with the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
Frontpage Item Orderinghttps://www.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html
Having trouble ordering your frontpage articles? After re-ordering articles wondering where it was taking the order it puts the articles in the front page (or landing page) was confusing me. The quick answer is that it is within the menu manager > main...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
to you (create a new joomla user if necessary). The gist: Login to your Joomla database Go to the #__users database table (where #_ is the prefix to your joomla tables) Find the column password and the row of your known user and Copy the text there Find...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
404 Component not found. Just because I'm doing something like this: How? I found that this was only affecting my subdomains where this template was installed. I installed some terrible 3rd-party SEF plugins to correct the situation but when I moved my...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB