Search found 12 matches

by alnz123
18 May 2024, 23:54
Forum: Scripts and Functions (v1)
Topic: AutoHotStreamDeck - AHK wrapper for Elgato Stream Deck (Keys with screens in them!)
Replies: 30
Views: 27797

Re: AutoHotStreamDeck - AHK wrapper for Elgato Stream Deck (Keys with screens in them!)

Hi, thanks for your work! I tried running example.ahk which was in the zip but nothing happens. Also the script from the 1st post has an error at line 12 image.png What is supposed to happen? I copied the files from the zip into my AHK script folder including the lib. Nothing happens that I can see....
by alnz123
06 May 2024, 21:12
Forum: Scripts and Functions (v2)
Topic: ADOSQL v6
Replies: 20
Views: 2053

Re: ADOSQL v6

ok - so I finally got it working. The SQL connect was getting a string instead of an array. The array syntax is different in v2 (no surprise, but wasn't easy for me to figure out) 1. The SQL connect needed to omit the ";ColDelim=`t" so it should be aList := ADOSQL(ConnectString, Query) 2. The elemen...
by alnz123
06 May 2024, 10:24
Forum: Scripts and Functions (v2)
Topic: ADOSQL v6
Replies: 20
Views: 2053

Re: ADOSQL v6

Sorry if I wasn't clear. The code I'm referring to is in my post. The error line is marked. I'm not not posting the code. It is there. I was testing a small SQL query. According to the guys on Discord, it is probably due to me calling ADOSQL incorrectly and getting text rather than an array. Anyway,...
by alnz123
06 May 2024, 09:44
Forum: Scripts and Functions (v2)
Topic: ADOSQL v6
Replies: 20
Views: 2053

Re: ADOSQL v6

Hi Boiler, the code that caused the error is line 18 in the code one above. I used the "same" code that hisrRB57 provided. You're right it might be to do with array, but it's also sourced from the SQL code. I'm not sure if which is creating the issue. The SQL script extracts the data I need but I ca...
by alnz123
06 May 2024, 02:49
Forum: Scripts and Functions (v2)
Topic: ADOSQL v6
Replies: 20
Views: 2053

Re: ADOSQL v6

This code works but I want select specific field and no header the Password, User, IP and Catalog have been changed #Requires AutoHotkey v2.0 #SingleInstance Force #Include ADOSQL.ahk ConnectString := "Provider=MSOLEDBSQL.1;Password=Password1;Persist Security Info=True;User ID=user;Initial Catalog=D...
by alnz123
06 May 2024, 02:40
Forum: Scripts and Functions (v2)
Topic: ADOSQL v6
Replies: 20
Views: 2053

Re: ADOSQL v6

sorry ...
here's the error

Code: Select all

Error: This value of type "String" has no property named "__Item".

	015: Query := "SELECT * FROM dbo.CLIENT;"
	017: aList := ADOSQL(ConnectString ";coldelim=   	", Query)
▶	018: For xIndex, xval in aList[1]
	018: {
	019: If (xIndex = 1)
by alnz123
05 May 2024, 23:43
Forum: Scripts and Functions (v2)
Topic: ADOSQL v6
Replies: 20
Views: 2053

Re: ADOSQL v6

for v2, I can't seem to get the right syntax to extract the field text.
I keep getting the error
This value of type "String" has no property named "__Item"
by alnz123
05 May 2024, 22:54
Forum: Scripts and Functions (v2)
Topic: ADOSQL v6
Replies: 20
Views: 2053

Re: ADOSQL v6

Hi Boiler

This is intended to be in v2.

I am trying to get a v2 script working
by alnz123
05 May 2024, 22:27
Forum: Scripts and Functions (v2)
Topic: ADOSQL v6
Replies: 20
Views: 2053

Re: ADOSQL v6

Can someone please help? Thanks! I'm missing something in my understanding... I get this error: This value of type "String" has no property named "_item" Thanks Ruevil2 for the script. The new v2 script "works" to list the MsgBox but I want to output the specific fields and not the header. The old s...
by alnz123
14 Jan 2022, 01:48
Forum: Ask for Help (v1)
Topic: Grabbing text from a document Topic is solved
Replies: 13
Views: 2912

Re: [SOLVED] Grabbing text from a document Topic is solved

:clap:
THANK YOU!

it was the "value" on line 11 the fixed it, thanks. (I changed line 9 to "fin-streamer" but keep getting an error.
by alnz123
13 Jan 2022, 22:26
Forum: Ask for Help (v1)
Topic: Grabbing text from a document Topic is solved
Replies: 13
Views: 2912

Re: [SOLVED] Grabbing text from a document Topic is solved

Hi Thanks for this TLM - it was working for a while but recently stopped working. Yahoo must have changed their code but I don't fully understand your script so can't get it working again. Appreciate if anyone can help. Thanks this fixes the issue msgbox % GetStockPrice( "AAPL" ) GetStockPrice( Sym ...
by alnz123
31 Jan 2021, 22:13
Forum: Scripts and Functions (v1)
Topic: Eval - Evaluate Expressions in Strings Dynamically (Updated Dec, 28, 2020)
Replies: 33
Views: 21346

Re: Eval - Evaluate Expressions in Strings Dynamically (Updated Dec, 28, 2020)

Rodolfo - great work. I just discovered this via Jack's AutoHotkey Blog. This will save me heaps of time. I'm not sure how to get it to work with percentages though.

Go to advanced search