Hi Joseph!

Thanks for the help...yeah, I was thinking about what you say above
last night @ home, but still couldn't get it to work.  I get the 'null'
value just like before, along with the same alert message.

Try
            sCon1.Open()
            Dim strSQL As String = "Select count(*) from WBTbl where
[WBNum] = '" & stateInitial & "'"
            Dim cmd As New SqlCommand(strSQL, sCon1)
            Dim intCnt As Integer = cmd.ExecuteScalar()
            sCon1.Close()
            If intCnt = 0 Then
                Return "This is unique"
            Else
                Return "Please select another!"
            End If

My breakpoint does show stateInitial with the value I put in the box
though.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Ajax.NET Professional" group.

To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]

For more options, visit this group at http://groups.google.com/group/ajaxpro

The latest downloads of Ajax.NET Professional can be found at 
http://www.ajaxpro.info
-~----------~----~----~----~------~----~------~--~---

Reply via email to