User Profile

Collapse

Profile Sidebar

Collapse
Trmbne2000
Trmbne2000
Last Activity: Aug 14 '08, 08:29 PM
Joined: Aug 2 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Trmbne2000
    started a topic Determine which fields to select based on date
    in SQL Server

    Determine which fields to select based on date

    Hi, I'm developing a service provider listing service. Part of the specification is to have both an address and a 'seasonal address' for each listing. The database stores the start and end months during which the seasonal address should be displayed as the address. Right now I am just grabbing everything out of the database, and using ASP to determine which address to display (seasonal if it is within the month range, normal otherwise [this works...
    See more | Go to post
    • Trmbne2000
      started a topic Article Preview with substring
      in ASP Classic

      Article Preview with substring

      Hello,

      I'm developing a press release system, and on the homepage, they want a short preview of the article. I would consider using left(...) to take the first x characters, however there is HTML in the articles. If you take a substring, you could end up with unclosed html tags, or end up somewhere in the middle of a tag (<a href="http://ww) Does anyone know of any functions that will let you take the proper amount of text,...
      See more | Go to post
      • Trmbne2000
        replied to Problem connecting to SQL with ASP
        in ASP Classic
        I can log in using SQL Server Manager using the same credentials. The error I get when executing the script is:

        Microsoft OLE DB Provider for SQL Server error '80040e4d'

        Login failed for user 'ASteenbuck'.

        /www/com/pressroom/includes/news.asp, line 14
        See more | Go to post

          Leave a comment:

        • Trmbne2000
          started a topic Problem connecting to SQL with ASP
          in ASP Classic

          Problem connecting to SQL with ASP

          Hi,

          I am making a pressroom application, which will serve up limited numbers of news articles on our site. I am using a brand new development server which was just installed. It has both the web server and the SQL server running on the same box. For some reason, none of my ASP scripts can connect to the SQL server on that box, but I can connect to databases on other boxes just fine. Is this a problem in the SQL or the IIS confiruration?...
          See more | Go to post
          • Trmbne2000
            started a topic Problem with SQL on same server as web server
            in SQL Server

            Problem with SQL on same server as web server

            Hi,

            I am making a pressroom application, which will serve up limited numbers of news articles on our site. I am using a brand new development server which was just installed. It has both the web server and the SQL server running on the same box. For some reason, none of my ASP scripts can connect to the SQL server on that box, but I can connect to databases on other boxes just fine. Is this a problem in the SQL or the IIS confiruration?...
            See more | Go to post
            No activity results to display
            Show More
            Working...