asp and combo box
Hi, Can you please help me with the following; I have a sql database with movie names. I have a visual basic dll with the following code: Function allmovies() Dim StrSql As String allmovies = allmovies & ``<html><body><table>`` Rs.Open ``select moviename from movies``, Cn, adOpenKeyset, adLockOptimistic For i = 1 To Rs.RecordCount allmovies = allmovies & ``<td><tr> `` & Rs.Fields(``Moviename``) & ``</td></tr>`` Rs.MoveNext allmovies = allmovies & ``</table></body></html>`` Next i End Function ---------------------------------------------------------------------------------------------------------- I have a asp page with a combo box where i want to enter the movie names from the database. i want it done automatically so if i change a movie in the db the combo box will be updated accordingly. How can i write it? I will appreciate your help.
Hi, Can you please help me with the following; I have a sql database with movie names. I have a visual basic dll with the following code: Function allmovies() Dim StrSql As String allmovies = allmovies & ``<html><body><table>`` Rs.Open ``select moviename from movies``, Cn, adOpenKeyset, adLockOptimistic For i = 1 To Rs.RecordCount allmovies = allmovies & ``<td><tr> `` & Rs.Fields(``Moviename``) & ``</td></tr>`` Rs.MoveNext allmovies = allmovies & ``</table></body></html>`` Next i End Function ---------------------------------------------------------------------------------------------------------- I have a asp page with a combo box where i want to enter the movie names from the database. i want it done automatically so if i change a movie in the db the combo box will be updated accordingly. How can i write it? I will appreciate your help.
