Jump to content

Zohar

Active Members
  • Posts

    841
  • Joined

  • Last visited

Recent Profile Visitors

845 profile views

Zohar's Achievements

Universalist

Universalist (7/7)

6

Reputation

  1. 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
  2. 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
  3. You're right.. Searching for windows registry run at shutdown indeed gives relevant results. I will try it now, thank you.
  4. 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?
  5. Hi all I need a small script to run every time the computer is Shut Down (or Restarted). While for Starting there's the known CurrentVersion\Run registry key, Is there something also for running a program just before Shutdown/Restart? Thank you
  6. Thank you very much jchd Does AutoIt have Functions for Sanitizing input strings? For example for SQL, for HTML, for JavaScript, etc..
  7. 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?
  8. 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.
  9. 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
  10. 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.
  11. Thank you very much Chimp. Can you please explain the RegExp line? What does "\w{2}" do?
  12. 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.
  13. 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?
×
×
  • Create New...