Empty variables

Author Message
appelcore

  • Total Posts : 2
  • Scores: 0
  • Reward points : 0
  • Joined: 10/27/2010
  • Status: offline
Empty variables Thursday, October 28, 2010 12:38 AM (permalink)
0

Hi,
I'm using a help class to call a Stored Procedure. The help class is working since to has been used for over 8 years. The SP is working (tried it in JavaScript).

My problem is that the variables that are defined (objGenDac, resSet, strSQLquery) always returns empty if I try to print them using MsgBox or simular.

I marked to rows in the code below. The first one returns True even though the 'Not' keyword is used or not. The second row also (always) returns True, even if I change the zero for a undefined varible.

Thanks for helping out.
BTW how can I format the code more neatly on this forum?

Sub txtClient_OnBlur()
<%
Dim objGenDac, resSet, strSQLquery
Set objGenDac = Server.CreateObject("GenDac.Dac")
Set strSQLquery = "CD_ACI_CheckIfAccHasBeenUpdated_SP " &  document.frm.ACI_ID.value  & ", '" &  document.frm.txtUpdateTime.value  & "'"
Set resSet = objGenDac.GenDac_GetRs(strSQLquery)
If Not resSet.EOF Then '<-- HERE[/style]
If resSet("IsAccountUpdated") = 0 Then '<-- AND HERE[/style]
%>
ClientSearch()
<%
End If
Else
%>
ClientSearch()
<%
End If
resSet.Close
Set resSet = Nothing
Set objGenDac = Nothing
%>
End Sub

 
#1
    appelcore

    • Total Posts : 2
    • Scores: 0
    • Reward points : 0
    • Joined: 10/27/2010
    • Status: offline
    Re:Empty variables Thursday, October 28, 2010 1:27 AM (permalink)
    0
    I felt that I wasn't clear enough.. My main problem is that my declared variables always is Empty.
     
    #2

      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