|
<%
'Author: Rafay Bin Ali
'email: rafayali@gmail.com
'URL: http://rafayali.blogspot.com
'http://cyberdev.visit.ws
record=request("Record")
Set objconn=server.createobject("adodb.connection")
objconn.open "provider=microsoft.jet.oledb.4.0; data source=" & server.mappath("names.mdb")
set objrecord=server.createobject("adodb.recordset")
set objrecord=objconn.execute("select * from mydbdata where firstName like'" & record & "'")
if objrecord.eof or objrecord.bof then
Response.Write "errorMsg=Not Found&firstName=&lastName=&City="
response.end
else
Response.Write "errorMsg=Found&firstName=" & server.URLEncode(objrecord.fields("firstName")) & "&" & _
"lastName=" & server.URLEncode(objrecord.fields("lastName")) & "&" & _
"City=" & server.urlencode(objrecord.fields("City"))
end if
%>
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
I am a freelance developer and technical author in Karachi, Pakistan. I am presently a student at Hamdard Institute of Management Sciences, City Campus, Karachi.
Email: rafayali@gmail.com
Blog: http://rafayali.blogspot.com
http://cc.1asphost.com/powerwebdev/index.htm