jisidro
|
| Posted: 03/09/2003, 6:31 PM |
|
Hi all, CC newbie here.
Can anyone tell me why the SQL string on my form is ignored when I run the page? The form won't bring back records at all, it doesn't even see the SQL, although the SQL string compiles fine, without errors. I'm using Code Charge 2.0.5 with Cold Fusion.
The form is a record. The weird thing is, if I change the form type to a grid, the SQL is recognized and executes perfectly. But I can't use a grid for this function, I must use a record.
I'm sure it's something easy I'm overlooking. Thanks.
|
|
|
 |
jisidro
|
| Posted: 03/09/2003, 6:42 PM |
|
never mind, I see that the topic has been addressed. Code Charge doesn't allow a custom query on a record type form because it could bring back more than 1 record. Too bad it can't distinguish when only 1 record is being recalled.
Thanks.
|
|
|
|
jisidro
|
| Posted: 03/09/2003, 7:39 PM |
|
Well, it was sure easy to just add my custom SQL string into the custom show event of my form. This Code Charge is a great tool. What a timesaver.
|
|
|
|
|
