Assuming final is required, the following 31 results were found.
-
this. The use-case here is that we have a dropdown/picklist on a CRM invoice record that has the options of "Deposit" and "Final Balance". This rewrites the invoice line items to represent a deposit or a final balance invoice with the deposit deducted....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
== 0: break if rec.AcceptWaveform(data): result = json.loads(rec.Result()) transcript.append(result.get("text", "")) # Get final result final = json.loads(rec.FinalResult()) transcript.append(final.get("text", "")) # Save transcript with...
- Type: Article
- Author: Joel Lipman
- Category: Apple
- Language: *
-
generates code that embeds a flash movie player * with reference to the uploaded movie. */ class FlvPlayer { /* Generate final code */ function render() { $this->url = $this->getViewPath($this->file); $this->code = ' The Camtasia Studio video content...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
} return search_pretty_terms($temp); } # separate function for dealing with apostrophes (injection?) function search_final_clean($terms) { $out = array(); foreach($terms as $term){ $out[] = addslashes($term); } return $out; } $terms =...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
Sunday 16/10/2011 A007 08:00 17:00 Sunday 16/10/2011 A009 08:00 17:00 NULL NULL NULL NULL NULL */ YAY!!! Note that in this final stage, you can replace NULL with lots of hyphens (if you want lots of dashes/hyphens as separators) or replace with whatever...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Jlipman 1.1 Merged into one query. ** ** Added schema to column_source. ** ** 15/10/2012 Jlipman 1.2 Added count column to final results. ** ** Added minStrLen and maxStrLen for more accurate matches. ** ** Changed order by MAX(column_source) to...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
display an AlertDialog with the 3 options to "take a photo", "choose from existing", or "cancel": /* 201411040126 */ static final int REQUEST_IMAGE_CAPTURE = 1; private static int RESULT_LOAD_IMAGE = 1; private static int TAKE_OR_PICK = 0; public void...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
still appear small. Sure I resized the text to about 46pt and everything was over 3000px in width but this is not good for a final solution. I thought maybe there was a setting for the default font size or where I've accidentally zoomed out in the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
my MP3 software to convert all the files into MP3 format and store these in another folder. I needed a program to: Check the final folder for all the MP3 filenames Check the original folder for the same filename (BUT NOT necessarily with the same...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
-- JCOMMENTS FOR J1.6+ -- Search my website for "Migrate" for the final script to migrate JComments -- VIRTUEMART? (what a nightmare, major upgrade, 30FTE) -- ROKBOX TO YOOTHEME? -- JEVENTS? --...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
second select statement (to list all the rooms) has to have the same number of fields as the first statement. This is the final script for the events table (DO NOT USE THE BELOW: this works for me and the timetabling system I have, you need to adjust...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
if zero rows were returned because Sum(Fields!Counter.Value, "Equipment") should come back as zero. MDX Expression: One final and a little confusing tweak to make it all work! Where "Equipment" is the name of the dataset. Bring up the tablix properties...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
performance is always rubbish anyway. Here's a breakdown of the MDX expressions and how I tweaked each one to return the final result: -- to get just the time value =( CDate(Last(Fields!REPORTENDTIME.Value, "Dataset2")) -...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
incomplete! Will post a final solution but here are the basics What? This article is a quick note to myself on the idea of a slideshow with the MooTools javascript framework. Basically, I want to create a div layer that I can see through (like a window...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: *
-
reported these default values sometimes list twice, especially when the case is different, eg. "Data not yet available". The final system (qlikview) was case-sensitive despite our server collation being case-insensitive. Furthermore, we now have the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
EXEC(@SqlToExecute); FETCH NEXT FROM Cursor1 INTO @ColToProcess END CLOSE Cursor1; DEALLOCATE Cursor1; -- Generate final query and execute it SET @SqlToExecute = ' SELECT DISTINCT myValue COLLATE ' + @p_UseCollation + ' AS myValue, myColumn,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
EXEC(@SqlToExecute); FETCH NEXT FROM Cursor1 INTO @TableToProcess END CLOSE Cursor1; DEALLOCATE Cursor1; -- Generate final query and execute it SELECT * FROM #CountRecordsPerTablePerCol; END Issues Consider adding a drop of the temporary table to the...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
NULL OR t2.TABLE_CATALOG IS NULL ) -- NOTE: This does not list if a column has been moved to another table Method #4 And a final enhancement to epitomize my laziness (replace [myDB1] with name of database 1 and [myDB2] with name of database 2): -- Joins...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
this script in many packages, we can change just this script instead of the ones for every package). Here is the near enough final version of my script (or more like an experienced colleague's comprehensive script to which I have merely added my...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
morning, I also worked on creating a template for the site I just made; I started at 9:45 and finished at 12:00") The final system needs to specify every day of the week and divide all the days activities into the morning and afternoon slots. All days...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF