Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
Set rs = New ADODB.Recordset sql = "SELECT FirstName, LastName, City, St, Phone, Email, DOB, Gender, Country, FBook, Twitter, Uploaded " sql = sql & "FROM Participant WHERE ParticipantID = " & PartsToAdd(i) rs.Open sql, srvr_conn, 1, 2 For j = 0 To 10 PartArr(j) = rs(j).Value Next j rs(11).Value = "y" rs.Update rs.Close Set rs = Nothing 'check to see if this participant exists lParticipantID = 0 Set rs = New ADODB.Recordset sql = "SELECT ParticipantID FROM Participant WHERE FirstName = '" & PartArr(0) & "' AND LastName = '" & PartArr(1) sql = sql & "' AND Email = '" & PartArr(5) & "' AND Gender = '" & PartArr(7) & "'" rs.Open sql, conn, 1, 2 If rs.RecordCount > 0 Then lParticipantID = rs(0).Value rs.Close Set rs = Nothing
|SQL Breakdown by month across past 3 years||6||40|
|Help in Copy Database Wizard From One SQL Server to Other SQL Server||10||25|
|Help Parsing a String with SQL Syntax||23||15|
|How do query sql to display current month date ?||15||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!