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

fedkrisAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jerry MillerCommented:
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
0
fedkrisAuthor Commented:
i use simple asp, another solution?
0
Jerry MillerCommented:
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

0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
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.  
0
fedkrisAuthor Commented:
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

0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
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.
0
fedkrisAuthor Commented:
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
0
fedkrisAuthor Commented:
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>
0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
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.
0
fedkrisAuthor Commented:
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

0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
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
0
fedkrisAuthor Commented:
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

0
fedkrisAuthor Commented:
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...
0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
That's my fault for changing names...

change:
response.write "{Name: """&rst2("lastname") &" "&rst2("firstname") &""", ID: """&rst2("idcontact") &""" }," 'sample data { label: "annhhx10", category: "Products" }

to below by switching out name for label and ID for category

response.write "{label: """&rst2("lastname") &" "&rst2("firstname") &""", category: """&rst2("idcontact") &""" }," 'sample data { label: "annhhx10", category: "Products" }
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fedkrisAuthor Commented:
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?)

0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
Did you get that to work?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.