bio_f is the field name and should ONLY be in the field list....you use bio_f = in UPDATEs ;-)
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
----- Original Message -----
From: Daniel Farmer
To: CF-Talk
Sent: Tuesday, June 01, 2004 11:08 AM
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]
- database error when using cfqueryparam Daniel Farmer
- Re: database error when using cfqueryparam Bryan Stevenson
- Re: database error when using cfqueryparam Bryan F. Hogan
- RE: database error when using cfqueryparam Barney Boisvert
- Re: database error when using cfqueryparam Charlie Griefer
- Re: database error when using cfqueryparam Daniel Farmer
- RE: database error when using cfqueryparam Dave Watts
- RE: database error when using cfqueryparam Tangorre, Michael