populate fields from db

[r_jayson]

How can I populate other fields from a user option selection? All info is
already in a db. My select code is below. Thanks.

<select name="eventname"
onChange="goType(this.options[this.selectedIndex].value);">
<option value="">Select Physician</option>

<%
sql = "SELECT * from Calendars order by EventName"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn, 3, 3
do while not rs.eof
%>
<option name="eventname" value="<%=rs("eventname")%>"><%= rs("eventname")
%></option>

<%
rs.movenext
Loop
%>
<%
rs.close
set rs = nothing
%>
</select>

 

[Stefan B Rusynko]

Explain "populate other fields from a user option selection"

Your code displays all records' rs("eventname")%, as options and the JavaScript function goType does something w/ the selection by
user

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| How can I populate other fields from a user option selection? All info is
| already in a db. My select code is below. Thanks.
|
| <select name="eventname"
| onChange="goType(this.options[this.selectedIndex].value);">
| <option value="">Select Physician</option>
|
| <%
| sql = "SELECT * from Calendars order by EventName"
| Set rs = Server.CreateObject("ADODB.Recordset")
| rs.Open sql, conn, 3, 3
| do while not rs.eof
| %>
| <option name="eventname" value="<%=rs("eventname")%>"><%= rs("eventname")
| %></option>
|
| <%
| rs.movenext
| Loop
| %>
| <%
| rs.close
| set rs = nothing
| %>
| </select>

 

[r_jayson]

What I desire is to have 3 other fields auto filled in from a table when user
selects from 'eventname'?

 

[Thomas A. Rowe]

The easiest way to accomplish this, is to have the user make selection on one page and then post to
another page to populates these additional fields

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

What I desire is to have 3 other fields auto filled in from a table when user
selects from 'eventname'?

Explain "populate other fields from a user option selection"

Your code displays all records' rs("eventname")%, as options and the JavaScript function goType
does something w/ the selection by
user

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| How can I populate other fields from a user option selection? All info is
| already in a db. My select code is below. Thanks.
|
| <select name="eventname"
| onChange="goType(this.options[this.selectedIndex].value);">
| <option value="">Select Physician</option>
|
| <%
| sql = "SELECT * from Calendars order by EventName"
| Set rs = Server.CreateObject("ADODB.Recordset")
| rs.Open sql, conn, 3, 3
| do while not rs.eof
| %>
| <option name="eventname" value="<%=rs("eventname")%>"><%= rs("eventname")
| %></option>
|
| <%
| rs.movenext
| Loop
| %>
| <%
| rs.close
| set rs = nothing
| %>
| </select>