Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: fdarkness
  • Order by date
  1. fdarkness

    SELECT nested in UPDATE not working

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

    SELECT nested in UPDATE not working

    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?
  3. fdarkness

    SELECT nested in UPDATE not working

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

    Delete with nested select?

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

    Delete with nested select?

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

    Session variable timeout

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

    Copying new items from one table to another

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

    CSS popup works in Firefox, glitchy in IE

    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. :/
  9. fdarkness

    CSS popup works in Firefox, glitchy in IE

    Yup, the #infowin is still there and I can see the margin-left code. 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. :)...
  10. fdarkness

    CSS popup works in Firefox, glitchy in IE

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

    CSS popup works in Firefox, glitchy in IE

    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!
  12. fdarkness

    CSS popup works in Firefox, glitchy in IE

    Sorry about the pause... had to take a streetcar to work instead of biking! Stupid rain! Here's what I have so far: in the photos.html page (just the relevant areas): <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <script...
  13. fdarkness

    CSS popup works in Firefox, glitchy in IE

    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!
  14. fdarkness

    CSS popup works in Firefox, glitchy in IE

    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. :)
  15. fdarkness

    CSS popup works in Firefox, glitchy in IE

    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)...
  16. fdarkness

    CSS popup works in Firefox, glitchy in IE

    *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.
  17. fdarkness

    CSS popup works in Firefox, glitchy in IE

    I'm not too worried about it 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...
  18. fdarkness

    CSS popup works in Firefox, glitchy in IE

    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?
  19. fdarkness

    CSS popup works in Firefox, glitchy in IE

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

    ExecuteScalar error

    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!

Part and Inventory Search

Back
Top