Assuming like is required, the following 183 results were found.
-
cross. On the system that used to do this, we could use the HTML attribute "OnError" to load an alternative image. We would like something similar for SSRS. Solution #2: Alternative image if file does not exist More of a workaround than a solution but...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
so there are more fun things to do out there. If you're the type of AutoHotkey programmer that doesn't like having to use the command prompt to write to an extra text file which your program has to read, then this is for you. DllCall will usually run...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
is the one to save as a PDF file and sends it to all customers. Training these people in adjusting row height would be like a magician revealing the secrets to his tricks... no it wasn't really, time was the issue. Additional conditions Direct access to...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
sites. I started with a Joomla 1.5 as the move from Joomla 1.6 or greater is a lot easier since it uses nested categories like Wordpress. There are lots of commercial migrators out there and they all seem to have this problem. I'm really keen not to ask...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
to 1. */ =IIF( Parameters!ParameterToCheck.Value"" AND Fields!NOTALPHANUMERIC.Value=0, "Valid", "Not Valid" ) Additional If like us, you've made a report containing a link dependent on parameters submitted, we had to apply a similar IIF statement block...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
'HH24:MI:SS.FF6') AS ReportStartTime FROM... Then add another dataset (using the same data source if you like): -- Oracle 10g: DataSet2 -- a quick dataset following the first (started before the first ends? hope not) SELECT TO_CHAR(systimestamp,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
REFCURSOR; EXEC sp_get_studentdetails_from_ad(:myResultSet,'jsmith2012'); PRINT myResultSet; Should yield something like: MYRESULTSET -------------------------------------------------------------------------------- STUDENTID STUDENT_USERNAME...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
the loop run the activities query and replace the string "STRING_TO_REPLACE_PER_ITERATION" with the User ID. Something like: $result=mysql_query($user_list_query); while($row=mysql_fetch_assoc($result)) { $this_user_id=$row['UserID'];...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
demo the crudest form which uses Joomla's version 2.5 core mootools (uncompressed?). This is intended for absolute novices (like me) who just want to see an example of an AJAX form within Joomla 1.6.x - 2.5.x in it's most basic state. At time of print,...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
group policies control our every deviation from the standard staff image and so we spend more time on "how do you make it like it was in XP?" situations. How? Who doesn't want to change their desktop background wallpaper? Using Windows 7, who doesn't...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
following (column positions added for demo purposes): String1.String2.String3.String4 1 5 10 15 20 25 30 -> length = 31 I'd like to end up with just the last part of this, ie "String4". So I need to delimit based on the dot/period (.) and use substring...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
bosses that you need the MySQL Workbench as this is FREE and with all the features you'd expect a GUI administration kit like this to have.
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
this data using other sources and in time a region by IP for more accuracy. Feel free to feedback. It's FREE to download unlike others which is probably why I made the generator in the first place but I do like to make people sign up so I can gauge the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
This is a quick article on what I change the error page for Joomla websites to. I like a clean error page, for a demo visit http://www.joellipman.com/my_error_page. Applies to Joomla 1.6.x, 1.7.x, 2.5.x How? Backup the file \templates\system\error.php...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Highlighter but both were causing problems for the sites I wanted to use it on. Mainly because of JavaScript frameworks (like jQuery and MooTools) conflicting with other scripts but do I really need a complex solution? So here I am making my own again....
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
If you want this, I think the rewrite rule is: RewriteCond %{REQUEST_URI} ^/([\w]+).html [NC] But, er, I like that first check (myFolder) that the submitted URL matches the format of your site (and a lot more opportunity to check for malicious code).
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
* FROM #__projects WHERE user_id= ORDER BY name Please Note: This article focuses on a front-end form dropdown. If you would like to see how to do modals for the admin panel, see my article Joomla article modal with clear button for Joomla article...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
the absolute path of the file to be copied, that file will be excluded from being copied. For example, specifying a string like \obj\ or .obj will exclude all files underneath the directory obj or all files with the .obj extension respectively. /P...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
bit of SQL but as you can see we have a few fields that need decoding (suffixed by "_code"). Run as it is, yields something like the following: sequenceID student_reference student_title_code student_name student_gender_code student_country_birth_code...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
you try to apply you should be prompted to convert to use gold characters: Test the XET export and you should get something like: 5826|England Almost! If the code and it's short name/full name exist in the database, this works accordingly. If however,...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *