Question
dynamic drop down based on user selection
hi all, ok, I have a table which contains use data, a name,
and a userID. for the example lets say "Simon Bullen" and my userID
is "999".
on a form I have, there is a dropdown box, which is dynamic from this table, and allows me to select Simon Bullen, however, I have a hidden field on the form, which when the user selects "simon bullen" the hidden field populates with the appropiate U number from the same table.... no i thought this would do it:
<cfquery name="userNumber" datasource="userList">
SELECT userNumber FROM dbo.Users WHERE Name =
<cfqueryparam value="#form.Name#">
</cfquery>
and then my dynamic form field (hidden) would reference to this query....
but it doens't work, could somebody please enlighten me? I'm hoping its something silly
Thanks in advance
on a form I have, there is a dropdown box, which is dynamic from this table, and allows me to select Simon Bullen, however, I have a hidden field on the form, which when the user selects "simon bullen" the hidden field populates with the appropiate U number from the same table.... no i thought this would do it:
<cfquery name="userNumber" datasource="userList">
SELECT userNumber FROM dbo.Users WHERE Name =
<cfqueryparam value="#form.Name#">
</cfquery>
and then my dynamic form field (hidden) would reference to this query....
but it doens't work, could somebody please enlighten me? I'm hoping its something silly
Thanks in advance
AdChoices