Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.