[thelist] way OT -- keyboard woes

Paul Cowan paul at wishlist.com.au
Thu Oct 18 22:15:41 CDT 2001


> Rudy - 
> 
> just curious:  Which keys?
> 
> Karen

The only correct answer to this, of course, is:
	The "" and "" keys.

:)

Paul

<tip type="ADO" author="Paul Cowan">
Be VERY VERY careful about mixing "output methods" from a stored proc when
using the ADO recordset/command objects. The "output methods" are: return
value; output parameters; result set(s). Mixing any two of these is asking
for headaches: mixing all 3 is a recipe for disaster. Recordsets need to be
closed before output params can be accessed, etc. Behaviour is very
inconsistent depending on versions of ADO, database, phase of moon, etc. If
you are getting weird behavious, first try SET NOCOUNT ON at the start of
your proc, and remove (or comment out) any and all "PRINT" statements -
sometimes they really screw things up surprisingly badly. If in doubt,
consolidate into one output method.
</tip>




More information about the thelist mailing list