-
Posts
841 -
Joined
-
Last visited
Recent Profile Visitors
845 profile views
Zohar's Achievements
Universalist (7/7)
6
Reputation
-
[Solved] How to Save a Dynamically Loading Webpage?
Zohar replied to Zohar's topic in AutoIt General Help and Support
OK I am posting here a simple answer: Simply sending [End] many times, till the page loads everything. To stop it, stop the script. While(True) Send("{End}") Sleep(2000) WEnd -
Hi all If you go to any Youtube Channel, and click the "Videos" tab, then you will see a list of all videos uploaded. This list does not appear in whole right from the start, you need to scroll down more and more, for it to load more videos to the list, until, in the end, you see the full list of Videos. Do you know how can I save to a file this webpage, but its full version? Thank you
-
Zohar reacted to a post in a topic: Does Windows Have a Place for Calling Programs to Run at Shutdown?
-
Werty reacted to a post in a topic: Does Windows Have a Place for Calling Programs to Run at Shutdown?
-
Thank you all. The purpose of this script it to Log. So the script does not have to run the whole Windows Session, only 1 second during Shutdown/Restart. Using OnAutoItExitRegister() indeed was an option, yet I prefer something by Windows, that happens during Shutdown, that way the script does not have to run the whole session, waiting for the Windows session to end.. That's a nice option, I might indeed use it. BTW, is there maybe a Registry option too? Similar to CurrentVersion\Run, just for Shutdown instead of Starting?
-
Zohar reacted to a post in a topic: [Solved] SQLite in AutoIt: Parameterized Queries, and Receiving the Column Names after a SELECT Query
-
I see. Thank you. It complicates the code quite much, so I will not use it.. Well, you can quote the parameters properly, but if the value(s) comes from the user, and the user starts playing with the quotes (as a part of the content that he enters), then the fact that you quoted the values properly will not help.. Am I correct? For this reason, _SQLite_Escape() and _SQLite_Encode() are a must, when running an SQL Query that includes values that come from the user. BTW, I have a question regarding _SQLite_Escape() vs _SQLite_Encode(): If you want to store Binary data ("Blob") in the DB, then obviusly you will use _SQLite_Encode(). But If you want to store a String (Text) in the DB, then technically, you can use either one of them: _SQLite_Escape() or _SQLite_Encode(). So regarding storing a String, will it be correct to say that we should always use just _SQLite_Escape(), or are there cases where we store a String, and _SQLite_Encode() would be the right choice?
-
Zohar reacted to a post in a topic: [Solved] SQLite in AutoIt: Parameterized Queries, and Receiving the Column Names after a SELECT Query
-
Hi benners Thank you very much for your reply. Indeed, seems that _SQLite_GetTable2d() does what I want to do in Q2, thank you very much. So I am now looking for an answer regarding Q1 - Parameterized Queries.. Hopefully that can be achieved too. Currently the closest thing to it that I found (in terms of Security) is using _SQLite_Escape() and _SQLite_Encode(). Of course these 2 functions are not Parameterized Queries, but they do give some protection from SQL Injection.
-
Hi all I would like to ask 2 questions regarding SQLite in AutoIt: The First Question: Is it possible to perform Parameterized Queries on SQLite in AutoIt? Something like this: SQLiteCommand C =new SQLiteCommand(DB1); C.CommandText = @" INSERT INTO T_Users (Name_First,Name_Last) VALUES (@Name_First,@Name_Last) "; C.Parameters.AddWithValue("@Name_First",Textbox_Name_First.Text); C.Parameters.AddWithValue("@Name_Last" ,Textbox_Name_Last.Text); C.ExecuteNonQuery(); Just in AutoIt, instead of in C# The Second Question: Is it possible to perform a SELECT query which returns a table, and receive not just the Data cells, but also another First row which will include the Column Names? As an example, instead of receiving this: I wish to receive this: Thank you very much
-
[Solved] Browser Automation in Android
Zohar replied to Zohar's topic in Developer General Discussion
I'm updating this thread in case someone finds it thru the Search, and needs a solution. The simplest way to do Browser Automation on Android, is to use a Browser that supports Add-ons, and then write the add-on with the web-automation code you need. An example of such a browser on Android is Kiwi Browser. -
How to Check If All Modifier Keys are Up?
Zohar replied to Zohar's topic in AutoIt General Help and Support
Thank you very much Chimp. Can you please explain the RegExp line? What does "\w{2}" do? -
Zohar reacted to a post in a topic: How to Check If All Modifier Keys are Up?
-
Zohar reacted to a post in a topic: Script breaking changes -> _Iif
-
Hi all 4.5 years have passed since this question, and I assume the answers of several people here have also changed. I am adding a post in case someone finds this via the Search, and needs an answer. IE is now discontinued, and since my favorite browser is Firefox, then the solution I found was this: I write a Firefox Add-on, which does most of the automation that I need - the Web Automation part, and for the parts that it can't, I communicate from the Firefox Add-on to an AutoIt script, and then do what I need using AutoIt. For the Communication between the Firefox Add-on and AutoIt, I use TCP. The reason is since a Firefox Add-on is quite limited in what it can access on the computer, outside the browser, for security reasons. So TCP is the simplest way to achieve IPC between Firefox and the rest of the computer.
-
How to Check If All Modifier Keys are Up?
Zohar replied to Zohar's topic in AutoIt General Help and Support
OK then, thank you very much. -
Zohar reacted to a post in a topic: How to Check If All Modifier Keys are Up?
-
How to Check If All Modifier Keys are Up?
Zohar replied to Zohar's topic in AutoIt General Help and Support
Thank you Danp2 Looks interesting - I will test it. It returns a 256Byte array, is there a chance that there's also a function just for Modifier Keys, instead for All Keys like the current one?