>
> ERROR
>
> MERANT][ODBC SQL Server Driver][SQL Server]The name 'bio_f'
> is not permitted in this context. Only constants,
> expressions, or variables allowed here. Column names are not
> permitted.
>
> ...
> VALUES (
> '#form.member_name#',
> '#form.email_address#',
> '#form.phone_office#',
> '#form.phone_cell#',
> '#form.phone_fax#',
> '#form.bio#',
> bio_f = <cfqueryparam value="#form.bio_f#"
> cfsqltype="cf_sql_longvarchar">
Your query is incorrectly written. You have "bio_f = <cfqueryparam ...>"
when you should just have <cfqueryparam>.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
