rproffitt 2,701 https://5calls.org Moderator

https://en.wikipedia.org/wiki/PHP gives a history of PHP and frankly it's none of the ones you noted. It appears to be a new organically grown language that wasn't intended to be a language at all.

Dani commented: Untrue -8
rproffitt 2,701 https://5calls.org Moderator

Our scenario was a product tester. Also known as Automatic Test. The SQL Server was on the network and there's only a dozen test machines which would spend about 10 or so minutes per device under test. So the load was never worth optimizing. The IT department would fret about having automatic tests overload their SQL Server but they could never show any increase in load during production runs. In other words, negligible load.
What was up on the SQL Server of interest? The order details. The product was configured to the client's order during this phase of final testing. So it was either have a human type all that in or automate it and go get it from the order database. You can guess what's cheaper.

rproffitt 2,701 https://5calls.org Moderator

I recall the caching of queries is something from about the 1990's. But hey, there is query caching (apparently) in SQL Server 2008. Plenty on the web about it such as https://dba.stackexchange.com/questions/43572/how-to-see-what-is-cached-in-memory-in-sql-server-2008 where with a little code you can see what is in the cache.

My heavy work on SQL was in the late 1990's till about 2010 when we did the end of life on that product line. So for now I cruise along on what I recall from those days. That is, we found that the overhead of a repeated query was too low to optimize away/out with more code or an addon product. That is, we learned to let the SQL Server do what it did best and work on the product side.

rproffitt 2,701 https://5calls.org Moderator

Given the tags asp.net and C# I don't know of a quick as in ready to code solution. Now if you had PHP on the backend, there are PDF utilities to create PDFs. What have you found for asp.net so far?

mtyide commented: They are all costly solutions. Need something quick and free, can't find one. +3
rproffitt 2,701 https://5calls.org Moderator

As I read https://dev.mysql.com/doc/refman/5.7/en/query-cache.html my view/answer is I wouldn't bother optimizing in this situation.

rproffitt 2,701 https://5calls.org Moderator

OK, let's check out Android support. https://riptutorial.com/selenium/example/29267/python-plus-chrome-plus-android
Fine, that's a go. You do iOS?

rproffitt 2,701 https://5calls.org Moderator

Since I don't have to build or buy Chrome, Python or Selenium I am left wondering what's missing.

Robotic interacting with a web page isn't something I can buy as a ready to click here package unless I farm out the spec and get someone to write a little code.

Remember I've been guessing what you are trying to accomplish. Right now it appears you want Chrome since it has the A+ score and then to "do something" on "some sites."

rproffitt 2,701 https://5calls.org Moderator

I am only beginning to GUESS what you want to achieve. So let's say I wanted to automate Chrome which has an A+ rating on your test. OK, I'd use Python and Selenium. Example article at https://python.plainenglish.io/create-your-browser-automation-robot-with-python-and-selenium-ed0db1d6d65d

rproffitt 2,701 https://5calls.org Moderator

I tested that trust score on the current version of Chrome on Windows 10 and it was an A+ rating.

Tell me what you are trying to do so I can think this through. Maybe it's some sort of auto-bot but I can't tell what your goal or what you were trying to create.

rproffitt 2,701 https://5calls.org Moderator

Reading https://www.quora.com/How-can-you-determine-the-trust-score-assigned-by-search-engines-for-a-given-website for example this score does NOT appear to be linked to the browser used.

Can you define "high trust score"?

rproffitt 2,701 https://5calls.org Moderator

Maybe its time to let the members choose tags like they do on Reddit.

rproffitt 2,701 https://5calls.org Moderator

I've seen this issue for years. It's not a show stopper but for me explains why many add tags that don't belong.

rproffitt 2,701 https://5calls.org Moderator

No code so this is a Design discussion. It's yours to make or the client's choice what the result should be but I can see how a SQL statement might be "ACME" and "APOGEE" which our Wile E Coyote may want to get both products as his experience has been awful with ACME.
So my thought is that the search would be for the rocket skates would be what both companies offer rather than a result of none.

rproffitt 2,701 https://5calls.org Moderator

Without detailing what it does, my nod is to https://docs.microsoft.com/en-us/dotnet/api/system.globalization.cultureinfo.defaultthreadcurrentculture and its example.

Given it affects the current and new threads, this line of code should appear too often.

Also note CurrentUICulture as it may be a good idea to implement or at least know about it.

rproffitt 2,701 https://5calls.org Moderator

This is one of those I would turn to Rosetta Code.
https://www.rosettacode.org/wiki/Letter_frequency has over 124 solutions in various languages.

While a student would have such as an assignment, later you are IRL and want to get the app done without re-creating the wheel.

rproffitt 2,701 https://5calls.org Moderator

Or replace D7 with a Schottky diode to minimize the drop and adjust your voltage divider to cancel out more of the error introduced by the source reverse polarity protection.

R2 and R3 could likely be 10X higher in value to avoid throwing off the Vin voltage. I don't know everything about your application but if protecting the node that contains U18 pin 3 is the goal, then a very small capacitor there in the order of say around 100pF might be added from U18 pin three to GND.

If you think there is noise on what looks like a voltage divider of R7, 6 and 7, you can add small filter caps to quiet that section.

I'm just a gray hair electronics designer.

F1dark commented: Your given solution is quite clear and simple. +0
rproffitt 2,701 https://5calls.org Moderator

Taylor Hyles wrote that in 2016: Be sure to give credit to their contribution:

import java.util.*;
import java.io.Console;

public class FourDigit {

public static void main(String[] args) {
  Console console = System.console();
  LinkedList<Integer> stack = new LinkedList<Integer>();
  int digits = 0;

  do {
  String response = console.readLine("Enter a four digit integer:");
   try{
    digits = Integer.parseInt(response);
   }
    catch (NumberFormatException e){  
    }
    if (1000 > digits || digits > 9999){
      System.out.println("Please try again...");
    }
  }
  while(1000 > digits || digits > 9999);

  while (digits > 0) {
    stack.push( digits % 10 );
    digits = digits / 10;
  }

  while (!stack.isEmpty()) {
    System.out.println(stack.pop());
  }
}
}
rproffitt 2,701 https://5calls.org Moderator

What control panel? Be specific.
Also a nod to https://support.hp.com/us-en/document/bpj07429 about printing a sheet at the printer along with said update.

This sort of device does NOT plug and play. There are many steps to get it working on a network and some networks require steps that are not required on all networks. The skill level for this device is "advanced." Not only that the product is used so it could be a DOA so be sure to print the sheet of information per HP to see if the card even shows up.

rproffitt 2,701 https://5calls.org Moderator

Continuing from our last discussion, I know what I would do but it hasn't dawned on you why that would be the fastest.
As such, post over in https://www.mongodb.com/community/forums/ to see what they say.

rproffitt 2,701 https://5calls.org Moderator

There are far too many issues with vb6 and Unicode. For example: "Visual Basic controls are not Unicode aware."
Also, "Strings passed to API are converted to ANSI and vice versa"

But hey, good luck with your attempt, there are prior discussions about this but no one I know will attempt making new VB6 apps or anything beyond simple fixes (which this is not!)

rproffitt 2,701 https://5calls.org Moderator

Sadly, there's been a lot of opengauss spam. I've used SQL databases for decades and Oracle just once. Ever since MySQL rolled out that's what we use along with SQLite.

Nobody is looking at openGauss except spammers it seems.

rproffitt 2,701 https://5calls.org Moderator

I'm leaving my typo as-is. I take it this is on Daniweb. Link to the content please?

pritaeas commented: Any chat message, but I tried to delete the phone number in the programming chat room +0
rproffitt 2,701 https://5calls.org Moderator

What isn't a good idea?

I propose your database starts with ZERO entries until there is a query. Obviously you will have to go get a location from some other service for that query but now you can put that into your database. After a few hundred queries your database will start to have IPs that your clients use over and over. And it only gets better from there.

What isn't a good idea: Go get a copy of an IP location database and host it yourself incurring a lot of storage fees.

What is a good idea: Don't store millions of IP locations and essentially cache the ones you do get a query for. A fraction of the storage needed and will dynamically grow only as needed.

rproffitt 2,701 https://5calls.org Moderator

No power is also a motherboard function. A Volt meter is used to check if the +5V StandBy is present and then we know the motherboard is the one to call for power on the green wire (see Green Wire PSU Test on google) but hey, if you feel it's the PSU, a little cheaper than most motherboards so why not get a good one?
At the shop the tech bench always has a spare to swap to test for this area. As a PC repair person you can't go far without good spares.

Alpha_6 commented: Yeah you are right. I guess I have to take it to some repair person, they might look better into it +0
rproffitt 2,701 https://5calls.org Moderator

"2." I meant what I wrote. DO NOT FILL THE DATABASE. Start with zero entries until you get a query then go find that via some web API and add that to your database. It's highly likely that in a short amount of use you'll get repeats and not have to go find new data.

sankar2000 commented: if i search for ip_hex: '0x234504252ca1000000000567567323b5' in 102 mil results ... i don't think is a good idea ... it will go into full text search +0
rproffitt 2,701 https://5calls.org Moderator

I think it's time to see if https://twitter.com/davepl1968 has an answer. While I can see a reason for the spy tool to give client coords vs screen coords and I did live near Redmond in the 90's I wasn't a MSFT engineer and only had to deal with Windows app development in about 1997 and on. Before that it was all about embedded work on a slew of microprocessors and of course, DOS.
Lucky me caught a seminar with Bill Gates talking about device independent graphics and the troubles with screen and app coordinates but that was around the Windows 1.0 days and given it was so long ago, the details are too fuzzy but it was leading edge back then.

Time to see if you can get the attention of people like Dave Plummer.

rproffitt 2,701 https://5calls.org Moderator

Find the dev pages usually by google and see what they say when you ask them.

rproffitt 2,701 https://5calls.org Moderator

Try this. Bump the app window border up to something big, like 20 or more. What does the spy tool tell us now?

rproffitt 2,701 https://5calls.org Moderator

So the BIOS setting has been changed, the new CMOS battery installed, CMOS values set to default except for fast boot and it fails. The usual is a failed motherboard.

Alpha_6 commented: Can't it be the PSU? Cause mine is a chinese PSU and I was already facing no power issue sometimes, like when I press power button nothing happens. +0
rproffitt 2,701 https://5calls.org Moderator

I'm finding today's browser cache content like no tomorrow. To see the new content or check if a deleted item is gone I try another browser or clear the cache(s). If the content is still there and this is Daniwed, message Dani and see if she can remove it.

rproffitt 2,701 https://5calls.org Moderator

Looking around for example code to draw on the Windows screen rather than in the app. Hmm, interesting.

rproffitt 2,701 https://5calls.org Moderator

The tool you mentioned is reporting (according to what I'm seeing) the client coordinate because AUTOIT code may need that to say move the cursor to x,y in the app and then click there. But for app placement on screen, that would use the Windows desktop coordinate system.

I just thought of another reason a full screen app has a 7 or 8 pixel border. If a maximized app did originate as screen coord 0.0 then the app would have to never place text at 0,0 because of the aesthetics. Since Windows started way back when some of the coord system is to make life easier for coders. That is, if your app had to constantly add 7 to x.y to avoid putting text and objects right at the monitor border, what a painful thing to inflict on all that write code.

The more I think about this, the more I think they did the right thing.

rproffitt 2,701 https://5calls.org Moderator

Try the solution at https://forums.tomsguide.com/threads/no-windows-no-uefi-just-a-black-screen-and-short-ticking-every-3-seconds.111128/
But at this age board, we try a few things then replace the board and whatever else is required if we have to change to a board that doesn't support the old CPU and RAM.

Also, we always pop in a new CMOS battery at such age because the battery is 25 CENTS in bulk. Troubleshooting low CMOS batteries is many dollars so we never do that. Put in new. Still, once in a while a tech will get upset at popping in a fresh 25 cent battery. Chalk it up to being a new tech?

Alpha_6 commented: In my case fastboot is already disabled. I am really confused because I have the same motherboard and same issue, but I can't solve it +0
rproffitt 2,701 https://5calls.org Moderator

I'm sure there's a tutorial about Windows coordinate systems out there but from memory the client window is the area inside the borders you see in a non-maximized app. So if the app's border is 7, then from the client area to the top left edge of the app would be -7, -7.

If the client coordinates included the border then folk that write apps would have to query border width then adjust for that to place controls and other app elements.

So back to app placement we use screen coordinates and not the client coordinates. That is, place the app at screen coordinate x.y. And for a button, place the button at client coordinates x,y.

rproffitt 2,701 https://5calls.org Moderator

I think it's explained by the following: "Au3Info allows you to get information from a specified window that can be used to effectively automate it."
The tool appears to be fetching client coordinates.

rproffitt 2,701 https://5calls.org Moderator

Which page? What editor?

Daniweb hasn't implemented a "copy code" feature that you see elsewhere.

pritaeas commented: I smell a feature request ;) +0
rproffitt 2,701 https://5calls.org Moderator

Is this the window.open issue on iOS and a lot of browsers?

rproffitt 2,701 https://5calls.org Moderator

Apps will have screen coords for the app placement and then the client area of said app.
I see this mentioned widely but you can see it in one paragraph at https://docs.microsoft.com/en-us/windows/win32/gdi/window-coordinate-system

Note screen coordinates and client coordinates.

rproffitt 2,701 https://5calls.org Moderator

Most likely answer: You can't rely on window.open because browsers may have different policies. Google prior discussions about this: https://www.google.com/search?client=opera&q=ios+window.open

rproffitt 2,701 https://5calls.org Moderator

The omission of all PC details means I'll stick with the usual fix which is a new motherboard.
Example: https://forums.tomshardware.com/threads/my-pc-wont-start-until-i-remove-and-reinsert-my-ram-or-turn-off-psu-after-shutdown-then-turn-it-on.3141531/

Alpha_6 commented: Pc specs: Processor: Intel i5 4590 Motherboard: GA-H81M (2 ram slots) Ram: 2x4gb ddr3 +0
rproffitt 2,701 https://5calls.org Moderator

From memory this is the area you paint in. The coordinate of the app might be at 0.0 but the border might be 7 wide so there are absolute windows coordinates, window bounding coordinates and so on. Try making the app full screen borderless and see what the spy says.

rproffitt 2,701 https://5calls.org Moderator

To @Felonely. Code does what the code does and not always what we want. Unless we see your code along with you telling what it did and what you want, no one can guess what was going on.

rproffitt 2,701 https://5calls.org Moderator

Here's to a speedy recovery.

COVID BA.4 and .5 have an R0 value of 18. Original COVID was about 3. You can see what's going on in the usual charts.
North Korea doesn't stand a chance on this variant.

rproffitt 2,701 https://5calls.org Moderator

All that but no indication of where you are stuck or if you wanted others to write this app for you.
This sounds like homework so let's hear:

  1. Where are you stuck?
  2. Show the relevant code section along with the error if there is one.
Felonely commented: I have actually tried writing some stuffs but it never seem to work the way i want. +0
rproffitt 2,701 https://5calls.org Moderator

Wait? What? https://en.wikipedia.org/wiki/Microsoft_Excel tells us this is Excel from 1992 or 30 years ago. I haven't seen that old a version of Excel in over 20 years and back then it didn't have the capability to call a DLL!

My advice is to forget this and write a new macro or if there's a typo in your post, correct that version.

rproffitt 2,701 https://5calls.org Moderator

No mention of the compiler. For Visual C++ the text file has to be in a certain folder but without knowing which compiler you use and host OS I can't see if that's the problem.

rproffitt 2,701 https://5calls.org Moderator

Weird assignment. No bank I know would code this in C++ today. It would be some web server and backend systems.
But hey who said what they teach you in school would be what is used today?

As per the Community Rules, show your work and if not at least tell where you are stuck. You should be at the point you can write code to present the menu at the very least.

Schol-R-LEA commented: Agreed on what you said about how unrealistic this is, but as you say, no one ever sais class assignments had to be realistic. +15
rproffitt 2,701 https://5calls.org Moderator

DOS you say? https://en.wikipedia.org/wiki/DOS reminds us this was prevalent during the 1990's but has not been seen by most in the last two decades. Maybe you meant something else or are you dealing with some legacy gear?

Many bootcamps are ways to part you from your money. Try https://www.w3schools.com instead.

rproffitt 2,701 https://5calls.org Moderator

I have to ask why this would have to be known. For me all I care about in SQL is price for the system, performance and the platforms (hardware and OS) it runs on. After that I might check that it's really SQL.

Tell me what is making you ask this question.

rproffitt 2,701 https://5calls.org Moderator

Wait, what? I show you're in Florida man!