The Stoat
The Grim Squeaker
- Local time
- Today, 20:33
- Joined
- May 26, 2004
- Messages
- 239
Hi,
Does anyone now how to use a parameter request within an In() funtion like
In([MyParameter]) where the parameter would be something like 19,20.
It's a little complicated but i'm passing the parameters via VBscript in an ASP page and i thought i'd tried and work out how access handles this as i struggling with the script. The basic premise is right i.e the code works if i just send an integer to a straight forward parameter, but the in() function-in the stored query in access-messes it all up.
My script.
Where StrCBIDs would be a string like 19,20.
Unfortunatley, for reasons too complicated to go into, i can't just right the query string in script.
Any clues gratefully received.
TS
Does anyone now how to use a parameter request within an In() funtion like
In([MyParameter]) where the parameter would be something like 19,20.
It's a little complicated but i'm passing the parameters via VBscript in an ASP page and i thought i'd tried and work out how access handles this as i struggling with the script. The basic premise is right i.e the code works if i just send an integer to a straight forward parameter, but the in() function-in the stored query in access-messes it all up.
My script.
Code:
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open strConn
set rsP=createobject("adodb.recordset")conn.QRY_COUNT_PATIENTS_AUDITED [COLOR=Red]StrCBIDs[/COLOR], rsPWhere StrCBIDs would be a string like 19,20.
Unfortunatley, for reasons too complicated to go into, i can't just right the query string in script.
Any clues gratefully received.
TS
