
Topic: The kind of stuff that just makes me crazy...
Re: The kind of stuff that just makes me crazy...
Maybe greatness brings out jealousy and anger. I don't know. But anyone who wants to understand Alexander will ultimately find out his true character.
Having just gotten back from Cairo, I would imagine this museum is well worth the trip. The collection at the Cairo Museum was unbelievable. And Egypt is definitely something to be experienced in one's lifetime. Get there!
I had trouble with it as well, Ruth. I kept skipping paragraphs looking for something that caught my interest.
I'd just like to wish you all a happy holiday! Thanks for some great forum debates!
Bravo!! Best of luck to you!!!
Topic: Alexander the Mummy?
Alexander the Mummy?
I've just returned from Egypt where I visited the Cairo Museum and the Pyramids of Giza.
Opinion there is that Alexander was mummified and buried in an unknown tomb in Alexandria.
It was very strange! No matter how I put in your address I couldn't get it to go. I'm very glad you checked here for it. Thanks again to Pothos for letting us get it right.Dysart is part of the Iowa region. The area code for Dysart is 1319476 and the calling code [email protected] is +1. The Dysart phone number format is +1 319-476-XXXX.
For mobile phones, you don't need to specify the area code of Dysart, but when you want to call a fixed line number, you should first type the area code.In case of Dysart you dial first +1319476.
This tool can be used if you want to have a list of Dysart random phone numbers that can be used for unit tests or in case you need some placeholders.Q: loading NA values from r to sql I am trying to load a dataframe from r to sql and am having trouble getting the NAs to load to their equivalent NULL in sql.  They are coming up as blank cells instead.  Example data:
data.frame(name = c('Sara', 'Matt', 'Kyle', 'Steve', 'Maggie', NA, 'Alex', 'Morgan'),
student_id = c(123,124,125,126,127,128,129,130),
           score = c(78, 83, 91, NA, 88, 92, NA, 77))

Table schema: student_score with columns name (varchar), student_id (int),  and score (int)
R code:  
load = "Insert into schema.student_score (name, student_id, score) values"  
data = list()  
for (i in seq(nrow(df))) {  
info = paste0("('", df$name[i], "','",  
df$student_id[i], "','",  
df$score[i], "')")  
data[[i]] = info  
}  
rows = do.call(rbind, data)  
values = paste(rows[,1], collapse = ',')  
send = paste0(load, values)  
dbSendQuery(conn, send)  

and when they are loaded in sql it comes out
name    student_id    score
Sara    123           78
Matt    124           83
Kyle    125           91
Steve   126           
Maggie  127           88
        128           92
Alex    129           
Morgan  130           77

I want the blank values to be replaced by NULL

A: In your code NA gets translated as "NA". You need to replace all 'NA' in send to NULL. Simply add below code at the end -
send <- gsub("'NA'", "NULL", send)
send

"Insert into schema.student_score (name, student_id, score) values('Sara','123','78'),('Matt','124','83'),('Kyle','125','91'),('Steve','126',NULL),('Maggie','127','88'),(NULL,'128','92'),('Alex','129',NULL),('Morgan','130','77')"

I suppose given the polemical nature of this brief paper that it might be helpful to reveal a little bit of my own personal history. Our history, after all, does often shape our views and our interests.
I was raised a Roman Catholic in Massachusetts. I was the ‘practicing’ kind of Catholic. My family was regular in our church attendance. I was baptized. I received first communion. I was confirmed. After my marriage, both of my children were baptized into the Roman Catholic Church.
My primary dispute with the Roman Catholic Church was not on secondary things, such as church government, feast days, liturgy, and the like.
The Bible teaches that no man will be justified by works of the Law. And for those that seek to add their good works to Christ’s Good work – they destroy the grace of God. This is to reject Christ and His salvation.
I realize that this is a key dispute between the Roman Catholic Church and the magisterial Protestant reformers. Rome says faith in Christ plus our good works justifies us before God. The Reformers say our faith alone in Christ alone justifies.
I trust only in Christ’s work for my justification. My best deeds are filthy rags before a holy God.
My purpose is simple and specific. I intend to show that the Roman Catholic church teaches and promotes idolatry as regards to Mary.
You see when Protestants seek religious unity with the Roman Catholic Church they often say things like this, well Rome has a Biblical view of the Trinity, they have a Biblical view on the two natures of Christ therefore we can treat them as true brothers and sisters in Christ. Notwithstanding Rome and the Reformers have different gospels.
We miss the elephant in the room, the idolatry of Mary. Whatever true sounding things a church may teach, if they teach idolatry, they are a false church.
Committing idolatry with Mary or with anyone or anything else is not secondary. It is not like debating how much water should be applied in baptism.
Committing habitual unrepentant idolatry reveals that one is not born again, not in Christ, not saved, still dead in their sins, and in great danger of dying Christless and spending eternity without Him.
Idolaters will not inherit the kingdom of God. The Roman Catholic Church attributes names, titles, works, and worship to Mary which are due to Christ alone. This is idolatry. We must reject it and cling to Christ alone as He is revealed in the Scripture alone.
In order to represent the Roman Catholic view on Mary fairly I will quote from their primary sources. And I will give the reference for those that wish to do further study. I will try to keep my commentary brief so as to let the Roman doctrine speak for itself.
Most of the quotes come from Catechism of the Catholic Church, 1994, Liguori Publications – Libreria Editrice Vaticana, ISBN – 0-89243-566-6. I have listed first the paragraph number and then the page number.
This is a very important statement and should not be glossed over.
This the basis of Rome’s idolatry. What Christ is, Mary is. Christ is immaculately conceived. Mary is immaculately conceived. Christ is sinless. Mary is sinless. Christ was assumed into heaven. Mary was assumed into heaven. Christ is a Mediator. Mary is a Mediatrix. What Christ does, Mary does. Christ saves the church. Mary saves the church. As Christ is prayed to and worshiped. Mary is prayed to and worshiped.
The rest of the paper will reveal how consistently Rome applies this principle.
As we said earlier the issue is not minor but rather one of eternal salvation. The Roman church teaches that Mary shares in the saving work of Christ Jesus. This strikes against Christ alone meriting the redemption of His people.
In fact, the Roman Church refers to Mary as ‘the Gate of Heaven’. She is the door through which people arrive at heaven.
Inseparably linked means more than Mary birthed Christ after the flesh. This attributes some linking or sharing with Jesus in His work of salvation. The idea is that she like Christ is a mediator of salvation to us.
Rome says Mary like Christ is a mediator of God’s merciful love expressed in salvation. Rome calls Mary the Mediatrix of all Graces, meaning all of God’s saving grace to sinners comes through Mary.
For Mary to ‘embrace the whole human race’ this would require attributes of Deity, such as omniscience and omnipotence. Attributing attributes of Deity to a mere human being is idolatry.
Christ alone is our Mediator. The Bible says so.
Rome says Mary like Christ was and is sinless.
Many Protestants err when they think that ‘immaculate conception’ refers to the virgin and sinless birth of Jesus Christ. By this Rome means Mary’s immaculate conception.
You see by maintaining the sinlessness of Mary, Rome thus qualifies her as a co-savior of sinners.
The Bible teaches everyone except Christ has sinned.
Luke 1:46. And Mary said: “My soul exalts the Lord, 47 And my spirit has rejoiced in God my Sav