Recent content by myspiral

in your opinion then i am doing it right?

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 would rather use regex to find the position.

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?

thanks guys both of those will work

how would I use this to replace though?

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?

thanks Golom exactly what I needed!

good question should have put that in my initial post. that set I would keep both as the records are not really duplicates. I only want to merge where one field is null and the other is not.

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...

find and replace on what though?

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...

select form driven by a query <select name="emailto" class="aceTextField" id="emailto"> <%Do Until emaillistdown.EOF%> <option value=<%=UCase(emaillistdown("email"))%>><%=UCase(emaillistdown("firstname"))%>&nbsp;<%=UCase(emaillistdown("lastname"))%></option> <%emaillistdown.MoveNext%>...