Search:

Type: Posts; User: MMock

Page 1 of 13 1 2 3 4

Search: Search took 0.07 seconds.

  1. Re: Query to find gap in begin date/end date series

    I also found this (I actually googled to see if I could find my own post from what keywords I was entering and I ended up getting a lot of hit, which I should've done before I posted. I didn't...
  2. Query to find gap in begin date/end date series

    I want to find records that exist that demonstrate a certain problem we are having with some of our data. But only if it's easy to find these records. In other words, if this is at all complicated...
  3. Re: What is the benefit of fixed-length string (as string * 14)?

    No new thread was necessary. There weren't a lot of data with the issue, so I ran individual queries and eyeballed the results. Thanks for your help with this. Turned out to be fun - fixing bad...
  4. Re: What is the benefit of fixed-length string (as string * 14)?

    I am going to post a related thread in the Database Development forum. Because what was happening when this code was live, is a value such as 12345/12345/12 was getting saved to the database when...
  5. Re: What is the benefit of fixed-length string (as string * 14)?

    We decided to have them stay fixed. This is old code (obviously...it's VB6) which will be rewritten so a quick band-aid is good enough. However, I shouldn't say "we decided". He decided, and...
  6. Re: What is the benefit of fixed-length string (as string * 14)?

    Right, tg, which is not the case here.

    I did ask the original programmer (because how often are you lucky enough to have the original programmer still around?!) just in case there is a reason - I...
  7. Re: What is the benefit of fixed-length string (as string * 14)?

    Right - I was going to check on the database end, too, to see if the truncation might be occurring there as well. Thanks.

    varchar(100) - no problem there!
  8. [RESOLVED] What is the benefit of fixed-length string (as string * 14)?

    I am working on an issue with our live vb6 application.

    A field used to be of the format nn/nn/nn. So the variable to store it was "as string * 8".

    Then our data changed and could possibly be...
  9. VS 2010 Re: [RESOLVED] Question about localhost:nnnn vs localhost

    Oh, we use source control; what I said was we didn't go to it in this case. Meaning, the developer who was the owner of the project zipped it up as a means of delivering it to us. I had also said...
  10. VS 2010 Re: Question about localhost:nnnn vs localhost

    Well, this is such a disappointing resolution. It's working now, simply from me grabbing the project fresh from a zip file. But that was where I got it in the first place weeks ago, so why it's...
  11. VS 2010 Re: Question about localhost:nnnn vs localhost

    Going back to square one (that being getting the project and source files from a zip file on the network). Will let you know how it goes.
  12. VS 2010 Re: Question about localhost:nnnn vs localhost

    Creating an IMAGES folder was an epic failure, onto the net thing... (Woops, meant "next thing" - Freudian slip???)

    What troubled me was I got this project from my coworker and when she loaded it,...
  13. Replies
    8
    Views
    209

    Re: sql server aggregate query

    Hi wild_bill - I've been having problems posting lately...recently I double-posted the same reply somehow while here I zero-posted though I am sure I replied the other day that temp tables were what...
  14. VS 2010 Re: Question about localhost:nnnn vs localhost

    Yes, I had verified that.
    Yeah, that's what I was just thinking of trying.
  15. VS 2010 Re: Question about localhost:nnnn vs localhost

    If I open a browser and enter: http://localhost:1609/Images/bullet-nd.gif I get a 404 Not Found.

    If I open a browser and enter: http://localhost/Images/bullet-nd.gif I see my image.

    So it...
  16. VS 2010 Re: Question about localhost:nnnn vs localhost

    Oh, I see that now that you've pointed it out...


    No, I'm sorry - this company is very secure and I am a contractor not an employee so I'd rather err on the side of caution. I know that makes it...
  17. VS 2010 Re: Question about localhost:nnnn vs localhost

    I should never have said the links resolve. It is the images that resolve. In other words, see how it is using bullet-nd.gif? That image is just a tiny red square used as a separator. So it goes...
  18. VS 2010 Re: Question about localhost:nnnn vs localhost

    Maybe I should also add...if I next edit the URL displayed in the browser and remove 1609, the links resolve and the styling kicks in, I hover over the three links and they are...
  19. VS 2010 Re: Question about localhost:nnnn vs localhost

    OK, from the top, here is a snippet of the source from file Master/Producer.master:

    <div id="searchTopNav">
    <a href="<%= theURL %>/default.aspx">Home</a>&nbsp;<img...
  20. VS 2010 Re: Question about localhost:nnnn vs localhost

    Uh, does it matter if I am running VS2010 and IIS 5.1???
  21. VS 2010 Re: Question about localhost:nnnn vs localhost

    I'm sorry, I don't quite know what that means, "launch to a different service"...

    I may ask stupid questions back to your intelligent questions - I don't know anything about this app yet. I just...
  22. VS 2010 Re: Question about localhost:nnnn vs localhost

    Well, the removal of the port was actually the issue - not the solution. If I'd thought it was a solution, I never would've posted in the first place because I knew right away that with no port...
  23. VS 2010 Re: Question about localhost:nnnn vs localhost

    It's in a master page, and I am not sure how it gets set...
  24. VS 2010 Re: Question about localhost:nnnn vs localhost

    I didn't see any post of mine where I said that. I didn't say "I'm not getting images" and then "oh, I fixed that by removing the port #'. I posted to understand what's going on, and I am...
  25. Replies
    8
    Views
    209

    Re: sql server aggregate query

    I apologize for my formatting - I don't know why it looks good when I'm typing it then when I post it, it all scrunches over. I know it's awful to read that way...
  26. Replies
    8
    Views
    209

    Re: sql server aggregate query

    So if this is my table being built:

    GroupID Status5RowId CreateDateStatus5 Status6RowId CreateDateStatus6
    43 95 NULL NULL NULL
    57 ...
  27. Replies
    8
    Views
    209

    Re: sql server aggregate query

    So it would be this:


    -- This return 57 675
    select
    egs.enrollgroupid,
    MAX(egs.enrollgroupstatusid) EGStatusID
    from EnrollGroupStatus egs

    inner join
  28. Replies
    8
    Views
    209

    Re: sql server aggregate query

    CreateDate is not a column in the table aliased by EGS1.

    Also, I would want to use the row id rather than the date, but if I could just figure out how to do it one way I think I'd know how to do...
  29. Replies
    8
    Views
    209

    [RESOLVED] sql server aggregate query

    Here are some rows from my table. You can see they are all for GroupID 57. I am interested in the StatusID = 5 and 6 records. I have to produce a report saying how many days the item spent in...
  30. VS 2010 Re: Question about localhost:nnnn vs localhost

    No, there's plenty of back and forth, or at least forth. I'm comfortable with it because it works. Is that because it navigates using Server.Transfer so once I've changed the port it keeps that...
  31. VS 2010 Re: Question about localhost:nnnn vs localhost

    Thanks MattP. I will look at that when I get a break from a report I have to modify. And muddy? Hell, no. I learned something which I always took for granted - I thought it was always using the...
  32. VS 2010 Re: Question about localhost:nnnn vs localhost

    The paths look like this:

    <a href="<%= theURL %>/default.aspx">Home</a>&nbsp;<img src='/Images/bullet-nd.gif' border='0'>&nbsp;
    So I assume that is \Images off something else?

    Yes, I could...
  33. Re: Why is BigResource.com suddenly front-ending my google hits?

    Speaking of stack overflow...Stack Overflow is a question and answer site for professional and enthusiast programmers - why are they using a noun to modify a noun???


    en·thu·si·ast ...
  34. VS 2010 Re: Question about localhost:nnnn vs localhost

    Someone posted this: When I look at Properties for the project, I just see two properties: Full Path and Opened URL. When I look at the Property Pages, I see 6 sections: References, Build,...
  35. VS 2010 Re: Question about localhost:nnnn vs localhost

    And if I wanted to still use Cassini (I don't think I've ever not used it - didn't know you had a choice or what pros/cons were) I can't change the port number?
  36. VS 2010 Re: Question about localhost:nnnn vs localhost

    Ah, so that popup that says ASP.NET Development Server - that is Cassini. Good to know (better late than never, right?)

    At this risk of sounding (even more) like an idiot, I can't find what you...
  37. VS 2010 Re: Question about localhost:nnnn vs localhost

    1. Are you running this through local IIS or with the VS web server? Local IIS.
    2. odds are the pathings are full... rather than relative... Are you saying make them relative? I shouldn't have to...
  38. Replies
    12
    Views
    389

    Re: Using MasterPages???

    I think Blake was asking for a recommendation of the thousands that are out there. That's one of my problems, too. There's so much, you don't know what's crap (even if it works it could be crap)...
  39. VS 2010 [RESOLVED] Question about localhost:nnnn vs localhost

    If I hit F5 in Visual Studio, my web app is running from localhost:nnnn. None of my images or styling is available. If I modify the URL in the browser and delete the :nnnn so it's just localhost,...
  40. Replies
    2
    Views
    205

    VS 2010 Re: system.web authorization

    Another developer who was also trying to get this to work on her PC edited the web.config to contain all the roles.

    Thanks for listening.
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4