Apostrophe Insert Problem

Hi. I'm having a problem inserting data from a form that contains an apostrophe, such as a last name like O'Hara. I don't recieve any errors but everything after the O is blank or trimmed. I'm not sure what I am doing wrong. This is a MS SQL db. Here's the code if anyone can take a look and help:

<cfquery name="name" username="#application.datasource#" password="#application.datasource#" datasource="db">
insert into contactform
(firstname, lastname, address, city, state, zipcode, homePhone, workPhone, email,
financialAid, veteran, visa, list, programofinterest, howdidyouhear)
values
(<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.firstname#">,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.lastname#">,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.address#">,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.city#">,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.state#">,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.zipCode#">,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.homePhone#">,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.workPhone#">,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.email#">,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.financialAid#">,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.veteran#">,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.visa#">,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.list#">,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.programofinterest#">,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.howdidyouhear#">
)
</cfquery>