Search - Joel Lipman .Com

1. TravelPort Universal API - Ping Request with PHP-cURL: / API Miscellaneous /; Applies to: TravelPort Universal API PHP 4 or 5 cURL What? An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using ...; Created on 27 April 2015
2. MySQL Updating a database table from another table: / MySQL /; What? A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they ...; Created on 22 October 2014
3. Parse a HTML Table into a ListView: / Hypertext Markup Language /; ... replicates any HTML table. How? I've been trying various ways so I'm posting them here. My opinions on them change with the weather so until I do some benchmarking I won't know which ones best: ...; Created on 30 March 2013
4. DataScramble - Randomizing data rows: / Transact-SQL /; ... CAST(@RandYear AS CHAR(4)) + '-' + STUFF(@RandMonth, 1, 0, REPLICATE('0', 2 - LEN(@RandMonth))) + '-' + STUFF(@RandDay, 1, 0, REPLICATE('0', ...; Created on 07 December 2012
5. Search a database for a string (MySQL, T-SQL): / Databases /; ... BEGIN PRINT REPLICATE('-',100) PRINT @tmpTblname PRINT REPLICATE('-',100) PRINT replace(@sql,'INTO SearchTMP','') END ...; Created on 08 October 2012
6. DataJumble - Shuffling characters in a data value: / Transact-SQL /; ... CAST(@RandYear AS CHAR(4)) + '-' + STUFF(@RandMonth, 1, 0, REPLICATE('0', 2 - LEN(@RandMonth))) + '-' + STUFF(@RandDay, 1, 0, REPLICATE('0', ...; Created on 01 August 2012
7. Connection Strings for SQL Server: / SQL Server /; ... to a server in a replicated server configuration without concern on which server to use. Server=serverAddress1 & serverAddress2 & etc..;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Using ...; Created on 05 January 2011
8. Blank columns issue when exporting to Excel (Data Only) from Crystal Reports: / Excel /; ... could not be replicated on the client machine (ie. from my workstation). I would have to upload the report to the server, configure the web application to use the newly uploaded report, export to a Crystal ...; Created on 15 June 2010