Posts by rproffitt

Was there a question?

You asked many questions so I'll attempt to cover a few of them.

1. Regarding the connection string:
   This is why long ago I would change my connection string to connect to 127.0.0.1 so the name was never an issue.
   There are so many articles about this so I'll offer one and you can find others.
   Read https://www.oreilly.com/library/view/adonet-cookbook/0596004397/ch01s07.html

2. "make it exe file with the database"
   There are a few ways to do this but one method that worked well for me was to write code that would test the SQL connection and then see if the tables were there. If not, the code would create tables and insert the starter data.

3. I also like this Quora answer:

   Use the publish wizard to publish a click once application.
   Under prerequisites make sure SQL Server Express is selected.

Read https://www.quora.com/How-can-I-deploy-my-project-attached-with-SQL-database-Im-using-VB-NET

Line 1 appears to have a misspelling.

Given only that detail and a picture I'd disable Graphics Acceleration in Windows and the browser you are using. If that helps then we move to one area of discussion and if not, another area.

https://www.thewindowsclub.com/hardware-acceleration-windows-7 seems to cover 7 and 10.
Google how to disable this in the browser too.

This needs more context and the usual minimum viable example so others can replicate the issue.

I'll skip supplying a link where others have discussed this issue because your discussion lacks details.

For the beginner, how much of a beginner are you?

Some have no computer skills, don't know what an integers, array or what random is. Those with some basics out of the way can go to tutorials such as https://www.tutorialspoint.com/cplusplus/index.htm and then as we say "Google is your friend."

Don't be vague. What would it take for you to start your work?

For meayrs, it's time to read https://www.upguard.com/breaches/power-apps

Frankly I've written off MS-Access for decades. I'd use some SQL system if a local store isn't an option. What local store?

1. My.Settings
2. Files such as CSV or other common format.
3. SQL of almost any out there.

That's what I read often enough such as https://www.vbforums.com/showthread.php?861281-How-to-store-data-in-VB-net

This appears to vary a little from version to version of IIS.

Let's start with what Microsoft writes at https://docs.microsoft.com/en-us/troubleshoot/iis/configure-default-document-iis

Did you read the Wikipedia on these. I read one at least if not more and felt they did an excellent job of explaining how they work.

But understanding how they work may not give a beginning programmer all they need to know to "code it up." Remember you didn't reveal this is homework as well as what the assignment was. Imagine the poor student that was assigned yet another Time Complexity piece of homework but wrote what you did and left out what they really needed to do. Nod to https://en.wikipedia.org/wiki/Time_complexity

As to learn these two algorithms, in all the classes I took over the year the algorithms were in the text that was part of the course. Today we can supplement that with the web but did the prof forget to supply "source material"?

I'm reading https://www.daniweb.com/programming/databases/threads/510152/the-best-way-to-store-ipv4-ipv6 which also reveals the INET6_ATON and maybe the other function you'll be asking about very soon.

This is so close to what is known as the Caesar Cipher that well, let's find 140+ samples to start with.

Read https://rosettacode.org/wiki/Caesar_cipher

Given this is so well done and you only added one slight change, this should be enough for now.

I read the Wikipedia on this and came back that I would not code this at all but use the search calls/APIs that are currently in whatever language I'm coding in now. If I felt one method was better than the next I would test it using each supplied search against a few test sets and be done with it by days end.

Maybe there's some homework assignment here but that was not told.

This looks like homework as few of my work projects demanded the UML diagram.

Let's discuss what's stopping you from doing this homework.

I don't have your database to test against so for now drop some debug echo or prints on those lines 11, 13 and after 15 to show where in your code it stopped.

example:
11 print "Now at line 11"
13 print "Now at line 13."

Spiffy up for formatting and maybe print how many records found.

Didn't anyone tell you to never store passwords in the clear like that?

More at https://www.google.com/search?&q=never+store+passwords+in+a+database

Also, with so many login, password examples on the web, why did you decide to create yet another one?

As noted in your other discussion line 2 of run.bat needs to cd to the proper folder. Use the full path.

Why? When you start a shell (cmd.exe or other) some OSes don't start execution in the folder you want.

IMO that's too vague a question. What scale is this to be? Will you support more than one country and language?

Next time put that code in a reply.

See the CD tools line? Change tools to the full path to where you need to go. You are not assured your cmd.exe will start in a specific folder/directory.

While you did not share the contents of run.bat my guess is the current directory does not have dw.exe.

Maybe the simplest fix is to add the CD command to your run.bat to change to the folder with dw.exe.

My brother is turning off his Quickbooks Cloud in a few months. Why? Recent price increases and he can do the accounting without their cloud.

As to server reliability it's not hard to make your own cloud. Also, in over 2 decades we've yet to see a hard drive failure. Why? We get reports ahead of time with SMART plus we know what to look out for.

I've read such claims before and my view is it's inherently unsafe. That is, if your business ERP is its lifeblood and the cloud provider you used is shut off by any of the usual methods or events then your business is toast.

Nod to https://www.forbes.com/sites/joemckendrick/2012/08/06/apple-co-founder-steve-wozniak-distrusts-the-cloud-is-he-right/?sh=43af80ce6042

If you do decide to go with a cloud solution, does it also have a system you can run on your own local server?
If not, that cloud ERP is unsafe.

The list of "What could cause this?" can be long. You mention cloud, API upload so my first thoughts which are guesses since I see no code or much details are:

1. The DNS lookup could fail since what they used and what you use can differ.
2. Your ISP could restrict traffic.
3. Your server if this runs on a server could have restrictions.
4. The script has a defect.

Remember these must be guesses given the story so far. Also the code could be flat out broken and really doesn't work.

Did you try a Javascript LINT (code checker)?

Are you sure you can't use Microsoft's supplied text to speech system?

Noted at https://en.wikipedia.org/wiki/Microsoft_Speech_API

I don't believe you here. 200 MB today would be well under a minute to backup.

https://www.quora.com/How-long-will-it-take-to-transfer-a-1-GB-file-size-on-a-USB-2-0-and-a-USB-3-0-drive notes that a mediocre USB drive is a slow 10 MB per second so about a 10 second wait.

Maybe you feel this is a long time?

I worry here. That is, how else would you get the information needed to process the payment?

Answer: It's legal to be paid for a product or service.

I can't guess the host OS, configuration and more but for us we would just FTP the files out to a new location, email them or something else. I can't guess what the server is here so it's unlikely I'll know how it's done for this server.

Since you need this, your host/employer should tell how to get this done if you can't find a way on your own.

Since you mention cooperate, I take it this is an agreed upon data share so no programmer would be required.

If this is to get data without the operator's consent then this thread dies right here.

-> If you need a programmer to use said data, there are plenty of programmers for hire on dozens of quality freelance platforms out there. It costs nothing to get some quotes on the work you need today.

That line 258 may need something like https://newbedev.com/how-to-convert-mysql-timestamp-to-date-time-in-php

As I don't know what your MySQL data looks like all I can do is guess that you'll have to keep $row->exstdate . ' ' . $row->exstime but put that into the example at link.

Maybe?
$new_datetime = DateTime::createFromFormat ( "Y-m-d H:i:s", $row->exstdate . ' ' . $row->exstime);

Nod to PHP usages at https://www.php.net/manual/en/datetime.diff.php

I'd like to hear more about this PC, the make, model, age of the DVDRW along with any other messages from say IMGBURN.

We have an open discussion on this. Let's continue there.

I see I was unclear. I was addressing your statement about $new_status by creating a minimum viable example. What it revealed to me was your one supplied line of code may not be doing what you expected. The 15 lines of code does work and $new_status was used and I see the output from the echo statements.

Take a trip to w3chools to use their online PHP tool to try it out.

Also, I can't guess what your single line of code's intent was. That's up to you.

That's good it can do 7 or fewer addresses which proved the code is close to working.

Now you need to talk to your email provider about how they throttle email sending. Remember this is NOT BROKEN but by design to halt spammers.

Also, you neglected to reveal all the details so no one can do more than guess.

$new_status seems fine in my test. But your $sendData statement? I can't tell what your intent was there.

Here's what I tested with an online PHP tool.

<!DOCTYPE html>
<html>
<body>

<?php
$new_status = "01010101";

$sendData = '{ "messages" : [ { "content" : "Your order is $new_status.", } ] }';

echo "<h2>" . $new_status . "</h2>";
echo  $sendData . "<br>";
?>

</body>
</html>

Thanks Dani.

My years of carrying an Apple iPhone ended when Apple, the Genius Bar failed to find a way to reset their security questions. I had my password, my account but had forgotten to record my security questions.

This results in two forever locked iPhones. After three years of trying to correct this with Apple, I decided to clear our inventory at the office of all Apple devices and move on.

What happened to these iPhones? I gave them to a local repair shop so they could use them for donor parts. Shame since if I were able to remove them from my account I might have sold them off or gifted them to students at the local college.

Goodbye Apple.

Small world. My last W2000 SP4 (I mention SP4 because it matters when we run this old OS) was a:

Self made PC with (two!) Pentium Pro II Overdrive CPUs. See http://www.os2museum.com/wp/intel-overdrive-part-iii-pentium-ii-overdrive/ for an idea of the power of the dark side back then. (We have cookies.) I had maxed out the RAM on the machine at 64MB (expensive back then) and for the HDDs it was some SCSI RAID 0. The graphics card was some early Nvidia or 3DFX. When it came time to move on I changed out the HDD array to a simpler single IDE drive which was the style at the time. Nod to the PS below! Otherwise the new owner would not be able to deal with SCSI rules.

All that aside, I can't tell if your setup ever worked yet but you do want to try the USB LEGACY settings in the BIOS and use PS/2 connected mouse and keyboard.

-> Thanks for the memories!

PS: "We can't bust heads like we used to. But we have our ways. One trick is to tell stories that don't go anywhere. Like the time I caught the ferry to Shelbyville. I needed a new heel for my shoe. So I decided to go to Morganville, which is what they called Shelbyville in those days. So I tied an onion to my belt, which was the style at the time. Now, to take the ferry cost a nickel, and in those days, nickels had pictures of …

I ran W2000 SP4 for close to a decade so I'll share that as new hardware came out with USB keyboards I had to test it with USB Keyboard Legacy (can be any name like that) on and off.

-> Your PC details are nil so I can't guess if it worked before or you are trying to run W2000 on modern hardware.

I was unclear that I make no attempt to write your code. I will discuss methods that I use to get the queries I use in my systems.

I would get my first query working before I added more rows with the UNION. So far it sounds like you haven't refined that first step and are getting more than one row in the result. That is where two SQL concepts come into play. 1. The LIMIT and 2. If it's the wrong item such as not the very last, the ORDER can be used.

For your first attempt you get a single category working and then can extend it with the UNION or maybe a loop in PHP and further SQL queries to output the table or what you want.

I don't see why this should work at all given the error output. You need to resolve the errors given such as "CodeTaskFactory."

YOU get to fix that and the other errors. Sometimes folk think this is a simple fix, sometimes it is but right there in the error is why.

Let me ask why do this at all? If you want to run a website there are much easier ways to put together a site.

Remember I am reverse engineering here and will most likely misunderstand your code.

It looks like you are trying to collect the blog categories in line 4. I wonder if you need to add the DISTINCT word there?
https://www.w3schools.com/sql/sql_distinct.asp for reference.

I bet I misunderstood that but hey, the method I'd deploy would be to collect the categories (nod to DISTINCT) then use another query to find one per query (LIMIT?)

Sorry but your reply above seemed to state your SQL returned one row. That is what I addressed using what you have revealed so far about your new SQL query. Maybe you need to share your code here.

Moving on, I didn't design your table as well as can't see the design so I can't address if the design supports your other goal but hey, I would work this in pieces. That is I'd get my query to return 1 row per your need before I added UNION and the next query for that next row.

I can't guess how many blog categories you have so that problem may have to coded to something more advanced such as a query to get how many and what these categories are, then those row results are fed into a new query that iterates over the categories. I would not do that right now but work the issue about the single row first along with a query that can pick up each category with the 1 from each category. Once I have that I can roll back to the top to make a query to find how many and what categories there are, THEN and only then tackle the full on solution. The end solution as I see it won't be a single query. Maybe someone else can do this in a single query?

If your SQL final statement only returned 1 item total then that might be correct but I can't see what you tried. In psuedocode it should look like:

SQL something something LIMIT 1
UNION
SQL something something LIMIT 1

If the query of each fetched 1 then you should end up with two rows.

This would be a very bad thing. Authors that don't release their works into the public domain would be deprived of income and more.

-> No one needs this.

Just a thought. Why is ob_start(); in what looks like line 1?

I'm reading https://www.php.net/manual/en/function.header.php

If this was mine I'd log or echo $expiry on line 20 to make sure this variable is what it seems.

Let's check out line 10. It looks like you not doing a comparison but an assignment. The old single vs. comparison operator issue?

Read https://www.php.net/manual/en/language.operators.comparison.php

I see you used the UNION so that would be my first thought. Now you have that, maybe you only need to add a LIMIT.
Tutorial Links follow:
https://www.tutorialspoint.com/sql/sql-unions-clause.htm
https://www.tutorialspoint.com/sql/sql-top-clause.htm

Looking over the ideas from HAK5 (YouTube, forum, etc.) you would never stop with any one OS or system. I must ask the following: Why stop here?

Welcome.

Weren't No Credit Check Loans considered a bad idea recently? I guess they're back (insert Johnny Meme here.)