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

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

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

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

How would I go about copying a table from one server to another server. The tables are in different databases. I suck at SQL PLus, I usually use Aqua Data Center. I know I need to use an INsert Into statement but how do you specifiy the different servers? Do I have to have a middle step, like...

I have a snippet of code that builds a command button for use in another program. I am using a bitmap image for the icon of this button. If I spell the name of the bitmap image incorrectly it doesn't work. So I set up a Try Catch block to catch this. It works but the trouble I am having now is...

I am writing an ASP page to take the results of a user survey and enter them into a new record in an access db. It works fine when the user fills out all of the questions (some yes/no, some multiple choice) but if they leave one blank the page returns an error at the line where the db would be...

Can stored procedures accept optional parameters? I am using an ADP in Access2k against an SQL Server 2k database. I am trying to build a form that allows users to query a particular table in my database. What I would like is for them to be able to select from among 5 criteria to use in their...

I have a stored procedure that I use to fill in a combobox on a user form. I like the fact that this box uses AutoExpand to finish off what the user is typing, however, I don't think that it is working with the entire range of possible values. When I run the proc in my Access project it defaults...

I have an Access 2000 project running on a SQL Server 2000 db. My main form is a data entry form and I would like my users to be able to hit a key to copy the value of the same field from the previous record. I know this is possible in Access using a key combination but I can't get this to work...

I designed a nice user interface using an Access project (.adp) based on a SQL Server 2000 db. It works fine and dandy and now I want to move it to another machine so the data entry technician can begin using it. I cannot seem to get it to work though. It will open but it has no tables and it...

I know there is a way to get a parameter back out of a stored procedure I just don't have the sin tax right. Can anyone help me out? Alter Procedure ReturnIDfromCommonName @COMMON_NAME varchar(50), @ID char(6) OUTPUT As SELECT @ID =BOVA FROM BOVA_TAXONOMY WHERE COMMON_NAME = @COMMON_NAME...

I have a db that stores large blocks of text as answers to questions posed to users. I have about 30 fields with this type of format. I would like a report that prints out the text of the question and then the resulting answer. My problem is that i want this text to go 'down' then page and not...