... rieve records with foreign characters:
SELECT *
FROM `myTable`
WHERE `myColumn` REGEXP '[^A-Za-z0-9 -()\-.]'
Joomla! Additional
My Joomla website needed the following code to display the ...
What?
An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. ...
... of print), I needed the serial number / product key from my Windows 7 Professional 32-bit operating system. I didn't want to dig through my CD/DVDs to find my original windows 7 disc and no longer have ...
... myself don't put any copyright information on the end product.
I needed a program to:
+ Group all the data by a specified column
+ Generate interactive flash charts
The program was intended ...
What?
I needed to use these in a template I was working on. Font awesome is a brilliant tool for webdevelopers who want icons that can be any size of any color without compromising on image quality ...
... 640x960
res/drawable-xxhdpi 960x1440
res/drawable-xxxhdpi // for launcher only 640dpi
res/drawable-tvdpi 1.33*mdpi // not needed as mdpi or hdpi is used
xlarge screens are at least ...
... mMapView.onResume();// needed to get the map to display immediately
try {
MapsInitializer.initialize(getActivity().getApplicationContext());
} catch (Exception e) ...
... one lookup task:
Changing the lookup to "use results of an SQL query":
Which would code with the joined tables as follows (note that in our case we needed the lookups on the source database which ...
... in our case and could be left as they were. Our last file backup was over a year old but we only needed the core files, a working system, and then we could proceed with a standard Joomla update.
I ...
...
There are various types of data sources used in SSRS so I'm going to try and cover the ones I have used previously and what we needed to get them working.
Custom DataSource
Upload the report ...
... sequence operator in any regular expression where collation is needed. For example, to specify the range from 'a' to 'ch', you can use the following expression:
[a-[.ch.]]
POSIX Character Equivalence ...
... values such as "Flat 4B", "Suite 4899A", "123A Myhouse".
Example #2: Using as a Custom Script Component
The above will work as a SSIS Script task. At work however, we needed to separate ...
... where I needed two derived column tasks, the first checks if the Date was blank and puts a NULL string. The second takes this string and converts it to a date:
-- Assuming EndDate is optional (can ...
... to clear once set.
How?
Well don't quote me on this but I haven't needed to modify this script for any different component. Simply include this file in the fields folder/directory of your component ...
... still in use. I needed a back-to-basics solution and this is the one I have used since my fad of JavaScript 1.2 in the 90s. For broader compatibility, this is my recommended solution.
How?
We're ...
... testing different mootools libraries to see why the Joomla ones weren't working. It may not be right, it may not be the best or optimized order but it works for me and that's pretty much all I needed.
Change ...
Why?
Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the ...
... I had sent all Wiki articles modified since the last export but then needed to send all images that had also been either added/modified since.
How?
Using MySQL, the following query lists the image ...
... which marks rows (identifying when a separator is needed) but this works. Inspired by Namwar Rizvi's blog, I wrapped my SQL query within a common table expression:
--Create CTE
WITH tblDifference AS
(
SELECT ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.