Html Keystroke Emulation for DB search.

Deus · Apr 17, 2001

Hi !

I'm making a peice of software for a project at university which involves the use of a mouse click emulation touch screen.

This software needs to be searchable idealy ! I already have a Data base setup and working, But I need some way to enter data into the search field within HTML !!!!

Is there anyway I can produce in effect an on screen keyboard allowing me to enter letters into such a search field ?

I'm truly stuck on this one ! any help would be hugely appreciated !

aperfectcircle · Apr 18, 2001

I might be misunderstanding what you want to do, but here's an example that might help you get started...

Code:

<html>
<head>
<title>Test</title>
<script language=&quot;javascript&quot;>
function type() {
document.forms[0].search.value = document.forms[0].search.value + &quot;a&quot;
}
</script>
</head>
<body>
<form>
<a href=&quot;#&quot; onclick=&quot;type()&quot;><img src=&quot;imagea.gif&quot; border=&quot;0&quot;></a>
<input type=&quot;text&quot; name=&quot;search&quot;>
</form>
</body>
</html>

When you click on the image it will add an "a" character to the text box.
If this is what you want to do you might ask on the javascript forum. I'm sure someone there could probably think of a better way to do it.

Hope that helps...

Guest_imported · Apr 18, 2001

Thats Exactly what I'm looking for and will do the job perfectly ! Thanks.

Only problem is (There's always 1 isnt there) I can't get it to work with my existing DB. It's only a simple Access DB which needs to search. Song Names and return the name and a Href for a pic.

Any ideas how I combine the two ? or where I can get a template I can add your idea to easily ? (I prefer using access DB's as it's all I can get to grips with in a short period of time)

aperfectcircle · Apr 18, 2001

If you're going to use that code you might want to change it to something like:

Code:

<html>
<head>
<title>Test</title>
<script language=&quot;javascript&quot;>
function type(letter) {
document.forms[0].search.value = document.forms[0].search.value + letter
}
</script>
</head>
<body>
<form>
<a href=&quot;#&quot; onclick=&quot;type('a')&quot;><img src=&quot;imagea.gif&quot; border=&quot;0&quot;></a>
<a href=&quot;#&quot; onclick=&quot;type('b')&quot;><img src=&quot;imageb.gif&quot; border=&quot;0&quot;></a>
<input type=&quot;text&quot; name=&quot;search&quot;>
</form>
</body>
</html>

It's a little bit "smarter" that way...

If you could post the existing code that you're trying to combine this with I can do my best to help...

Deus · Apr 18, 2001

Thanks for all this help. The code I have for the DB at the minute is a bit of a mess and needs quite a lot changed on it

)

I really need to start again from scratch ! As soon as I have done this I will post the code here.

Deus · Apr 18, 2001

Right this is still a mess as a program created parts of it automatically ! The final DB will display the Song Name and Artist in 1 field so they can both be searched then it will show the link. (No Genre field).

Ok ready for this

<html>

<head>
<meta http-equiv="Content-Language" content="en-gb">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Display Database</title>
</head>

<body>

<p align="center"><b>Display Database</b></p>
<p align="center"> </p>
<form BOTID="0" METHOD="POST" ACTION="display_database.asp">
<p>Search here:</p>
<table BORDER="0">
<tr>
<td align="center">
<p align="center"><b>Title</b></p>
</td>
<td align="center">
<p align="center"><input TYPE="TEXT" NAME="Field1" VALUE="<%=Request("Field1&quot

%>" size="20"></p>
</td>
</tr>
</tr>
</table>
<p align="left">
<br>
<input TYPE="Submit" value="Search Now" name="Search"><input TYPE="Reset">
<p> </p>
</form>
<table width="100%" border="1">
<thead>
<tr>
<td><b>Title</b></td>
<td><b>Artist</b></td>
<td><b>Genre</b></td>
<td><b>Link</b></td>
</tr>
</thead>
<tbody>

<%
fp_sQry="SELECT * FROM Table1 WHERE (Field1 LIKE '%::Field1::%' AND Field2 LIKE '%::Field2::%' AND Field3 LIKE '%::Field3::%')"
fp_sDefault="Field1=&Field2=&Field3="
fp_sNoRecords="<tr><td colspan=4 align=left width=""100%"">Sorry - nothing found!</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=25
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=4
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>


<tr>
<td><%=FP_FieldVal(fp_rs,"Field1&quot

%>
</td>
<td><%=FP_FieldVal(fp_rs,"Field2&quot

%>
</td>
<td><%=FP_FieldVal(fp_rs,"Field3&quot

%>
</td>
<td><%=FP_Field(fp_rs,"Field4&quot

%>
</td>
</tr>


</tbody>
</table>
<p align="center"> </p>

<p align="center"><a href="database.htm">Go back to Database page</a></p>

</body>

</html>

aperfectcircle · Apr 18, 2001

Does anything show up in the text box when you first load the page?

Deus · Apr 18, 2001

No not if you run it on a PWS other wise you get something about the result !!!!

I imagine it would be easy to encorperate the two pieces of code, but I reall have no idea how to get the info you gave me to feed the search box I have in this DB !

aperfectcircle · Apr 18, 2001

Ok...go ahead and try this code. I'm not too familiar with asp, so I really don't know if it'll work or not.
Also, if you open this file in FrontPage it will most likely screw up the code I added...

Code:

<html>

<head>
<meta http-equiv=&quot;Content-Language&quot; content=&quot;en-gb&quot;>
<meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=windows-1252&quot;>
<meta name=&quot;GENERATOR&quot; content=&quot;Microsoft FrontPage 4.0&quot;>
<meta name=&quot;ProgId&quot; content=&quot;FrontPage.Editor.Document&quot;>
<title>Display Database</title>
<script language=&quot;javascript&quot;>
function type(letter) {
document.forms[0].Field1.value = document.forms[0].Field1.value + letter
}
</script>
</head>

<body>

<p align=&quot;center&quot;><b>Display Database</b></p>
<p align=&quot;center&quot;> </p>
<form BOTID=&quot;0&quot; METHOD=&quot;POST&quot; ACTION=&quot;display_database.asp&quot;>
  <p>Search here:</p>
<a href=&quot;#&quot; onclick=&quot;type('a')&quot;><img src=&quot;imagea.gif&quot; border=&quot;0&quot;></a>
<a href=&quot;#&quot; onclick=&quot;type('b')&quot;><img src=&quot;imageb.gif&quot; border=&quot;0&quot;></a>
  <table BORDER=&quot;0&quot;>
    <tr>
      <td align=&quot;center&quot;>
        <p align=&quot;center&quot;><b>Title</b></p>
      </td>
      <td align=&quot;center&quot;>
        <p align=&quot;center&quot;><input TYPE=&quot;TEXT&quot; NAME=&quot;Field1&quot; VALUE=&quot;<%=Request(&quot;Field1&quot;)%>&quot; size=&quot;20&quot;></p>
      </td>
    </tr>
  </table>
  <p align=&quot;left&quot;>
  <br>
  <input TYPE=&quot;Submit&quot; value=&quot;Search Now&quot; name=&quot;Search&quot;><input TYPE=&quot;Reset&quot;><!--webbot bot=&quot;SaveAsASP&quot; CLIENTSIDE
  SuggestedExt=&quot;asp&quot; PREVIEW=&quot; &quot; -->
  <p> </p>
</form>
<table width=&quot;100%&quot; border=&quot;1&quot;>
  <thead>
    <tr>
      <td><b>Title</b></td>
      <td><b>Artist</b></td>
      <td><b>Genre</b></td>
      <td><b>Link</b></td>
    </tr>
  </thead>
  <tbody>
    <!--webbot bot=&quot;DatabaseRegionStart&quot; startspan
    s-columnnames=&quot;Field1,Field2,Field3,Field4&quot; s-columntypes=&quot;202,202,202,202&quot;
    s-dataconnection=&quot;Database1&quot; b-tableformat=&quot;TRUE&quot; b-menuformat=&quot;FALSE&quot;
    s-menuchoice s-menuvalue b-tableborder=&quot;TRUE&quot; b-tableexpand=&quot;TRUE&quot;
    b-tableheader=&quot;TRUE&quot; b-listlabels=&quot;TRUE&quot; b-listseparator=&quot;TRUE&quot;
    i-ListFormat=&quot;0&quot; b-makeform=&quot;TRUE&quot; s-recordsource=&quot;Table1&quot;
    s-displaycolumns=&quot;Field1,Field2,Field3,Field4&quot;
    s-criteria=&quot;[Field1] CNT {Field1} + [Field2] CNT {Field2} + [Field3] CNT {Field3} |&quot;
    s-order
    s-sql=&quot;SELECT * FROM Table1 WHERE (Field1 LIKE '%::Field1::%' AND Field2 LIKE '%::Field2::%' AND Field3 LIKE '%::Field3::%')&quot;
    b-procedure=&quot;FALSE&quot; clientside SuggestedExt=&quot;asp&quot;
    s-DefaultFields=&quot;Field1=&Field2=&Field3=&quot;
    s-NoRecordsFound=&quot;Sorry - nothing found!&quot; i-MaxRecords=&quot;256&quot;
    i-GroupSize=&quot;25&quot; BOTID=&quot;0&quot; u-dblib=&quot;_fpclass/fpdblib.inc&quot;
    u-dbrgn1=&quot;_fpclass/fpdbrgn1.inc&quot; u-dbrgn2=&quot;_fpclass/fpdbrgn2.inc&quot;
    tag=&quot;TBODY&quot;
    local_preview=&quot;<tr><td colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot; width=&quot;100%&quot;><font color=&quot;#000000&quot;>Database Results regions will not preview unless this page is fetched from a Web server with a web browser. The following table row will repeat once for every record returned by the query.</font></td></tr>&quot;
    preview=&quot;<tr><td colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot; width=&quot;100%&quot;><font color=&quot;#000000&quot;>This is the start of a Database Results region.</font></td></tr>&quot; --><!--#include file=&quot;_fpclass/fpdblib.inc&quot;-->
<%
fp_sQry=&quot;SELECT * FROM Table1 WHERE (Field1 LIKE '%::Field1::%' AND Field2 LIKE '%::Field2::%' AND Field3 LIKE '%::Field3::%')&quot;
fp_sDefault=&quot;Field1=&Field2=&Field3=&quot;
fp_sNoRecords=&quot;<tr><td colspan=4 align=left width=&quot;&quot;100%&quot;&quot;>Sorry - nothing found!</td></tr>&quot;
fp_sDataConn=&quot;Database1&quot;
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=25
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=&quot;&quot;
fp_sMenuValue=&quot;&quot;
fp_iDisplayCols=4
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file=&quot;_fpclass/fpdbrgn1.inc&quot;-->
<!--webbot bot=&quot;DatabaseRegionStart&quot; i-CheckSum=&quot;36360&quot; endspan -->
    <tr>
      <td><!--webbot bot=&quot;DatabaseResultColumn&quot; startspan
        s-columnnames=&quot;Field1,Field4&quot; s-column=&quot;Field1&quot;
        b-tableformat=&quot;TRUE&quot; b-hasHTML=&quot;FALSE&quot; clientside
        local_preview=&quot;<font size=&quot;-1&quot;><<</font>Field1<font size=&quot;-1&quot;>>></font>&quot;
        preview=&quot;<font size=&quot;-1&quot;><<</font>Field1<font size=&quot;-1&quot;>>></font>&quot; --><%=FP_FieldVal(fp_rs,&quot;Field1&quot;)%><!--webbot
        bot=&quot;DatabaseResultColumn&quot; i-CheckSum=&quot;14330&quot; endspan -->
      </td>
      <td><!--webbot bot=&quot;DatabaseResultColumn&quot; startspan
        s-columnnames=&quot;Field1,Field4&quot; s-column=&quot;Field4&quot;
        b-tableformat=&quot;TRUE&quot; b-hasHTML=&quot;FALSE&quot; clientside
        local_preview=&quot;<font size=&quot;-1&quot;><<</font>Field2<font size=&quot;-1&quot;>>></font>&quot;
        preview=&quot;<font size=&quot;-1&quot;><<</font>Field2<font size=&quot;-1&quot;>>></font>&quot; --><%=FP_FieldVal(fp_rs,&quot;Field2&quot;)%><!--webbot
        bot=&quot;DatabaseResultColumn&quot; i-CheckSum=&quot;14338&quot; endspan -->
      </td>
      <td><!--webbot bot=&quot;DatabaseResultColumn&quot; startspan
        s-columnnames=&quot;Field1,Field2,Field3,Field4&quot; s-column=&quot;Field3&quot;
        b-tableformat=&quot;TRUE&quot; b-hasHTML=&quot;FALSE&quot; clientside
        local_preview=&quot;<font size=&quot;-1&quot;><<</font>Field3<font size=&quot;-1&quot;>>></font>&quot;
        preview=&quot;<font size=&quot;-1&quot;><<</font>Field3<font size=&quot;-1&quot;>>></font>&quot; --><%=FP_FieldVal(fp_rs,&quot;Field3&quot;)%><!--webbot
        bot=&quot;DatabaseResultColumn&quot; i-CheckSum=&quot;14346&quot; endspan -->
      </td>
      <td><!--webbot bot=&quot;DatabaseResultColumn&quot; startspan
        s-columnnames=&quot;Field1,Field2,Field3,Field4&quot; s-column=&quot;Field4&quot;
        b-tableformat=&quot;TRUE&quot; b-hasHTML=&quot;TRUE&quot; clientside
        local_preview=&quot;<font size=&quot;-1&quot;><<</font>Field4<font size=&quot;-1&quot;>>></font>&quot;
        preview=&quot;<font size=&quot;-1&quot;><<</font>Field4<font size=&quot;-1&quot;>>></font>&quot; --><%=FP_Field(fp_rs,&quot;Field4&quot;)%><!--webbot
        bot=&quot;DatabaseResultColumn&quot; i-CheckSum=&quot;11662&quot; endspan -->
      </td>
    </tr>
    <!--webbot bot=&quot;DatabaseRegionEnd&quot; startspan b-tableformat=&quot;TRUE&quot;
    b-menuformat=&quot;FALSE&quot; u-dbrgn2=&quot;_fpclass/fpdbrgn2.inc&quot; i-groupsize=&quot;25&quot;
    clientside tag=&quot;TBODY&quot;
    local_preview=&quot;<tr><td colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot; width=&quot;100%&quot;><font color=&quot;#000000&quot;>This is the end of a Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64><FORM><NOBR><INPUT TYPE=Button VALUE=&quot;  |<  &quot;><INPUT TYPE=Button VALUE=&quot;   <  &quot;><INPUT TYPE=Button VALUE=&quot;  >   &quot;><INPUT TYPE=Button VALUE=&quot;  >|  &quot;>  [1/25]</NOBR></FORM></td></tr>&quot;
    preview=&quot;<tr><td colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot; width=&quot;100%&quot;><font color=&quot;#000000&quot;>This is the end of a Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT TYPE=Button VALUE=&quot;  |<  &quot;><INPUT TYPE=Button VALUE=&quot;   <  &quot;><INPUT TYPE=Button VALUE=&quot;  >   &quot;><INPUT TYPE=Button VALUE=&quot;  >|  &quot;>  [1/25]</NOBR><BR></td></tr>&quot; --><!--#include file=&quot;_fpclass/fpdbrgn2.inc&quot;-->
<!--webbot bot=&quot;DatabaseRegionEnd&quot; i-CheckSum=&quot;62730&quot; endspan -->
  </tbody>
</table>
<p align=&quot;center&quot;> </p>

<p align=&quot;center&quot;><a href=&quot;database.htm&quot;>Go back to Database page</a></p>

</body>

</html>

Deus · Apr 18, 2001

Right It works in the fact that it enters data into the correct field, but that field already has "<%=Request(" written in it !!!

Getting closer though cheers

if it is easier to use a different type of database (That I dont need software for) I can change the DB format !

Deus · Apr 18, 2001

Just to let you know - If I delete that data from the feild it all works perfectly

And to think I was about to give up and make people have to browse a list !

I really appreciate this !

aperfectcircle · Apr 18, 2001

If you view it on a PWS does it work?

You could try opening the file up in notepad or some other text editor and change the VALUE="<%=Request("Field1&quot

%>" to VALUE="".

I really don't know what else to tell you. Unless you could post the working code online somewhere...then maybe I could understand what it is doing.

Deus · Apr 18, 2001

Wooo Got it

) It all works ! (I can hardly belive it !)

Thanks so much for your help, 1 things that I'm not sure on how to do would be to remove a letter ! "A Backspace" key !

Any ideas ?

Thanks for the time you've been a huge help.

aperfectcircle · Apr 19, 2001

Glad I could help...

On the backspace thing, I really have no idea. I am by no means a javascript programmer...but I'm sure if you ask in the javascript forum someone will be able to help.

link9 · Apr 19, 2001

If you want to chop the last character off a string, you can do this:

var theString
theString = formName.elementName.value
theString = theString.slice(0, theString.length-1)
formName.elementName.value = theString

Deus · Apr 19, 2001

Wooooo.

Thanks for all your help guys. I'll have to remember this forum for in the future it's been a life saver !

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!

Html Keystroke Emulation for DB search.

Deus

Technical User

aperfectcircle

Programmer

Guest_imported

New member

aperfectcircle

Programmer

Deus

Technical User

Deus

Technical User

aperfectcircle

Programmer

Deus

Technical User

aperfectcircle

Programmer

Deus

Technical User

Deus

Technical User

aperfectcircle

Programmer

Deus

Technical User

aperfectcircle

Programmer

link9

Programmer

Deus

Technical User

Similar threads

Part and Inventory Search

Sponsor