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 biv343 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 guys, thanks for your help. Converting the query to a stored procedure is possible but difficult for me as there are so many variables that can make up the query, cheers Wolf. Terry your solution also looks good and I do have an index on that column. r937 I have gone for your solution as...
  3. 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...
  4. permissiondenied

    Assigning variables at runtime?

    Hey thanks Tarwn, you confirmed what I was thinking for me. Yep the function you layed out is the one I was considering using. Thanks again. Phil
  5. 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...
  6. 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