Hey ...
Can you help me out with this error?
<!---------------------------------->
Microsoft OLE DB Provider for SQL Server error '80040e07'
Error converting data type varchar to bigint.
<!---------------------------------->
This is the code I used:
<!---------------------------------->
<form name="form5" method="post" action="regi_search_mobile.asp">
<form method="POST" action="regiUserOVInfoTest.asp" webbot-action="--WEBBOT-SELF--">
<!--webbot bot="SaveResults" U-File="../../_private/form_results.csv" S-Format="TEXT/CSV" S-Label-Fields="TRUE" startspan --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--webbot bot="SaveResults" i-checksum="43374" endspan -->
<p><font face="Tahoma">
<font color="#FFFFFF">
<input type="text" name="txtMobile" size="20"><input type="submit" value="See Details" name="B1"></font><font size="2" color="#FFFFFF">
</font></font></p>
</form>
<!-- another ASP page -->
<%
Dim conn, selectSQL, RecSet
Dim mobileNo
Dim getMobileNo
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog = dbMobile; User Id = sa; Password=sa1234"
getMobi1eNo = Request.Form("txtMobile")
Response.Write(getMobi1eNo) & "<BR><BR>"
' mobileNo = getMobileNo
' mobileNo = value of ("getMobileNo")
' document.write(VarType(getMobileNo) & "<br />")
Response.Write(mobi1eNo)
selectSQL = "SELECT cb_seller.mobile_no as csm, cb_district.district_full_name as cdm, cb_seller.create_time as cct FROM cb_seller, cb_district where cb_seller.seller_dist_id = cb_district.district_id and cb_seller.mobile_no = '&getMobileNo&' order by create_time"
Set RecSet = conn.Execute (selectSQL)
do while not RecSet.eof
Response.Write RecSet("csm") & RecSet("cdm") & RecSet("cct") & "<BR><BR>"
RecSet.MoveNext
Loop
RecSet.Close
conn.Close
Set RecSet = Nothing
Set conn = Nothing
%>
help me out here. thnx.