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...
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
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...
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...
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 =...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.