User Profile

Collapse

Profile Sidebar

Collapse
Pauley
Pauley
Last Activity: Mar 31 '08, 04:45 PM
Joined: Mar 13 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Pauley
    started a topic Stopping EOF(End Of File) from happening?
    in ASP Classic

    Stopping EOF(End Of File) from happening?

    Hello again,

    I have an asp page that displays a list of records according to what im pulling in from my select statement. As long as there is a record in the database the page works fine but if all records in the database are deleted then the page crashes.

    I've used the same code in other pages and have no problem with it but for some reason this page either hits EOF or BOF and the page just doesn't load. I've tried...
    See more | Go to post
    • Pauley
      started a topic Good old list boxes.
      in ASP Classic

      Good old list boxes.

      I have an ASP page that has a list box that allows multiple selections. I can take those items selected and submit them to my SQL table. Of course they are submitted as: selection1, selection2, selection3 and so on.

      I can also pull those values back into my list box in an update form by using HTML and ASP code such as:
      Code:
      <option selected value="<% =rs("division") %>"><% =rs("division")
      ...
      See more | Go to post
      • Pauley
        replied to Trying to get Date Diff or Timespan a simple way.
        in ASP Classic
        Nevermind, I got it!

        Thanks for all the help!...
        See more | Go to post

          Leave a comment:

        • Pauley
          replied to Trying to get Date Diff or Timespan a simple way.
          in ASP Classic
          Hi Jeff,

          Still working on this thing and I've got it down to one problem. I have my date formatted as EndTime = FormatDateTime( Now(),0)

          When I write out the EndTime variable to the screen before submitting it writes it as it should with both the current date and time. However, once I submit it to my datetime field in my table it still records the time portion of the date as 12:00:00 AM instead of the current time....
          See more | Go to post

            Leave a comment:

          • Pauley
            replied to Trying to get Date Diff or Timespan a simple way.
            in ASP Classic
            Hi Jeff,

            Thanks so much for the reply! I attempted to use the examples on w3schools when I began this project but had no luck. However it did help me to understand a lot. I rely on that site a lot. I was able to use a variation of the line of code you gave me and got the page to produce the hours since a record had been submitted. The line of code is below.

            Code:
            StartTime = rs("date") 'datetime field
            ...
            See more | Go to post

              Leave a comment:

            • Pauley
              started a topic Trying to get Date Diff or Timespan a simple way.
              in ASP Classic

              Trying to get Date Diff or Timespan a simple way.

              Hello,

              Please keep in mind when you read this post that I am a total noob when it comes to coding.

              Coding in ASP
              On MS Server
              SQL Database/Table

              I know this topic has been covered many times and many ways. In fact I've tried to use one version or another of 20 examples with no success. All I am trying to do is determine the timespan between the date a sql record was submitted and the current...
              See more | Go to post
              No activity results to display
              Show More
              Working...