Simple coldfusion update query

[exel]

Hello,

I can't seem to get my update query to "check" a yes/no access database field. It's probably something really simple that I am missing.

Here's the fields that I have on the database side:

id  AUTONUMBER
name  TEXT
userNo  NUMBER
agreed  YES/NO

On the coldfusion page I have the following query: Notice the form.varNames are coming from a previous form where user typed in the information

<CFQUERY NAME="userInfo" DATASOURCE="user">

UPDATE t_User 
SET name = '#form.name#', 
userNo = '#form.userNo#', 
agreed = '#form.agreed#',
WHERE user.id = #form.id#;

</CFQUERY>

So the problem is that the code will not update the 'agreed' field inside the database. Any suggestions/ideas/hints/help?

Thank you in advance.

 

[maxedoutcc]

while your sql look correct, I'd look for database specific sql for access yes/no

also you really should be using cfqueryparam instead of straight variable names.

 

[exel]

while your sql look correct, I'd look for database specific sql for access yes/no

also you really should be using cfqueryparam instead of straight variable names.

Yeah, the sql code was correct, the problem turned out to be that it was never running that update query. I had session variable problems

Anyways, after a bit of reading/googling I decided to use cfqueryparam from now on.

Cheers!

 

[ferrisnox]

You should dump the queryparams, and use stored procedures, that is the best way to work it.

 

[maxedoutcc]

You should dump the queryparams, and use stored procedures, that is the best way to work it.

He is using access.