Search results for query: *

A little while ago, I had some help putting together an update query that selected the new data out of a table. It looks something like this: UPDATE Assignments SET EndDate = (SELECT EndDate FROM SF.dbo.Events WHERE SF.dbo.Events.EventNumber = Assignments.AssignmentNumber) FROM...

I have a query that currently SELECTs data that I need to delete. The problem is that I need to delete based on TimeSheetID, AssignmentCode *and* ActivityID. I can't delete based on just one. The main criteria is that I need to delete any entries that have a SUM(Length) = 0. Here's the query...

I have several applications that are written in ASP and one application written in ASP.NET. Each app is stored in its own directory. Both the ASP and .NET apps use session variables for logging in. I managed to pass the information to the .NET app in order to reset the variables when a...

I'm currently running a job in SQL server that copies contents from a daily download to tables in my database. The daily download drops table A then rebuilds it from the backup, which contains the old data, plus the new data that was inserted over the course of the day. The job that runs on...

I'm tweaking and adjusting another programmer's ASP.NET application and this language is definitely not my forte. As a result, I'm totally lost on this error and I'm not sure how to fix it or even where to start. In one of the pages when I attempt to save the information to the database, I get...

I'm tweaking and adjusting another programmer's ASP.NET application and this language is definitely not my forte. As a result, I'm totally lost on this error and I'm not sure how to fix it or even where to start. In one of the pages when I attempt to save the information to the database, I get...

Currently, I have a backup file that's downloaded on a daily basis to a drive on my server called dn0r.dbu. There's a SQL management job that executes every morning that extracts the tables from the backup file to a database on my server called dn0r. The command that's executing this backup...

I'm attempting to restore a database using the following command: RESTORE DATABASE test FROM DISK = 'G:\dbbkups\mssql\cis0\dn0r.dbu' WITH REPLACE It got busy for about 30 seconds, then returned this error: Server: Msg 3101, Level 16, State 2, Line 1 Exclusive access could not be obtained...

Due to having to use a big hammer on my code, I've run into a bit of a hiccup. I have the following link on a page: <form method="post" action="/timesheet/UserMain.aspx" name="timesheet_form"> <input type="hidden" name="UserID" value="<%=Session("UserID")%>"> <a...

Please bear with me... it's kinda messy! :) I have a main application that I wrote in ASP. A second part of the application was contracted out to another developer who did it all in ASP.NET. I need to merge the two of them together (without rewriting everything from scratch) so they work...

Due to the way my server is set up, I have a session variable set to identify a user when they go onto the site (it's an internal only website). In the global.asax page, I have: Session["CISUserID"] = Request.Form["UserID"]; in the Session_Start method. It appears to work fine (tested it...

I used the pure CSS popup feature for a picture section on a website I developed for a family member. My bad, I didn't test it in IE before completing it. It works great in Firefox, but is definitely not good in IE. The website is http://www.michaelbeauclerc.com and the section that's acting...

This shouldn't be too difficult but it's not working for me. Hopefully someone can help! I have two tables: Table1 Name Number UserID James Jimmy E1255 <NULL> Jones Tom E8544 <NULL> Loeb Lisa E9988 <NULL> Table2 UserID FirstName LastName 12 Jimmy James 55 Tom Jones 49 Lisa Loeb I need...

I have an Excel sheet stored on my server and an ASP page that queries the data on the sheet. It works great, except there seems to be a "time limit"... ie, when I query the sheet and display the data the first time, it displays fine. If I back up a menu and display the page with the query...

I've tweaked a submit button on my page with a bit of CSS. But is it possible to have the text colour in it change when hovering over it, ideally with an inline style? <input type="submit" name="submit" style="background-color:#003360; font-size:10pt; color:white; font-family:Arial...

I've done searches in general, searches through the forum, and searches in the FAQs and I'm not quite getting the answer I'm looking for. I have most of it, but not quite all of it, so hopefully someone can help me with the last little bit. My page is querying a database and then displaying...

Please bear with me... this may get a bit convoluted. I have a form where I need to replace some data in it. I'm doing this through a javascript function which is launched through an onClick event in a button input type. Once the data is run through the function, I need the page to submit...

I'm using the "pure CSS popup" from http://meyerweb.com/eric/css/edge/popups/demo.html. it creates a popup box on a hover action, but uses only CSS and no javascript. (I've fixed the bugs in it so it does actually work). The CSS code I have is: div a:hover {text-decoration: none; border...

I'm just right baffled with this and I'm at my wits end. I have a form that queries a database and displays the results on a page in a table. The results are displayed in the following format: <% while NOT AccountsRS.EOF %> <tr><td>First Name:</td> <td><input type="text"...

I originally posted this in the VBScript forum, but it seems that it's more ASP than VBScript (according to them). I have the following cludge of code (direct C&P from my page): for each key in Request.Form if Request(key) = "on" then key = 1 else key = 0 end if...