de PHP to ASP

[cehojac]

prueba asi:

Código:

<%
'Replace the data in these two with data for your db connection
Dim my_connection, res, getClientId, inf
my_connection= server.createobject("ADODB.Connection")
my_conection.open "PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD=password;DATABASE=databasename "
getClientId=request.Form("getClientId")
res as new SqlDataAdapter("select * from ajax_client where clientID='"&getClientId&"'",sqlcon)
inf ' esta variable no está definido
if inf = DataSet(res) then 
response.Write("formObj.firstname.value = '"& request.Form("fistname")&"';<br/>")
response.Write("formObj.lastname.value = '"& request.Form("lastname")&"';<br />")
response.Write("formObj.adderess.value = '"& request.Form("address")&"';<br />")
response.Write("formObj.zipCode.value = '"& request.Form("zipCode")&"';<br />")
response.Write("formObj.city.value = '"& request.Form("city")&"';<br />")
response.Write("formObj.country.value = '"& request.Form("country")&"';<br />")

else
response.Write("formObj.firstname.value = '';<br/>")
response.Write("formObj.lastname.value = '';<br />")
response.Write("formObj.adderess.value = '';<br />")
response.Write("formObj.zipCode.value = '';<br />")
response.Write("formObj.city.value = '';<br />")
response.Write("formObj.country.value = '';<br />")

end if
%>