You are here:

VB Script/Help need in text populated

Advertisement

Expert: Miguel Zapico - 6/22/2006


Question
I am wondering if you would help me with this?
   
    I am using _vbscript or _javascript with asp to doing web application.
    In the form(TextBlur.asp), first time you have to put PatientNo and patient last and first name, mid name information by type. After push submit button,  these four fields data send to database table named tblTextBlur.
    Ever since then when you come to filling this form, you want after you typed PatientNo, the rest three fields will automatical populated.
    How can you complete it?
Appreciated!


tblTextBlur
UniqueID PatientNo  LastName FirstName MidName
1         C21192-01 Martin   Charles    H.
10        21201-01  Tolbert  Jimmie     L.  
2         C21192-01 Martin   Charles    H.
3         21167-01  Stepherson Ronald   
4         C21194-01 Richardson Keith    B.
5         21183-01  Dupra     Ann       S.
6         21163-02  Lindemuth Randall   S.
7         21184-01  Sobelson  Glenn     M.
8         C21180-01 Mitchell  Polly     M.
9         C21187-01 Joseph    Etzer   

  
in the tblTextBlur, UniqueID is auto number, the rest are text.
  
 
<html>
<head>


<title>Text Blur Testing</title>
</head>

"#000000" leftmargin=0 topmargin=0 marginheight="0" marginwidth="0">
<form actionfiltered="/TextBlur.asp" method="post" name="TestBlur">
<div align="center">  
<table border=0 cellspacing=0 cellpadding=2 width="641">
  

 <tr>
   <td bgcolor="#eeeeff" width="251"><font face="arial, helvetica" size=2><b>Unique ID</font></B></td>
   <td width="379"><input size=20 maxlength=30 name="UniqueID" value="<%=UniqueID%>"></td>
   
 </tr>

<tr>
   <td bgcolor="#eeeeff" width="140"><font face="arial, helvetica" size=2><b>Patient No</font></B></td>
   <td><input size=20 name="PatientNo"></td>
   <td bgcolor="#eeeeff" width="189"><font face="arial, helvetica" size=2><b>Last Name</font></B></td>
   <td><input type="text" size=20 maxlength=30 name="LastName" value="<%=LastName%>"></td>
 </tr>
<tr>
   <td bgcolor="#eeeeff" width="140"><font face="arial, helvetica" size=2><b>First Name</font></B></td>
   <td><input type="text" name="FirstName" value="<%=FirstName%>"></td>
   <td bgcolor="#eeeeff" width="134"><font face="arial, helvetica" size=2><b>Mid Name</font></B></td>
   <td width="134"><input type="text" size=20 name="MidName" value="<%=MidName%>"></td>
</tr>


<tr><td><br></td></tr>


<tr align=middle>
 <td colspan=4 bgcolor="#ffffff" width="570"><input type="submit" name="Action" value="Submit" style="HEIGHT: 24px; WIDTH: 125px">
 <input type="reset" value="Reset" name=reset style="HEIGHT: 24px; WIDTH: 121px"></td>
 </tr></table>
 </div>
</form>
<br>
<br>



</html>  

Answer
Sorry, this is outside my experience, but at least I will try with some tips.
From my limited experience in web, any code that fills fields automatically requires client side code.  I wouldn't use a connection with a database here, I am not even sure if it would work.
Doing it on the server side makes more sense.  All the database connection details are hidden to the user.  What I don't know is how to make it automatically, without having to submit a form.
Sorry I cannot give more details, web is really not my area of experience.

Miguel.

VB Script

All Answers

Answers by Expert:

Ask Experts

Volunteer

Miguel Zapico

Expertise

I can answer question about how to use scripts to consolidate data, connect different systems and automate tasks. I have no experience on using VBScript on web programming.

Experience

I have been using VBScript and Windows Scripting Host as my swiss tool for the last 6 years.

Organizations
New York PC users group (NYPC)
Independant Computer Consultants Association (ICCA)

Education/Credentials
Microsoft MCSE in Windows NT

©2012 About.com, a part of The New York Times Company. All rights reserved.