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")

"jason" <ja***@catamaranco.com> wrote in message
news:eW**************@TK2MSFTNGP10.phx.gbl...

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

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

[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.

"Tom B" <sh*****@hotmail.com> wrote in message
news:u3**************@TK2MSFTNGP09.phx.gbl...

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")

"jason" <ja***@catamaranco.com> wrote in message
news:eW**************@TK2MSFTNGP10.phx.gbl...

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

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