Generate variables from SQL recordset using classic ASP/VBScript
Posted on 2010-01-06
I have an SQL recordset rsTran that gives translations of some words. The key fields in a record are WordID, WordOrig, WordTran. Note that WordID is not an index (there is a separate one), and WordTran sometimes is null.
I want to generate variables that can be used in classic ASP webpages for the words from this recordset, but am having difficulty. The variables would be for example <%=word11%> where word11 is defined either equal to WordTran (if not null) or else WordOrig, where the WordID is 11.
How to do this, using a repeat region that expands automatically as more words are added to the recordset?