Forum OpenACS Q&A: ad_form key pseudotype

Collapse
1: ad_form key pseudotype
Posted by Gabriel Burca on 11/12/03 07:22 AM
Can ad_form be used with tables where the primary key spans more than one column (a compound key)? A number of parameters such as -select_query and -edit_request seem to only work when the built-in key management feature is used.
Collapse
2: Re: ad_form key pseudotype (response to 1)
Posted by Jade Rubick on 11/12/03 09:07 PM
It can.

I find that the more complicated the things I try to do with ad_form, though, the more I feel like I'm cludging around to make it work.

In this case, the solution I've used is to use a sequence not related to your table, like acs_objects_seq (or something like that). That should give you double-click protection (I believe), but free you from the constraints of using a single column key.

Collapse
3: Re: ad_form key pseudotype (response to 1)
Posted by Don Baccus on 11/12/03 10:53 PM
Jade, how do you make select_query and edit_request work without using the built-in key management feature?
Collapse
4: Re: ad_form key pseudotype (response to 1)
Posted by Jade Rubick on 11/13/03 07:12 PM
Hmm, good point. I'm not so sure.

Gabriel, can you post post code excerpts of what you're trying to do?