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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to search string field
OK, this is how far I got Set con = server.createobject("adodb.connection") src = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=E:\Inetpub\Database\DutyLog\DutyLog_beweb.mdb" con.open src Dim rs, rs1 Set rs = Server.CreateObject("ADODB.Recordset") choices...- mtndew
- Post #11
- Forum: Microsoft: ASP (Active Server Pages)
-
How to search string field
Use this for multiple values... "SELECT * FROM tblLog Where TOE Like '%11%' OR TOE Like '%10%'" I'll develop a dynamic sql statement to cover unknown number of values and post it later. mtndew- mtndew
- Post #9
- Forum: Microsoft: ASP (Active Server Pages)
-
Searching string data field, returning entire record(s)
That did it...May you live a thousand lives my friend:):) mtndew -
How to search string field
OK, I come from the school of hard knocks. I should always remember that it is usually the simplest method or function that will do the job... This what worked after a tip I got from this site and another site... "SELECT * FROM tblLog Where TOE Like '%05%' " Thanks for all your...- mtndew
- Post #7
- Forum: Microsoft: ASP (Active Server Pages)
-
Assign value to a dropdown list
As I understood it your user makes a selection from a <Select> list which you want to then go to a form so they they can edit and/or make another choice. If what you really want to do is have the user make their choices, save it to the database and then open a form showing what they did...thats...- mtndew
- Post #5
- Forum: Microsoft: ASP (Active Server Pages)
-
Assign value to a dropdown list
I use javascript to take the value selected and place it in a separate textbox; function changetext5() { selected = document.Events.Type.selectedIndex; value = document.Events.Type.options[selected].value; text = document.Events.Type.options[selected].text; document.Events.text5.value =...- mtndew
- Post #2
- Forum: Microsoft: ASP (Active Server Pages)
-
How to search string field
I have several SQL books and each of them, as unhelpful as they are, show a InStr() function. In fact, it's viable in many languages. It's just that it can only be used in a one dimensional array. "05" is a string. It is entered into the record from a drop-down <Select> box. So the...- mtndew
- Post #5
- Forum: Microsoft: ASP (Active Server Pages)
-
How to search string field
This is what I've been testing with today. It's a hodgepodge but I was able to get it to produce an array of an example of a value the user would want. The object, eventually, is for the user to select parameters which are passed to this page and a report is produced. Done this pretty well with...- mtndew
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
Sample ASP Quiz site
http://www.w3schools.com/default.asp mtndew- mtndew
- Post #2
- Forum: Microsoft: ASP (Active Server Pages)
-
How to search string field
I need help searching a string field in an Access 2K database from an ASP page. I'm having trouble pulling the entire record into an HTML table. I have tried InStr in SQL statement, tried Split(), InStr() of the field from an array to no avail. If anyone can direct to an article or book that I...- mtndew
- Thread
- Replies: 11
- Forum: Microsoft: ASP (Active Server Pages)
-
Searching string data field, returning entire record(s)
Hi, I'm stuck. I've been trying to search a field in a database that has a string like this one; "01, 02, 03, 04, 05". Some records, over 20,000, will have one number, some more than one number, most have different assortment. I need to be able to find records where the value in that...
