Assuming start is required, the following 98 results were found.
-
2012 What? These were in a solution and I thought I'd note them on my site so I can refer to them more easily. How? Let's start with a function that just converts a string of words delimited by spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable]...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
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 my webhost, and the problem is the number of MYSQL database queries. It goes...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Click on "Connector ODBC" Download a version suitable to your system Install it Setup the ODBC Connection Start > Programs > Administrative Tools > Data Sources (ODBC) Click on the System DSN tab Select "MySQL ODBC 5.1 Driver" > Finish Data Source Name...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
the alias "AS" is optional in MySQL (think it's optional for most SQL forms). I found that to add further 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...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
-- get total number delimeters and add 1 -- add 1 since total separated values are 1 more than the number of delimiters -- start of while loop WHILE(ctr
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Data Activities by employees with start dates and end dates in a mySQL database. Objective User Mon Tue Wed Thu Fri Sat Sun Total --------------- ------- ------- ------- ------- ------- ------- ------- --------- Me 09:00 07:30 08:00 07:00 06:00 00:00...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
left hand panel: In the screen that appears, select your database, specify to export to a Self-Contained File and click on Start Export: Importing Before importing a SQL file, check that nothing in it instructs it to use a specific database (otherwise...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
to ASCII), they weren't what we were looking for. The quick solution was to make 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...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Pancakeshttps://www.joellipman.com/component/content/article/pancakes.html?catid=96&Itemid=165
paper to smear it round before you make each pancake. Now get the pan really hot, then turn the heat down to medium and, to start with, do a test pancake to see if you're using the correct amount of batter. I find 2 tbsp is about right for an 18cm/7in...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
in, the time slot doesn't overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time: req_StartTime = input.Date_Field; req_Duration = 90; bool_doubleBooked=false; for each thisRecord in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
admin interface with your website's style. The following is from http://forum.joomla.org/viewtopic.php?f=32&t=252258&start=0 at this date/time. Can't simply hide an item but can hide a menu (of course the menu could have been created with just one item...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Basically if you've just started using "incognito" mode with the Google Chrome web-browser, this article is just how to switch the quick launch shortcut (next to your start button). All the articles I googled were windows vista so I thought I'd share...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
I started getting this error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.2" is not registered for use on this computer Why? We use a combination of MS Visual Studio 2008, 2010 and 2012. VS2008 for our old SSIS packages...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Services 2008 R2 (SSRS) What do I want? I have a report displaying room bookings. Each row lists the day, date, room name, start/finish times, booking details and the staff contact. I want an empty row to appear between each day in the list, so I have:...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
fond of downloading REG files and running them even if I have checked what it's doing. I'm putting a note here just for me: Start > Run > Regedit > OK Browse to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer Create New...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
Practice makes perfect. Or in my case, any practice is a start. This article serves as a quick note on how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`....
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
requires PHP 5.6 and above. For lower versions you can issue the MySQL commands directly like: mysqli->query("START TRANSACTION") mysqli->query("COMMIT") mysqli->query("ROLLBACK") Important note: Our tables must use an engine that supports transactions...
- Type: Article
- Author: Ike Francis
- Category: MySQL
- Language: en-GB
-
how do I do it using just Microsoft Windows? How? I don't have a clue. Here's what I've got so far: Open a command-prompt (Start > Run > Type COMMAND > OK) Type ftp my_ftp_host (where "my_ftp_host" is the hostname or IP of the server holding my site)...
- Type: Article
- Author: Joel Lipman
- Category: File Transfer Protocol
- Language: *