Search found 34 matches

by Sergio
28 Sep 2017, 14:44
Forum: Ask For Help
Topic: Will paypal $30 to whoever helps me successfully connect to PGSQL with ADO
Replies: 4
Views: 213

Re: Will paypal $30 to whoever helps me successfully connect to PGSQL with ADO

Absolutely amazing! I can't thank you enough. I'll DM you requesting your Paypal e-mail. If qwerty12 is so generous solving your request for free (btw, thx 4 that. Much appreciated :thumbup: ) why not think about to sponsor AHK's foundation instead?! https://autohotkey.com/foundation/#contributions...
by Sergio
27 Sep 2017, 23:50
Forum: Ask For Help
Topic: Will paypal $30 to whoever helps me successfully connect to PGSQL with ADO
Replies: 4
Views: 213

Re: Will paypal $30 to whoever helps me successfully connect to PGSQL with ADO

Absolutely amazing! I can't thank you enough. I'll DM you requesting your Paypal e-mail.
by Sergio
27 Sep 2017, 20:48
Forum: Ask For Help
Topic: Will paypal $30 to whoever helps me successfully connect to PGSQL with ADO
Replies: 4
Views: 213

Will paypal $30 to whoever helps me successfully connect to PGSQL with ADO

I've posted a few times and the community seems pretty convinced that a person can connect to a PostgreSQL database using the ADO SQL library . However I have not been able to get it to work. I've set up a dummy server here and provided the credentials: https://pastebin.com/NeeNeZj1. If anyone knows...
by Sergio
19 Apr 2017, 11:01
Forum: Ask For Help
Topic: Connecting to postgresql
Replies: 0
Views: 87

Connecting to postgresql

I've seen a few posts on the topic but no resolution. So it's either very simple & I'm missing it or maybe not possible? Using the IsNull/ahkDBA library for an easy UI, I've tried with two connection strings constructed from ( connectionstrings.com ). ADO Driver={PostgreSQL};Server=localhost;Por...
by Sergio
19 Apr 2017, 09:53
Forum: Offtopic
Topic: Thank you Autohotkey!
Replies: 3
Views: 287

Re: Thank you Autohotkey!

That's great, I'm interested to know what part of ahk if any you turned into a career ? It's helped in probably more ways that I can list. But to give you some idea: * Prior to AHK I wrote in HTML & some actionscript. So the bulk of all of my programming knowledge came from AHK. Even if I'm mos...
by Sergio
18 Apr 2017, 18:39
Forum: Offtopic
Topic: Thank you Autohotkey!
Replies: 3
Views: 287

Thank you Autohotkey!

Ten years ago this forum helped turned me from a young sapling into a programmer. People used to yell RTFM a lot more in those days but I lived by that damn documentation and it made all of the difference. Today, a decade later, I was adding a portion of the site where I pay tribute to the open sour...
by Sergio
03 Mar 2017, 23:28
Forum: Ask For Help
Topic: SOLVED: Help with a HTTP POST request with a binary (PDF) response Topic is solved
Replies: 1
Views: 481

Re: Help with a HTTP POST request with a binary (PDF) response Topic is solved

People much smarter than myself figured it out here: https://autohotkey.com/board/topic/71528-com-winhttprequest-responsestream/page-2. I vaguely modified it to call it more easily below. To define the function: httpGetter(RequestType := "" ,URL := "" ,Payload := "" ,Fu...
by Sergio
03 Mar 2017, 19:24
Forum: Ask For Help
Topic: SOLVED: Help with a HTTP POST request with a binary (PDF) response Topic is solved
Replies: 1
Views: 481

SOLVED: Help with a HTTP POST request with a binary (PDF) response Topic is solved

I have to call an API & collect the PDF response. After looking at a few options, it looks like Blackholyman's code in this link is the easiest . However, the response provided by the server is a binary file (PDF) which I need to download onto my computer. I'm still googling but I'm only getting...
by Sergio
20 Feb 2017, 14:26
Forum: Ask For Help
Topic: Possible to intercept text input & manipulate?
Replies: 5
Views: 296

Re: Possible to intercept text input & manipulate?

I suggests that you post a link to the QR reader you are using or explain how it work from the perspective of your ahk script. For instance is it a command line utility that can be called from ahk or is it an application that needs to be worked around ? Good point, I just assumed that people were f...
by Sergio
20 Feb 2017, 13:57
Forum: Ask For Help
Topic: Possible to intercept text input & manipulate?
Replies: 5
Views: 296

Possible to intercept text input & manipulate?

I am working with QR codes & QR reader. The QR code has data that looks like this: GENERAL CLK5|b82a7603-b78c-4f09-a32c-f27c2185c585 The information before the pipe is useful & the information after should be ignored. However, the QR reader, rapidly collects & types the data without any ...
by Sergio
27 Sep 2016, 13:11
Forum: Ask For Help
Topic: URLDownloadToFile with original file name?
Replies: 6
Views: 782

Re: URLDownloadToFile with original file name?

Thanks Garry. I just want to reiterate that it is an API & I do not know at the time of the request what the filename of the response will be. So my request is a lot like this: http://thesite.com/api/foo?paramter=bar And the response file is named: 74bfb59b-8410-42a7-83ad-fca268a5b49c.xlsx
by Sergio
27 Sep 2016, 11:46
Forum: Ask For Help
Topic: URLDownloadToFile with original file name?
Replies: 6
Views: 782

URLDownloadToFile with original file name?

I want to use AHK to create a small UI for querying an API. The API generates a random UUID for each download & I just need to know the name of the file which I've downloaded. The problem is that URLDownloadToFile forces you to specify the filename upon downloading. Is it possible to get the fil...
by Sergio
07 Sep 2016, 15:23
Forum: Ask For Help
Topic: Getting device properties from USB (Apple Ipad)
Replies: 0
Views: 299

Getting device properties from USB (Apple Ipad)

I need to collect the serial number from several different Apple Ipads. I see that if I go to the properties of my connected USB device, I see a trait called "Serial Number" and a value. How would I collect that value via the command line? I know that I can make the windows open & righ...
by Sergio
31 May 2016, 16:40
Forum: Scripts and Functions
Topic: Compare arrays & create final array with deltas
Replies: 0
Views: 341

Compare arrays & create final array with deltas

I happened to need this & couldn't find anyone who wrote it out, so I figured I'd add my own. This script takes two multidimensional arrays and compares the first two columns as key/value pairs. I could have used a dictionary, but ADOSQL outputs tuples - which is what I needed - so I kept it all...
by Sergio
12 Apr 2016, 14:51
Forum: Ask For Help
Topic: Closing (invisible) excel after writing
Replies: 2
Views: 231

Re: Closing (invisible) excel after writing

wolf_II wrote:Xl.Quit ?


I've been Googling answers for over a year & haven't needed a single question. Of all things, this one stumped me.

That was it. Thanks
by Sergio
12 Apr 2016, 14:29
Forum: Ask For Help
Topic: Closing (invisible) excel after writing
Replies: 2
Views: 231

Closing (invisible) excel after writing

I have to create the simplest module to generate excel files. It works well as is, but I don't know how to close the connection once I've written to the file. It is invisible so I can't just alt-F4. Can someone tell me how to do it? ID := "1234567" saveFileName = %A_Desktop%\ID-%ID%.xlsx T...
by Sergio
04 Oct 2015, 11:53
Forum: Ask For Help
Topic: Listview LV_GetText() get second column?
Replies: 2
Views: 455

Re: Listview LV_GetText() get second column?

I literally facepalmed.

Thank you very much! I almost went through the painstaking work of looping through the array that populated the LV just to get more data...
by Sergio
04 Oct 2015, 11:34
Forum: Ask For Help
Topic: Listview LV_GetText() get second column?
Replies: 2
Views: 455

Listview LV_GetText() get second column?

Is there any way to get any other data from the listview other than the first column?
by Sergio
20 Jan 2015, 15:08
Forum: Ask For Help
Topic: How to change the user agent in IE with AHK
Replies: 2
Views: 716

Re: How to change the user agent in IE with AHK

Thanks! Ironically, I kept searching this forum because I thought it was more complicated than something that would come up on that one.

Good to see there's healthy commingling though. Thanks again, it's always appreciated.
by Sergio
20 Jan 2015, 10:02
Forum: Ask For Help
Topic: How to change the user agent in IE with AHK
Replies: 2
Views: 716

How to change the user agent in IE with AHK

I want to use AHK to operate in the mobile version of a website. To do that, I need IE (for the COM access) and IE can change the user agent (below). I can't find (or figure out) how to change the User Agent through the command line. I could hit F12 & manipulate the mouse, but I'd prefer to do i...

Go to advanced search