Here the problem. I need to do a SQL statment similary to the following.
Select * from tableA where field1 in ?
Where the question mark is a call to a ADO paramenter object. MS tells me that I can put arrays into the parameters and that it will work. But I can't find a example of how to create the parameter so I can append it to the command object
commobj.Parameters.Append(commobj.CreateParameter("ID", adArray Or adVarChar, adParamInput, 10, ID_array));
Is the best stuff I have now, but i am getting a error about a expected ) which just doesn't seem right. I am just hoping someone out there as seen this and can show me a example of how to format this command. The money's gone, the brain is shot.....but the liquor we still got.
Select * from tableA where field1 in ?
Where the question mark is a call to a ADO paramenter object. MS tells me that I can put arrays into the parameters and that it will work. But I can't find a example of how to create the parameter so I can append it to the command object
commobj.Parameters.Append(commobj.CreateParameter("ID", adArray Or adVarChar, adParamInput, 10, ID_array));
Is the best stuff I have now, but i am getting a error about a expected ) which just doesn't seem right. I am just hoping someone out there as seen this and can show me a example of how to format this command. The money's gone, the brain is shot.....but the liquor we still got.