-
Posts
276 -
Joined
-
Last visited
-
Days Won
2
Everything posted by JohnQSmith
-
ImageSearch I need it faster
JohnQSmith replied to GeneNight's topic in AutoIt General Help and Support
Letting @Melba23 handle this, but off-topic about the app in the image. If you picked "B", which answer would it select? -
How to get number of sections in JSON file
JohnQSmith replied to ur's topic in AutoIt General Help and Support
Here it is using WinHTTP as suggested by @mLipok $oHTTP = ObjCreate("winhttp.winhttprequest.5.1") $oHTTP.Open("GET", "http://api.github.com/repos/github/linguist/commits?per_page=1") $oHTTP.Send() $header = $oHTTP.Getresponseheader("Link") $numCommits = StringRegExpReplace( $header, '.*page=([0-9]+)>; rel="las.*', '$1' ) ConsoleWrite($numCommits) -
How to get number of sections in JSON file
JohnQSmith replied to ur's topic in AutoIt General Help and Support
I'm guessing you're using CURL because you have either Cygwin or are using Windows 10's Subsystem for Linux. Here's a quick solution using that... curl --silent -I https://api.github.com/repos/github/linguist/commits?per_page=1 | grep "^Link" | sed -e 's/.*page=\([0-9]*\)>; rel=\"last.*/\1/' -
There is no issue with nested switch statements. You just need to use the correct syntax. You need to tell the switch command "what" you are wanting to switch. switch $A ; I want to check variable $A case "apple" ; does variable $A = "apple"? msgbox(0,"","","It's an apple") ; tell me it's an apple case "banana" ; does variable $A = "banana" msgbox(0,"","","It's a banana") ; tell me it's a banana case "car" ; does variable $A = "car" switch $B ; I want to check variable $B case "audi" ; does variable $B = "audi" msgbox(0,"","","Your car is an audi") ; tell me it's a car and an audi case "bmw" ; does variable $B = "bmw" msgbox(0,"","","Your car is a bmw") ; tell me it's a car and a bmw endswitch ; finish testing variable $B endswitch ; finish testing variable $A
-
Multiply the fractional part by 60 to get minutes, then the fractional part of that to get seconds. .81818 * 60 = 49.0908 ~ 49 minutes .0908 * 60 = 5.448 seconds
-
Take a look _PathSplit() from the File.au3 UDF. Edit: You'll have to use two iterations to first grab the RAR and then grab the PARTxx afterwards.
-
The code provided by mikell only makes it easier to create your character array; it does not help with your problem. Perhaps you could clarify what you are trying to do and what exactly is not working as expected. From what I see, you are trying to get the raidcall program to scroll your name in some space of it's display by repeatedly updating the name field. I'm not going to install the program to try it, but your reproducer code works fine if I change your three lines of window access with a ConsoleWrite. Maybe JLogan3o13 can look at your code and "read and figure it out" and possibly provide a helpful suggestion.
-
Can i change cell color in excel with autoit ?
JohnQSmith replied to kcvinu's topic in AutoIt General Help and Support
Just use an RGB color chart and swap the R and the B. -
Is there a way to parse/Read midi files as notes
JohnQSmith replied to Ruben's topic in AutoIt General Help and Support
Try http://lmgtfy.com/?q=convert+midi+file+to+notes. Or if you are feeling adventurous, try http://cs.fit.edu/~ryan/cse4051/projects/midi/midi.html, combined with FileOpen() -
A year and a half later and you're still doing it.
-
No. It's an autoincrement field that remembers the last value. So, if you start from a new database and add 100 records and then delete all of them, the next ROWID will be 101. See here... http://www.sqlite.org/autoinc.html Edit: After reading down on that page, this is not "exactly" true. Quoting from there... Which sounds pretty much exactly like what you are trying to do.
-
Thanks for that. I didn't know about the automatic ROWID.
-
If there is no schema, then it's really not a database; it's just a file with a .sqlite extension. How large is this "logs.sqlite" file and are you sure that it was located in the "sqlitebrowser_200_b1_win" folder that you tried opening it from? If you run sqlite3 against a file that doesn't exist, it will create a new file in the current location with the filename provided. Edit: Also, like @jchd said, try opening it in SQLite Expert or Database Browser for SQLite. They're much friendlier than the command line.
-
Since @gcue doesn't appear to have a large working knowledge of databases and @jchd's attitude is bigger than his patience... @gcue If you don't have the sqlite3 executable, you can get it from http://sqlite.org. From the command line, run: sqlite3 yourdatabasename Then when you get the "sqlite>" prompt, type and enter: .schema You should end up with something similar to the following CREATE TABLE person ( id INTEGER PRIMARY KEY, first_name TEXT, last_name TEXT, age INTEGER ); Copy and paste that in a reply and @jhcd might a little more accommodating.
-
Dr R. Hipp keynote at PGCon 2014: SQLite / PostgreSQL
JohnQSmith replied to jchd's topic in Developer General Discussion
I watched it yesterday after seeing a link to it posted on the Fossil-SCM users mailing list; he wrote Fossil to maintain the SQLite code. Awesome material. -
Best Practice for renaming a bunch of files
JohnQSmith replied to reaper1gulf's topic in AutoIt General Help and Support
Since we're going to "give a man a fish" today, here's a CMD prompt line you can run in your folder that will do the same thing. for /f "usebackq tokens=1,2 delims=." %i in (`dir /a-d /b *.*`) do ren %i.%j %i_%j.%j -
Very nice simple Lisp interpreter. Good job.
-
Check out RenameMaster at http://www.joejoesoft.com/vcms/108/.
-
pixelchecksum newbie question
JohnQSmith replied to awayne's topic in AutoIt General Help and Support
Also, if you have font smoothing (i.e. ClearType) enabled, sub-pixel rendering might be different on one location of the screen as compared to another. -
If you're talking about your local checkout, from that folder you will want to run svn update This will update your working copy to match what is on the server. You don't need to check if your working copy and the server have matching versions as the update command will either update your checkout or do nothing if you're already at the same HEAD revision as the server.
- 1 reply
-
- SVN
- Auto-update
-
(and 2 more)
Tagged with:
-
Paper, Rock, Scissors - Challenge
JohnQSmith replied to guinness's topic in AutoIt General Help and Support
It doesn't matter to me one way or the other... I was just being pedantic. Edit: You're still my hero, guinness. -
Paper, Rock, Scissors - Challenge
JohnQSmith replied to guinness's topic in AutoIt General Help and Support
Wouldn't rindeal's modified Melba23 script be the winner? One line of code with no declaration vs. one line of code and one declaration ( two lines... yours doesn't run without a warning without the declaration ). Original requirements said nothing about having to use variant datatypes.