Search found 37 matches

by VxE
23 Dec 2015, 21:08
Forum: Scripts and Functions
Topic: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)
Replies: 41
Views: 19229

Re: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)

I imagine you'd need to pass the address of the output variable. Unfortunately I can't test it right now.

Code: Select all

	If !( coer := A_LastError ){
		oRec := oCon.execute(Query_Statement,&recordsAffected)
		msgbox %  NumGet(recordsAffected)
	}
by VxE
19 Mar 2015, 22:34
Forum: Scripts and Functions
Topic: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)
Replies: 41
Views: 19229

Re: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK

@Gio: You could boost performance by keeping an open connection, though whether you would notice the performance boost is anyone's guess. If your script creates an ADODB.connection object, you can configure it however you like and manually open/close the connection. With an open connection, you can ...
by VxE
08 Jun 2014, 19:27
Forum: Scripts and Functions
Topic: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)
Replies: 41
Views: 19229

Re: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK

You mention a provider, does that mean your mysql database is hosted by a company like amazon or rackspace? If so, ask your provider for detailed instructions for connecting to a mysql database on your instance.
by VxE
23 Feb 2014, 17:56
Forum: Ask For Help
Topic: Upload image to Google Images failed
Replies: 8
Views: 4164

Re: Upload image to Google Images failed

It looks like google image search expects the image to be base-64 encoded (inside the multipart form). You can probably prepare the POST body as plain text.
by VxE
16 Feb 2014, 15:57
Forum: Offtopic
Topic: How Can Rockets Travel To The Moon, If MoonTravels at 6mKPM
Replies: 36
Views: 12544

Re: How Can Rockets Travel To The Moon, If MoonTravels at 6m

Either it's a really bad attempt at humor, or Roonyroo has never run alongside a flying frisbee. Either way... what's the deal with the swear filter!? Can I still play [foul/derogatory language][foul/derogatory language]in's Creed 4?
by VxE
02 Feb 2014, 13:16
Forum: Scripts and Functions
Topic: [Func] JSON-like (de)serializer (AHK-L)
Replies: 6
Views: 4954

Re: [Func] JSON-like (de)serializer (AHK-L)

You have permission to use the code in any manner you see fit, as long as you meet the conditions of the license, which basically says you must include the copyright notice and license text with any distributions that include the function code.

It's a very loose license.
by VxE
23 Jan 2014, 04:06
Forum: Ask For Help
Topic: How to start my AHk definitions automatically
Replies: 12
Views: 5262

Re: How to start my AHk definitions automatically

Assuming UAC is the culprit, you'll have to create a special shortcut to bypass UAC for your script. You can try following the guide in this page: http://www.technorms.com/253/create-sho ... -uac-check
by VxE
19 Jan 2014, 20:03
Forum: Scripts and Functions
Topic: [Func] SHA-256 with HMAC
Replies: 0
Views: 1373

[Func] SHA-256 with HMAC

What seems like a long time ago, I ported the SHA-256 hash algorithm (and the related HMAC) to native AHK.

Since the Windows crypto API is probably superior in most cases, this is intended only for academic interest or to satisfy your curiosity.

https://github.com/Jim-VxE/AHK-Lib-SHA256
by VxE
18 Jan 2014, 03:07
Forum: Ask For Help
Topic: [solved] Notepad?? - Change Width of syslistview321
Replies: 4
Views: 1698

Re: Notepad?? - Change Width of syslistview321

You can try LVM_SETCOLUMNWIDTH on that dastardly listview.
by VxE
30 Dec 2013, 17:18
Forum: Scripts and Functions
Topic: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)
Replies: 41
Views: 19229

Re: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK

Just use the file name as you would a table name in the JOIN clause.

Code: Select all

...
FROM [file1.csv] a
INNER JOIN [file2.csv] b
ON a.id = b.id
by VxE
18 Dec 2013, 20:58
Forum: Scripts and Functions
Topic: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)
Replies: 41
Views: 19229

Re: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK

Honestly, I just set the working dir to the folder with all the csv files, then use the file names like table names in the query.
by VxE
16 Dec 2013, 22:02
Forum: Scripts and Functions
Topic: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)
Replies: 41
Views: 19229

Re: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK

SetBatchLines has no effect on the query execute time. "LIKE" is a very slow operation (it's similar to RegexMatch). If you're running a query like "...WHERE column LIKE 'pattern'..." against ~1 million records, expect it to take a while. Of course, you can always install MySQL, import the records t...
by VxE
16 Dec 2013, 01:55
Forum: Ask For Help
Topic: ADO / Database advice for AHK
Replies: 5
Views: 2500

Re: ADO / Database advice for AHK

Here's my ADODB wrapper function: http://ahkscript.org/boards/viewtopic.php?f=6&t=74

The example in that thread shows SQL querying a CSV file like a database table. I don't think you can UPDATE or DELETE using text file drivers.
by VxE
16 Dec 2013, 01:43
Forum: Offtopic
Topic: My board name suggestions?
Replies: 34
Views: 9157

Re: My board name suggestions?

CodePocalypse?

CodeNado?

Codémon?

Troll++
by VxE
09 Dec 2013, 05:30
Forum: Ask For Help
Topic: Perpetually growing Window
Replies: 12
Views: 3037

Re: Perpetually growing Window

Remembering the gui position and restoring it is one of the items in my bag of tricks. Here's my take on it : ; You can put an actual gui prior to this point. scriptCfg = %A_ScriptDir%\config.ini IniRead, guiPos, %scriptCfg%, Script, GuiPos ; Load gui pos If !InStr( guiPos, "," ) ; this checks for a...
by VxE
20 Nov 2013, 20:26
Forum: Offtopic
Topic: « What's on your mind? »
Replies: 4243
Views: 758156

Re: « What's on your mind? »

Indubitably!
by VxE
20 Nov 2013, 04:21
Forum: Ask For Help
Topic: Quality of Graphics and scaling with AHK
Replies: 2
Views: 1360

Re: Quality of Graphics and scaling with AHK

Try creating the picture control with native size (automatically detect the image size), then resize it later with GuiControl, Move.
by VxE
15 Nov 2013, 20:03
Forum: Ask For Help
Topic: xml prettifier Topic is solved
Replies: 4
Views: 2269

Re: xml prettifier Topic is solved

Yeah, that looks like my code. Here's the updated function: sXML_Pretty( XML, IndentationUnit="`t" ) { ; Adds linefeeds (LF, asc 10) and indentation between XML tags. ; NOTE: If the XML does not begin with a "<?xml...?>" tag, the output will begin with a newline. StringLen, il, IndentationUnit Loop,...
by VxE
01 Nov 2013, 03:40
Forum: Offtopic
Topic: Does DeleteAll keep a menu from getting any more items?
Replies: 3
Views: 2048

Re: Does DeleteAll keep a menu from getting any more items?

Try

Code: Select all

Menu, Tray, NoStandard

Go to advanced search