SELECT thisdate,subject,note,type,compid
FROM clntnote
</cfquery>
----- Original Message -----
From: Steven Sharko
To: CF-Talk
Sent: Wednesday, February 25, 2004 8:53 AM
Subject: total newbe question
Can you give me an example of how to rewrite this into a CFQUERY?
<CFINSERT datasource="#application.db#" tablename="clntnote"
formfields="thisdate,subject,note,type,compid">
At 08:36 AM 2/25/2004, you wrote:
> > From: Steven Sharko
> > Is the word "type" a reserved word in CFMX?
> >
> > Error Executing Database Query.
> >
> > [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
> > Microsoft
> > Access Driver] Syntax error in INSERT INTO statement.
>
>That's a database error, not a CF error
>
>It's a reserved word in Access
>
>----------
>[
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
