Link to home
Start Free TrialLog in
Avatar of fedkris
fedkris

asked on

practical question - help -

i created an patient database, so,when i add an appoitment, i can select date, hour, location and the patient.

if it's a new one, you need to add the name, phone (thats ok for me!)

If it's an existing patient, i created an select listbox. When you have 5 patients thats no problem, but when you have 300 of them, it's not practical, and that's my problem!

how can i fix that? (i can add a search patient, but how can i do, that i click on a patients name and then he add's it to my page?

any idea's ?

lower, the code i have now (it's asp connected to an access database).


</head>
<%
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=" & Server.MapPath("database.accdb")


%>

<body style="background-image: url('images/bg_osteo.png')">

<table cellpadding="0" cellspacing="0" style="width: 100%">
	<tr>
		<td width="75px" class="style3">&nbsp;</td>
		<td width="20px">&nbsp;</td>
		<td width="20px">&nbsp;</td>
		<td width="750px">
		<!-- #include virtual="/test/includes/inc_topmenu.asp" -->
		</td>
		<td width="250px">&nbsp;</td>
	</tr>
	<tr>
		<td width="75px" class="style3">&nbsp;</td>
		<td width="20px">&nbsp;<span class="style3"> &nbsp;</span></td>
		<td width="20px">&nbsp;</td>
		<td width="750px"></td>
		<td width="250px">&nbsp;</td>
	</tr>
	<tr>
		<td class="style3" align="center" valign="top" rowspan="2">
		<br />
		<!-- #include virtual="/test/includes/inc_leftmenu.asp" -->
		</td>
		<td class="style3">&nbsp;</td>
		<td class="style3">&nbsp;</td>
		<td class="style9" valign="top">
		<table cellpadding="0" cellspacing="0" style="width: 100%">
			<tr>
				<td class="style12"><strong>
    			&nbsp;<span class="style13">VOEG AFSPRAAK TOE</span></strong></td>
			</tr>
			<tr>
				<td>
				<table cellpadding="0" cellspacing="0" style="width: 100%">
					<tr>
						<td><br>&nbsp; <img src="images/Calendar-icon.png" />patient 
					<br />
						</td>
						<td>&nbsp;</td>
						<td class="style16"></td>
					</tr>
				</table>
				</td>
			</tr>
		</table>
		</td>
		<td>&nbsp;</td>
	</tr>
	<tr>
		<td class="style3">&nbsp;</td>
		<td class="style5">&nbsp;</td>
		<td class="style4" valign="top">
		
<table align=center width=1000 border=0>
	<tr>
		<td class="style3" colspan="6">
		
		<form action="/test/calendar.asp" method=post id=form1 name=form1>
<table width=850 align=center cellspacing=10>
<tr>
<td >
<span class="style17">Datum (jj/mm/yy):
</td>
<td colspan="2" >
<%if len(Request.QueryString("date"))>o then%>
 </span>
 <input class="style10" type="text" name="date" maxlength=10 size=12 value=<%=day(Request.QueryString("date"))& "/" & month(Request.QueryString("date"))& "/" & year(Request.QueryString("date"))%>>
<span class="style17">
<%else%>
 </span>
 <input class="style10" type="text" name="date" maxlength=10 size=12>
<span class="style17">
<%end if%>
</span>
</td>
</tr>
<tr>
<td class="style17" style="height: 38px" >
Beginuur:
</td>
<td style="height: 38px" >
	<select class=style10 name="heure">
	<option>06</option>
	<%
	for x=7 to 9
	%>
	<option>0<%=x%></option>
	<%next%>
	<%for x=10 to 23
	%>
	<option><%=x%></option>
	<%next%>
	</select><span class="style17"> h
	</span>
	<select class=style10 name="min">
		<option>00</option>
		<option>15</option>
		<option>30</option>
		<option>45</option>
	</select><span class="style17"> </span>
</td>
<td width="400px" style="height: 38px">
							</td>
</tr>
<tr>
<td class="style17" >
Einduur:
</td>
<td >
	<select class=style10 name="heure_fin">
	<option>06</option>
	<%
	for x=7 to 9
	%>
	<option>0<%=x%></option>
	<%next%>
	<%for x=10 to 23
	%>
	<option><%=x%></option>
	<%next%>
	</select><span class="style17"> h
	</span>
	<select class=style10 name="min_fin">
		<option>00</option>
		<option>15</option>
		<option>30</option>
		<option>45</option>
	</select><span class="style17"> </span>
</td>
<td rowspan="3" valign="top" class="style18">
<table cellpadding="0" cellspacing="0" style="width: 100%">
	<tr>
		<td class="style17"><strong>Nieuwe patient:</strong>&nbsp;</td>
		<td class="style17">&nbsp;</td>
	</tr>
	<tr>
		<td class="style17">Naam:</td>
		<td class="style17"><input type="text" value="<%=vname%>" name="name" maxlength="60" class="style10"></td>
	</tr>
	<tr>
		<td class="style17">Voornaam:</td>
		<td class="style17"><input type="text" value="<%=vfirstname%>" name="firstname" maxlength="60" class="style10"></td>
	</tr>
	<tr>
		<td class="style17">Mobile:</td>
		<td class="style17"><input type="text" value="<%=vmobile%>" name="mobile" maxlength="60" class="style10"></td>
	</tr>
	<tr>
		<td class="style17">Mailadres:</td>
		<td class="style17"><input type="text" value="<%=vmail%>" name="email" maxlength="60" class="style10"></td>
	</tr>
	<tr>
		<td class="style17">&nbsp;</td>
		<td class="style17">&nbsp;</td>
	</tr>
</table>
</td>
</tr>
<tr class="style17">
<td >
existing patient:</td>
<td >
<select name="patient" class="style10">
	<option value="" selected>&nbsp;</option>
	<%
	Set rst2= Server.CreateObject("ADODB.Recordset")
	strsql2 = "SELECT * from contacts order	by lastname"
	rst2.Open strsql2,adoCon,,3
	do while not rst2.eof
			Response.Write "<option value=" & rst2("idcontact") & ">" & rst2("lastname")  & " " &rst2("firstname") & "</option>"
	rst2.movenext
	loop
	rst2.close
	%>
	</select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
OF</td>
</tr>
<tr>
<td class="style17" >
Praktijk (locatie) :
</td>
<td >
<select class=style10 name="id_salle">
<option></option>
<option>Beersel</option>
<option>Braine</option>
<option>Dion</option>
</select>


<span class="style17">


</select class="reservation"> 
</span> 
</td>
</tr>
<tr>
<td class=style17 valign=top>
Informatie :
</td>
<td colspan="2" >
 <textarea class=style10 name="comment" rows=5 cols=62></textarea><span class="style17">
 </span>
</td>
</tr>
<tr>
<td colspan=3 align=center class="style17">
&nbsp;
</tr>
<tr>
<td colspan=2 align=center>
<input class=style10 type="hidden" name="approuvé" value=0> 
<input class=style10 type="button" name="<< Back" value="<< Back" onclick="javascript:history.go(-1)"> 
<input class=style10 type="submit" value="Save >>" id=submit1 name=origine_add><span class="style17">
</span>
</tr>
<td align=center>
&nbsp;</tr>
</table>
</form>

		
		
		</td>
	</tr>
	<tr>
		<td class="style3">&nbsp;</td>
		<td class="style3">&nbsp;</td>
		<td class="style3">&nbsp;</td>
		<td class="style10">&nbsp;</td>
		<td class="style10">&nbsp;</td>
		<td>&nbsp;</td>
	</tr>
</table>

</body>

Open in new window

this is a search that is actif an works in an other page

<%
' Declare our variables... always good practice!
Dim strURL     ' The URL of this page so the form will work
               ' no matter what this file is named.
Dim cnnSearch  ' ADO connection
Dim rstSearch  ' ADO recordset
Dim strDBPath  ' path to our Access database (*.mdb) file

Dim strSQL     ' The SQL Query we build on the fly
Dim strSearch  ' The text being looked for

' Retreive the URL of this page from Server Variables
strURL = http://127.0.0.1/test/search_patient.asp

' Retreive the term being searched for.  I'm doing it on
' the QS since that allows people to bookmark results.
' You could just as easily have used the form collection.
strSearch = Request.QueryString("search")
'strSearch = Replace(strSearch, "'", "''")

' Since I'm doing this all in one page I need to see if anyone
' has searched for something.  If they have we hit the DB.
' O/W I just show the search form and quit.

%>
				<table cellpadding="0" cellspacing="0" style="width: 100%">
					<tr>
						<td width="10px">&nbsp;</td>
						<td><form action="<%= strURL %>" method="get">
						<input name="search" value="<%= strSearch %>" />
						<input type="submit" value="zoek" />
						</form><br></td>
					</tr>
				</table>
<%
If strSearch <> "" Then
	strDBPath = Server.MapPath("maud_dejonghe.accdb")

	Set cnnSearch = Server.CreateObject("ADODB.Connection")
	
	strSQL = "SELECT * from contacts where LASTNAME LIKE '%" & Replace(strSearch, "'", "''") & "%'  OR Firstname LIKE '%" & Replace(strSearch, "'", "''") & "%'"
	strsql = strsql & "ORDER BY LASTNAME"

	cnnSearch.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\inetpub\wwwroot\test\database.accdb;Persist Security Info=False;"

	Set rstSearch = cnnSearch.Execute(strSQL)

	%>
	<table>
	<tr>
	<td width="10px"></td>
	<td class="style10">Zoekresultaat :</td>
	</tr>
	<%
	Do While Not rstSearch.EOF
		%>
		<tr>
		<td width="10px"></td>
		<td>
		<a href='../test/patientdetail.asp?origine=0&amp;idcontact=<%=rstSearch("idcontact")%>'>
		<span class="style10">
		-&nbsp;<%= rstSearch.Fields("lastname").Value %></span>&nbsp;<span class="style10"><%= rstSearch.Fields("firstname").Value %></span></a><span class="style10">
		</span>
		</td>
		</tr>
		<%

		rstSearch.MoveNext
	Loop
	%>
	</table>
	<%
	rstSearch.Close
	Set rstSearch = Nothing
	cnnSearch.Close
	Set cnnSearch = Nothing
End If

%>

Open in new window

Avatar of Jerry Miller
Jerry Miller
Flag of United States of America image
If you are using ASP.Net, I would load the search results in a grid view.

Create a form where you have text boxes for each field then you can search on any known value. If you leave them blank, it returns all rows. Gridviews allow you to set the number of records per page and you can sort them by any of the columns.

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.aspx
Avatar of fedkris
fedkris

ASKER

i use simple asp, another solution?
Avatar of Jerry Miller
Jerry Miller
Flag of United States of America image
You could do a check on the number of records returned and display a message box. "Your search has returned greater than 25 records, please narrow your search criteria". This would limit the amount of data in the listbox.

Use the RecordCount property on the recordset.

rstSearch.RecordCount

Avatar of Scott Fell
Scott Fell
Flag of United States of America image
Check out the samples on jquery autocomplete http://jqueryui.com/demos/autocomplete/#combobox.  On the left of that page there are different samples.  Where they have samples using a php as an external datasource you will just use an asp page.  

See if one of those examples works for you and if you need detail for your program let me know.

Where you have your drop down for existing patient: would be replaced by that code.  The look up would be done on an external asp page.  
Avatar of fedkris
fedkris

ASKER

hi padas,

i took ths one: (autocomplete - categories)

now, i want to modify my existing code, how do i start? thx
this is the js code, i need to modify 


	<link rel="stylesheet" href="jquery-ui-1.8.16.custom/development-bundle/themes/base/jquery.ui.all.css">
	<script src="jquery-ui-1.8.16.custom/development-bundle/jquery-1.6.2.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.core.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.widget.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.position.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.autocomplete.js"></script>
	<link rel="stylesheet" href="jquery-ui-1.8.16.custom/development-bundle/demos/demos.css">
	<style>
	.ui-autocomplete-category {
		font-weight: bold;
		padding: .2em .4em;
		margin: .8em 0 .2em;
		line-height: 1.5;
	}
	</style>
	<script>
	$.widget( "custom.catcomplete", $.ui.autocomplete, {
		_renderMenu: function( ul, items ) {
			var self = this,
				currentCategory = "";
			$.each( items, function( index, item ) {
				if ( item.category != currentCategory ) {
					ul.append( "<li class='ui-autocomplete-category'>" + item.category + "</li>" );
					currentCategory = item.category;
				}
				self._renderItem( ul, item );
			});
		}
	});
	</script>
	<script>
	$(function() {
		var data = [
			{ label: "anders", category: "" },
			{ label: "andreas", category: "" },
			{ label: "antal", category: "" },
			{ label: "annhhx10", category: "Products" },
			{ label: "annk K12", category: "Products" },
			{ label: "annttop C13", category: "Products" },
			{ label: "anders andersson", category: "People" },
			{ label: "andreas andersson", category: "People" },
			{ label: "andreas johnson", category: "People" }
		];
		
		$( "#search" ).catcomplete({
			delay: 0,
			source: data
		});
	});
	</script>
</head>
<body>

<div class="demo">
	<label for="search">Search: </label>
	<input id="search" />
</div><!-- End demo -->



<div class="demo-description">
<p>A categorized search result. Try typing "a" or "n".</p>
</div><!-- End demo-description -->

Open in new window

this is the code i had, to find all my patients 

<%
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=" & Server.MapPath("database.accdb")


%>


<select name="patient" class="style10">
	<option value="" selected>&nbsp;</option>
	<%
	Set rst2= Server.CreateObject("ADODB.Recordset")
	strsql2 = "SELECT * from contacts order	by lastname"
	rst2.Open strsql2,adoCon,,3
	do while not rst2.eof
			Response.Write "<option value=" & rst2("idcontact") & ">" & rst2("lastname")  & " " &rst2("firstname") & "</option>"
	rst2.movenext
	loop
	rst2.close
	%>
	</select>

Open in new window

Avatar of Scott Fell
Scott Fell
Flag of United States of America image
where you have 

		var data = [
			{ label: "anders", category: "" },
			{ label: "andreas", category: "" },
			{ label: "antal", category: "" },
			{ label: "annhhx10", category: "Products" },
			{ label: "annk K12", category: "Products" },
			{ label: "annttop C13", category: "Products" },
			{ label: "anders andersson", category: "People" },
			{ label: "andreas andersson", category: "People" },
			{ label: "andreas johnson", category: "People" }
		];

Open in new window


you can replace with

		var data = [

                       <%  
                         if not rst2.eof or not rst2.bof then ' make sure there is data
                              do until rst2.eof 'start loop
                                 response.write "{Name: """&rst2("lastname") &" "&rst2("firstname") &""", ID: """&rst2("idcontact") &""" }," 'sample data { label: "annhhx10", category: "Products" },

                              rs2.movenext
                              loop
                        end if
                        %>
			
		
		];

Open in new window


If you have just have a few hundred contacts this will work fine.  If you have thousands of contacts, the page could take a little time to load and then I would suggest pulling the data from a separate asp page where the typed text the search box acts as a filter.
Avatar of fedkris
fedkris

ASKER

hi, when i modify the code, and replace what you gave me, he doesn't load the page, he does'nt load the search...


thx for what you did, but do you know a solution? thx
Avatar of fedkris
fedkris

ASKER

this is the error in the sourcecode of the page

            var data = [

                        <font face="Arial" size=2>
<p>Microsoft VBScript runtime </font> <font face="Arial" size=2>error '800a01a8'</font>
<p>
<font face="Arial" size=2>Object required: ''</font>
<p>
<font face="Arial" size=2>/test/Reservation_add.asp</font><font face="Arial" size=2>, line 162</font>
Avatar of Scott Fell
Scott Fell
Flag of United States of America image
I just noticed you are using both rstSearch.Fields("lastname").Value  and  rst2("lastname").   Is your recordset rstSearch or rs2?

If it is rstSearch then use that in place of rs2.
Avatar of fedkris
fedkris

ASKER

this is the code i use now
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="nl-be" http-equiv="Content-Language" />
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>add reservation</title>


 

</head>
<%
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=" & Server.MapPath("database.accdb")


%>

<body style="background-image: url('images/bg_osteo.png')">

<table cellpadding="0" cellspacing="0" style="width: 100%">
	<tr>
		<td width="75px" class="style3">&nbsp;</td>
		<td width="20px">&nbsp;</td>
		<td width="20px">&nbsp;</td>
		<td width="750px">
		<!-- #include virtual="/test/includes/inc_topmenu.asp" -->
		</td>
		<td width="250px">&nbsp;</td>
	</tr>
	<tr>
		<td width="75px" class="style3">&nbsp;</td>
		<td width="20px">&nbsp;<span class="style3"> &nbsp;</span></td>
		<td width="20px">&nbsp;</td>
		<td width="750px"></td>
		<td width="250px">&nbsp;</td>
	</tr>
	<tr>
		<td class="style3" align="center" valign="top" rowspan="2">
		<br />
		<!-- #include virtual="/test/includes/inc_leftmenu.asp" -->
		</td>
		<td class="style3">&nbsp;</td>
		<td class="style3">&nbsp;</td>
		<td class="style9" valign="top">
		<table cellpadding="0" cellspacing="0" style="width: 100%">
			<tr>
				<td class="style12"><strong>
    			&nbsp;<span class="style13">VOEG AFSPRAAK TOE</span></strong></td>
			</tr>
			<tr>
				<td>
				<table cellpadding="0" cellspacing="0" style="width: 100%">
					<tr>
						<td><br>&nbsp; <img src="images/Calendar-icon.png" />patient 
						opzoeken = )als lange lijst bestaande patienten, andere 
						oplossing???? in kalender
						rasterlijnen toevoegen + appoint ten opzichte van deze 
						lijnen in juiste tijdzone zetten
						
</head>
<body>

						<br />
	<link rel="stylesheet" href="jquery-ui-1.8.16.custom/development-bundle/themes/base/jquery.ui.all.css">
	<script src="jquery-ui-1.8.16.custom/development-bundle/jquery-1.6.2.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.core.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.widget.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.position.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.autocomplete.js"></script>
	<link rel="stylesheet" href="jquery-ui-1.8.16.custom/development-bundle/demos/demos.css">
	<style>
	.ui-autocomplete-category {
		font-weight: bold;
		padding: .2em .4em;
		margin: .8em 0 .2em;
		line-height: 1.5;
	}
	</style>
	<script>
	$.widget( "custom.catcomplete", $.ui.autocomplete, {
		_renderMenu: function( ul, items ) {
			var self = this,
				currentCategory = "";
			$.each( items, function( index, item ) {
				if ( item.category != currentCategory ) {
					ul.append( "<li class='ui-autocomplete-category'>" + item.category + "</li>" );
					currentCategory = item.category;
				}
				self._renderItem( ul, item );
			});
		}
	});
	</script>
	
	<%
	Set rst2= Server.CreateObject("ADODB.Recordset")
	strsql2 = "SELECT * from contacts order	by lastname"
	rst2.Open strsql2,adoCon,,3

%>
	<script>
	$(function() {
		var data = [

                       <% if not rst2.eof or not rst2.bof then ' make sure there is data
                              do until rst2.eof 'start loop
                                 response.write "{Name: """&rst2("lastname") &" "&rst2("firstname") &""", ID: """&rst2("idcontact") &""" }," 'sample data { label: "annhhx10", category: "Products" },

                              rs2.movenext
                              loop	
                              
                        end if  %>
			
		
		];
				$( "#search" ).catcomplete({
			delay: 0,
			source: data
		});
	});
	</script>
<%
rst2.close

%>
</head>
<body>

<div class="demo">
	<label for="search">Search: </label>
	<input id="search" />
</div><!-- End demo -->

						<br />
						
	&nbsp;</td>

Open in new window

Avatar of Scott Fell
Scott Fell
Flag of United States of America image
Are you getting the same error but now on line 106?  Object Required is something to do with your database.  It has been a long time since I used access so I don't know the latest in connecting with the database.  

Is your database named correctly? database.accdb?  

Is the path correct? Server.MapPath("database.accdb") means your database is in the same folder as your asp page, right?

After you double check that, if you are still having problems with the database I found this http://digitallibraryworld.com/?p=6
Avatar of fedkris
fedkris

ASKER

hi, now the code works correclty, link with db is ok, but i recieve "undefined" ...


no names...
<!DOCTYPE html>
<html lang="en">
<head>
<%
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=" & Server.MapPath("database.accdb")


	Set rst2= Server.CreateObject("ADODB.Recordset")
	strsql2 = "SELECT * from contacts order	by lastname"
	rst2.Open strsql2,adoCon,,3


%>

	<meta charset="utf-8">
	<title>jQuery UI Autocomplete - Categories</title>
	<link rel="stylesheet" href="jquery-ui-1.8.16.custom/development-bundle/themes/base/jquery.ui.all.css">
	<script src="jquery-ui-1.8.16.custom/development-bundle/jquery-1.6.2.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.core.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.widget.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.position.js"></script>
	<script src="jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.autocomplete.js"></script>
	<link rel="stylesheet" href="jquery-ui-1.8.16.custom/development-bundle/demos/demos.css">
	<style>
	.ui-autocomplete-category {
		font-weight: bold;
		padding: .2em .4em;
		margin: .8em 0 .2em;
		line-height: 1.5;
	}
	</style>
	<script>
	$.widget( "custom.catcomplete", $.ui.autocomplete, {
		_renderMenu: function( ul, items ) {
			var self = this,
				currentCategory = "";
			$.each( items, function( index, item ) {
				if ( item.category != currentCategory ) {
					ul.append( "<li class='ui-autocomplete-category'>" + item.category + "</li>" );
					currentCategory = item.category;
				}
				self._renderItem( ul, item );
			});
		}
	});
	</script>
	<script>
	$(function() {
		var data = [

                       <%  
                         if not rst2.eof or not rst2.bof then ' make sure there is data
                              do until rst2.eof 'start loop
                                 response.write "{Name: """&rst2("lastname") &" "&rst2("firstname") &""", ID: """&rst2("idcontact") &""" }," 'sample data { label: "annhhx10", category: "Products" },

                              rst2.movenext
                              loop

                        %>
			
		
		];		
		$( "#search" ).catcomplete({
			delay: 0,
			source: data
		});
	});	
	
	</script>
	<%                        end if	
                        rst2.close

	%>

</head>
<body>


<div class="demo">
	<label for="search">Search: </label>
	<input id="search" />
</div><!-- End demo -->



<div class="demo-description">
<p>A categorized search result. Try typing "a" or "n".</p>
</div><!-- End demo-description -->

</body>
</html>

Open in new window

Avatar of fedkris
fedkris

ASKER

but in the source code it's:


var data = [

                       {Name: "Bourins step", ID: "29" },{Name: "de Quirini Guibert", ID: "28" },{Name: "Defever Simone", ID: "21" },{Name: "degreve anton", ID: "24" },{Name: "delfosse jan", ID: "79" },{Name: "delhez kristof", ID: "78" },{Name: "Dereumaux Catherine", ID: "26" },{Name: "devos jan", ID: "82" },{Name: "ellen verstraete", ID: "86" },{Name: "Gonsalez Jeremy", ID: "22" },{Name: "jan Simon", ID: "74" },{Name: "Jockir Jeremy", ID: "30" },{Name: "kkkkk ", ID: "80" },{Name: "Michiels Mireille", ID: "25" },{Name: "Renier Geraldine", ID: "23" },{Name: "slaets veronique", ID: "87" },{Name: "timmer anne", ID: "85" },{Name: "timmer anne", ID: "84" },{Name: "timmer anne", ID: "83" },{Name: "vermeire alain", ID: "81" },{Name: "verstrate ellen", ID: "31" },
                  
            
            ];            


the different id's...
ASKER CERTIFIED SOLUTION
Avatar of Scott Fell
Scott Fell
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of fedkris
fedkris

ASKER

hey,

this works,the only thing i need is

previous in my listbox, you saw the name, and the parameter i sended to the other page (was hidden) was the id (exemple)

<option value=" & rst2("idcontact") & ">" & rst2("lastname")  & " " &rst2("firstname") & "</option>

how can you modify this code, to obtain the same? (here "catergory contains the id, how do i transfer it?)

Avatar of Scott Fell
Scott Fell
Flag of United States of America image
Did you get that to work?