Assuming your is required, the following 352 results were found.
-
We want to scramble sensitive data that we send to suppliers for support or analysis. With inspiration from: "Obfuscating your SQL Server Data" by John Magnabosco but tweaked for our purposes. NOTE that the following has only ever been run on...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
1988-06-24 3 John Smith 1972-11-17 Looks pretty good, doesn't it? The advantages of this is that you can send this data to your developers and the data types will be correct and maybe they'll resolve issues faster than if they were given scrambled data...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
report. How? Browsing the web for a solution, most suggest using NVL() but this only replaces a NULL value with a string of your choice; and even if you NVL all returned fields, no rows are returned, and not a row of NULL/blank/empty values. Sounds...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
Thank You!https://www.joellipman.com/component/content/article/thank-you.html?catid=50&Itemid=165
Your feedback has been successfully submitted and is much appreciated. This filters through to an account which is checked regularly and you should get a quick response.
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
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 with a...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
of 7:00 will result in 37:00 total. // Our working week starts on Monday 00:00 and ends on Sunday 23:59. Putting it together Your first query should loop through the users list, within the loop run the activities query and replace the string...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
This is an article on how to replace a string 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...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
System Requirements (in case you need to transfer/move to another server) Critical functions used in the system? (do this yourself anyway and use theirs as a guide only) Site Authentication Method(s) (will this need to be rewritten? eg. clear-text...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
{ content:'\00bb'; margin-right:5px; } The last snippet is completely optional if you want to prefix the character » to your breadcrumbs. Unfortunately, this only deals with the opacity transition as the width transition is not a smooth one. If anyone...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
seconds remaining and seconds elapsed in PHP first then passing these as two variables to the below code but you could get your values from anywhere: On page load, the seconds remaining and elapsed are specified JS then takes over and runs the time var...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
This is when using a MySQL query within a PHP script. The process is used often to do a statistics table or top ten chart of your data (eg. movies, music, etc). My aim is to do the following: retrieve data from a table, count the number of times each...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
RLIKE '[[::]]')"; } else { $scorepartstring = implode(' + ', $scoreparts); } // Generate the SQL query for your search engine $filter_sql = " SELECT t.PageID, t.PageTitle, t.PageContent, t.Source, ".$scorepartstring." AS Score FROM (".$live_sub_query.")...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
shady and varies from language to language, I've written this article as a quick reference point. How? Well you use this in your PHP scripts, the examples below are meant to help but feel free to comment if they do not: Surround string (apostrophes)...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
data into an XML array and use the built-in PHP function: "json_encode". How? So here's what I tried and ended up with: If your XML is UTF-8 This is the basic code and will work to fetch some XML and return it in JSON formatting as long as the XML is...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
); $file_xml = simplexml_load_string( utf8_encode( $file_content ) ); // works! DONE! Stop reading any further and tell your boss it was always in hand. Other things I tried but to no avail The solution above was as easy as that. Here are a number of...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
both code and name will be blank. -- possibly use "-1|*LookupFailed*" for the error to come through the XSLT but watch your datatypes Notes: We did not find a way to return the code when the lookup failed, only an alternative message "*LookupFailed*".
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
tomatoes, green onions, and basil. This dish may be served hot or at room temperature. Use store-bought vinaigrette or make your own. Prep Time: 10 minutes Cook Time: 5 minutes Ingredients: 1/4 teaspoon dried garlic powder 1 package (10 ounces) plain...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
thumbnails on the fly or uses local images if they exist. (Note: This retrieves thumbnail from a service and stores this on your server) - Warning: Images will reset if you specify a different image type (default is PNG) (eg. PNG to JPG -> means module...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
permitted server with a single IP address. How? It's likely that you already know how to submit a HTML form to a server via your Mobile application so the following will only document the process of sending data under the server IP address. We're going...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
which had been copied in between the currency amount and the currency symbol. Microsoft could argue this is a problem with your data but the way I see it is it's a space character and TRIM() should work. My solution Include the space (if there is one)...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB