Re: tweak of A2002 Enterprise Dev Handbook fails?

pietlinden@xxxxxxxxxxx wrote:
Thanks Bob,

I removed the Parameters declaration and just created them in the
query itself (I thought ADO couldn't access the parameters collection
of what I thought was a DAO object... shows what I know!). but when I
took that out, it worked a champ!

thanks!

Pieter

Here's the part of the code I changed...

You don't need this part:
************************************************
Set cmd.ActiveConnection = cnn
cmd.CommandText = "xp_ActiveSkills"
cmd.CommandType = adCmdStoredProc
************************************************


' Execute the command and place results
' in Recordset object.
Set rst = New ADODB.Recordset
cnn.xp_ActiveSkills intBuildDay, rst

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.