I am having trouble getting a stored prcedure to run with vbscript, that has 2 parameters the first is a string for a table name and the second is For the current date.
Now the SP i know works ok as if I run the following in Query analyser it runs ok
EXEC sp_UpdateTable 'Properties', '2005-06-14'
But i cant seem to pass the variables when trying to get a vbscript to execute the SP. Basically i am having trouble passing the date value.
Any ideas anyone, beg, beg!!!!!
Now the SP i know works ok as if I run the following in Query analyser it runs ok
EXEC sp_UpdateTable 'Properties', '2005-06-14'
But i cant seem to pass the variables when trying to get a vbscript to execute the SP. Basically i am having trouble passing the date value.
Any ideas anyone, beg, beg!!!!!