Well,

My point is that it isn't necessary to make personal comments. I don't care what someone's "style" is, it's rude. Imagine the fights we'd have here if everyone started their...

Frank,

I've posted my share of both questions and answers in these forums. Joe can have his style, but he doesn't get to tell me I don't know what I'm doing...

<!--- #include file="..path/adovbs.inc" -->

"..path/" is the path to the file. If the file is in the same directory as your ASP page you don't need the path info.

Thanks again for...

Let's start off with your tone: "Let's start off with your **REAL** problem; you don't know what First Normal Form (1NF) is and someone let you get on a...

cmdStoredProc2.CommandType = adcmdStoredProc works just fine assuming you include adovbs.inc.

It was the damned SQL permissions. The DBA didn't set up the userid the way I'd asked. Once I got the...

OK, so I posted this yesterday but it never showed up so I'll try again...

I appreciate the feedback I've gotten on my own set vs. cursor problem, but I haven't...

While a good tutorial on using native SQL with ADO, I would not recommend this technique for web site development. Rather most, if not all, SQL calls should be to...

I'm confused on this:

       CAST (SUBSTRING (I1.input_string

                        FROM S1.seq

                         FOR MIN(S2.seq) - S1.seq -1)

         AS INTEGER)

in your Select statement. SUBSTRING should have a string, start and length operand....

My understanding of the conventional wisdom was that there was no difference in performance for small recordsets between set and cursor processing. In the case of small recordsets while set...

I guess this question is really for the site owners. Does the forum software you're using have a "poll" capability built in? (I'm guessing "Yes" unless the QOD is run...

Axel,

I'm looking to find out what people use and what they use it for. We're trying to figure out not only the best tool, but the best practices (sort of...

At least you're calling a Stored Procedure You wouldn't believe the code I've seen in some triggers where the trigger cursored through the...

Cursors are not necessarily bad!!! (Begin huge religious argument )

It has been shown that from a performance perspective for queries with low utilization...

Thanks! I'll take a look...

Hmm.. Never saw that wizard. Thanks. I'll have to check it out and see how good the code is that it generates.

You're right, a general Read function is probably pretty...