----- Original Message -----
From: Daniel Farmer
To: CF-Talk
Sent: Tuesday, June 01, 2004 2:08 PM
Subject: database error when using cfqueryparam
Having trouble figuring out what is causing this error....
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.
SQL = "INSERT INTO team ( member_name, email_address, phone_office, phone_cell, phone_fax, bio, bio_f, sml_image ) VALUES ( 'dan farmer', 'sdfsdf', 'sdfdsf', 'dsfsdf', 'sdf', 'sdfsdf', bio_f = ? ,'' )"
Query Parameter Value(s) -
Parameter #1 = dsfsdfsdf
MY QUERY
<cfquery name="addit" datasource="#db_datasource#" username="#db_username#" password="#db_password#" dbtype="#db_type#" dbname="#db_name#" dbserver="#db_server#">
INSERT INTO team (
member_name,
email_address,
phone_office,
phone_cell,
phone_fax,
bio,
bio_f,
<cfif isdefined('form.sml_image_name')>sml_image</cfif>
)
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">
<cfif isdefined('form.sml_image_name')>,'#form.sml_image_name#'</cfif>
)
</cfquery>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
