ASP guru's please help

Results 1 to 2 of 2

Thread: ASP guru's please help

  1. #1
    Join Date
    Dec 1969
    Posts
    940

    Default ASP guru's please help

    I am trying to create a Conference room scheduler. I have four rooms with time slots ranging from 7:00 am to 6:30 pm. I have the output display as a simple table. I create a db connection then I create recordsets using that connection. I am currently having to create 120 recordsets. As you know, this causes a real performance problem, as well as a licensing problem for SQL. I then do a test on the recordsets, all 120 of them, to see if they are empty, end of file. There can only be one record for each time for each room each day. If they are then I declare a variable that is similar to variable1="Available" and if it is not the end of file then I do something similar to: variable1=recordset("feild") So by the end of this asp page I have made one database connection, 120 recordsets and 120 variables that contain either "Available" or recordset("field"). Then I simply display the variables in their correct spot in the table. Thanks for your help.

  2. #2
    Mark Guest

    Default RE: ASP guru's please help

    Hi Eric<BR><BR>I think I posted a reply to your question on this subject last week (it isn&#039t available anymore it would seem), and you requested more info. Sorry it&#039s taken soo long to get back to you, murderous schedule at the moment.<BR><BR>Rather than clutter up the message board, if you could mail me what you&#039re trying to do I&#039ll see what i can do to help. i can put you on the road to the approach I took and you can decide if it&#039s right for you.<BR><BR>Mark<BR>mark@blueberrie.freeserve.co.u k

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •