Assuming above is required, the following 179 results were found.
You can now specify the size of the image as well (16x16 is a tad small). Caveat(s): A bit work needs to be done to the code above to prevent attachments from going in twice. You would need to record the attachment ID and only push it to Analytics if...
after the slash /org-details/###### (eg. "123456789") Note this down for later use Create a connection to Zoho Analytics: Above the function in Zoho People > Connections > Create Connection Select Zoho Analytics and give the required scopes (I've...
a go: The page responses query showing only the last survey attempt per respondent I'm going to modify the analytics query above to only return the latest responses that a respondent has completed; this means that if they have completed the same survey...
GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html
on implied warranties or the exclusion or limitation of certain damages. If these laws apply to you, some or all of the above disclaimers, exclusions, or limitations may not apply to you, and you might have additional rights. Applicable Law By visiting...
Log into the phpBB3 Administration Control Panel. Based on the phpBB3 installation instructions above, this should be something like http://www.mysite.com/phpBB3/adm/. Click on the 'General' tab, look at the "Server Configuration" section and click the...
.', ordering':' ORDER BY title ASC'; To sort by another value on page load To do this, change the word 'title' in the above code to one of the following values: id => sort by ID catid => sort by Category ID sid => ? dunno title => by web link title...
in a row My old method was to: Select distinct column1.table1 FROM table1 PHP script would loop through all rows of the above mysql query Count for each row how many times the column1.table1 value appears in table1 Format this count result by prefixing...
to the WHERE clause Specify that the field name in the series fields is not blank So I've added the AND line to the above statement yielding: SELECT _SMDBA_.Incident.[Incident #] ,_SMDBA_.Incident.[Group Name] ,_SMDBA_.Incident.[Close Date & Time]...
through the same rubbish. I just took a step back and thought this through and this is what I came up with! Additional The above will all work if you're working on a local report within BIDS connecting to remote servers. If you want the report to be...
to use a specific European date format and you spend as long as I did searching the web for a solution, then ignore all the above. Another built-in function is the text-formatter =Format(Fields!myDateTime.Value, "M/d/yy")... 6/15/09...
do with this. We could add a row with a SELECT UNION statement but I found this can be resolved by adding a counter, so the above becomes: SELECT DISTINCT re.[RoomId] ,re.[SiteId] ,re.[EquipId] ,eq.[Description] ,1 Counter FROM [ROOMEQUIPMENT] re INNER...
(formats, defaults and vulnerability) Check ALL server-side errors EventViewer (if Windows) errors.log (if Linux) Above and beyond Product Handover (branded pack with contact details - make it simple and friendly!!!) Warranty / Grace Period (agreed...
Win32 Constantshttps://joellipman.com/articles/automation/autohotkey/win32-constants.html
Flags Const HHT_NOWHERE = $0001 Const HHT_ONHEADER = $0002 Const HHT_ONDIVIDER = $0004 Const HHT_ONDIVOPEN = $0008 Const HHT_ABOVE = $0100 Const HHT_BELOW = $0200 Const HHT_TORIGHT = $0400 Const HHT_TOLEFT = $0800 ;#End Region ;#Region List View sub...
student always has a "Student Reference" but not necessarily a student AD account (enquired/applied only). So following the above, I end up with: Then I want the ID parameter ("@StudentReference") to populate itself if it is left blank when the report...
Move this added field to the Report Filter section (click on it and select "Move to Report Filter") Advanced Sorting So the above works which is great but what if you have a list of month names? January comes before February but not alphabetically, so...
small letter a with diaeresis 133 85 U+00E0 à latin small letter a with grave 134 86 U+00E5 å latin small letter a with ring above 135 87 U+00E7 ç latin small letter c with cedilla 136 88 U+00EA ê latin small letter e with circumflex 137 89 U+00EB ë...
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
A009 08:00 17:00 Separator Marker */ As I mentioned at the beginning of this article, I am comparing on Day names. The above query generates a last column which is either empty or says "Separator Marker". Based on the CTE above, I now need to add an...
should be empty for clarity results_file.txt is the resulting file, it will be created in the current working directory. Above and Beyond: Add to your Context Menu My absolute laziness drives me to write the instructions on adding this to the context...
LEFT JOIN DMExtractReferenceTable r1 ON e1.CodeType=r1.MapIn So simply change the "=" to a "LIKE". Scenario #2 So when the above has been addressed or we've tried casting as varchars all over the place, check the value that gets outputted is also a...
the -- Employee Number concatenated with a 2 digit sequence -- number (padded with zeros) How? So how do we do it? In the above example, Joel Lipman has two qualification records. So let's start with a simple query: SELECT RIGHT('000' + CAST(e.ID AS...