Assuming have is required, the following 416 results were found.
-
worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows in a table. This is for Oracle PL/SQL....
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
the loop (and at every first entry of a page). I want the script to close the DIV layer at the last entry of each page. So I have a loop Rather crude but it's a FOR loop for those old CMS's running PHP4: for ($this_link_index=1; $this_link_index
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
Strip HTML in MySQLhttps://www.joellipman.com/articles/database/mysql/strip-html-in-mysql.html
putting a note as I have spent ages looking for a solution and getting it to work in my environment. What? Need to be able to omit HTML tags in certain fields of a mySQL database. Why? We are preparing to migrate old content to a new system. From a...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
for activity/session durations and although I usually get MySQL to do the date/time calculations, there are times when we have to do with PHP. This is the shortest way I know to properly convert seconds into total hours, minutes and seconds (taking into...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Drop If Object Existshttps://www.joellipman.com/articles/database/t-sql/drop-if-object-exists.html
Some people have been suggesting you can use "CREATE OR REPLACE... VIEW... FUNCTION" but my SQL Server 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various websites, I...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
the Opensource Content Management System (CMS - phew what a mouthful) Joomla! version 1.6.x to 2.5.x; no wonder customers have difficulty following. How? So it's the field on the XML file /models/forms/whatever.xml which needs the filter=raw attribute,...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
what were the most recent files I modified and uploaded to a site, 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...
- Type: Article
- Author: Joel Lipman
- Category: File Transfer Protocol
- Language: *
-
Add the meta tag they give you to your index.php file (under template folder in effect or your root index.php - wherever you have jdoc:include type="head") Done!
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
So having moved desk from one side of the room to another, I have lost my view of the sea. Oh well, this is where technology has come to the rescue and returned my calming view... Note: I think this is running in British Summer Time (BST) rather than...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
We have an excel spreadsheet which reports against a mySQL database and reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, tasks down the first column, and time spent in the form of...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Just a pretty picture on how hackers have created an infographic of the internet: Source: BitBucket.Org - Internet Census 2012
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
these more than my all-in-one GUI applications. How? Note: we're using the code in a DOS Batch program so our variables have to be prefixed with a double-percent rather than just the one: -- the following loops through directory for any file beginning...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
sure you are using the Joomla user component or a 3rd-party such as Community Builder or K2? If so, you're in trouble as you HAVE to use the joomla admin panel to edit the settings of the 3rd party components.
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
SSRS Border Problemhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-border-problem.html
be misbehaving in SSRS. This note corrects the situation at Design time. This is where you are trying to select a cell to have an outline border but then cells around it without a border. You may find that BIDS or Report Builder (however you're building...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first thing I did was to create the logic: //...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Microsoft SQL Server Reporting Services 2012 Microsoft Visual Studio 2012 Premium Microsoft Windows 7 Enterprise What? So I have a column in an SSRS report which displays a date. Being rather pernickety, I would like a question mark to display if there...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
you can go and retrieve a student/staff (depending on what data your XET feeds off) Bring up STU File > Export... You should have something similar to the following:
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
but I was stumped for a bit until I found it on the a forum: Stack Overflow: Android App Development. How? Basically don't have the following declared more than once in the AndroidManifest.xml
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was written...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
A quick article on if you want to extract the link from some text you have copied off the web and into an MS Excel document. How? Open up a new workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Copy and Paste the Excel user...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF