... surname does NOT contain a letter or number
-- eg. O'Brien will NOT be returned as it contains letters
MySQL
And my favorite. Note the circumflex as we are still excluding non-alphanumeric ...
... so do not expect it to reconcile with the requirement example. Note that we have two events on the Thursday.
A few things we have to deal with still:
We have lost the rows with days that have no ...
... work.
My solution
Include the space (if there is one) in the substitute formula:
=SUBSTITUTE(B3, " ₱", "")
The resulting value will still need to be multiplied by 1 to convert to a number ...
... 00204
003 00305
Almost There!
So we're using the ROW_NUMBER() functionality with an ORDER BY which seems to work somewhat. But using the code above still produces an error ...
... could stop here as Stage 1 substantially improves your Joomla search, but the above files are enough to start adding your own code to make the "relevance" ordering more relevant.
... ok still to come ...
... "10" comes before "8" and it does but just to check, let me pad the 8 with the prefixing zero:
Annoyingly "10" still comes before "08" so maybe I'm barking up the wrong tree. If I padded ...
A replacement for Joes Revolver Maps?
So I recently came across the Chrome Experiments WebGL Globe which I think is beautiful; here's a screenshot of what I envisaged though:
Demo
It's still ...
... tags:
Use PHP or JavaScript (avoiding Framework conflicts)
You select what words are highlighted what color.
Uses separate CSS file for overall look.
This is still in development!
Currently ...
... the options in the connection manager will let you skip rows and specify column datatypes. You don't get that with Excel but you can still control the data range.
How?
My example is that I have ...
... column will have a string of 8 characters long in the format DDMMYYYY and on other rows, this is blank with spaces instead, I still get the Error: The conditional operation failed.
-- I've been given ...
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.