Search results for query: *

I have an application that does the following. A UDP packet comes into the server with say 5 pieces of data (5 varies widely) and the receive program creates an entry in a table we'll call 'packet'.The entry looks like: [ProductID] [Timestamp] [PacketID] - [PacketID] is primary key Then each...

I have a table Type Age Number Blue 1 3 Blue 2 4 Blue 3 5 Red 1 7 Red 3 6 I need a query that will output like this: Type 1 2 3 Blue 3 4 5 Red 7 0 6 I'm thinking of using subqueries ie SELECT...

I want to use regular expressions to retrieve the position of a match. For example In the phrase "Help me please" I want to retrieve the position of "me" any suggestions

I know for IE to print a background color you have to go to tools - Internet options - advanced and check the "print background color and images" button. However my copy of IE6 does not have the advanced tab, not sure why. Any suggestions?

I need to replace all instances of Ave with Avenue, which I can do except for when it occurs at the end of the field. If you do a simple replace(txt,'Ave','Avenue') it screws up Avenue ie AveAvenue. Any advice on how to accomplish this?

I have a table with records that i need to merge ie FirstName LastName Phone Address Ken Smith 555-0000 Ken Smith 123 4th st BECOMES FirstName LastName Phone Address Ken Smith 555-0000 123 4th st there are...

I have a database that looks like this 1 Canada 2 Edmonton Alberta 3 Calgary Alberta 4 Toronto Ontario 5 United States 6 New York New York 7 Las Vegas Nevada I need to move the single field to everything underneath it 1 Canada 2 Edmonton Alberta Canada 3...

I have a page that when a user enters 3 letters it submits the page to itself, queries the database and gives a dropdown list with only entries that match those letters. What I want to do is when the page submits itself it sends the focus to the dropdown list, I have this working, I also want it...