Assuming using is required, the following 334 results were found.
-
sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script over this one as this leaves data very difficult to work with: Before: StudentID StudentName...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
AS MyCount FROM DMExtractEmployeeTable e2 LEFT JOIN DMExtractReferenceTable r2 ON e2.CodeType=r2.MapIn -- THIS IS THE LINE CAUSING THE PROBLEM!!! WHERE e2.ID=e1.ID GROUP BY e2.ID,r2.MapIn ) AS MatchingRecordsCount FROM DMExtractEmployeeTable1 e1 LEFT...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
a custom script component for SSIS. How? You can search my site for how to do this in VB or C#. This version is entirely using T-SQL and we're going to use a function so no dynamic SQL (execute, evaluate). Method #1: First version This was my first...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
the same length and the same type of data. Why? The joy of working with the plethora of applications out there result in me using MySQL, Oracle PL/SQL and Transact SQL in my day job. The equivalent functions have to be written up all in the name of...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
package. I have uninstalled and reinstalled once just to make sure everything was OK. Basically after I use my website (using the default Joomla welcome template with NO modifications whatsoever) I start to get the "cannot connect to MYSQL." I contacted...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Basically, I've started using so much more SQL in our new Business Intelligence projects that I've been revising all my scripts to see what SQL I can optimize. One of my systems is a MediaWiki CMS which is used for the official Bournemouth University...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
That's all folks! Hopefully this will save you time. I spent a whole morning following someone else's complicated connection using SQL Server Management Studio and would not recommend anyone to go through the same rubbish. I just took a step back and...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
What's the problem? Enter this as a query in Excel without the parameters and it will work. Set MySQL parameters (using @ - same as T-SQL) and Microsoft Excel 2007 gets confused. Putting it all together Create a SQL query that will return: staffname,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
...do some more here ???... } } Yields -- Note this data matches the brief as we've converted the seconds to time. -- Using MySQL to convert rather than PHP so as not to have to deal with hour changes and the magical 23:00 hour. -- 2nd Note: We use...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Thursday 11:00:00 11:50:00 -- 2013-12-05 Thursday 10:00:00 11:30:00 -- 2013-12-06 Friday 07:00:00 09:00:00 This example is using a small table with very little sample data so do not expect it to reconcile with the requirement example. Note that we have...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
standards. (includes iPhone compatibility and disabled access) Explain balance of scope, quality, time and cost. (focusing on one element means less on another) Search Engine Optimization constraints and standards Domain Registration This is so that you...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
$sum_hours = number_format(((strtotime($this_time_from_sql)-strtotime($this_time_from_sql))/60)/60, 2); // Using the examples above this is doing the following: 2011-03-04 12:00:00 - 2011-03-04 10:00:00 = 2.00 2011-03-08 00:30:00 - 2011-03-08 23:30:00 =...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
OR add the linked stylesheet to the head section of your webpage You then add the icon to your webpage using a CSS reference: My facebook social icon Further examples are on the following site at https://fortawesome.github.io/Font-Awesome/examples/. The...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
the mouse over the "Lanterns" link: » Home / Products / More Lanterns How? Given the following HTML: Home Products lanterns Using CSS only, I have so far achieved the following: /* Specify a blank prefix which is fully transparent */ ul.breadcrumb a...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
to know the machine configuration, these tests ran on a Celeron 1.6GHz processor based laptop with 768 MB of RAM. And I am using PHP 5.1.1 Source: http://hasin.wordpress.com/2007/04/30/c … functions
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
I've decided to put something in here as it took me an age to find out how I could do it. 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)....
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
the script run a MySQL command at the start: SET NAMES 'utf8' Now I need to run this command from within a Joomla! extension using the mysql Joomla! classes, here's how I've used in this script pulling IDs and titles from the a sample table: $db =&...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Hello @World » Hello @World $string_formatted = preg_replace( '/@[a-z]+/i','$0', $string_original); -- METHOD #2: equivalent using preg_match_all $matches = null; preg_match_all('/(?!\b)(@\w+\b)/',$string_original,$matches); foreach ($matches as $match)...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
Joomla Admin Panel option: Cache-mode - Date Uploaded: Mon, 20th Sep 2010 1.0.0 - Created according to brief (automated, using most frequent words) - Added Joomla Admin Panel option: Scan Joomla! articles - Added Joomla Admin Panel option: Scan K2...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
- Enhancement: 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...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *