Concatinating database fields in a drop down box

cwolgamott · Jun 21, 2002

Hello.

I am having great difficulty in figuring out how to create a drop down box (or menu) by concatinating two database fields, and then trying to pass the selection to another ASP page. Here is the code I use to create the drop down:

if NOT rs.eof then
rs.movefirst
nameArea = nameArea + "<SELECT NAME=full_name>"

Do until rs.eof
nameArea = nameArea + "<OPTION VALUE=''>" + rs("first_name&quot

+ " " + rs("last_name&quot

recCounter = recCounter + 1
rs.movenext

Then, on the page I am trying to pass it to, I use this code to assign it to a variable:

inputFullName = rs("full_name&quot

After that, I try to use it in the WHERE clause in my select statement. The only catch is, I need to compare the first_name that was put into the drop down with a first_name field and the last_name that was put into the drop down with a last_name field. In other words, I need to pass these values separately. I have tried everything that I can think of. I would greatly appreciate any suggestions that I can get.

Thank you.

SashiRaveendran · Jun 21, 2002

you can split the form data into the two parts first name and last name:

dim arrFNLN
dim strFN
dim strLN
inputFullName = "John Smith"
arrFNLN = Split(inputFullName, " &quot

If UBound(arrFNLN) = 1 Then
strFN = arrFNLN(0)
strLN = arrFNLN(1)
end if

cwolgamott · Jun 21, 2002

Hello.

Thank you so much for your reply.

I really appreciate it. I tried the coding that you gave me, but it does not seem to bring back any data. Here is coding that I am using to build the drop down:

SQL = "Select "
SQL = SQL + "first_name + ' ' + last_name as fullname From Employees"
SQL = SQL + " ORDER BY first_name ASC"

rs.movefirst
nameArea = nameArea + "<SELECT NAME=fullname>"

Do until rs.eof
nameArea = nameArea + "<OPTION VALUE=''>" + rs("fullname&quot

recCounter = recCounter + 1
rs.movenext

Then, I tried this coding on the page that I want to pass the name to:

inputFullName = Request("fullname&quot

arrFullName = Split(inputFullName," &quot

If UBound(arrFullName) = 1 Then
strFN = arrFullName(0)
strLN = arrFullName(1)
End If

SQL = "Select "
SQL = SQL + "last_name, first_name, email, extension, userid, work_site FROM Employees WHERE "
SQL = SQL + "first_name=" & "'" & strFN & "'" & " AND last_name=" & "'" & strLN & "'"

I just cannot seem to figure out where I am going wrong. I would greatly appreciate any suggestions or help.

Thanks again.

SashiRaveendran · Jun 21, 2002

Example:

<BODY>
<form action="ASP.asp" method=post>
<select name="fullname">
<option value="John Smith">John Smith
<option value="John Smith1">John Smith1
<option value="John Smith2">John Smith2
</select>
<input type=Submit>
</form>

</BODY>

file ASP.asp:

Dim arrFNLN
Dim strFN
Dim strLN
Dim inputFullName
inputFullName = Request.Form("fullname&quot

arrFNLN = Split(inputFullName, " &quot

If UBound(arrFNLN) = 1 Then
strFN = arrFNLN(0)
strLN = arrFNLN(1)
End If
Response.Write strFN & ":" & strLN

the above code works fine for me.

harmmeijer · Jun 21, 2002

The value of your select is not set, only the innerHTML of the option instances of the select, this can only be used in client script.
You should write your option like so:

"<OPTION VALUE='" & rs("fullname&quot

& "'>" + rs("fullname&quot

You will have a problem if someone's got the ' in their name.
You can replace this ' with the text in the following line please remove the spaces.
& # 3 9 ;

cwolgamott · Jun 21, 2002

Thank you so much harmmeijer and sjravee for all of your help and suggestions.

I appreciate it so much.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Concatinating database fields in a drop down box

cwolgamott

Programmer

SashiRaveendran

Programmer

cwolgamott

Programmer

SashiRaveendran

Programmer

harmmeijer

Programmer

cwolgamott

Programmer

Similar threads

Part and Inventory Search

Sponsor