Big problem in ASP using procedure variable to select statement

Author Message
patwong

  • Total Posts : 1
  • Scores: 0
  • Reward points : 0
  • Joined: 1/2/2006
  • Status: offline
Big problem in ASP using procedure variable to select statement Wednesday, December 15, 2010 8:05 PM (permalink)
0
Variable can get from procedure and show alert but NIL use to select statement. Result already show 'No record found' but really have the record in table. Does anyone can help !.
 
<input type="button" height="20" value="Chk bldg" onClick="call checkbldg(txtaddress1.value)" language="vbscript"/>
 

<Script Language="VBScript">
Sub checkbldg(xadr)
<%

strDSN = "provider=MSDAORA;data source=muDB;user id=temp;password=123"
Set cn = Server.CreateObject("ADODB.Connection")
cn.Open strDSN
Set rsPublic = Server.CreateObject("ADODB.Recordset")

strSQL = "select count(*) from table where user='" & xadr & "'"
 
On Error Resume Next
set rsPublic = cn.Execute(strSQL)
if rsPublic.EOF then %>

alert "No record found"
<%else %>

alert "Record found"
<%end if%>
end sub
</Script>

 
#1

    Online Bookmarks Sharing: Share/Bookmark

    Jump to:

    Current active users

    There are 0 members and 1 guests.

    Icon Legend and Permission

    • New Messages
    • No New Messages
    • Hot Topic w/ New Messages
    • Hot Topic w/o New Messages
    • Locked w/ New Messages
    • Locked w/o New Messages
    • Read Message
    • Post New Thread
    • Reply to message
    • Post New Poll
    • Submit Vote
    • Post reward post
    • Delete my own posts
    • Delete my own threads
    • Rate post

    2000-2012 ASPPlayground.NET Forum Version 3.9