Paramater for cnn.EXECUTE?

[jason]

How does one pass a parameter to the EXEC query recordset:

set rs = cnn.execute("EXEC tblListings_qry2")

 

[Tom B]

Assuming that tblListings_qry2 is a stored procedure than you would just
append it

Set RS=cnn.Execute("EXEC tblListings_qry2 5")

if there are multiple parameters, you just separate them with commas

Set RS=cnn.Execute("EXEC tblListings_qry2 5,3,'Bob''s your uncle', 99,
'hello','etc',1")

 

[Aaron Bertrand - MVP]

set rs = cnn.execute("EXEC tblListings_qry2")

Numeric:

set rs = cnn.execute("EXEC tblListings_qry2 5")
set rs = cnn.execute("EXEC tblListings_qry2 @paramName = 5")

String:

set rs = cnn.execute("EXEC tblListings_qry2 'bob'")
set rs = cnn.execute("EXEC tblListings_qry2 @paramName = 'bob'")

I'd tell you how to pass dates, but you didn't bother telling us which
database you're using...

 

[jason]

Thanks -it is a stored qry for Access.

Assuming that tblListings_qry2 is a stored procedure than you would just
append it

Set RS=cnn.Execute("EXEC tblListings_qry2 5")

if there are multiple parameters, you just separate them with commas

Set RS=cnn.Execute("EXEC tblListings_qry2 5,3,'Bob''s your uncle', 99,
'hello','etc',1")