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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Html Keystroke Emulation for DB search.

Status
Not open for further replies.
Deus

Deus

Technical User
Apr 17, 2001
10
GB
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 !
 
Sort by date Sort by votes
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 &quot;a&quot; 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...
 
Upvote 0 Downvote
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)
 
Upvote 0 Downvote
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 &quot;smarter&quot; that way...

If you could post the existing code that you're trying to combine this with I can do my best to help...
 
Upvote 0 Downvote
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 :eek:)

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

 
Upvote 0 Downvote
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=&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>
</head>

<body>

<p align=&quot;center&quot;><b>Display Database</b></p>
<p align=&quot;center&quot;>&nbsp;</p>
<form BOTID=&quot;0&quot; METHOD=&quot;POST&quot; ACTION=&quot;display_database.asp&quot;>
<p>Search here:</p>
<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>
</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>&nbsp;</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=&amp;Field2=&amp;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;&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;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.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&quot;
preview=&quot;&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the start of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&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;&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Field1&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;&quot;
preview=&quot;&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Field1&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;&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;&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Field2&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;&quot;
preview=&quot;&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Field2&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;&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;&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Field3&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;&quot;
preview=&quot;&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Field3&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;&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;&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Field4&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;&quot;
preview=&quot;&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Field4&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;&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;&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the end of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64&gt;&lt;FORM&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;| &quot;&gt; [1/25]&lt;/NOBR&gt;&lt;/FORM&gt;&lt;/td&gt;&lt;/tr&gt;&quot;
preview=&quot;&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the end of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;| &quot;&gt; [1/25]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;&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;>&nbsp;</p>

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

</body>

</html>
 
Upvote 0 Downvote
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 !
 
Upvote 0 Downvote
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>
 
Upvote 0 Downvote
Right It works in the fact that it enters data into the correct field, but that field already has &quot;<%=Request(&quot; 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 !
 
Upvote 0 Downvote
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 !
 
Upvote 0 Downvote
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=&quot;<%=Request(&quot;Field1&quot;)%>&quot; to VALUE=&quot;&quot;.

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.
 
Upvote 0 Downvote
Wooo Got it :eek:) 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 ! &quot;A Backspace&quot; key !

Any ideas ?

Thanks for the time you've been a huge help.
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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

:)
 
Upvote 0 Downvote
Wooooo. :)

Thanks for all your help guys. I'll have to remember this forum for in the future it's been a life saver !
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Alt255
  • Locked
  • Question
Searching for a string that contains brackets
Replies
0
Views
179
Alt255
Alt255
lmcate
  • Locked
  • Question
From HTML Page open an MDB files on the server and work
Replies
0
Views
171
lmcate
lmcate
soni21
  • Locked
  • Question
JavaScript String to Number Conversion in HTML: Seeking Clarification
Replies
4
Views
1K
Chris Miller
Chris Miller
jizzer
  • Locked
  • Question
HTML/CSS Image map with multiple tool-tips
Replies
3
Views
1K
spamjim
spamjim
scorney
  • Locked
  • Question
background image with overlay which Hover when over a specific Area/Form
Replies
1
Views
636
3esolar
3

Part and Inventory Search

Sponsor

Back
Top