Code Bank
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Programming > Code Bank
Reload this Page

Classic ASP/AJAX - Auto Suggest Form

Discuss Auto Suggest Form in the Code Bank forum on ASP Free.
Auto Suggest Form Code Bank forum containing sample code and scripts to help solve common problems. Take a look and use the code to assist in your projects.

Record onscreen activity, your voice & webcam video. Turn everyday presentations into HD-quality videos.

For perfectly clear screencasts every time.
Build the right apps the right way with powerful development tools.


Visual Studio 2010. Learn more.
We cover the world of technology like no one else, constantly updating you with the best information available on open source software, Microsoft technologies, hardware and news from around the world.

Try Camtasia Studio today!
www.microsoft.com/visualstudio.com
Sign up today!

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old November 20th, 2007, 05:15 PM
alexk13's Avatar
alexk13 alexk13 is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Jul 2005
Location: Sydney, Australia
Posts: 213 alexk13 User rank is Second Lieutenant (5000 - 10000 Reputation Level)alexk13 User rank is Second Lieutenant (5000 - 10000 Reputation Level)alexk13 User rank is Second Lieutenant (5000 - 10000 Reputation Level)alexk13 User rank is Second Lieutenant (5000 - 10000 Reputation Level)alexk13 User rank is Second Lieutenant (5000 - 10000 Reputation Level)alexk13 User rank is Second Lieutenant (5000 - 10000 Reputation Level)alexk13 User rank is Second Lieutenant (5000 - 10000 Reputation Level) 
Time spent in forums: 1 Week 1 Day 3 h 30 m 52 sec
Reputation Power: 89
Classic ASP/AJAX - Auto Suggest Form
Hi Guys

I just posted this as a reply to this query , and thought I would share it here also

OK, here we go:

This is the main page, with a small form, and includes the javascript (further down this post) that talks to the ASP script on the server (even further down this post) to get the suggestions
ASP Code:
Original - ASP Code 
  1. <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
  2. <html>
  3. <head>
  4. <script src="clienthint.js"></script> 
  5. </head>
  6. <body>
  7.  
  8. <form> 
  9. Enter Word:
  10. <input type="text" id="txt1"
  11. onkeyup="showHint(this.value)">
  12. </form>
  13.  
  14. <p>Suggestions: <span id="txtHint"></span></p> 
  15.  
  16. </body>
  17. </html>


This is the javascript:
JavaScript Code:
Original - JavaScript Code 
  1. var xmlHttp
  2.  
  3. function showHint(str)
  4. {
  5. if (str.length==0)
  6.   { 
  7.   document.getElementById("txtHint").innerHTML="";
  8.   return;
  9.   }
  10. xmlHttp=GetXmlHttpObject()
  11. if (xmlHttp==null)
  12.   {
  13.   alert ("Your browser does not support AJAX!");
  14.   return;
  15.   } 
  16. var url="gethint.asp";
  17. url=url+"?q="+str;
  18. url=url+"&sid="+Math.random();
  19. xmlHttp.onreadystatechange=stateChanged;
  20. xmlHttp.open("GET",url,true);
  21. xmlHttp.send(null);
  22. } 
  23.  
  24. function stateChanged() 
  25. { 
  26. if (xmlHttp.readyState==4)
  27. { 
  28. document.getElementById("txtHint").innerHTML=xmlHttp.responseText;
  29. }
  30. }
  31.  
  32. function GetXmlHttpObject()
  33. {
  34. var xmlHttp=null;
  35. try
  36.   {
  37.   // Firefox, Opera 8.0+, Safari
  38.   xmlHttp=new XMLHttpRequest();
  39.   }
  40. catch (e)
  41.   {
  42.   // Internet Explorer
  43.   try
  44.     {
  45.     xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
  46.     }
  47.   catch (e)
  48.     {
  49.     xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
  50.     }
  51.   }
  52. return xmlHttp;
  53. }

and this is the ASP script on the server:
ASP Code:
Original - ASP Code 
  1. <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
  2. <%
  3. response.expires=-1
  4. Dim rsWords
  5. Dim rsWords_numRows
  6. Dim q
  7. Dim hint
  8. q=ucase(request.querystring("q"))
  9. hint=""
  10. Set rsWords = Server.CreateObject("ADODB.Recordset")
  11. rsWords.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db_hint_words.mdb")
  12. rsWords.Source = "SELECT *  FROM TBL_WORDS  WHERE (word LIKE'" + q + "%') ORDER BY WORD"
  13. rsWords.CursorType = 2
  14. rsWords.CursorLocation = 2
  15. rsWords.LockType = 3
  16. rsWords.Open()
  17. rsWords_numRows = 0
  18.  
  19. If Not rsWords.EOF Then
  20.     Do While Not rsWords.EOF
  21.         If trim(hint) = "" Then
  22.             hint = rsWords("word")
  23.         Else
  24.             hint = hint & " , " & rsWords("word")
  25.         End If
  26.         rsWords.MoveNext()
  27.     Loop
  28. End If
  29. if trim(hint)="" then 
  30.   response.write("no suggestion")
  31. else
  32.   response.write(hint)
  33. end if
  34.  
  35. rsWords.Close()
  36. Set rsWords = Nothing
  37. %>

This one talks to the access database to get any words that start with whatever is the form field - and this is done each time the content of that field change (each and every keystroke)

I have attached a ZIP file of this code with an Access DB, containing a list of Railway Station names in Sydney, Australia (300+ entries, so a good sample of the code can be run ).

If you would like to see this in action, you can view it on my development server at http://dev.unimaetrix.com/hint/clienthint.asp

The layout of the page is very simple as it is ony a sample of the scripts in action.

Let me know if you need any further assistance , or if you find any errors in my code.
Attached Files
File Type: zip gethint.zip (20.9 KB, 1151 views)
__________________
Alex - Lucky Number 13

Did I do something that helped you? - please click the scales and help my rep
Reply With Quote
  #2  
Old November 29th, 2007, 03:23 PM
alexk13's Avatar
alexk13 alexk13 is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Jul 2005
Location: Sydney, Australia
Posts: 213 alexk13 User rank is Second Lieutenant (5000 - 10000 Reputation Level)alexk13 User rank is Second Lieutenant (5000 - 10000 Reputation Level)alexk13 User rank is Second Lieutenant (5000 - 10000 Reputation Level)alexk13 User rank is Second Lieutenant (5000 - 10000 Reputation Level)alexk13 User rank is Second Lieutenant (5000 - 10000 Reputation Level)alexk13 User rank is Second Lieutenant (5000 - 10000 Reputation Level)alexk13 User rank is Second Lieutenant (5000 - 10000 Reputation Level) 
Time spent in forums: 1 Week 1 Day 3 h 30 m 52 sec
Reputation Power: 89
In the thread mentioned in the above post, there was a query about making the suggestions clickable, so here is some more code for that purpose:

Clickable suggestion that populate the text box
I haven't got the autosubmit to work yet tho

ASP Code:
Original - ASP Code 
  1. <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
  2. <html>
  3. <head>
  4. <script src="clienthint.js"></script> 
  5. </head>
  6. <body>
  7. <%
  8. 'this displays the value of the textbox after the form is submitted
  9. If trim(Request("txt1")) <> "" Then
  10.     Response.Write "You entered:"
  11.     Response.Write "<b>" & Request("txt1") & "</b><br /><br />"
  12. End If
  13. %>
  14. <form name="form1" action="clienthint.asp" method="post">
  15. Enter Word:
  16. <input type="text" name="txt1" id="txt1" onKeyUp="showHint(this.value,'txt1','form1',true)">
  17. <input type="submit" name="submit" value="submit">
  18. </form>
  19. <p>Suggestions: <span id="txtHint"></span></p> 
  20. </body>
  21. </html>


JavaScript Code:
Original - JavaScript Code 
  1. var xmlHttp
  2.  
  3. function showHint(str, box, thisForm, autoSubmit)
  4. {
  5. if (str.length==0)
  6.   { 
  7.   document.getElementById("txtHint").innerHTML="";
  8.   return;
  9.   }
  10. xmlHttp=GetXmlHttpObject()
  11. if (xmlHttp==null)
  12.   {
  13.   alert ("Your browser does not support AJAX!");
  14.   return;
  15.   } 
  16. var url="gethint.asp";
  17. url=url+"?q="+str;
  18. url=url+"&b="+box;
  19. url=url+"&f="+thisForm;
  20. url=url+"&a="+autoSubmit;
  21. url=url+"&sid="+Math.random();
  22. xmlHttp.onreadystatechange=stateChanged;
  23. xmlHttp.open("GET",url,true);
  24. xmlHttp.send(null);
  25. } 
  26.  
  27. function stateChanged() 
  28. { 
  29. if (xmlHttp.readyState==4)
  30. { 
  31. document.getElementById("txtHint").innerHTML=xmlHttp.responseText;
  32. }
  33. }
  34.  
  35. function GetXmlHttpObject()
  36. {
  37. var xmlHttp=null;
  38. try
  39.   {
  40.   // Firefox, Opera 8.0+, Safari
  41.   xmlHttp=new XMLHttpRequest();
  42.   }
  43. catch (e)
  44.   {
  45.   // Internet Explorer
  46.   try
  47.     {
  48.     xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
  49.     }
  50.   catch (e)
  51.     {
  52.     xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
  53.     }
  54.   }
  55. return xmlHttp;
  56. }
  57.  
  58. //this function allows for Clickable suggestions
  59. function setTextBox(thisText,thisBox,thisForm,autoSubmit){
  60.     document.getElementById(thisBox).value = thisText
  61.     //this autoSubmits the form after a suggestion is clicked - it is not working :(
  62.     //if(autoSubmit=='true'){
  63.     //  alert(thisForm);
  64.     //  document.getElementById(thisForm).submit();
  65.     //}
  66. }


ASP Code:
Original - ASP Code 
  1. <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
  2. <%
  3. response.expires=-1
  4. Dim rsWords
  5. Dim rsWords_numRows
  6. Dim q
  7. Dim b
  8. Dim hint
  9. q=ucase(request.querystring("q"))
  10. b=(request.querystring("b"))
  11. f=(request.querystring("f"))
  12. a=(request.querystring("a"))
  13. hint=""
  14. Set rsWords = Server.CreateObject("ADODB.Recordset")
  15. rsWords.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db_hint_words.mdb")
  16. rsWords.Source = "SELECT *  FROM TBL_WORDS  WHERE (word LIKE'" + q + "%') ORDER BY WORD"
  17. rsWords.CursorType = 2
  18. rsWords.CursorLocation = 2
  19. rsWords.LockType = 3
  20. rsWords.Open()
  21. rsWords_numRows = 0
  22.  
  23. If Not rsWords.EOF Then
  24.     Do While Not rsWords.EOF
  25.         If trim(hint) = "" Then
  26.             hint = "<a href=""javascript:setTextBox('" & rsWords("word") & "','" & b & "','" & f & "','" & a & "');"">" & rsWords("word") & "</a>"
  27.         Else
  28.             hint = hint & " , <a href=""javascript:setTextBox('" & rsWords("word") & "','" & b & "','" & f & "','" & a & "');"">" & rsWords("word") & "</a>"
  29.         End If
  30.         rsWords.MoveNext()
  31.     Loop
  32. End If
  33. if trim(hint)="" then 
  34.   response.write("no suggestion")
  35. else
  36.   response.write(hint)
  37. end if
  38.  
  39. rsWords.Close()
  40. Set rsWords = Nothing
  41. %>


New Zip attached of this version

You can also see it working at : http://dev.unimaetrix.com/hint2/clienthint.asp

I'll continue to try to get the autosubmit when a suggestion is clicked - if I succeed, I'll post the function for that here also
Attached Files
File Type: zip gethint2.zip (21.3 KB, 918 views)
Reply With Quote
  #3  
Old June 27th, 2008, 05:22 PM
phoenixaz phoenixaz is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Feb 2008
Posts: 565 phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 5 Days 9 h 36 m 49 sec
Reputation Power: 26
autosuggest
Do have a modified version of this code that would keep the suggested words in the textbox (from the databse field) so you can tab through or click on and then submit to your page.

Thanks!
Reply With Quote
  #4  
Old July 3rd, 2008, 01:43 PM
baseballdude_'s Avatar
baseballdude_ baseballdude_ is offline
Expert Learner
ASP Free Intermediate (1500 - 1999 posts)
  
Join Date: Feb 2005
Location: Wisconsin
Posts: 1,907 baseballdude_ User rank is Second Lieutenant (5000 - 10000 Reputation Level)baseballdude_ User rank is Second Lieutenant (5000 - 10000 Reputation Level)baseballdude_ User rank is Second Lieutenant (5000 - 10000 Reputation Level)baseballdude_ User rank is Second Lieutenant (5000 - 10000 Reputation Level)baseballdude_ User rank is Second Lieutenant (5000 - 10000 Reputation Level)baseballdude_ User rank is Second Lieutenant (5000 - 10000 Reputation Level)baseballdude_ User rank is Second Lieutenant (5000 - 10000 Reputation Level)  Folding Points: 22104 Folding Title: Starter FolderFolding Points: 22104 Folding Title: Starter Folder
Time spent in forums: 1 Week 5 Days 15 h 28 m 41 sec
Reputation Power: 93
Send a message via AIM to baseballdude_ Send a message via MSN to baseballdude_ Send a message via Yahoo to baseballdude_ Send a message via Google Talk to baseballdude_
Rather than using onkeyup straight, I'd recommend using something like the following function, which dramatically reduces the number of AJAX calls, and is still as (if not more) effective for the client.

Usage:
Code:
<input type="text" name="q" onkeyup="search_delay(this)" />


Code:
function search_delay(element) {
	// Create a function to get the search results
	var func = function() { getBox(document.getElementById('ab_q').value, 'RhapArtist', 10); };

	// Check to see if there is already a timeout and if so...
	// ...cancel it and create a new one
	if ( element.zid ) {
		clearTimeout(element.zid);
	}
	element.zid = setTimeout(func,500);
}
Reply With Quote
  #5  
Old July 3rd, 2008, 11:38 PM
phoenixaz phoenixaz is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Feb 2008
Posts: 565 phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 5 Days 9 h 36 m 49 sec
Reputation Power: 26
I am not able to get it to work. Am I suppose to but the following code in the bottom of the clienthint.js file?

Code:
function search_delay(element) {
	// Create a function to get the search results
	var func = function() { getBox(document.getElementById('ab_q').value, 'RhapArtist', 10); };

	// Check to see if there is already a timeout and if so...
	// ...cancel it and create a new one
	if ( element.zid ) {
		clearTimeout(element.zid);
	}
	element.zid = setTimeout(func,500);
}
Last edited by phoenixaz : July 4th, 2008 at 02:33 AM.
Reply With Quote
  #6  
Old July 4th, 2008, 12:19 AM
phoenixaz phoenixaz is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Feb 2008
Posts: 565 phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 5 Days 9 h 36 m 49 sec
Reputation Power: 26
I think I am having a brain cramp because I can't seem to substitute my sql connection with your access database connection.

Here is my sql connection. Can you suggest how I make the changes?

Code:
set objConn = server.CreateObject("adodb.connection")
objConn.Open application("my_ConnectionString")


SQL = "select * from table1 WHERE (studentname LIKE'" + q + "%') order by studentname"

Set objRS = objConn.Execute(SQL)


I tried changing objrs to rswords, but that didn't work. And when you had rsWords("word") I changed that to rsWords("studentname")

Any suggestions would be appreciated.

Thanks
Reply With Quote
  #7  
Old July 4th, 2008, 03:13 AM
phoenixaz phoenixaz is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Feb 2008
Posts: 565 phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 5 Days 9 h 36 m 49 sec
Reputation Power: 26
I was able to get it to work, but had to comment out 5 lines of code. Any thoughts?

Code:
set objConn = server.CreateObject("adodb.connection")
objConn.Open application("My_ConnectionString")
strSQL = "SELECT studentname  FROM table1 WHERE (studentname LIKE'" + q + "%') ORDER BY studentname"
Set rsWords = objConn.Execute(strSQL)


'rsWords.CursorType = 2
'rsWords.CursorLocation = 2
'rsWords.LockType = 3
'rsWords.Open()
'rsWords_numRows = 0
Reply With Quote
  #8  
Old July 4th, 2008, 05:01 PM
phoenixaz phoenixaz is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Feb 2008
Posts: 565 phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 5 Days 9 h 36 m 49 sec
Reputation Power: 26
You did a great job on coding gethint2.zip files.

If I want to add another field and pass it to the form, how can I capture the StudentID in the form?

Code:
If trim(hint) = "" Then
			hint = "<a href=""javascript:setTextBox('" & rsWords("studentname") & " (" & rswords ("studentid")& ")" & "','" & b & "','" & f & "','" & a & "');"">" & rsWords("studentname") & " (" & rswords ("studentid")& ")" &  "</a>"
		Else
			hint = hint & " , <a href=""javascript:setTextBox('" & rsWords("studentname") & " (" & rswords ("studentid")& ")" & "','" & b & "','" & f & "','" & a & "');"">" & rsWords("studentname") & " (" & rswords ("studentid")& ")" & "</a>"
		End If


That code works fine and the results would be something like this....

John Doe (1411) , John Doe (3288) , John Doe (3432)

So I have 3 different students with the same name. So when I click on the one I want, it puts ....

John Doe (3288) in the text box.

So if I now click on SUBMIT, I want to put in the form the studentname and ALSO the studentid so I can use that in my sql string.


Code:
<form name="form1" action="clienthint.asp" method="post">
Student Name:
<input type="text" name="studentname" id="txt1" onKeyUp="showHint(this.value,'txt1','form1',true)">
<input type="submit" name="submit" value="submit">
</form>
<p><span id="txtHint"></span></p>


I appreciate your suggestions.

Thanks!
Reply With Quote
  #9  
Old July 5th, 2008, 07:51 PM
baseballdude_'s Avatar
baseballdude_ baseballdude_ is offline
Expert Learner
ASP Free Intermediate (1500 - 1999 posts)
  
Join Date: Feb 2005
Location: Wisconsin
Posts: 1,907 baseballdude_ User rank is Second Lieutenant (5000 - 10000 Reputation Level)baseballdude_ User rank is Second Lieutenant (5000 - 10000 Reputation Level)baseballdude_ User rank is Second Lieutenant (5000 - 10000 Reputation Level)baseballdude_ User rank is Second Lieutenant (5000 - 10000 Reputation Level)baseballdude_ User rank is Second Lieutenant (5000 - 10000 Reputation Level)baseballdude_ User rank is Second Lieutenant (5000 - 10000 Reputation Level)baseballdude_ User rank is Second Lieutenant (5000 - 10000 Reputation Level)  Folding Points: 22104 Folding Title: Starter FolderFolding Points: 22104 Folding Title: Starter Folder
Time spent in forums: 1 Week 5 Days 15 h 28 m 41 sec
Reputation Power: 93
Send a message via AIM to baseballdude_ Send a message via MSN to baseballdude_ Send a message via Yahoo to baseballdude_ Send a message via Google Talk to baseballdude_
Quote:
Originally Posted by phoenixaz
I am not able to get it to work. Am I suppose to but the following code in the bottom of the clienthint.js file?

Code:
function search_delay(element) {
	// Create a function to get the search results
	var func = function() { getBox(document.getElementById('ab_q').value, 'RhapArtist', 10); };

	// Check to see if there is already a timeout and if so...
	// ...cancel it and create a new one
	if ( element.zid ) {
		clearTimeout(element.zid);
	}
	element.zid = setTimeout(func,500);
}
That code can go anywhere, as long as it's not contained within any other function or class. It can be used globally.
Reply With Quote
  #10  
Old July 7th, 2008, 12:26 PM
phoenixaz phoenixaz is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Feb 2008
Posts: 565 phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level)phoenixaz User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 5 Days 9 h 36 m 49 sec
Reputation Power: 26
Last name search
Is it possible to do a search with your autosuggestion for the last name when the name field contains both first, last and sometimes middle.

Example: Let's say that there are 2 names,

John Doe Smitih , John Smith

If you type.... John, both names show up in the suggest list.

If you type.... John D, then only John Doe Smith shows and not John Smith.

I think there is a way to do a split, but I am not sure how to do it.

Thanks
Last edited by phoenixaz : July 7th, 2008 at 07:55 PM.
Reply With Quote
  #11  
Old December 19th, 2008, 06:35 PM
tester7777 tester7777 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Dec 2008
Posts: 1 tester7777 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 13 m 33 sec
Reputation Power: 0
any progress on autosubmit?
Dear alexk13,
thanx for the nice piece of code.

do you have any progress on autosubmit? would be great if you did.
Reply With Quote
Reply

Viewing: ASP Free Forums > Programming > Code Bank > Classic ASP/AJAX - Auto Suggest Form

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump





 Free IT White Papers!
 
Create the Optimal Architecture for your Critical Applications
Warburton's the largest independently owned bakery in the UK faced a number of difficult challenges in providing the most robust yet efficient IT infrastructure for their organization's success. IBM's services combined with their xSeries servers created the perfect platform for their SAP environment with sufficient flexibility, and did so in very time effective fashion.
 
Five Best Practices for Deploying a Successful Service-Oriented Architecture
This white paper describes the benefits you can expect with SOA, and how IBM can help take your business there.
 
Gartner Magic Quadrant for Application Delivery Controllers
Gartner summarizes its view on Application Delivery Controllers, evaluates strengths and weaknesses of solutions, and provides Magic Quadrant reporting for a quick comparison across all vendors. Learn from Gartner how you can benefit from an all-in-one device like Citrix NetScaler that delivers the highest levels of availability, performance and security.
 
Knowledge is Power
What you don't know can hurt you, and is likely costing you money and increasing your security risks during an era of scarce resources. This white paper proposes six key strategies that enterprise security managers can use to improve their network defense posture.
 
Rationalizing the Multi-Tool Environment
The rationalized multi-tool approach is flexible, scalable and cost effective. It provides the necessary input to the IT service management business processes. It preserves prior investments in monitoring tools, empowers technologists to select the best tools with which to do their jobs, and enhances effective response to incidents.
 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2010 by Developer Shed. All rights reserved. DS Cluster 11 Hosted by Hostway. 
For more Enterprise Application Development news, visit eWeek