AutoHotkey Community

VxE

IfWinActive is easiest to use with the window title. You can use a browser plugin (i.e. Tampermonkey for Chrome) to put the addressbar text in the window title with one line of code // Tampermonkey pseudocode. Check plugin documentation for boilerplate & config syntax document.title = document.title...

VxE

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)
	}

VxE

@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 ...

VxE

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.

VxE

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.

VxE

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?

VxE

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.

VxE

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

VxE

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

VxE

You can serialize AHK objects as JSON.

VxE

You can try LVM_SETCOLUMNWIDTH on that dastardly listview.

VxE

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

VxE

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.

VxE

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...

VxE

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.

VxE

CodePocalypse?

CodeNado?

Codémon?

Troll++

VxE

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...

VxE

Indubitably!

VxE

Try creating the picture control with native size (automatically detect the image size), then resize it later with GuiControl, Move.

VxE

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,...

Search found 38 matches

Re: IfWinActive based on URL in Chrome?

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

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

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

Re: Upload image to Google Images failed

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

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

Re: How to start my AHk definitions automatically

[Func] SHA-256 with HMAC

Re: How to get object overall size

Re: Notepad?? - Change Width of syslistview321

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

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

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

Re: ADO / Database advice for AHK

Re: My board name suggestions?

Re: Perpetually growing Window

Re: « What's on your mind? » Topic is solved

Re: Quality of Graphics and scaling with AHK

Re: xml prettifier