Search results for query: *

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?

So one day I turn on my computer and my drives are no longer recognized. They are getting power. I have a dvd and a cd drive. I haven't moved my machine around lately so I don't think it can be a bad connection. I have XP. It's a Dell 2350. Device Mangler says everything is working fine but the...

I am just learning Oracle after having an Access SQL Server background and the SQL is killing me. The joins work so differently. If I just had some base code to start with I would be off and running. What I am trying to do here is update a table (A) with a value that determine by looking at...

How can I set the Text property of a child textbox control in a panel control on an asp.net web form? I have panel1 and it has textBox5 in it. I want to set the text in textbox5 to "Hello". How do you do this? I know how you can't do it and this is what I have been trying: Dim ctl As...

I have a field with a text value. I want to write a function that updates another field with the value of the first letter of that text field, but only when it falls within a specific group. For example, if the text field is 'goat' then the first letter if 'g' and I have a table that lists...

My issue has finally been solved, here is what happened in my case. I had a box with the Oracle .NET provider on it so that I could develop using VS.NET against and Oracle instance on another machine. Eventually, we installed Oracle on that development machine itself and I started getting that...