These are chat archives for codefellows/sea-b15-javascript

22nd
Aug 2014
Tyler Morgan
@toastynerd
Aug 22 2014 00:39
yeah, there’s an open house tonight
Kevin Stephens
@kevinmstephens
Aug 22 2014 00:40
HAHAHAHA
Kyle Warbis
@UWarbs
Aug 22 2014 00:40
sheeeeeeeeeeit
Kevin Stephens
@kevinmstephens
Aug 22 2014 00:40
you leaving work warbi?
Kyle Warbis
@UWarbs
Aug 22 2014 00:40
yes
Kevin Stephens
@kevinmstephens
Aug 22 2014 00:40
ok I'll head out
you make that?
Kyle Warbis
@UWarbs
Aug 22 2014 00:41
no, but i have been watching it for 20 minutes
above my pay grade
Kyle Warbis
@UWarbs
Aug 22 2014 05:47
me_and_java.jpg
That is me trying to fix stuff on a java server.
Andy Ernst
@AndyCErnst
Aug 22 2014 05:48
You using Eclipse?
Eclipse has a learning curve but it makes Java way the hell easier to program. I wish JavaScript had an Eclipse
And don't say Webstorm, that's not the same.
Kevin Stephens
@kevinmstephens
Aug 22 2014 16:16
Webstorm
Andy Ernst
@AndyCErnst
Aug 22 2014 16:18
NOT THE SAME
Kevin Stephens
@kevinmstephens
Aug 22 2014 16:19
@toastynerd
Public Function AppendData(varItem As Variant)
'varItem is xlsx that needs to be appended to ImportedData table
'link the FlatData table to the varItem and then append to ImportedData

Dim tdf As TableDef
Dim tdf2 As TableDef
Dim db As dao.Database

Set db = CurrentDb
Set tdf = db.TableDefs("FlatData")
Set tdf2 = db.TableDefs("Services Case Notes")

tdf.Connect = "Excel 12.0 Xml;HDR=YES;IMEX=2;ACCDB=YES;DATABASE=" & varItem
tdf.RefreshLink

tdf2.Connect = "Excel 12.0 Xml;HDR=NO;IMEX=2;ACCDB=YES;DATABASE=" & varItem
tdf2.RefreshLink

Dim sql As String
Dim id As Long
Dim caseID As String

' Insert dummy record and record it's ID into DataServices
' to be able to delete it and next two header rows later
sql = "INSERT INTO ImportedDataServicesCaseNotes ( [Date] ) SELECT ""BLAH"""
DBEngine(0)(0).Execute sql, dbFailOnError
id = DLookup("max(ID)", "ImportedDataServicesCaseNotes")

DBEngine(0)(0).Execute "FlatDataImport", dbFailOnError
DBEngine(0)(0).Execute "ServicesCaseNotesImport", dbFailOnError

' Capture CaseID from newly written 1st row of DataServices
caseID = DLookup("[Service Provider]", "ImportedDataServicesCaseNotes", "ID = " & (id + 1))

Debug.Print (caseID)
' Delete rows id to id + 2 from DataServices
sql = "Delete * from ImportedDataServicesCaseNotes where ID >= " & id & " and ID <= " & (id + 2)
DBEngine(0)(0).Execute sql, dbFailOnError

' Delete blank rows.
DBEngine(0)(0).Execute "ServicesCaseNotesBlankRows", dbFailOnError

' Insert caseID into remaining rows
sql = "Update ImportedDataServicesCaseNotes Set ImportedDataServicesCaseNotes.[CaseId] = '" & caseID & "' Where [ID] >= " & id
DBEngine(0)(0).Execute sql, dbFailOnError

Set db = Nothing
Set tdf = Nothing
Set tdf2 = Nothing

End Function
@toastynerd More than a macro!
Tyler Morgan
@toastynerd
Aug 22 2014 16:21
fuck that looks like something I don’t want to read
Kevin Stephens
@kevinmstephens
Aug 22 2014 16:22
Does the SQL confuse your brain? Haha.
OK, we are even on snarky comments.
Tyler Morgan
@toastynerd
Aug 22 2014 16:23
lol
I’ve actually never worked with sql functions
never really had a need for them
Robert Talamantez
@Talamantez
Aug 22 2014 20:37
hello developers - when you're using Foundation and SASS, do you use Compass for animations/interactivity? or another library?
Brook Riggio
@brookr
Aug 22 2014 21:33
jQuery?
Robert Talamantez
@Talamantez
Aug 22 2014 21:35
what is this jQuery of which you speak ;-) thanks
Brook Riggio
@brookr
Aug 22 2014 21:41
[: Look here, under Effects: http://oscarotero.com/jquery/
Robert Talamantez
@Talamantez
Aug 22 2014 21:43
woah - that's a great reference - thanks again
Stephen Boles
@stephenboles
Aug 22 2014 21:43
@KuroFluff Definitely apply.
In fact, if you are breathing, have any entrepreneurial ambition in your body, and like to network with awesome people, apply.
Plus, we will have hors dourves during the demo night on September 3rd, 2014. ALL FOR FREE.
So, seriously, what are you waiting for.
:)
Brook Riggio
@brookr
Aug 22 2014 21:46
@stephenboles, would you like to invite my Foundations bootcamp students as well?
They’ve done just 4 weeks of html/css/js, but are making cool shit already: https://gitter.im/codefellows/sea-b26-foundations
@stephenboles Better yet, maybe email, since the chat room is cfbot-abuse. [:
@stephenboles Better yet, I’ll email the class with the message sent to alumni.
Stephen Boles
@stephenboles
Aug 22 2014 23:09
@brookr Absolutely...send them my way.
Brook Riggio
@brookr
Aug 22 2014 23:09
Yup, done!