franky_1
|
| Posted: 04/17/2003, 4:02 AM |
|
hi
I'm a newbie to CC, and I' m having problems doing a manual update.
When I'm on a record page and doing an update, there is a Before Update event that also updates another field.
The problem comes in the WHERE clause of the SQL:
$sSQL = "update fm_user set " .
"cv_show = " . tosql($fldcv_file, "Text") .
" where UID = " . tosql($fldUID, "Number");
$sSQL .= $db->query($sSQL);
when UID is a textbox this works, when it's hidden it doesn't.
Can anyone please help me?
|
|
|
 |
maf
|
| Posted: 04/17/2003, 7:12 AM |
|
Hi,
It seems that CC has a bug when programed with PHP4. I also had the problem of loosing the variable when it is hidden in the form. It only works if it is a textbox.
If you try to associate the hidden variable to a session variable it also doesn't work.
I managed it using the textbox and verifying its contents before updating the database.
|
|
|
|
|
