Search results for query: *

I have a script which writes to an excel sheet and saves it. Once the cells have values, another column runs calculates on those cells. When I open the sheet afterwards, the formula cells all look correct. BUT, when I try to use VB to read from those formula cells, all it returns is "001"...

I have a script which writes to an excel sheet and saves it. Once the cells have values, another column runs calculates on those cells. When I open the sheet afterwards, the formula cells all look correct. BUT, when I try to use excel to read from those formula cells, all it returns is "001"...

I am pretty new to JQuery, but I have managed to at least get the accordion to work and load data via AJAX call when it first opens in my MVC project. Now I am running into an issue where I'd like to add a drop-down in the header so that the data shown is changed. Problem 1: the header...

This is really frustrating. I thought I had everything working great, but when I test it outside of debug mode in VS.Net, it all craps out. I am trying to create a simple Intranet site to point to files on a shared drive. The database stores the location of the file on the drive as...

Well, I'm not a complete noob with stored procedures, but it is certainly not my strong point... I have two tables of employee data that want to combine parts of them together. How can I write a stored procedure that steps through and selects data from one table, and then updates the...

I'm a bit fuzzy on the how to have multiple sites on the same IIS 6.0 box with SSL for them. I know you can't use the same IP address with host headers and have multiple sites... because the IP address has to be unique for the SSL to function. So, I have 2 external IP addresses now for 2...

I've searched all over, but nothing yet is helping. The website works like a breeze on IIS 6 or IIS 5.1. I put the same website (ASP.NET 2.0) onto IIS 7 with Server 2008, and the images load dirt slow. They aren't big images, and the server itself is fairly powerful Dual Core Xeon 3 Gz 8 meg...

I'm been searching all day trying to find a solution to this. Surely others have figured this out. I have a .Net menu control with a series of MenuItems. If you click the text of a given MenuItem, the window navigates goes to the correct NavigateURL page. But, clicking anywhere else in the...

I've seen a number of posts about Firefox issues with getURL, but nothing addressing calling javascript with that command. I have a button in Flash that calls getURL("javascript: hideMovie();"); which basically runs a simple script to set the DIV to hidden. It works fine in IE, but in...

Its been a while since I used classic ASP. I'm trying to modify some old code someone else wrote. The code calls a stored procedure which returns a recordset. I want to change it so that it returns a single string variable that is defined in the proc. So, the proc has an OUTPUT value of a...

I am a completely average query programmer. I built a simple SPROC so a user can retrieve their password from the system based on 3 criteria. The SELECT query either finds a match for all 3 in the WHERE clause, or it fails. The 3 criteria are e-mail, birthdate, and zipcode. But, I'd like to...

I've been searching all the forums and trying to fix this all day long. I've tried changing all kinds of permissions, but so far to no avail. Maybe someone else can help? I have a Web site I built on my local machine, and I can upload files from it to our DEV server through a typical...

If seen tons of posts about a dropdown event that DOESNT fire, but... In my case the event is firing for SelectedIndexChanges or TextChanged, but the SelectedValue and SelectedIndex doesn't... Which makes absolutely no sense to me. So, how can my event be firing, but the selected index and...

I've tried unsuccessfully to find some answers to this, although I'm sure people have done this before. I want to have a min and max size to my web page. Right now I want the Min to be about 950px wide and the max at 1200px. I set up my stylesheet as: table.main { background-color...

I'm not sure what I'm doing wrong here. I have a website I've built that works great in debug mode, and when I'm looking at all the VB code behind, etc, I see no underlined "error items". But, my error list show 47 stinking errors. When I open the list, and double click the errors, VS jumps...

I took a database from SQL Server 2005 and restored it onto my local machine running SQL Server 2008 Express. The database appears to have restored just fine. I can open the database engine in Management Stuido and view all the tables (thru Windows Integrated Authentication). The Classic ASP...

I am in the process of moving a bunch of queries from Access 2003 into a VB.Net application. The query still runs against the Access MDB file, though. They all work fine but one. Its a fairly large, convulted series of IIf statements and calculations. It runs, but the results are slightly...

I've read instructions on how to do this, but apparently I am doing something wrong. Out of space on main SQL and want to set-up nightly backups to different network server. At first, I tried mapping the other server & backup directory as a new drive N:\ on the SQL Server box. This failed. I...

I know I have successfully done this before, and for the life of me I have no clue what I'm doing wrong. Too much time in the office, maybe. Have report which uses a separate query for pulling data. The query uses an ID parameter which I am trying to pass from my form via VBA code. Yet - the...

I am taking over a database project from a previous developer who insisted on building massive, gigantic queries which are basically huge nested IIf statements. IFf within Iff within Iff. It makes it incredibly difficult to read and understand what is actually going on. Is there any such tool...