Assuming returned is required, the following 67 results were found.
-
(not a blank row either) as one of my reports uses a row counter to display a "No data found" message when no rows are returned. This does not affect the above problem as the stored procedure simply fails and discontinues processing the overall report....
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
report processing. An error has occurred during report processing. The Group expression used in grouping 'table1_month' returned a data type that is not valid. My DataSet Query was as follows: SELECT CONCAT(MONTHNAME(t1.Date), ' ', YEAR(t1.Date)) Month,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
'[^a-zA-Z0-9]') -- returns all rows where the student surname contains non-alphanumeric characters -- eg. O'Brien will be returned SELECT * FROM STUDENTS WHERE REGEXP_LIKE(S_SURNAME, '[^a-zA-Z0-9\'']') -- returns all rows where the student surname...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
( p_STUDENT_ADNAME IN varchar2, l_CURSOR OUT sys_refcursor ) IS BEGIN -- going to declare variables that are to be returned in SSRS but not -- mentioned in the above OUT variables: DECLARE p_STUDENT_REF number(8); p_STUDENT_DETAILS varchar2(255); --...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Studio (BIDS / VS2008), the IDE would crash and close without warnings or notifications. We found that if the query only returned 1000 rows, it completed and displayed in just under 1 minute. If limited to 500 rows, it would complete in just under 40...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
AND wikimedia_page.page_is_redirect=0 -- yields: let's call it MyTable1: Query time: 0.187s. 880 rows returned. PageID PageTitle PageContent ---------------- ------------------ --------------------- 1144 7911_and_7912_t... ==Description==... -- to get a...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
list in Zoho CRM with a view on to related records in Zoho Creator. For some reason, only some random fields were being returned, all pretty much useless to me. Well the "for some reason" turned out to be because my detail view on the report was...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Lipman) - Enhanced debug messages as function not auto-triggering on receipt of Order - Resolved: SO ID was not being returned when created. - Forced re-upload of photo for item on any modification Date Modified: 2023-03-20 (Joel Lipman) - Check if...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
= invokeurl [ url :v_Endpoint_Goals type :GET connection:"zpeople" ]; // // parse the response loop through each record returned m_GoalsResponse = ifnull(r_GoalsData.get("response"),Map()); l_GoalRecords = ifnull(m_GoalsResponse.get("result"),List());...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
FROM #__assets WHERE parent_id=0 -- where #_ is the Database Tables Prefix value There can be only one: If the number returned is 1 then this article is not addressing your issue. This is a red herring. If the number returned is greater than 1 then run...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Error: Data conversion failed while converting column "This_Date" (3833) to column "This_Date" (3932). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.". Error: SSIS Error Code...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
with Team Foundation Server 2010. The database with our stored procedure is Oracle 10g. The Stored Procedure Rather than a returned dataset, our Stored Procedure updates a field in one of our Oracle tables and returns nothing. It accepts 3 parameters:...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; CharSet=UTF8; Note that resultsets still are returned in the character set of the data returned. Specifying shared memory name Use this one to specify the shared memory object...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
error is recorded ByteCount bigint NOT NULL Size of rendered reports in bytes. RowCount bigint NOT NULL Number of rows returned from queries. Conversions Needed: I want to convert a start and end date to a single time value (hours minutes seconds...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
and Note in the details (will appear in each cell per day). Grouping by weeks: Now we finish with the report wizard and returned to the designer. Right-click on the "[Order]" cell and select "Add Group" then click on "Parent Group..." as shown. Week...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
a singleton (or empty sequence), found operand of type 'xdt:untypedAtomic *' This is because more than one record was returned so you need to surround with brackets and append a [1] as per the above example. Retrieving nodes -- to get all below nodes...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
a link, I want that link to turn blue and display an underline. When I move the cursor away from the link, I want the link returned to black without an underline. How? #NoEnv SendMode Input SetWorkingDir %A_ScriptDir% #SingleInstance Force ;...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
this article to document an issue we encountered where our code was as per the documentation provided, and the responses returned as successful, but the target fields did not update. This was as a result after changing the owner of the Creator app to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
= v_MyString.replaceAll(("([&'\"])"),"\\$1",false); // yields Joe\'s \"Amazing\" Skill \& \ Grunt Replace new lines in returned JSON (invalid in Zoho): v_MyString = "{"MyKey":"MyValue "}"; // the long way (and cos the regex for this isn't working)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
to: zoho.adminuserid subject: v_Subject message: v_Message attachments:file:v_CSVFile ]; Issue(s): CSV being returned in a single line, consider different methods of inserting a new line: Joel Lipman: ZohoDeluge: Inserting a new line character in a CSV
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *