>basically
>
><cfquery datasource="blah">
>
>insert into clntnote (thisdate,subject,note,type,compid)
>values ('#form.thisdate#','#form.subject#','#form.note#','#form.type#',#form.compid#)
>
></cfquery>
>
>You will need to debug it of course.
>
>-Mark
Now that you've seen the simple solution, I'll transition you to the
full version. Learn to use <cfsqlparam> NOW rather than retro-coding
later. Look into the docs and DAGS on "cfqueryparam."
insert into clntnote (thisdate,subject,note,type,compid)
values (
<cfqueryparam value="#form.thisdate#" cfsqltype="CF_SQL_DATE">,
<cfqueryparam value="#form.subject#" cfsqltype="CF_SQL_VARCHAR">,
<cfqueryparam value="#form.note#" cfsqltype="CF_SQL_VARCHAR">,
<cfqueryparam value="#form.type#" cfsqltype="CF_SQL_VARCHAR">,
<cfqueryparam value="#form.compid#" cfsqltype="CF_SQL_INTEGER">
)
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
