Assuming because is required, the following 154 results were found.
-
"OK this should take just a few minutes..." I've written this because I spent all night on setting up a "quick" demo resulting in a quick 1 hour nap before having to go to my day job... It sounds straight forward because both phpBB3 and RocketTheme...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
inside. Additionally we would like this linked to events in a database. I'm calling this project "Reinventing the Wheel" because the request was a report that was similar to an MS Outlook calendar which will display any room bookings for that month....
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
their website design everyday... It's 100% FREE Open Source, (well as long as you have your own internet connection) mainly because it's not just my code. I simply combined three technologies into one: Basic Website browser (in its own window - uses...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
to download a file that was uploaded into a Zoho Creator form and then to attach it to a Sales Order in Zoho Books. Why? Because it took me so long to find out how to do this even after reading the official documentation and going through the online...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html
based on their religion, race, sex, political beliefs, or whether they are gay or straight. This is worse than flaming, because it also hurts other members of the board who fall into the catagory you insult. TEU is a place where everyone is equal, and...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
The HTML DOM - (Document Object Model) A basic understanding of the HTML DOM is essential for controlling webpages. This is because it's a "map" or "heirarchy" for accessing parts of the webpage. The HTML DOM is not language dependent, but rather the...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
{"code":"MANDATORY_NOT_FOUND","details":{"api_name":"data"},"message":"required field not found","status":"error"} is because you did this: r_CreateCrmQuote = invokeurl [ url :"https://www.zohoapis.eu/crm/v2.1/Quotes" type :POST parameters:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Thought I'd put this error in here and how I fixed it. Basically because firstly I don't want to have to create an account on someone else's forum just to post my answer and secondly because my solution is a "cowboy fix" rather than the other...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
(BIDS VS2008) with Team Foundation Server (TFS VS2010) and connecting to an Oracle database (ie. "seamless integration because our setup is perfect and well thought through" not - note the DBMS is not hugely relevant for the purposes of this article)....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
t.TeamID=s.TeamID GROUP BY s.LogID ORDER BY s.TeamID, u.Username, s.DateTimeCreated, Resource Note there is no WHERE clause because we're going to use EXCEL filters as the parameters. Bit of a cop-out but this was just a workaround and never a solution....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
SSRS Zero Paddinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html
Reminder I didn't want to do this at the database level, mainly because it meant modifying the SQL query. The zero padding would need to be applicable within an MDX query. The Situation We have a database using Oracle 10g, and a SQL Server Reporting...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
if this could be restored to a normal case, a mixture of mostly lowercase and some UPPERCASE. Why? I'm writing this article because other solutions on the net were either incomplete, did not work for me or simply did not match the requirements (do they...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
that will popup for any user on the submit of a form, or on the click of a button or on the click of a link on a page. Why? Because alert (alert task) can only be used on a load of a form, on a change of a field or on the validate process. And because...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
rather than trying to retrieve the details with a zoho.people.getRecordByID("P_ApplyLeave",v_RequestId) in the function because on application, the record doesn't properly exist in the system yet and the delay causes errors further down the line. Just...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
else DaysInMonth=31,28,31,30,31,30,31,31,30,31,30,31 ThisMonthNum:=A_MM * 1 ; because we want 01 to equal 1 ThisDateNum:=A_DD * 1 ; because we want 01 to equal 1 StringSplit, DaysPerMonth, DaysInMonth, `, DaysInThisMonth:=DaysPerMonth%ThisMonthNum% ;...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
at Microsoft's Windows Update The Long Fix Now below are the notes I've had to try and fix this before (personally it was because Microsoft released an optional windows update that fixed my issue. check that this issue isn't being caused by any Windows...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
installing IE8 will break this) Possibly the easiest thanks to http://browsers.evolt.org/ who have a version 6 standalone. Because their site seems to be under construction and links on the WWW are no longer valid, I've uploaded their zip just in case...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
Newsfeeds Users * UPDATED Weblinks So this is fun. We've waited and waited and Joomla 1.6 is now stable... Exciting because this is not a simple 1.5.21 to 1.5.22 upgrade. But don't believe the drama across the web, the system introduces only a few new...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Why So I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) and then others not. The What I'm going to run these...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
JOIN [EQUIPMENT] eq ON eq.EquipId=re.EquipId WHERE re.RoomId=@GivenRoom AND re.SetId=@setId This seems to have problems because when there are no matching rows (so zero results), BIDS doesn't seem to know what to do with this. We could add a row with a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB