|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
April 5th, 2005, 10:30 AM
|
|||
|
|||
|
Display client name not number
I have a database that is using a client table and job table.
The clients are using lookup to populate dropdown menu's. What i need to do is call up a record from the job table and display the clients name... only problem is i keep getting there number ie 2,3,1... Does anyone know how to get the client name to appear instead.. i can do it with the dropdown by setting the value to be the same as the client table but i want to do this with normal text or text box. Thanks in advance and sorry but i'm fairly new to asp.
|
|
#2
April 5th, 2005, 11:28 AM
|
||||
|
||||
|
you'll have to use the number (which I assume is unique id) and run sql select statement on the clients table and grab the name from there:
Code:
<%
strSQL="Select ClientName From Clients Where ClientId="&clientID
Set rs=objConn.Execute(strSQL)
clientName=rs("ClientName")
%>
...
<input type="text" name="client" value="<%=clientName%>" />
|
|
| Viewing: ASP Free Forums > Programming > Code Bank > Display client name not number |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
