Assuming reference is required, the following 82 results were found.
-
search on EITHER the student's username or the student's ID (2 report parameters: @StudentADAccount [varchar] and @StudentReference [int] respectively). Most of the remaining datasets use the resulting @StudentReference number in their "where" clause. A...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Stored Procedure updates a field in one of our Oracle tables and returns nothing. It accepts 3 parameters: The StudentID (reference) varchar2, Username (who's running the report) varchar2 and a JobID (request reference) number. The Report We start off...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
created to run the stored procedure. This requires using 2 data sources in SSRS. A user will specify the student reference in the parameters of the first report (the one with all the main details), as well as a job reference (for audit purposes) and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
4th Jun 2014 3.0.1 ThomasM- Fixed Bug: Strict Standards Issue: New Operator removed for PHP5+. - Fixed Bug: Object without reference: Child object design converted to Object array. - Date Uploaded: Thu, 31st Oct 2013 3.0- Fixed Bug: Version compatible...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
be something like: { "Invoices": [ { "Type": "ACCREC", "Contact": { "ContactID": "abcdef01-2345-6789-abcd-ef012345678" }, "Reference": "TEST Invoice (DO NOT ACTION) 1", "DueDate": "2021-09-13", "Date": "2021-08-13", "LineItems": [ { "Description": "My...
- Type: Article
- Author: Joel Lipman
- Category: Xero
- Language: *
-
salesperson ID if(!isnull(r_SoDetails.get("Owner"))) { v_OwnerID = r_SoDetails.get("Owner").get("id"); v_Filter = "crm_reference_id=" + v_OwnerID; l_AllSalesPersons = zoho.books.getRecords("salespersons", v_BooksOrgID, v_Filter, "joel_books"); for each...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
in Zoho Books would be enough: { "date": "2021-09-08", "zcrm_potential_id": "123456789012345678", "currency_code": "GBP", "reference_number": "Salespersons Test Reference", "terms": "These are our test terms and conditions", "customer_id":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
function built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) on the ZohoSign document and searches for the relevant Deal record in CRM. Why? A client wants...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
- GetMyeBaySelling Documentation: https://developer.ebay.com/devzone/xml/docs/reference/ebay/getmyebayselling.html - GetOrders using Trading API: https://developer.ebay.com/Devzone/XML/docs/Reference/eBay/GetOrders.html - Get Access Token:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the Stripe webhook when it comes back into ZohoBooks to record it against the invoice. Note how we added the invoice reference and Zoho ID in the description of the payment capture in our previous bit of code: /*...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
- GetOrders Documentation: https://developer.ebay.com/Devzone/XML/docs/Reference/eBay/GetOrders.html - eBay Errors by Number: https://developer.ebay.com/devzone/xml/docs/Reference/ebay/Errors/errormessages.htm */ // // declare v_Page = 1; v_PerPage =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
it returns the ID to use. Some of these can be found elsewhere in my site but I'm putting all of them here just for quick reference. How? Note that for the below, I recently updated this article (2024-05-21) due to the API domain name change from...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
it's for the radar chart and what it does is group all the responses per page (per survey attempt) so that given a survey reference, it will give me the sums per page. SELECT i."Attempt ID" AS "Survey Response", max(i."Survey") AS "Survey", i."Page...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
What? This is a quick bit of code for my reference so that I don't have to keep finding a function that gives me the syntax of how to either create or update a record using invokeUrl. Why? Because my designers keep including custom fields in their...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This took me a while to do so I thought I'd document it for future reference. The Issue See the restore default setting link at the bottom of this page in the footer? I wanted to put one of the styled buttons behind it but then found that there's a lot...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
UInt,SPI_SETCURSORS, UInt,0, UInt,0, UInt,0 ) } In this code, the IDC stuff commented out at the beginning is for your reference. You need to include the setsystemcursor() and restoreCursors() functions somewhere in your script. Update: 07 July 2011:...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
field, selecting Object Size and Position and then setting the XY coordinates. Use the horizontal and vertical rulers as a reference when specifying height, width, and XY coordinates. Export the report to Excel and all the fields in the section appear...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
Language Codeshttps://www.joellipman.com/articles/cms/joomla/language-codes.html
but it's not very international and narrow-minded to think only English speakers will use Joomla! CMS. The below is for reference only: Language Codes af Afrikaans sq Albanian ar-sa Arabic (Saudi Arabia) ar-iq Arabic (Iraq) ar-eg Arabic (Egypt) ar-ly...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
DSN tab Select "MySQL ODBC 5.1 Driver" > Finish Data Source Name (should be system name followed by Live/Test/Dev for reference) Description can be some long winded text that very few will ever use TCP/IP Server is the server name (without the DNS...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
proofs of concept. Why? We have a first report which acts like a search page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page, then we want it to redirect to the details report for that...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF