Recent content by VBAHole22

I have a database with 6 tables that are all joined together in one way or another. At certain points in time I want to take a subset of the records in one table(based on a criteria in that table) and 'catalog' them somehow along with the related records in the other tables. It's somewhat hard...

But getting back to the original post. How do you manage consecutive reader requests, parameters, etc.

That is precisely what I am doing and you are right it clears up the clutter alot and makes the code easier to reader. My concern is primarily with commands, readers and parameters. How best to manage those?

I have a long block of code that makes about 10 or 12 different parameterized queries against SQL server. Some are readers others are NonQuery. My question is what is the best way to manage the connection(s) to optimize performance. One way I had was opening and closing the connection after...

Thank you very much Mark. That did the trick very nicely

Humm... don't know anything bout no request headers. What's that all bout?

Maybe it's something simple that I am missing. Maybe I need to add a mouseout event? Here are the relevant snippets: in body: <a href="www.buffalowildwings.com" class="quote" onMouseover="showQuote( 'BW3' )"><u>BW3</u><span id="BW3"></span></a> in js file: var req; var quoteArray =...

I am trying to create a mouseover script that calls back an xmlrequest to get data off of my server without a post back. I modeled my code after this http://www.anders.com/projects/blogQuote/ and added my own C# web service back end I'm having a problem with it in IE though. It works when the...

Is it possible to write a T-SQL query that goes through another table and pulls out a field that is the name of a table and another field that is the name of a field and then query for that? I'm not explaining so well, sorry. I have a table that has id, tablename, field. I want, for every record...

I have the capability to calculate the actual distance to the hospital - I am doing this in ArcMap (ESRI). But this is more of a theoretical exercise in impact analysis. You drop a point that simulates an event (such as a gas leak). And then you radiate impact circles out from the point and...

You got it rita! Thank you so much for helping me out. Your sql works perfectly. It provides the ring and hospital for each new hospital that appears in the ring but that was not in the ring before it.

I have a program that takes a point and creates circles of different sizes around the point. Then these circles are intersected with the locations of hospitals. I then get the number of the hospital out of that intersection. Anyway here is the issue. I have a table that contains the hospital...

Okay I overreacted there. XP is really good about this. I hit F8 as it was booting and there was an option to boot to the last know good spot. So I got back in the game. Still no cd or dvd drive. But a lesson learned. I can be a little more patient about the drives as long as my machine still...

Now I did a bad thing! I read somewhere about a registry fix for this issue. So I went in and deleted a few keys, now I am really screwed! When I boot I can't get the keyboard or mouse to work. Dam. I always make a bad issue worse by impatience. I backed up the registry at least before I did...

Date Time is correct. The CD drive shows up as 2nd slave but the second master is blank. That should be the dvd drive. It's getting power and I can open the door and all. Should I just crack the case open and snug the cables?