Search found 38 matches
- 09 Feb 2021, 16:45
- Forum: Ask for Help (v1)
- Topic: IfWinActive based on URL in Chrome?
- Replies: 1
- Views: 329
Re: IfWinActive based on URL in Chrome?
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...
- 23 Dec 2015, 21:08
- Forum: Scripts and Functions (v1)
- Topic: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)
- Replies: 43
- Views: 94674
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)
}
- 19 Mar 2015, 22:34
- Forum: Scripts and Functions (v1)
- Topic: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)
- Replies: 43
- Views: 94674
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 ...
- 08 Jun 2014, 19:27
- Forum: Scripts and Functions (v1)
- Topic: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)
- Replies: 43
- Views: 94674
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.
- 23 Feb 2014, 17:56
- Forum: Ask for Help (v1)
- Topic: Upload image to Google Images failed
- Replies: 8
- Views: 5727
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.
- 16 Feb 2014, 15:57
- Forum: Off-topic Discussion
- Topic: How Can Rockets Travel To The Moon, If MoonTravels at 6mKPM
- Replies: 36
- Views: 17659
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?
- 02 Feb 2014, 13:16
- Forum: Scripts and Functions (v1)
- Topic: [Func] JSON-like (de)serializer (AHK-L)
- Replies: 6
- Views: 7245
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.
It's a very loose license.
- 23 Jan 2014, 04:06
- Forum: Ask for Help (v1)
- Topic: How to start my AHk definitions automatically
- Replies: 12
- Views: 7479
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
- 19 Jan 2014, 20:03
- Forum: Scripts and Functions (v1)
- Topic: [Func] SHA-256 with HMAC
- Replies: 0
- Views: 2330
[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
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
- 18 Jan 2014, 03:09
- Forum: Ask for Help (v1)
- Topic: How to get object overall size
- Replies: 6
- Views: 3527
- 18 Jan 2014, 03:07
- Forum: Ask for Help (v1)
- Topic: [solved] Notepad?? - Change Width of syslistview321
- Replies: 4
- Views: 2874
Re: Notepad?? - Change Width of syslistview321
You can try LVM_SETCOLUMNWIDTH on that dastardly listview.
- 30 Dec 2013, 17:18
- Forum: Scripts and Functions (v1)
- Topic: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)
- Replies: 43
- Views: 94674
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
- 18 Dec 2013, 20:58
- Forum: Scripts and Functions (v1)
- Topic: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)
- Replies: 43
- Views: 94674
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.
- 16 Dec 2013, 22:02
- Forum: Scripts and Functions (v1)
- Topic: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)
- Replies: 43
- Views: 94674
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...
- 16 Dec 2013, 01:55
- Forum: Ask for Help (v1)
- Topic: ADO / Database advice for AHK
- Replies: 5
- Views: 3802
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.
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.
- 16 Dec 2013, 01:43
- Forum: Off-topic Discussion
- Topic: My board name suggestions?
- Replies: 34
- Views: 14591
Re: My board name suggestions?
CodePocalypse?
CodeNado?
Codémon?
Troll++
CodeNado?
Codémon?
Troll++
- 09 Dec 2013, 05:30
- Forum: Ask for Help (v1)
- Topic: Perpetually growing Window
- Replies: 12
- Views: 4932
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...
- 20 Nov 2013, 20:26
- Forum: Off-topic Discussion
- Topic: « What's on your mind? » Topic is solved
- Replies: 4893
- Views: 1393642
Re: « What's on your mind? » Topic is solved
Indubitably!
- 20 Nov 2013, 04:21
- Forum: Ask for Help (v1)
- Topic: Quality of Graphics and scaling with AHK
- Replies: 2
- Views: 2295
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.
- 15 Nov 2013, 20:03
- Forum: Ask for Help (v1)
- Topic: xml prettifier
- Replies: 4
- Views: 3961
Re: xml prettifier
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,...