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!

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

Recent content by alexej

  1. alexej

    Selecting last 50 entries

    I'm test running it first on my PWS
  2. alexej

    Selecting last 50 entries

    Yes, I do access my DB from ASP and I suppose I have the latest verson of MS Jet which should come with Access 2000 I'm using, but it doesn't accept TOP anyway.
  3. alexej

    Selecting last 50 entries

    No :-( Neither DISTINCT TOP 50 nor LIMIT TO 50 ROWS works with MS Access. Thanks anyway
  4. alexej

    Counting hits

    I'm using this Sub in my global.asa file:<br><br>&lt;SCRIPT LANGUAGE=VBScript RUNAT=Server&gt;<br>Sub Session_OnStart<br>host = Request(&quot;REMOTE_HOST&quot;)<br>browser = Request(&quot;HTTP_USER_AGENT&quot;)<br>referer = Request(&quot;HTTP_REFERER&quot;)<br>url =...
  5. alexej

    Selecting last 50 entries

    Hi, actually I'm logging visitors to my site to a database. I'm using Access now, but I'm going to migrate it to SQL-server. So last 50 entries are based on time of entry. Calahans tip above (SELECT TOP 50) doesn't work in my ASP script. It just ignores this &quot;TOP 50&quot; statement. Could...
  6. alexej

    Custom error message

    How can I display my own custom message instead of &quot;Either BOF or EOF is true..&quot;? Thank you!
  7. alexej

    Selecting last 50 entries

    How can I select the last 50 entries in a table?

Part and Inventory Search

Back
Top