Recent content by sugarthans

There is no syntax like create cursor i believe. The syntax for cursor creation goes like declare cursor cursorname for Select statement open cursorname fetch next from cursorname .... Youc an get tons of help from the Books online I dont see any difference between create and declare cursor...

I think if it takes 13 seconds in sql-2000 it should take little more time in MSDE. but 2 min is somethign which you have to probe into. The 'GO' statement is mereley to differentiate it into many batches.it doesnt have anything to do with performance i believe. Sugarthan

According to my understanding 5 Workloads in MSDE denotes to 5 concurrent conenctions and the performance degrades with moe connections. MSDE implements something called as workload governer..It is used to limit the performance of application. That too when the workload goes up it will affect...

Yup. you are right alfredo. For more code enhancement, there is no need of opening a recordset for this. Since the count() query is going to return a value atleast 0 for sure,no need of opening recordset nd closing it again you can just use, connection.execute("select count(*) from...

You cant rely on CDONTS mail object. Sometimes all the mails colelcted in the mailroot/Queue folder and after soem time all the mails get fired at the same time. I have exprience often these kind of problems.Would advise you to go either for aspmail or Jmail. Sugarthan

After the loop is over write one more query using a sum Operator to get the total. Display The value after the loop to get it done. If its using sql-server you can either use a compute sum(field) operator. Dont think Access support it. This sounds simple. Am i right or am i misunderstanding...