StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7918560
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
2011-10-27T15:44:23.677
CreationDate
2011-10-27T15:44:23.677
FavoriteCount
0
LastActivityDate
2011-10-27T15:44:23.677
LastEditDate
LastEditorUserId
0
OwnerUserId
781512
ParentId
7880908
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Here's what I ended up using (in case someone else runs into an issue like this): Thanks everyone for your help. <pre class="lang-vb prettyprint-override"><code>Server.ScriptTimeout = 2147483647 Response.Buffer = False on error resume next dim conn1, conn, rs, updatedUser, updatedDate, filePath, dim deactivateSQL, csvConn, connCSV, csv, sql dim csvID, csvSSN, csvLast, csvFirst, csvMiddle dim csvGender, csvScl, csvGrd, csvCls, dbCls updatedUser = Request.Cookies("UserN") updatedDate = date() & " " & time() filePath = "\path\to\file" ' --- Connect to DZ database set conn1=Server.CreateObject("ADODB.Connection") conn1.Provider="Microsoft.Jet.OLEDB.4.0" conn1.Open "E:/path/to/database.mdb" ' --- Deactivate ALL students deactivateSQL = "UPDATE tblStudent SET Active=False " &_ "AND lastUpdatedUser='" & updatedUser & "' "&_ "AND lastUpdatedDate='" & updatedDate & "';" conn1.execute(deactivateSQL) conn1.close ' --- Connect to Students.CSV exported by iNOW csvConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &_ Server.MapPath(filePath) &_ ";Extended Properties='text;HDR=no;FMT=Delimited';" Set connCSV = Server.CreateObject("ADODB.Connection") connCSV.Open csvConn Set csv = Server.CreateObject("ADODB.recordset") csv.open "SELECT * FROM Students.csv", connCSV ' --- Begin looping through Students.csv do until csv.eof ' --- Get Students.csv Column Values csvID = csv.fields(0) if isnull(csv.fields(1)) then csvSSN = NULL else csvSSN = csv.fields(1) end if csvLast = replace(csv.fields(2), "'", "") csvFirst = replace(csv.fields(3), "'", "") ' --- Using IsNull() fixed the 2nd problem ' --- I was having after updating the question if isnull(csv.fields(4)) then csvMiddle = csv.fields(4) else csvMiddle = replace(csv.fields(4), "'", "") end if csvGender = csv.fields(5) csvScl = csv.fields(6) csvGrd = csv.fields(7) csvCls = csv.fields(8) ' --- Connect to database set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open "E:/path/to/database.mdb" set rs=Server.CreateObject("ADODB.Recordset") rs.open "SELECT * FROM tblStudent " &_ "WHERE StudentID='" & csvID & "';", conn if rs.bof and rs.eof then ' --- if rs.bof & rs.eof, the csvID is NOT in the table ' --- Add the new csvID to DB, we'll add the rest in ' --- the UPDATE statement below conn.execute("INSERT INTO tblStudent (StudentID) " &_ "VALUES ('" & csvID & "');") ' --- Set to 0 since it's supposed to be a number dbCls = 0 else ' --- Get tblStudents.Class from existing record dbCls = rs.fields("Class") end if ' --- UPDATE the table with the appropriate info sql = "UPDATE tblStudent SET " &_ "Active=True, " &_ "SSN=" & csvSSN & ", " &_ "LastName='" & csvlast & "', " &_ "FirstName='" & csvFirst & "', " &_ "MiddleName='" & csvMiddle & "', " &_ "Gender='" & csvGender & "', " &_ "School=" & csvScl & ", " &_ "GradeLvl=" & csvGrd & ", " &_ "Class=" & csvCls & ", " &_ "PrevClass1='" & dbCls & "', " &_ "lastUpdatedUser='" & updatedUser & "', " &_ "lastUpdatedDate='" & updatedDate & "' " &_ "WHERE StudentID='" & csvID & "';" conn.execute(sql) csv.movenext loop if error<>0 then response.cookies("updated") = "no" response.cookies("updated").Expires = dateadd("s", 2, now()) response.redirect("step-5.asp") else response.cookies("updated") = "yes" response.cookies("updated").Expires = dateadd("s", 2, now()) response.redirect("step-6.asp") end if </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POASP Update database, insert if does not exist
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USjoshmax
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.