Inserting a record, not working. Please help
I am stumped. I am trying to get this code to insert a new record, but when it
goes through the code, it loses the record and doesn't insert it to the db.
What am I missing? I can't figure it out.
here is my query if it is updating and existing record
<cfquery datasource="#APPLICATION.dataSource#" dbtype="ODBC">
INSERT INTO news
(title, newsDate, htmlList)
VALUES (<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.title#">,
<cfqueryparam cfsqltype="cf_sql_date" value="#form.newsDate#">,
<cfqueryparam cfsqltype="cf_sql_longvarchar" value="#form.PDSeditor#">)
What did I miss? I can't figure it out.
|<Prev in Thread]
||[Next in Thread>
- Inserting a record, not working. Please help,