Assuming used is required, the following 202 results were found.
-
Usr 1964-08-08 Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Used to reference RAND with in a function CREATE VIEW dbo.vwRandom AS SELECT RAND() as RandomValue; GO The Function Again you...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
on SQL Server. -- Drop the view if it already exists IF OBJECT_ID ('vwRandom', 'V') IS NOT NULL DROP VIEW vwRandom ; GO -- Used to reference RAND within a function CREATE VIEW vwRandom AS SELECT RAND() as RandomValue; GO The Function -- Drop the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
the error happened less... I then went through the menus and installation screen to get rid of anything that was not visibly used on the website. The website was working fine and I was able resume my click-happy habits. It's a given that in my test,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
the developer wrote a system he felt would last the rest of his PhD degree, it's a shame he started in his last year. He used functions to mktime and simulate the dates. A function goes in with a normal calendar date and returns an academic week number...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
the first letter of each word, and is pronounced as a series of individual letters. For example HTML (the computer language used to author webpages), is an initialism of HyperText Markup Language, and is pronounced: “H-T-M-L”. (Um... think I just call...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
that still needs addressing?) 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...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
on it again. Note that the below examples, demonstrate a script on a Non-SSL-Enabled host. How? Previously, I would have used cURL but for some reason, I couldn't get the configuration right. After several days... I tried the example as per the Apimo...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
in the style of... Note that these are almost definitely infringing on copyright/intellectual property and should not be used in a commercial setting. Afro Samurai (Takashi Okazaki) Akira (Katsuhiro Otomo) Batman Charlie Brown (Charles Schulz) the Dark...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
you resize the app. Syntax: GuiSize: GuiControl, MoveDraw, MainRedBackground, w%A_GuiWidth% h%A_GuiHeight% Return If I just used GuiControl, Move,... then this would be as above but if you are using images, then you will get problems with the image...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
on a workstation's C drive. There are other programs about and even some built-in to MS Windows that could potentially be used. This is a quick article on how to write an AutoHotkey program to simply return the folders in the drive and display the size...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
will be redundant if Google ever update their Chrome browser to list the multiple profiles in alphabetical order like it used to be... but to date they have not. So I made a program that lists the profiles in alphabetical order and can be double-clicked...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
field is provided (defaults to A_ScriptDir) to specify what folder to scan for files. The 3rd button simply reloads the app (used mostly for testing/development). Lastly, a listview that has 2 columns: the 1st lists the files in that directory, the 2nd...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
Google search every solution. As an IT developer, I often get told I may win the lottery or get run over by a bus, so I am used to needing a backup plan. My aim is always to hand over the project so that I am no longer required. Isn't that when we know...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
and generate a chart from the data. What my program does is convert all the data into a settings and data file that can be used by the charting system AMCharts.com. AMCharts.com provide a flash-based interactive chart which you can zoom in and out of,...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
as well as Opera 10+). Administrators or Super Users to generate thumbnails? The authorized group to generate new thumbnails USED TO BE Administrators or Super Admins/Users. Due to several requests, the module has been modified to accommodate any...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
host names on double-click without causing network traffic (tried netstat. NTS: try this again with dll calling) Program used to open port (still need to distinguish between out/in) detect bytes instead of kilobytes GUI Move Icon Disallow program...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Values (CSV) list of all data from an Advanced Web Statistics [AwStats] v7.0 (build 1.971) report. The data file is used by my infographic script which allowed quicker reports then scanning entire website visitor logs. No installation and USB portable....
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
client-side page. The tool analyzes any input on-the-fly without sending or receiving data to a server. The page used to be a part of a Password Security System I wrote back in 2008 and I missed the analysis capability so I have restored it on my...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Wikipedia) Known UK military bases (Royal Marines, Royal Navy Air Service, Royal Air Force, Remote Radar Heads) Some "disused" airfields (former military) Specified nuclear power plants Specified historical buildings Legend: Yellow: Restricted Area:...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *