Hi Angel,
Try something like this:
SET @cmdSQL = "SELECT col1, col2, col3, col4 WHERE name = '" + @myname + "'"
Using double quotes to enclose the single quotes, and make them part of the actual string you're building.
Hope that helps,
Phillip
Hi JefB,
You are really just building a string, so something like this should work:
' Get a recordset of info from Airports table...
sqlStr = "exec RoomsByDay_Rollup_SP '" & myStartDateVar & "', '" & myEndDateVar & "'"
set rsAirports =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.