I have this query that I am passing form fields to and it keeps giving me
errors... It worked before but now it just crashed out from under me please
help here is the query and the error:
<cfquery name="insert_adoption" datasource="course_adopt" dbtype="ODBC">
INSERT
INTO adoption
(
date_placed, dept_course, crn, estimated, last_name,
first_name, email,
department, phone, author1, title_price1, edition_cover1, publisher1, isbn1,
required1,
<cfif isdefined('author2')>
author2,
</cfif>
<cfif isdefined('title_price2')>
title_price2,
</cfif>
<cfif isdefined('edition_cover2')>
edition_cover2,
</cfif>
<cfif isdefined('publisher2')>
publisher2,
</cfif>
<cfif isdefined('isbn2')>
isbn2,
</cfif>
<cfif isdefined('required2')>
required2,
</cfif>
<cfif isdefined('author3')>
author3,
</cfif>
<cfif isdefined('title_price3')>
title_price3,
</cfif>
<cfif isdefined('edition_cover3')>
edition_cover3,
</cfif>
<cfif isdefined('publisher3')>
publisher3,
</cfif>
<cfif isdefined('isbn3')>
isbn3,
</cfif>
<cfif isdefined('required3')>
required3,
</cfif>
<cfif isdefined('author4')>
author4,
</cfif>
<cfif isdefined('title_price4')>
title_price4,
</cfif>
<cfif isdefined('edition_cover4')>
edition_cover4,
</cfif>
<cfif isdefined('publisher4')>
publisher4,
</cfif>
<cfif isdefined('isbn4')>
isbn4,
</cfif>
<cfif isdefined('required4')>
required4
</cfif>
)
values
(
'#date_placed#', '#dept_course#', '#crn#', '#estimated#',
'#last_name#',
'#first_name#', '#email#', '#department#', '#phone#', '#author1#',
'#title_price1#', '#edition_cover1#', '#publisher1#', '#isbn1#',
'#required1#'<cfif isdefined('author2')>, <cfelse> </cfif>
<cfif isdefined('author2')>
'#author2#',
</cfif>
<cfif isdefined('title_price2')>
'#title_price2#',
</cfif>
<cfif isdefined('edition_cover2')>
'#edition_cover2#',
</cfif>
<cfif isdefined('publisher2')>
'#publisher2#',
</cfif>
<cfif isdefined('isbn2')>
'#isbn2#',
</cfif>
<cfif isdefined('required2')>
'#required2#',
</cfif>
<cfif isdefined('author3')>
'#author3#',
</cfif>
<cfif isdefined('title_price3')>
'#title_price3#',
</cfif>
<cfif isdefined('edition_cover3')>
'#edition_cover3#',
</cfif>
<cfif isdefined('publisher3')>
'#publisher3#',
</cfif>
<cfif isdefined('isbn3')>
'#isbn3#',
</cfif>
<cfif isdefined('required3')>
'#required3#',
</cfif>
<cfif isdefined('author4')>
'#author4#',
</cfif>
<cfif isdefined('title_price4')>
'#title_price4#',
</cfif>
<cfif isdefined('edition_cover4')>
'#edition_cover4#',
</cfif>
<cfif isdefined('publisher4')>
'#publisher4#',
</cfif>
<cfif isdefined('isbn4')>
'#isbn4#',
</cfif>
<cfif isdefined('required4')>
'#required4#'
</cfif>
)
</cfquery>
----------------------------------------------------------------------------
---------------------------------------
Error Diagnostic Information
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (1:1) to (1:72).
Date/Time: 11/28/00 18:04:57
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
Remote Address: 128.223.165.134
HTTP Referer: http://www.uobookstore.com/coursebooks/coursebook_proc.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
