[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