Σεπτέμβριος 2018 - Δημοσιεύσεις

Getting resulting SQL string from parametric ADO.net SqlCommand
19 Σεπτεμβρίου 18 07:18 μμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

Microsoft is suggesting to always use Named parameters with SqlCommands for security reasons (to avoid SQL injection exploits), but they haven’t thought of providing a property at SqlCommand to give you back the result SQL so that you can have your app log it without resorting to SQL Server for that logging. Found a solution […]

Δημοσίευση στην κατηγορία: .NET, ADO.net, Logging, Parameters, Posts, SQL, SqlCommand, Workarround

Gotcha: VBScript DropHandler doesn’t support Unicode filenames
09 Σεπτεμβρίου 18 12:33 πμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

It seems VBScript (.vbs) script file’s DropHandler on Windows is broken regarding Unicode filenames, as described at https://stackoverflow.com/a/4366906/903783 A workaround suggested by user DG there (https://stackoverflow.com/a/13587850/903783) was to use a batch file to accept the dropped file, then pass the filename(s) to the VBScript script file (.vbs) as command-line parameters. If you just care about […]

Δημοσίευση στην κατηγορία: DragDrop, DropHandler, Excel, Filenames, Gotcha, Posts, Unicode, VBScript, Workaround