[thelist] Part II: ASP, FSO, Replace

Michele Foster michele at wordpro.on.ca
Tue Feb 4 15:19:01 CST 2003


Me again ..

Now part two of the problem ... which I don't think is solvable .. but I can
approach it another way (i.e. evaluate line by line from the text file using
instr() and get it to work ... but thought I would ask here and see if
anyone has any ideas.

strCombo = Replace (strCombo, "<option value=""" & str_Citizenship &
""">","<option selected value=""" & str_Citizenship & """>")

Works great when str_Citizenship = oneNumber

But if it equals more than one .. how to do that?  IOW,  this is a
multi-select list, and the values in the DB are such as 1214,3435,2211 (yes,
I am replacing the standard string delimiter ";" with a "," on insert to the
DB so that it'll work in a multiselect form in Access .. Access doesn't like
the ";".)

I've no idea how to use the Replace above to evaluate it on the multiple
options.

TIA,

Mich





More information about the thelist mailing list