dplaut
|
| Posted: 03/13/2002, 7:09 AM |
|
I am attempting to fill the lookup with data from SQL but no matter what valid sql I put in I get the following CF error:
Error resolving parameter LOOKUP_ALIAS_ID
Are there any CF examples with lookup sql in a lookup control?
|
|
|
 |
Tom
|
| Posted: 03/13/2002, 12:26 PM |
|
Yeah! another CF user
Here's what I do if I want this sql
select myPk, myShowThis from myTable order by myShowThis
I actually type the following sql in
select myPk AS lookup_alias_ID, myShowThis as lookup_alias_VALUE from myTable order by 2
I noodled this thru by looking at the generated code
Good luck
|
|
|
|
dpluat
|
| Posted: 03/15/2002, 1:17 PM |
|
Thanks, I'll give it a try Monday.
|
|
|
|
|
