Assuming left is required, the following 87 results were found.
-
number" AS "PO Custom Ref", po."Sales order ID" AS "SO ID", soi."Item ID" AS "SO Item ID" FROM "Purchase Order Items" poi LEFT JOIN "Purchase Orders" po ON po."Purchase Order ID" = poi."Purchase Order ID" LEFT OUTER JOIN "Sales Orders" so ON so."Sales...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
fraction one half 172 AC U+00BC ¼ vulgar fraction one quarter 173 AD U+00A1 ¡ inverted exclamation mark 174 AE U+00AB « left-pointing double angle quotation mark 175 AF U+00BB » right-pointing double angle quotation mark 176 B0 U+2591 ░ light shade 177...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
as "window_slide" and "inner_window". Slide divs to be added inside the "inner_window". Move the slides in from right to left with a transition. Push existing slide out to the left; as soon as this is out of sight then hide it behind the displayed...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: *
-
for me using the "push" div layer. Loosely based on Ryanfait: Make a Footer Stick to the Bottom of the Page Aim: Header Left Right Footer Situation The header displayed fine. The left and right columns finally got them side by side. But the footer that...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
Win32 Constantshttps://joellipman.com/articles/automation/autohotkey/win32-constants.html
= $00000100 Const WS_EX_CLIENTEDGE = $00000200 Const WS_EX_CONTEXTHELP = $00000400 Const WS_EX_RIGHT = $00001000 Const WS_EX_LEFT = $00000000 Const WS_EX_RTLREADING = $00002000 Const WS_EX_LTRREADING = $00000000 Const WS_EX_LEFTSCROLLBAR = $00004000...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
after the DELETE clause (so instead of DELETE FROM myTable WHERE myValue=givenValue): DELETE s, ssf, sst FROM `Session` s LEFT OUTER JOIN `SessionStaff` ssf ON ssf.sessionId=s.sessionId LEFT OUTER JOIN `SessionStudent` sst ON sst.sessionId=s.sessionId...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
x.[student_ethnicity_code], f.[ethnicity_name] AS [student_ethnicity] FROM [sourcedb].[dbo].[events] x LEFT JOIN [sourcedb].[dbo].[lookup_titles] a ON x.student_title_code=a.lookup_title_code LEFT JOIN [sourcedb].[dbo].[lookup_genders] b ON...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
virtual desktop on your device. For those that don't know it, the feature is similar to mobile phones where you swipe left/right to reveal another screen of app icons. The same can be done to the desktop versions with open applications instead of just...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Time") > sub_date(to_date(now()), 5), 'Data Warn', 'Data Failed' ) ) AS "Status" FROM "Accounts" acc ) AS t1 LEFT JOIN "Joels Image Library" img ON t1."Status" = img."Status Value" This produces something as follows: Create a widget that shows an image...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_CssStyle = v_CssStyle + ".zc-Color_Picker .customRadio+label{display:none !important;}"; // float the radio options to the left to be horizontal rather than vertical v_CssStyle = v_CssStyle + ".zc-Color_Picker .choice-table-cell{float:left;padding:0...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the days of the week which they can then click on to select a particular day. Some navigation is required in the form of a left arrow and right arrow to see previous or next weeks respectively. What I have: What I want: How? This was achieved using some...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
List MediaWiki Articleshttps://joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html
latin1)) FROM wikimedia_categorylinks WHERE wikimedia_categorylinks.cl_from=p.page_id) AS PageCategory FROM wikimedia_page p LEFT JOIN wikimedia_revision r ON p.page_latest=r.rev_id LEFT JOIN wikimedia_text t ON r.rev_text_id=t.old_id WHERE...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
a "Matrix" into the body of your report. Drag "ReportName" into the field that says "Columns". Right-click on the grey left margin and select "Insert Row" then "Outside Group - Below". Delete the row with the left parenthesis Click on the dropdown of...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
so that we get the "MapOut" value: SELECT r1.MapIn ( SELECT (COUNT(e2.EmpType)-1) AS MyCount FROM DMExtractEmployeeTable e2 LEFT JOIN DMExtractReferenceTable r2 ON e2.CodeType=r2.MapIn -- THIS IS THE LINE CAUSING THE PROBLEM!!! WHERE e2.ID=e1.ID GROUP...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
2, 1000) AS Items FROM Employees_Attendance_Table JOIN master..spt_values n ON n.type = 'P' AND n.number...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
vertical-align: bottom; border-bottom: 1px solid #eee; } #my-line-items thead tr th:first-child{ width: 50%; text-align:left; } #my-line-items tbody tr td img{ width: 75px; height: auto; max-height: 75px; max-width: 75px; margin-right: 15px; float:left;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Login to Zoho Analytics, and choose a workspace with the relevant data (in this case Zoho Books Analytics workspace) In the left sidebar, select "Data Sources" then click on the "Add Data Sources" button Select "Zoho Analytics Workspace" as the data...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
$total_time =intval(intval($total_seconds)/ 3600).":"; $total_time.=str_pad(intval(($total_seconds/60)%60),2,"0",STR_PAD_LEFT).":"; $total_time.=str_pad(intval($total_seconds%60),2,"0",STR_PAD_LEFT); // yields // 82800 = 23:00:00 // 108000 = 30:00:00 On...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
the Back or Forward arrow in the browser toolbar. Displays your browsing history in the tab. Press Backspace, or Alt and the left arrow together. Goes to the previous page in your browsing history for the tab. Press Shift+Backspace, or Alt and the right...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
Panel" Click on the "General" category link at the top of the module management list (not the "General" tab in the top left) At the bottom, type ROKBB3 then press the "Create new module" button. Make sure "enabled" is selected in the radio buttons and...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *