javascript - ColdFusion and AJAX - Updating Database -



javascript - ColdFusion and AJAX - Updating Database -

i'm wanting have scheme set users can go page there's list of items can rate (say, 1 through 5) drop-down. list going quite long much more convenient if go through , rank each item without ever having nail "save."

i'm very much novice when comes ajax figure can't that difficult. found an reply in different discussion think quite relevant doesn't provide plenty info me know it.

in short, how utilize ajax, in congruence jquery , coldfusion, update database without need save/submit button?

clarification: should have clarified user can rate items - not rank. meaning there's no #1, #2, #3, etc. instead, each item can rated on scale 1-5.

currently i'm basing off of ".change()" when user makes selection in drop-down. @ point have 2 jquery variables set "id" of item changed new "rating." need find way utilize these 2 variables update table in database.

updateon main page, have simple jquery ajax post call: $.post('update.cfc', {id: inputid, rating: selrat}) triggered .onchange(). "inputid" id of entry want update in database , "selrat" selected rating in drop-down.

<cfcomponent output="false"> <cffunction name="updaterating" access="remote" output="false"> <cfupdate datasource="#session.db#" name="update"> update ajaxtest set rating = #form.rating# id = #form.id# </cfupdate> </cffunction> </cfcomponent>

i'm getting 500 (internal server error).

thoughts/suggestions?

have tried submitting traditional way form see happens? can add together simple debugging writing file log executed attempt?

one thing stands out me: should <cfupdate opening , closing tag <cfquery don't utilize cfupdate or cfinsert, don't think cf flavor supports syntax you're trying use, leads me believe it's easy mistake.

on note, query dangerous, , sorry go off on tangent..

if submitted "0; drop table users" value of id, users table disappears (if have users table). pass other mutual table names members, news, pages, content, cms, transactions. (i wouldn't this, never know when user might.)

there's easy solution, <cfqueryparam>. i'll allow research tag, i'll show how alter particular query.

<cfquery datasource="#session.db#" name="update"> update ajaxtest set rating = <cfqueryparam cfsqltype="cf_sql_integer" value="#form.rating#"> id = <cfqueryparam cfsqltype="cf_sql_integer" value="#form.id#"> </cfquery>

cfqueryparaming variables stops risk of , passes variable values text rather sql.

javascript jquery ajax coldfusion

Comments

Post a Comment

Popular posts from this blog

c - Compilation of a code: unkown type name string -

c - Compilation of a code: unkown type name string - i have next lines of code compiler says following: "unknown type name 'string'" both in declaration , definition of function. can tell me what's wrong? thanks. #include <stdio.h> #include <stdlib.h> #include <string.h> void frecognizeclient(string *actualclient) there no string type in c. need utilize array so: char array[10]; then can pass in function: void frecognizeclient(char *actualclient); c arrays string compilation
Read more

java - Bypassing "final local variable defined in an enclosing type" -

java - Bypassing "final local variable defined in an enclosing type" - i'm writing programme , i'm getting "the final local variable asd cannot assigned, since it's defined in enclosing type". i provide illustration not code produces error aswell. have arraylist utilize later (if define within button can't utilize later on), outside of button, pressing button should give values arraylist. in illustration "create new arraylist" cause same problem. button btn = new button("asd"); final arraylist asd = new arraylist(); btn.setonaction(new eventhandler<actionevent>() { public void handle(final actionevent event) { asd = new arraylist(); //here's error.. } }); clear arraylist , add together values. java javafx
Read more

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) -

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) - hello have problem hibernate , jackson. have 2 pojos @entity @table(name = "users") public class user implements serializable { static final long serialversionuid = 4235637833262722256l; @id @generatedvalue private int id; @column(name = "creation_date") private date creationdate; @column(name = "first_name") private string firstname; @column(name = "last_name") private string lastname; @version @column(name = "version") private int version; @column(name = "e_mail") private string email; @column(name = "enabled") private boolean enabled; @column(name = "login") private string login; @column(name = "password") private string password; @jsonmanagedreference("role") @onetomany(mappedby = "user", cascade = cascadetype.all,fetch = fetchtyp...
Read more