Re: problem with using String Variable in IN Function
Thanks for the reply. Actually the result of the first query is not fixed.like
recordSet.open" select coursecode from course where student id='1'" , connectionobject
'Consider the result of this query will be different ever time when ever it runs.
' Like it may give 4 records,10 records may be 15 in the recordset
'now i have two ways to store the result of the query , i can store it either in a "string variable" or in an "Array".
' if string variable is used like
dim str as string
str = "('phy','chem','math')" or str = ('eng','oop','db','oose')
(forget this how i saved the data from the query in this string like this )
the only problem with using the string in the query is the outer quots " " . like
recordset1.open "select studentid from student where coursecode = "' & str & '" ",connectionObject,adopenstatic
Now if i use an array for storing the result of the first query. Tell me the way how that array will be use in the second query like
recordset1.open "select studentid from student where coursecode = array ",connectionObject,adopenstatic