Search results for query: *

I have done many group bys, and I think this is doable, but the depth is messing me up. 2 Tables: RUN --- SAMP_SITE_ID RESULT ------ CON_ID VALUE_RPTD DEPTH I want to find the maximum value reported for each sampling site/constituent combination. No problem when I group by the samp_site_id...

What is the best way to handle referring to dev and production servers without "re-referencing" all your code? I am just starting this project, so I want to do it right. Currently we get a nightly dump of data to another server and database and here is the reference to the method table in it's...

I have an inherited .mdb with a browse button (common dialog active x) that works on my box, but doesn't on a co-workers new box (it worked on his old one). We are both using XP Professional SP2, and we both have the same version of MDAC. His box simply will not recognize the control (it...

The following returns this error (Syntax error converting the varchar value '10, 12, 15' to a column of data type int). The variables are actually input parameters in a function, and the '10, 12, 15' string is passed in: ---------- declare @appID int declare @qID varchar(100) set @appID = 113...

We had a power failure a couple weeks ago, and ever since we have had this problem. Our SQL Server is scheduled to reboot itself once a week. It reboots fine, but after it reboots, the MSSQLSERVER service won't start even though it's set to automatic. If we go into the service and RE-TYPE our...

Forgive me if this is an easy question. I am fairly advanced in Photoshop, but a rookie at Illustrator. Here is my problem. I am working on a logo for a friend in which I need to make a stone block with two letters on the face of the front 2 sides. I was able to use the 3d filter in Illustrator...

You can create a default in SQL Server using the following line: create default rowAdministration as 2 I believe this is retrievable through the defaults collection, but I can't find any examples that show you how to retrieve that value once you have created the default? Is this possible, if...

I added a new (secondary) hard drive, and my drive letters got switched all around in the process. So when I tried to open Outlook, I got some funky error saying the application had to be installed from the same location ... So, I tried to re-install from every drive under the sun and that...

I need an insert trigger that checks a value in one field and if it is a certain string, then change it to another value. I need to change the string "Required Selection" to a corresponding foreign key value. So here is the pseudo-code (the name of the field is "answer"). If inserted.answer =...

I have looked everywhere and not been able to find an answer to this question. Is there a way to communicate with a SQL Server database WITHOUT a DSN (linking), and loop through the tables in a particular database, pulling the information you need (field names, datatype, length, etc.) from...

I have run into this countless times, so I figured I would ask the experts. If I have 2 images that are touching, and I want to blend them together, how can I do this and make it look seemless. Using the gradient tool on a different layer doesn't work because it is solid colors. The blur tool...

Here is what I need to do. First I need a developer to pass me about 30 ID/Value pairs on which I need to loop through and add a new row (insert statement) for each pair. What is the most efficient way to do this? I do not know how to loop through input parameters, or if it is possible, and I...

To make a case for ASP.Net to my boss, I need to know how long Microsoft is planning on supporting classic ASP. Does anyone have an idea? I have searched the web, but been unsuccessful. The reason I am asking this in the ASP.Net forum is because someone who is contemplating, or has already...

This may be elementary, or a stupid question, but why would the following function always return true even if cboOfferResult_? = acc? numOfOffers and acc are variables set earlier in the code (numOfOffers = 2, and acc = 1) ==================================== function acceptedOffers () { var...

I found some code to download files through asp, and it seems to work correctly. However, when I download any kind of text file (txt, asp, htm, etc), the file is blank when it gets to my hard drive. I checked the file on the server and it is fine, but it basically erases everything on the...

I have a dowload page that is called from another page. On the dowload page, I get the file I need to download, and download it (which works great). At the end of the code, I need to redirect back to my calling page, but it is not working. I assume it's because of the response.flush. If I take...

Our proposed backup plan is to Backup the db every night with 1 hour trans log backups (the 1 hour increments are warranted, we have taken some time to determine this). That said, If I backup the db at 11:00 PM and my trans logs backup on the hour from 12:00 AM to 10:00 PM, should I use...

I am sure this is an easy syntax thing, but I can't seem to get it. This works fine: function checkAll() { for(var i=0; i<document.frm.chk1.length; i++) { document.frm.chk1[i].checked=true; } } However, I have sevaral check box control arrays (chk1, chk2, chk3, etc.), and want to...

I have been programming in VB/VBA for many years, and ASP for nearly 3 years. Our company is always behind the curve when it comes to new technology. We do a large amount of internal, intranet web apps (19,000 employees). I recently attended a great class on ASP.Net, and was impressed by the...

I want to be able to update the last value in a sequence to the maximum value from a table. If it were a table, I would use this: Update table1 set lastvalue = (Select Max(ID) from table2) However my book says to use Alter Sequence, so I tried this: alter sequence test_seq minvalue (Select...