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