This content has been marked as final. Show 4 replies
in the code you posted there is no code for updating the db...
> <CFQuery name = "query1" datasource = "#APP_DB_DSN#">
> select code , COALESCE(code::text,'') || ':' || COALESCE(name,'') as name
> from tblpmdsetcomblist
> where valid_flag = 1
> and id = #id#
> order by sort,code
there is no 'sort' column pulled from the db or aliased by that name as
it appears in the order by clause in the query above...
> <!--- this is the code that invokes the CFC code above and displays it as well
> <CFInvoke Component="component.selbox" Method="Sel_Plusoneflag"
you did not post any code for the 'Sel_Plusoneflag' function in your
cfc... did you post a wrong function or should you change the method's
name in the cfinvoke?
> i checked all the sources of the problem which are obvious to me but found
> none :(
and what's the actual problem you are facing? the select box still not
working (HOW is it not working? - not displaying/displaying wrong data?)
or something else?
i posted the wrong code, here is the correct one
<CFFunction name = "Sel_Plusoneflag" output = "false" returntype = "string" access = "public">
<!--- 引数の定義 --->
<CFArgument name = "prm_SelID" required = "true">
<CFSet res1 = "">
<cfset id = 6>
its all the same from that point on
the problem with the selection box is when you choose an option (only two; 0 or 1) then submit it, it doesnt show up in the database, a new record is placed but the plus_one_flag field is null
OK. can you also please post the code that inserts/updates record in the
db? since your select box displays on the page, then the problem must be
in the update/insert code...
thanks again sir, ive found the problem in the template that submits all the data to the db, i was looking at the wrong place after all.
its all working good now :)