> it's perplexing. i checked the reserved word list for access
> (i thought NOTE
> might be) but nothing is in the reserved word list that you're using.
:nods
Thought of that too :-/
> what about the code immediately before or after the CFQUERY?
> anything there
> that looks suspicious?
Snipit here - you can see it picks up that were updating on line 1, and
looks to see if we should update or insert, the problem query is marked
'[here]'.
The database has two lines for userid = #session.userid# (i.e. 32715281),
neither with a note:
userid skill skill_level note
32715281 1 2
32715281 2 2
---snip top of file, just GUI stuff---
<cfif IsDefined("form.level")>
<cfquery name="update_ch" datasource="ps_skills">
select * from con_list where userid = #session.userid# and
skill=#form.skill#
</cfquery>
<cfif update_ch.recordcount eq 0>
<cfquery name="update" datasource="ps_skills">
insert into con_list values
(#session.userid#,#form.skill#,#form.level#,'#form.notes#')
</cfquery>
<cfelse>
<cfquery name="update1" datasource="ps_skills">
update con_list set skill_level=#form.level# where userid =
#session.userid# and skill=#form.skill#
</cfquery>
<cfquery name="update2" datasource="ps_skills"><!--- [here]
--->
update con_list set note = 'dr' where userid =
#session.userid# and skill = #form.skill#
</cfquery>
</cfif>
Updated OK.
<cflocation url="index.cfm">
</cfif>
---never gets this far---
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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