Hassle-free live chat software re-imagined for business growth. 2 users, always free.
bPartFound = False Set rs = Server.CreateObject("ADODB.Recordset") sql = "SELECT RosterID FROM Roster WHERE FirstName = '" & field1 & "' AND LastName = '" & field2 & "' AND Gender = '" & field3 sql = sql & "' AND TeamsID = " & lTeamID rs.Open sql, conn, 1, 2 If rs.RecordCount > 0 Then bPartFound = True rs.Close Set rs = Nothing
|Can't connect to new installation of SQL Server 2016||6||29|
|Updating a table from a temp table||4||28|
|C# guarantee sql connection close||6||25|
|Trouble analysing a database||9||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!