AllExperts > Experts 
Search      

VB Script

Volunteer
Answers to thousands of questions
 Home · More Questions · Answer Library  · Encyclopedia ·
More VB Script Answers
Question Library

Ask a question about VB Script
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About 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

 
   

You are here:  Experts > Computing/Technology > Basic > VB Script > Help need in text populated

Topic: VB Script



Expert: Miguel Zapico
Date: 6/22/2006
Subject: Help need in text populated

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.

Add to this Answer    Ask a Question



  Rate this Answer
   Was this answer helpful?
Not at allDefinitely              
   12345  

     
About Us | Advertise on This Site | User Agreement | Privacy Policy | Help
Copyright  © 2008 About, Inc. About and About.com are registered trademarks of About, Inc. The About logo is a trademark of About, Inc. All rights reserved.