Search results for query: *

Thanks both! I was able to put it together and get it to work!

gmmastros: I'm not updating EndDate. The first query works fine... I used it to create the second query, which is the one that doesn't work. monksnake: I tried putting in JOINs but that didn't work out at all. Where would I put them in?

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

Woo hoo! It worked perfectly! Thank you! I've now gone from over 800,000 lines in the table to only 98,000. This will do until I can figure out a way to code the application so it doesn't insert lots of junk data in the table in the first place. (I didn't write it, cause I certainly...

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

...when the download does come in. This is because the way I built the query, it looks for new data from the past day. This query works perfectly *provided* the daily download doesn't fail. This isn't the best way to do this. I didn't realize that when I wrote it, but when my boss asked me...

thanks! I fixed the errors you pointed out. And I'll try to do that pre-load thing. It's just a pain considering there's *so* many pics. :/

...For some reason it's not picking up the 20%. Weird. Yet it works perfectly in FF. Go figure. I'm going to leave it as it is and upload it like this. It works better than it did before and everyone will be happy. :) Thanks *tonnes* for all your help! If I could give you ten stars I would!

Also, how can I get it to move over a bit towards the right? This is smack up against the left border. I've tried playing with the CSS and JS code for the location, but I've only been able to move it down.

Yahoo! It worked! Thank you thank you! :D One last little question! How can I put a border around the images that pop up? I had that with the CSS popup thing going and I'd like to put it back in. This chunk of code doesn't do it now. Thankyouthankyou!

...border: #984700 2px solid; background: white;} #infowin { margin-left:20%; position: absolute; } And what the page is currently doing: * loads with the image in the wrong spot (this might be fixed once I add in the popup code to all the pictures... I'm just doing one right now...

I'm holla'ing! :) I haven't managed to get it to work yet. I'm debating just scrapping the way I have it set up and doing "open in new window" links with it!

heh! no problems! Have fun! I'm going to Vancouver tomorrow and won't be back for a few days myself! My bro-in-law won't be too ansty on this as the page is up and live and getting some good traffic for him. He's accepting that I'll get to it soon. :)

Ooookay. Now I'm not sure what I did... the base small picture is moving! It's *kind* of doing what it should be doing though, as it's 20 pixels down and moves down. You can't see the actual site because I'm doing it locally right now (at work, no access to the server this should be on)...

*sigh*. It's still not going. I inserted the onmouseover (can't believe I forgot that) and put in "position: absolute" in the CSS page for infowin. I'll check your code and see what comes up.

...being pure CSS... I just used it because I figured it would be easier, not realizing that IE doesn't support it well! :D Here's what I've done: * Pasted your JS code into the top of the photos.html page. * Modified styles.css (which is included in the photos.html page) with: #infowin...

1DMF: thanks, I'm trying to get the script to work, but it doesn't seem to be. I'm getting the images showing, but they're not taking into account the scrolled status of the page. What am I missing?

Sorry to bump this up but I never got around to looking at this until today. Vragabond: the link didn't offer me a solution. I can get the images to pop up in IE, but they're not stable. They jump all over the place, whereas in FF, they're in the same location and rather smooth. 1DMF: I...

Turns out the damn thing was empty. Didn't know it was supposed to have anything in it to begin! Nice of the previous developer to not think about putting that in his notes! *grr*. Thanks!