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 derfloh 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: *

  1. permissiondenied

    DBgrid?

    I have an ASP application that uses a MS SQL database and am looking at various hosts for hosting it, I see some hosts offer a component called DBGrid and was wondering what it does and if it could be useful to me. Anyone have any or know of practical uses for this component. Cheers Phil
  2. permissiondenied

    Query to return all rows and count

    Hi, I made this query which returns all rows matching the WHERE but I am having trouble adding a count of the returned rows using the COUNT function. SELECT * FROM tblAds WHERE adClose > {ts '2002-12-30 12:39:00' } AND adTitle Like '%test%' ORDER BY adClose ASC My database being used is...
  3. permissiondenied

    Assigning variables at runtime?

    Hi, I have scripts sitting on a UK server set at GMT but want to use the Now function as if it is in EST which is -5hrs off GMT. My first thought was to simply use a variable vNow and assign it in a an included file like this: vNow = DateAdd("h", -5, Now) But I have scripts that call...
  4. permissiondenied

    SQL Server 2000 DB design question

    I wish to include a new table in my database which will hold up to 150 different records (17 columns with mostly int values) per customer for a possible 10,000 customers giving me a possible 1,500,000 records in the table. I will be accessing this table via ASP for the web and pulling only the...

Part and Inventory Search

Back
Top