client and server side script in the same function.

[ganusha]

hi
i've a find page wherein you have to enter a name and find the address for the name in the database .
i've to first validate in the client side if the textbox is left empty and if not then connect to the database and find the record.
i've created a textbox and a find button and in the onclick event i call the function check which checks if the text box is blank properly.
but how do i write the else part where i've to connect and search the database.



<script language=vbscript>
sub check()

if document.find.text1.value=&quot;&quot; then
msgbox &quot;Enter some name to find the corresponding
address.&quot;
else
<%
session(&quot;Connection&quot= &quot;Provider=SQLOLEDB.1;Persist
Security Info=False;User ID=sa;Initial
Catalog=EPersonalAssistant;Data Source=GANUSHA-
HS4QTTQ&quot;

dim objconn,objrs,strSql,strName

set objconn=server.CreateObject(&quot;adodb.connection&quot
objconn.Open session(&quot;Connection&quot
set objrs=server.CreateObject(&quot;adodb.recordset&quot
strSql=&quot;select * from addressbook where name ??
objrs.Open strSql,objconn

%>
end if
end sub
</script>