Results for "Category: String Manipulation"

A REALLY simple way to do AI chatting. Uses the instr function to see if a word exists in a question. Show how to use instr, arrays, sesquentenial file reading/writing. I haven't programmed in much question's (open chat.dat in notepad) follows structue keyword1,keyword2,keyword3,answer (comma seperates, must do comma even if you use only 1 or 2 keywords)

If you ever wanted to have a string with quotes inside this is a handy tip.

ADO has a great batch update feature that not many people take advantage of. You can use it to update many records at once without making multiple round trips to the database. Here is how to use it.

Transactions are atomic operations that allow you to do multiple operations on a database as one operation. For example, if you were creating a banking application in which you deducted $100 from one account and added it to another account, you wouldn't want the operation to fail right in the middle, because the money would be 'lost'! The solution is to wrap the SQL in a transaction. If the operation is aborted in the middle (the pc gets shut off for example) the database will rollback the changes so that the initial account was never debited the $100. This will make you feel good, especially if its your bank account!

You can use ADO GetRows to output and ADO recordset to an array. This is often useful in n-tier applications when you are moving data between tiers--or if you want to persist your data in another way. http://adozone.cnw.com/default.htm

Since ASP is especially good at reading and writing to databases, let's start with a very simple database and scripts that we'll eventually build into a guestbook... Reprinted with permission from http://www.web-savant.com/users/kathi/asp

This is not real RDS but a simulation (Like Access's Not_In_List event). This functions gives the user the ability to 1) Add a new Value into a Database table and 2) update and select the value in the combobox WITHOUT REFRESHING the page from the server. I found this to be a life saver with large ASP pages with comboboxes on them that need to be dinamicaly filled. (You don't have to worry about the controls on the pages)

This code returns a boolean expression that declares if a string is a valid email address or not. It returns true if the string is valid, false if not

This code converts UNIX files to DOS files and DOS files to UNIX files

This code gives a dump(backup) of your local or remote database. I use this in combination with vb to backup my remote database. If you are interested in the vb_code to do so... let me know....

how to do subselects in mySQL

will search a listbox's contents for a string returning a True if the string exists and a False if it dosent

takes a string like "Johnny*(722)555-5555*35" and splits it into columns on a listview control(designed for Report view)

This code shows you how to create Unlimited Undo and Unlimited Redo, along with Cut Copy, Paste, and Select All features, in a RichTextBox Control.

This Code shows, how easy it is to store some dates in a mysql database

This Moves a Forms caption from left to right.

THIS VERY COOL FUNCTION TAKES A NORMAL STRING AND CONVERT EVERY CHARACTER IN IT FROM UCase TO LCase OR FROM LCase TO UCase... CHECK IT OUT!! AND VOTE IF YOU FIND IT USEFUL

I keep reading requests for RichtextBox code on PSC so I decided to upload one of my templates with a few added features. Nothing that special here really - basic RichtextBox functioality. The RichtextBox is pretty good at what it does though ! This example demonstrates : Find and Replace, Infinite Undo/Redo, Using .tmp files, HighLighting selected words, Inserting Images, Inserting text at a set location with different Fonts, Common Editing Functions, Shrinking a path to a desired length, Creating your own light-weight Wizard. This is not meant to be a complete application merely a demonstation of some techniques. All error messages and bugs are provided entirely free of charge. Feel free to use any of the code or errors as you wish - MS wrote the control - I've just shown how you might use it. It's capable of more than I've shown here.

Search a directory for files containing a specified string and return a list of such files. Once again, I've uploaded this in response to a quetion posted in the Discussion Forum.

Syntax coloring, advanced selection routines and Highlighting. Highlighting using the Richtextbox control is awkward. Whilst there are a host of Selection properties there is no Highlight property we can access from VB. We just have to parse the RTF code.