searching recordset

[MikeDNova]

hey guys hows it goin???

i have a recordset that contains fields labeled:
sentence1, sentence2, ... sentenceA, sentenceB

now i'm trying to find a way to retrieve the values of these fields. obviously i'm goin to loop through the recordset for each field. however, i'm not sure how to specify the wildcard because i'm not sure how many sentence fields are going to be in each recordset.

i've tried syntax such as string = rs(like "sentence*&quot

any suggetions would be greatly appreciated!
thanks in advance!
mike
mikednova@hotmail.com

 

[grnzbra]

Are the "sentence" fields the only fields in the table. If not, what other kinds of things are in the table. how are these various "sentence" fields going to be used?

 

[LittleSmudge]

So how have you managed to create a recordset with an unknown number of fields in it ?

Where do you get this variable number of fields from ?


I can think of a way of doing what you're asking, but I REALLY get the feeling that you shouldn't be asking. I suspect there is a much better structure that will avoid the problem all together.




G LS

 

[MikeDNova]

ok i'm sorry. the field name is not sentence....
its "QuestionType" the strings within this field are
sentence1, sentence2, etc...

other fields in this recordset besides QuestionType are QuestionID, CategoryID, etc...

thanks again
mike

 

[MikeDNova]

i got it nevermind i'm an idiot!! brain fart!! hahaha

too hungover today to think!!!



-Mike

 

[LittleSmudge]

A clear case of "Using the correct term to describe the problem - leading to a clear understanding of the issue - leading to the solution" !


:- )

G LS