datadoit
|
| Posted: 10/07/2007, 8:54 AM |
|
CCS3.2.0.2; PHP5; MySQL5
I have a record form that will write information to more than one table.
In this record form I place controls for field values that will come
from tables other than the form's designated source.
Getting that control's value via a BeforeShow event works fine:
Ex: CCDLookUp("field","other_table","id=".CCGetParam("id",""),$Connection);
What I'd like to be able to do is get the value for the control WITHOUT
programming. If I put this CCDLookUp statement into the Control Source,
with Source Type = Database Column, it actually works when the record is
initially pulled. The problem comes when the record form is submitted
for add/save. It'll display a record error similar to this:
Database Error: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near '("id",""),$Connection) = 1 WHERE id = 1' at line 1
I don't know exactly what's happening here, thus don't know how to work
around it. Anyone have any clues as to how or why CCS is doing this
post in this manner and thus throwing the error?
Again, my goal is to not do any custom programming to pull these form
control values. There are many many of these in this record form. Of
course, I'm handling the writing of the control's information in a
custom function I created which is called in AfterInsert/Update events.
Gracias.
|
|
|
 |
|
