4,911 Posted Topics
 | If you use the regular expression \((.+?),\s*(.+?),\s*(and|or)\),\s*?\((.+?),\s*(.+?),\s*(and|or)\),\s*?\((.+?),\s*(.+?),.* and a replacement string of \($1[$2]\) $3 \($4[$5]\) $6 \($7[$8]\) then you get what you want except that `and` & `or` will be in the original case rather than upper case.  |
 | >I am trying to create a database. I want to add records to it, delete records, and find records. That's pretty much what anyone who creates a database wants. Before you begin you must first decide what data you want to store and how you want to access it. And …  |
 | Unions are intended to select the same columns from different tables. You can't select different columns.  |
 | I think you might also get more input if you posted your code here instead of making people jump through hoops at another site to get to it. Also, this thread will be of no use to anyone else in the event that your code is removed from the other …  |
 | They look highly suspicious to me. If that were on my computer I would 1. export HKCU to a file 1. take an image of the partition Delete the keys and see if anything stops working. If it does and the things that stop working are legitimate you can import … |
 | There is an example of embedding Windows Media Player in a vb form [here](https://www.daniweb.com/programming/software-development/tutorials/479908/create-a-video-library-with-an-embedded-windows-media-player). I have also embedded a vlc media player control in another project if you are interested.  |
 | Can't offer much help unless we can see what you have done so far. Post your code. |
 | Start by learning how to program. Sorry for being so blunt but based on the effort you put into asking the question, what type of answer were you expecting? We have no idea of your abilities or education and you have apparently not read the [Daniweb Posting Rules](https://www.daniweb.com/welcome/rules) or [Suggestions …  |
 | |
| | ##vbScript - Run an External Program and Capture the Output Please see my post [vbScript - The Basics](https://www.daniweb.com/programming/threads/516400/vbscript-the-basics) for more details on vbScript. When you want to execute an external program for a particular result (such as resizing an image, as shown in a previous snippet) you can simply use … |
 | |
| | Over the last few days I have been converting old video files from avi to mp4. I've been doing this using the command line version of DivX. This is the process behing the DivXPro GUI and it is named `DivXEngine.exe`. Converting video files takes a big hit on the CPU … |
 | If you want help I have a few suggestions: 1. Read the [Daniweb Posting Rules](https://www.daniweb.com/welcome/rules) 1. Read [Suggestions For Posting Questions](https://www.daniweb.com/programming/threads/435023/read-this-before-posting-a-question). Pay particular attention to the sections about hijacking old threads, and showing effort. If you put as little effort into your education as you have shown here then I … |
 | I have found that almost all information about Windows config & status is available via a WMI query. Finding the correct query can be a problem but there is a great tool available to help.It is called scriptomatic. It's an HTA (html application). It's basically some vbscript code with a … |
 | I think what you want is SELECT column-names FROM table-name WHERE column-name IN (values) |
 | >Any help? Probably not, based on the almost complete lack of details. |
 | Try str = "select * from Miscellaneouse where Position = '" & SlcComboBox1.SelectedItem & "' " |
| | We don't do homework. However, if you show us that you have put in serious effort to solve this yourself we are here to offer suggestions when you get stuck. Please read the [Daniweb Posting Rules](https://www.daniweb.com/welcome/rules) and [Suggestions For Posting Questions](https://www.daniweb.com/programming/threads/435023/read-this-before-posting-a-question). |
| | ##vbScript - An Application to Modify srt Subtitle Files Please see my post [vbScript - The Basics](https://www.daniweb.com/programming/threads/516400/vbscript-the-basics) for more details on vbScript. So far I've posted either functions/subs or code snippets to illustrate a technique. This time I am going to post a complete application. First, a few points. 1. … |
| | ##vbScript - A Multi-column Sort With Minimal Coding Please see my post [vbScript - The Basics](https://www.daniweb.com/programming/threads/516400/vbscript-the-basics) for more details on vbScript. A previous post dealt with sorting. The code easily handles sorting simple things like lists of words, lines of text - cases where you only had to compare two … |
| | ##vbScript - Some Useful String Functions Please see my post [vbScript - The Basics](https://www.daniweb.com/programming/threads/516400/vbscript-the-basics) for more details on vbScript. vbScript provides a number of functions for manipulating strings. I find that a few more simple functions would have made things a lot simpler. For example, I find myself checking to …  |
| | ##vbScript - Identify File by Perceived Type Please see my post [vbScript - The Basics](https://www.daniweb.com/programming/threads/516400/vbscript-the-basics) for more details on vbScript. There are times when you want to operate on all files of a given type. For example, you may want to enumerate all files in a folder or a drive … |
| | ##vbScript - Get Drive Letter by Volume Label Please see my post [vbScript - The Basics](https://www.daniweb.com/programming/threads/516400/vbscript-the-basics) for more details on vbScript. I have all my computers partitioned with two partitions. The drive letters are C (OS and applications) and D (user data). I use Macrium Reflect to take monthly full … |
 | The hardest program wasn't the hardest because of its complexity although it **did** involve linked lists within linked lists within linked lists (possibly four levels deep). I wrote it to validate database definition files (text files used to create the hierarchical databases for each of dozens of hyroelectric generating stations, … |
 | There are ways to hook into the sytem keyboard handler although I do not know how to do that. In lieu of that might I suggest [AutoHotKey](https://autohotkey.com/download/) which would provide that ability plus a lot more. |
| | ##vbScript - Browse for Folder or File Please see my post [vbScript - The Basics](https://www.daniweb.com/programming/threads/516400/vbscript-the-basics) for more details on vbScript. Some scripts need input (other than from the command line) from the user. This can be read from the console (StdIn) or from a pop-up textbox (InputBox). This is fine … |
 | I'm assuming that `>30` means expired so why not just do a `case` in the query that returns a value for `Expired` (or unexpired) of `True` or `False`. That way if the subscription period changes, all that would need to be modified is a stored query. For that matter, instead …  |
| | ##vbScript - Convert Integer to Binary String Please see my post [vbScript - The Basics](https://www.daniweb.com/programming/threads/516400/vbscript-the-basics) for more details on vbScript. vbScript has a number of functions for converting from one type to another. These functions are named C<type> as in CInt (convert to int), CDbl (convert to double), etc. There … |
| | I've been listening to various debates on the potential impact of AI and the two sides seem to boil their arguments down to 1. AI is dangerous because it will mean the extinction of humanity as machines that can improve themselves will do it so rapidly as to quickly make … |
| | ##vbScript - Sorting With and Without Code Please see my post [vbScript - The Basics](https://www.daniweb.com/programming/threads/516400/vbscript-the-basics) for more details on vbScript. Sorting is something that must be done from time to time. I'm going to examine three ways. The first is the well known (at least by name) QuickSort method. Rather … |
 | >I am going to retire pretty soon Welcome back and congrats. I retired in 2008 and haven't spent one second regretting it. >and how wonderful the Amiga was You and I may be the only ones here like that. Of course, I imagine most people here were born post-Amiga. I … |
| | This is the first in (hopefully) a series of posts about vbScript. Please see my post [vbScript - The Basics](https://www.daniweb.com/programming/threads/516400/vbscript-the-basics) for more details on vbScript. My wife and I take a lot of pictures. Naturally, we end up sending pictures to friends through email. I find it is unnecessary, and … |
 | Of course it fetches all the words. That's what you are telling it to do. In order to restrict what gets returned you have to provide a `WHERE` clause as in SELECT <fieldname> FROM ,tablename> WHERE <fieldname> <condition> <fieldvalue> For example SELECT FirstName, LastName FROM Employees WHERE EmployeeID = 221078 … |
| | ##vbScript - the basics My plan is to post a series of hopefully useful and informative vbScript Functions and Subs. I started writing up my first code snippet and found that I was taking too many side trips to explain things about the vbScript syntax and language so I decided … |
 | If you post a couple of files I'll see if I can write a script. I don't know php syntax but I might be able to toss something together with a few examples. |
 | |
 | 1. whby do you have to convert it? 1. why can't you convert it? 1. are there any error messages? 1. what is the platform (windows/linux)? 1. what compiler are you using? 1. are you having any specific problems? 1. what does the code do? You want help but you …  |
| | Here at the cottage I have a 3 gig/month cap. If I go over I pay extra. That gives me about 100 meg a day to play with. In preparation for the summer I have to spend some time 1. setting my wifi connection to metered (to block updates) 1. … |
 | Where I used to work, we standardized our date formats on all computers and databases/apps as yyyy-mm-dd. For one thing it made comparing dates trivial. |
| | Try cmbSearch.CommandText = "SELECT Assignment FROM Apu WHERE StudentID = '" & txtStudentID.Text & "';" The format is SELECT <fields> FROM <table> WHERE <conditions> I strongly suggest, however, that instead of building queries by concatenation you use [parameterized queries](https://www.daniweb.com/programming/software-development/code/445801/use-parameterized-queries-to-avoid-sql-injection-attacks). |
 | Re: C programming The loop continues as long as x is less than y. It isn't until x = 55 that the test fails. |
 | Re: javascript If you can't be bothered to ask a question then why should we go to the trouble of helping? |
| | I have to agree. Consider that I started to learn my craft decades before the internet became a thing. I have almost zero knowledge of how to develop a web app and zero interest in learning a skill that I would likely never use again. I would have to spend … |
| | Skype is worse since m$ took it over. First of all, I amn unable to defer/block updates while at the cottage but more importantly, there is now no way to block unsolicited requests to "kissieface wants to be added as a contact". Fortunately instead of getting 5-6 of these requests …  |
 | A huge problem I had to deal with several times over the years is the programmer who overestimates their abilities. I would much rather work with a programmer like you than one of those yobs.  |
 | Re: C++ guess word And what is your question? Before you reply I suggest that you read the [Daniweb Posting Rules](https://www.daniweb.com/welcome/rules) and [Suggestions For Posting Questions](https://www.daniweb.com/programming/threads/435023/read-this-before-posting-a-question). |
| | Re: Amazon Stock Dip Not surprised it took a dip. I recently bought a few items from Amazon. One order (two pieces of luggage) had to be returned because the luggage was larger than advertized (too big to be used for carry-on) and one other order never arrived. |
 | You start by learning python. Based on the minimal information you gave, what kind of an answer were you expecting?  |
 | I think 79-97 are all part of the same if-then-else-end if construct, just badly indented. |
| | Run msconfig.exe and deselect the No GUI Boot option in the Boot tab.  |
The End.