Assuming instead is required, the following 103 results were found.
-
I could use SWITCH to do this in an MDX query but I spent over an hour before I gave up trying to get SWITCH to work. Instead I cheated and got the ordinal in the Transact-SQL query: CASE DATEPART(DAY, [MyDateValue]) WHEN 1 THEN 'st' WHEN 21 THEN 'st'...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
that I've asked it to return the full date of the parameter, this is because I will format it via the text-box properties instead of getting the expression to return it exactly (there seem to be issues with this - error textbox1[0]...). You will need...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it will be applied to names and addresses as well as job titles and departments. Why? We wanted a T-SQL version despite...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
all I need in this case. In my example, I need to submit an Active Directory (AD) username and receive a student ID number instead, all with the aim to improve performance on some SSRS queries which accept either an ID number or an AD name as user...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
we simply help support them. You say less than ideal, I say realistic. Quit complaining about processes and management and instead prove your worth. I'm good at what I do because I make do with what I have available and I've yet to fail in coming up...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
tables, simply start with another "UNION ALL" clause with a note to give the 3rd table a different alias to the 2nd (so "C" instead of "B"): SELECT title, intro FROM ( SELECT `title`, `introtext` intro FROM `jos_content` a WHERE a.state=1 UNION ALL...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
rather than PHP so as not to have to deal with hour changes and the magical 23:00 hour. -- 2nd Note: We use "WEEKDAY" instead of "DAYOFWEEK" as our working week starts on Monday (Mon=0, Tue=1, Sun=6). User Mon Tue Wed Thu Fri Sat Sun Total Days...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
has a height of 2000 pixels, the iframe gets aligned to the top of the parent... How? We're going to use a touch of CSS and instead of determining heights and alignment with JS. The following code will work with DIV layers but in this case, also works...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
"Name:" and the color back to grey. If it isn't, then leave as is and ensure the color is still black. Additional Note that instead of just saying if this value equals "Name:" I've added some code to trim the values. If the user types two spaces, then...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: en-GB
-
relevant? (when it isn't, the sound matches and then it's a typo on the sound so it matches words that are vaguely similar instead of spot on). $didyoumean_words_array=array(); foreach ($terms as $term) { $term=strtolower($term); # get closest word by...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
CURLOPT_RETURNTRANSFER, TRUE); // TRUE to return the transfer as a string of the return value of curl_exec() instead of outputting it out directly. // store the response $ch_result = curl_exec($ch); // close connection curl_close($ch); // convert the...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
When we copy and paste their content into our website, our webpages display a question mark inside a diamond shape instead of the foreign character. How does it happen? Have I tried the other solutions on the web? I have tried adding the following to my...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
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 I have: no export format 5826 -- What I could have:...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
Date is now "created" date. - Enhancement: Included span tags for individual elements. - Enhancement: Using div layers instead of tables. - Fixed Bug: Switched CSS ID tag to CLASS for W3C Validation. - Fixed Bug: Now allows description inline with popup...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
to a company then 2) getting the properties for each agency: Other Methods Here's the cURL I couldn't get working. Instead I used Apimo's documentation with file_get_contents. Just storing this in case. // cURL With SSL via method GET: FAIL $header =...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
approved. Follow steps 1 – 5 as stated under Finding your Kindle email address. However, click on Preferences this time, instead of Devices. Scroll down and select the Personal Document Settings Scroll down again and select the Approved Personal...
- Type: Article
- Author: Joel Lipman
- Category: Kindle
- Language: *
-
pretty old code and not wanting to cause offence, it isn't the JavaScript style or chain I like which appends the functions instead and is clearer for me personally to understand: // I want 010 v_NextIndex = 10; // yields 10 v_NextIndexStr =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
OR the same category. The setting is in your Joomla > Module Manager > Banner... What I do is I don't select a client but instead just select a category. Set it to only display 1 banner at a time. If you want other categories to display, consider...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
some terrible 3rd-party SEF plugins to correct the situation but when I moved my test site to live at www.joellipman.com (instead of being on http://test1.joellipman.com), I found I could disable the third-party SEF extension and enable my Joomla SEF...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just specifying the one day. If the second parameter (ToDate) is the same as the first (FromDate), then the range is for...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *