Assuming error is required, the following 168 results were found.
-
DECLARE p_STUDENT_REF number(8); p_STUDENT_DETAILS varchar2(255); -- putting a begin within otherwise I get warning errors (with an end!) BEGIN -- initial query to get me the student ID based on the inputted parameter SELECT student_accounts.student_id...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
I'm using windows 7 and my day-job machines tend to be windows xp. I found this solution on a windows xp machine so if the error happens again, I'll try fixing it on my windows 7 setup and update this article. I found someone else on the Internet who...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
Source of the report exection (1=Live, 2=Cache, 3=Snapshot, 4=History) Status nvarchar(32) NOT NULL either rsSuccess or an error code; if multiple errors occur, only the first error is recorded ByteCount bigint NOT NULL Size of rendered reports in...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
) SELECT @ChosenID = MAX(ID ) FROM (SELECT TOP (@random) ID FROM #Scramble WHERE Chosen IS NULL ) A IF @ChosenID IS NULL RAISERROR('There are no values left to change the Data',16,1) UPDATE #Scramble SET Chosen = 1 WHERE ID = @ChosenID SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
if c1%notfound then student_no := 0; end if; close c1; RETURN student_no; EXCEPTION WHEN OTHERS THEN raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM); END fn_get_sref_from_adname; To run this: SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
for front-end use Create custom documentation for back-end (admin panel) use. Links to basic documentation Issues and Errors List Issues List Create an excel spreadsheet that all involved can modify date entered description owner status (open, in...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
== "image/bmp") ) && ($_FILES["uploaded_file"]["size"] < 20000) ) { if ($_FILES["uploaded_file"]["error"] > 0) { echo "Return Code: " . $_FILES["uploaded_file"]["error"] . " "; } else { echo "Upload: " . $_FILES["uploaded_file"]["name"] . " "; echo...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
set url_counter = url_counter + 1; end while; END; | DELIMITER ; Note that running this in PhpMyAdmin might show as an error, possibly due to the delimiters, but you can run it anyway. Additional Note(s): The trigger only runs if inserting a record. If...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
paste the below code Sub SplitData() Dim WorkRng As Range Dim xRow As Range Dim SplitRow As Integer Dim xWs As Worksheet On Error Resume Next xTitleId = "JoelsTooCoolForExcel" Set WorkRng = Application.Selection Set WorkRng =...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
a shortcut playing with the base64encode function: v_Etag = zoho.encryption.base64encode(v_Combined_Fields); // returns error Error on Execution Execution Failed Due to invalid expressions insert statement is terminated Line:(102) Value of the field...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
we get the latest by ordering the dataset of the subquery. In T-SQL and MySQL, this is not so much of an issue. I get this error when having to use an ORDER BY clause in a subquery within an Oracle 11g environment. How? Consider the following: SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
404: Page Not Foundhttps://www.joellipman.com/component/content/article/404.html?catid=50&Itemid=165
site is still to be found on our new website at www.joellipman.com. The Page you are looking for doesn't exist or an other error occurred. Go back, or head over to Joel Lipman .Com to choose a new direction.
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
accordingly. The use of some environment variables (eg. %ComSpec% or %windir%) in the command may cause an "Access Denied" error on some networks. Use the hardcoded path.
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
30 seconds. /REG :: Save /R:n and /W:n in the Registry as default settings. /TBD :: wait for sharenames To Be Defined (retry error 67). :: :: Logging Options : :: /L :: List only - don't copy, timestamp or delete any files. /X :: report all eXtra files,...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
and reducing processes to single-click fixes, I made this teeny tiny program to run the above commands and check the error levels. Installation: 1) Decompress to a folder of your choosing 2) Run the EXE (there is no install process, it should just...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
accidentally zoomed out in the browser... but these were red herrings as I have other templates that work fine. How? The error is one of those that you wouldn't consider relevant in this case, after all, all styling was removed... Here are two...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
// Push to Creator: m_CrmFields = Map(); m_CrmFields.put("My_MultiPicklist": l_MyMultiPicklist.toString(",")); // Yields ERROR: Failure, Invalid column value \"Options 2, 3\" specified // i.e. Cannot match picklist option in Creator (Options 2 is split...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
following: // Normalize to +HH:MM offset = "+0530"; offset = offset.replaceAll("([+-]\d{2})(:?)(\d{2})", "$1:$3", false); Error: Argument type mismatch -Found 'TEXT' but Expected 'Long' // Solution: Convert your string into a date. Source(s) toTime()...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= Map(); m_RelatedList.put("header_context",l_HeaderColumns); m_RelatedList.put("data",l_DataRows); return m_RelatedList; Error(s) Encountered Sorry, there was a problem processing your request.: Your returned XML is invalid Sorry, there is a tag...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
to see the notifications for each m_Params.put("PreferenceLevel","User"); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *