I surely do need you guy's help...
I'm currently developing a DHTML project...
I'm including a htm file to the DHTML page.
I would like to get the values of the database and display in the drop down list box. I'm using data environment...
here's my code:
<SELECT id=selCurrency name=selCurrency>
<OPTION value="">Select a Currency</OPTION>
<OPTION value="">-----------------</OPTION>
SQL="SELECT Currency_ID, Currency FROM Currency_Code"
Set fso = CreateObject("Scripting.FileSystemObject")
Set rsCurrency = fso.OpenRecordset(SQL)
<%If Not rsCurrency.EOF Then
Do until rsCurrency.EOF
Response.write("<OPTION value='" & trim(rsCurrency("Currency")) & "'>" & trim(rsCurrency("Currency")) & "</OPTION>")
rsCurrency.Movenext
Loop
End If%>
</SELECT>