Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

After line 18 you add some code to the effect

if (pledge >= 100)
        {
            numMugs++;
        }
Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

At 1000 transactions per day it does matter what kind of database you use. I once had to support an application built on Access. Once the database got to a certain size we had to do a rebuild weekly because it kept crashing. At 1000 transactions per day you'll run into problems soon enough. Unfortunately the developer did not isolate his db code, and he used built-in functions rather than ADO which would have made conversion to MSSQL much easier.

I suggest a database with proper design/maintenance tools such as MSSQL.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

On the one end of history you have "I cannot tell a lie" Washington, and on the other, "I cannot tell the truth" Trump. It shows you just how far the country has come as a people.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

You guys tell me which you would prefer:

Doesn't matter to me. For anything more than a few lines I use MarkdownPad, then copy/paste into the thread.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

You can find that here.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

If you are only interested in the number of rows of something then do

SELECT COUNT(*) FROM test [WHERE...]

Doing

SELECT SQL_CALC_FOUND_ROWS * FROM `test`

is a waste. In the first case, all the db has to return is the record count. In the second case it has to return all of the rows.

cereal commented: thank you! +14
Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

The letters in Fine print at the bottom can be rearranged to spell Often the important bit.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Ah. As is the case with so may online tutorials, they get you 99% of the way there then leave out the 1% that actually makes it work. In the example, you load the video into the playlist by executing

vlc.playlist.add(OpenFileDialog1.FileName)

In ac tuality, what you have to execute is

vlc.playlist.add("file:///" & OpenFileDialog1.FileName)

Once I made that change the video played. That's sort of an important thing to leave out. Another thing I find with sample code and/or tutorials is when they leave out

  • What Imports are required for the code to work
  • What references must be added to the project for the code to work

These are the things that the "experts" omit because they assume that everyone else knows to add them, but they forget that if the people who watch the videos already knew what to do then they wouldn't be watching the videos.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

The Microsoft documentation for the use of embedded WMP is obtuse at best. It describes the pieces without giving any useful information on how to use them. Having said that, I have not found a way to enable/disable the individual controls. They appear to be managed by the object itself and only change states as required when you "press" the given controls as exposed through the IWMPControls collection. If you are interested in my use of embedded wmp you can have a look at this article that I posted two years or so back.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

I recently rebuilt a friend's PC. He had dual boot Vista/Win7. All I had to do was run msconfig, go to the boot tab and remove the Vista entry. Once I had done that I was free to delete all of his Vista folders.

rproffitt commented: +1 for the end of Vista again. Office has no more Vista machines. Hurrah. +12
Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Here's a handy tip I haven't seen documented anywhere. If you have an Explorer window open, do the following

  1. Click in the address bar to the right of the address so that the entire address is highlighted/selected
  2. Type cmd in the address bar so that it replaces the address
  3. Press ENTER

A command shell will be openened at the folder that was displayed in the Explorer window.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Check the root of the external drive and see if there is a hidden file named desktop.ini. In my My Documents folder it contains

[.ShellClassInfo]
LocalizedResourceName=@%SystemRoot%\system32\shell32.dll,-21770
IconResource=%SystemRoot%\system32\imageres.dll,-112
IconFile=%SystemRoot%\system32\shell32.dll
IconIndex=-235

and in My Music it looks like

[.ShellClassInfo]
LocalizedResourceName=@%SystemRoot%\system32\shell32.dll,-21790
InfoTip=@%SystemRoot%\system32\shell32.dll,-12689
IconResource=%SystemRoot%\system32\imageres.dll,-108
IconFile=%SystemRoot%\system32\shell32.dll
IconIndex=-237

Note the diffent values for IconIindex. My guess is that your desktop.ini files have been created and/or modified to change the icon. You can delete the desktop.ini file if you like but you may have to

attrib desktop -s -h

first to make it visible.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Whenever I am asked, "what language should I learn first", my answer is always, "English". Being able to communicate effectively is going to be your biggest asset. For example, your thread had the extremely uninformative title of "need help". As an effective communicator you should have taken the time to compose a more useful title. On most forums, a title like "need help" would be lucky to get any response.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

FYI, the query to insert only new values was

   'I know the vbCrLf is not required at the end of each line but it makes it
   'so much easier to see what's going on when debugging.

   query = " insert into Analog_Key (                                      " & vbCrLf _
         & "   Station_Name,                                               " & vbCrLf _
         & "   Device_Type,                                                " & vbCrLf _
         & "   Point_Name,                                                 " & vbCrLf _
         & "   Point_Type)                                                 " & vbCrLf _
         & " select                                                        " & vbCrLf _
         & "   WorkingTable.Station_Name,                                  " & vbCrLf _
         & "   WorkingTable.Device_Type,                                   " & vbCrLf _
         & "   WorkingTable.Point_Name,                                    " & vbCrLf _
         & "   WorkingTable.Point_Type                                     " & vbCrLf _
         & " from                                                          " & vbCrLf _
         & "   WorkingTable                                                " & vbCrLf _
         & " where not exists (                                            " & vbCrLf _
         & "   select * from Analog_Key                                    " & vbCrLf _
         & "     where                                                     " & vbCrLf _
         & "       Analog_Key.Station_Name = WorkingTable.Station_Name and " & vbCrLf _
         & "       Analog_Key.Device_Type  = WorkingTable.Device_type  and " & vbCrLf _
         & "       Analog_Key.Point_Name   = WorkingTable.Point_Name   and " & vbCrLf _
         & "       Analog_Key.Point_Type   = WorkingTable.Point_Type       " & vbCrLf _
         & "    )                                                          "

The above query relies on a previous step in which the raw data was bulk loaded into an empty working table.

The engineer who got my job when I retired (and who has moved up the corporate ladder since) was kind enough to send me my old code. I was pleased to see it is still in service and still unmodified since I left.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Or you could skip the last if and just use

while (pick !== 'quit')
Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

I was being laughted at

Oh, Woj. We are laughing at you for so many other reasons.

diafol commented: Wingnut of the highest order :D +0
rproffitt commented: Ever use more than one wingnut on a thread? Sometimes they deadlock. +0
Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Have a look at this article to see one tech person's response to scam calls.

Stefce commented: hahahahaha that give me good laugh :D +2
Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Some background information:

This is going back a few years so I'll have to dig. In my former life I set up a series of maintenance scripts to manage our EMS/SCADA data bases. I had to bulk insert about 8000 records once an hour. The unique key consisted of a combination of station name, point name and point type and new points were only occasionally added. For space and efficiency reasons I generated a unique point id (numeric) for each point and kept the original key in a separate table. So every hour I had to process a new batch of points

  1. insert any new points into the pointid table (generating new IDs)
  2. create a new bulk insert text file with the original key replaced by the generated key
  3. bulk insert the new text file

I've looked around to see if I have a copy of the original code but I do not so I emailed a former co-worker to see if I can get a copy of the code (the last I heard it was still in service after more than 15 years). If I hear back I'll post the code.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

You might try just rebooting your router. I have to do that periodically when my connection bogs down (only 3 computers on it). As soo as it restarts my connections speed up considerably. There is no way I can see what the problem is but I suspect router tables are getting too large (or possibly scrambled).

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

And you could charge him a fee for the installation and configuration and possibly a bit of training. If he is happy with the service he will likely return when he needs more help.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Jim, you really need to turn off or block your webcam

My face is the only thing they could see but it ain't Grecian Formula they're trying to sell me.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

I'd brace myself if I were you.

rproffitt commented: The braces there look right to me. +0
diafol commented: he he he +0
cereal commented: lol +0
Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

any page a searcher lands on has a clearly defined question

So why don't we delete poorly asked questions? Are you afraid of alienating people who ask poorly defined questions? Look at some of these

  • help with multiplying three numbers in VB6

  • how do I start making a simple search engine

  • example. pointer. int p ; double k ; (p)++ ; (k)++; cout<<"..........................." ;

To that end, we noindex all sorts of content ...

So someone has to manually go through all the questions and answers, post by painstaking post, and decide what is, and is not worthy of indexing? That sounds mind-numbingly brutal. Obviously the mods aren't able to do this so that leaves the admins and there aren't many of those.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

No one got the clever "never ending story" reference to Scheherezade?

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

I'm not into Zombies but we just got through binge watching an excellent show called Sneaky Pete. One of the co-starts is Margot Martindale whom I have loved ever since season two of Justified. Sneaky Pete will be back for a second season.

Like you, I really miss the back-and-forth in the Geeks Lounge. I still post there occasionally but it doesn't have the participation that it used to. Perhaps you could elevate it from a tag to a link in the waffle under Community Center.

Community Center
For Hire/Hiring
Geeks Lounge
DaniWeb Community Feedback
etc
Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Please read this thread for suggestions on how to post meaningful questions. Keep in mind that we expect you to show what you have done so far.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

delete any unwanted partitions but not the smallest as i said windows needs that partition for temp files

Can you please clarify what you mean by this? Unless I misunderstand what you are saying this statement is completely false.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

When you declare an array in vbScript the indexes go from 0 to the number declared. As silly as that may be, it works the same for vbScript and vb.Net.

Feel free to post any more vbScript questions you may have. It was my main programming language for about 8 years and I haven't quite forgotten it all yet.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Please consider that when you just post a homework assignment verbatim you are possibly in violation of some sort of copyright. Also please note that nowhere in your post is there any question actually coming from you. To us it looks like:

Here's my homework assignment. I'm too bloody lazy to do it or even add any content of my own. You do it for me so I don't have to go to any more effort than cutting and pasting. As a side benefit I can completely avoid the inconvenience of actually learning anything.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Try google with your exact question.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

There are fears that Trump has normalized all types of language and bad behaviour. In almost all cases I agree that this is a bad thing. However, there is one word in particular that Trump has used instead of all the usual euphemisms. That word is "lie" as in "she lies" or "lying Marco". This is a word I want to see more of. Whenever the press reports on a Trump speech, statement or tweet I want to see it followed (when appropriate, of course) with the phrase "he lied" or "this is a lie". In the past the press has avoided stating the obvious by using such weasel words such as "unsubstantiated, "unproven", "this turns out not to be the case" or "this is not entirely accurate". When a statement directly and obviously contradicts the provable facts then I think it is the responsibility of the press to state this clearly.

Wouldn't you like to see the headline "Trump stated that when he started giving his inaugural speech it immediately stopped raining and the sun came out" immediately followed by (in bold text) THIS IS A LIE?

If nothing else this would drive him batshit insane(r) and give Congress the fuel it needs to remove him from the presidency.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

If you've been searching for days for how to input two numbers and divide one by the other, and you haven't had any luck, then I suggest a career in anything that doesn't involve either computer programming or the internet.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Are you actually unable to read any of the dozens of books or hundreds of introductory web sites that show you how to do this? You are too lazy to Google this yourself, but you expect someone here to spoon feed you the answer to such a simple question.

rproffitt commented: Maybe it's that new code system of "alternate teaching methods." +11
Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Unfortunately, with the splintering of "news" sources into 6 (maybe fewer now) major traditional conglomerates and several thousand internet feeds, most people are free to consume only those "facts" that support their existing world view. I have a cousin with a PhD in statistics (retired) who used to be fairly high up at Stats Canada. You'd expect this person to have a farily high regard for the facts. And yet, I would regularly get forwarded email from containing the most ridiculous garbage. My usual reaction when I get blatantly false information is to do a fact check and reply to the sender with the corrected information. When I did that he accused me of being pedantic and said he didn't care if it was true as long as it was entertaining.

He lives across the country from me but I happened to run into him at a function here recently. He asked me my thoughts on the Trump victory. I simply replied "that's what happens when people don't give a flying f**k whether or not what they read and pass on is true or not."

We haven't spoken since.

diafol commented: he he he +0
Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

I frequently find myself looking for files on my computer. 99.9% of the time I am looking for a file by name rather than by contents. Typically there are two ways to find a file when you don't know what folder it is in. You can do it from the command line as in

D:\
dir *partname* /s

This generally takes quite a while with the larger drives/partitions in use these days. You can also go to an Explorer window and type something in the search box. I find this horribly slow as well. For my purposes, I want a fast way to get the full name and location of a file and the following free software was recommended to me by a trusted expert. It consunmes pretty close to zero resources. Once it has built a database of files (which files and folders are configurable), searching is almost instantaneous. Searching has many options. If you know a file name contains certain words you can just type them into the search box separated by spaces and a list (updated as you type) of file names containing all of the entered strings (in any order) is displayed. You can also separate terms by a vertical bar to use an OR instead of AND search. There are more complex searches such as

dm:today
dm:thisweek

to display files with the corresponding date modified (use dc for date created). There are many other search parameters for more complex searches (regex patterns are also available …

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

We are now officially in the world of George Orwell. The Trump administration is now using the phrase "Alternative Facts" when what they say disagrees with reality. For those unfamiliar with doublespeak

alternative facts = lies
ddanbe commented: Yep! +0
rproffitt commented: I don't where to put this. The new colors for this year are gold, gold and gold. +0
diafol commented: Heh heh. His new mouthpiece Kellyanne is a dick too. +0
Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

That might work for some but not for me. I'm not saying it's a bad idea but to me it sounds like one-on-one tutoring and I think the quality of the answers improves when I have time to reflect/refine/test. Also, I can spend 10-15 minutes at a time on a solution and interruptions don't matter. Real-time interaction would require scheduling and commitment to a block of time.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

You might want to have a look at my recommendations for installing Windows 7 in this thread

The imaging software I use is Macrium Reflect free edition.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

You can start by being more helpful when you post. For example, you said you gave it 40mb and now the space is showing 20gb. That statement is confusing if not meaningless.

  1. how big is your physical drive
  2. how is it currently partitioned
  3. how much free space do you have in each partition

A screencap of the diskmgmt.msc display would be useful. Depending on your answers, the solution may be as rproffitt says, to simply reinstall. However, you may require something like linux live USB with gparted to resize your partitions. I can advise further once you provide more information.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Looks like an old tool will be close to what I want. perfmon.exe has been a part of Windows since XP, perhaps even back to NT. The current version is missing a few of the counters that would have been better but I can still set it to collect disk reads/writes on a user defined interval and save the data to disk so I can view the graph later. Note that this is not the same as the Performance Monitor you get at from Task Manager.

Thanks for the suggestions.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Please provide more detail and show us what work you have done so far.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

its not the job of the compiler to write our wrongs

I never said that it was. Whether or not a compiler should optimize is an opinion. Whether or not it actually does is a fact.

WRONG: You need to understand operator precedence mate.

And you need to actually try the given example before making a nonsensical claim. A simple test of the statements y = x - (1+1) and y = x - 1 + 1 shows that they give different results.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Ethical hacking is not necessarily a bad thing but we have no way of knowing if that is your intention. Actually

how to access social media accounts like facebook, watspp etc.

I think we can make some reasonable assumptions as to your intentions.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Is it part of your desktop wallpaper? Does it appear when you boot into safe mode? What if you log on as Administrator? On most Windows systems the Administrator account is not active. In that case, open a command shell as Administrator and type

net user administrator /active:yes

The next time you log off and go to the logon screen you will Administrator as one of the options. Then logon as Administrator and see if you still see the image. Make sure you set a password on that account. It's handy to have around in case your usual account gets fubarred.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

The problem is that, from a technical point of view, there is no difference between ethical hacking and the other kind. It's sort of like asking someone to show you how to build an ethical bomb. I don't think this is the place to get that sort of advice.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Just a few suggestions to start.

  1. Functions/Subs should be named to reflect their purpose. For example, GetLine should get the input and nothing more. Instead it gets the input from the user then calls CommandRun to do the scrambling. CommandRun should be named something less generic and should be called from Main instead of GetLine. GetLine could return the user input as a string. Perhaps a null string would terminate the program.
  2. Don't use the multiple If-Then-End If blocks. The way you code it each block must be evaluated for every letter. You could use a Select-Case, or even better, a dictionary, to do the mapping from single letters to their scrambled equivalents.
  3. The only prompt you provide is >>. How is the user to know to enter Hello or Scramble?
  4. Is opening a new Notepad window for each scrambled string really the best way to display output?
rproffitt commented: Is that how Adam named the animals? +11
Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

A lot of that was just fodder to keep the media from focusing on important issues, IMO. "Build that wall" and "Lock her up" make for better sound bites than sensible fiscal policy. The media is just reflecting the apparent attention span of the American public who don't seem to be capable of following anything that can't be summarized in a tweet.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

If you are populating the Listview/DataGridView in a loop then I suggest you disable updates before you start the loop then enable them after the loop. This will save you a lot of processing time doing unnecessary control updates.

Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

I have family in from out of town for Christmas and big plans today but I will certainly drop everything and get right on that as well.

rproffitt commented: Getting the band back together as well. +0
Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

In mathematics, when a range is specified as (a,b) it is referred to as an open range and does not include the endpoints. When it is specified as [a,b] it is a closed range and does include the endpoints. A programming language should be consistent. When I see (a,b) I expect (and rightly so) to see consistent behaviour. A desired feature of a language is that the expected behaviour should be the actual behaviour. I accept that this is the way Python was designed. I maintain my opinion that it is wrong, no matter how convenient that behaviour is.

Perhaps they should have allowed range(a,b), range[a,b], range(a,b] and range[a,b). That would be consistent with mathematical definitions and would still allow the convenience for coding.

There are many programming tricks that are convenient but are still strongly discouraged because they are lack clarity. But this is probably not the thread to hold this debate (again).

rproffitt commented: Endpoints. Gotta love 'em. +11