tech stuff
Aug. 21st, 2002 10:26 am![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
nollyI'm writing this half to organize my thoughts, but suggestions are welcome, too.
We need a tool to allow internal users (on Win boxes) to create the many-to-many relationships between items and objectives. The workflow is something like:
1) Get all items in an itemset
2) Search for potentially relevant objectives
3) Associate items with objectives
-- select an item
-- select one or more objectives
-- save
The backend is a MySQL DB.
Doing this via a web interface looks like it will necessitate a frameset and either a bunch of javascript or a lot of extra clicking.
The frameset means we can't integrate it with our actual site easily, since we're sticking a header and footer on every page in a manner that will be somewhat annoying to work around.
So the leading plan right now is to have a second Apache running on a box, not going through our usual framework, just handling this tool. In theory, I'm setting this up on my box today. But it seems like there must be a better way, an existing wheel, some way to create pretty forms for MySQL. On the other hand, I can see that there wouldn't be, for the same reasons it's taken so long to get Linux et al. anywhere close to Mom-and-Pop usable.
So how about it -- anything out there which will let me build a nice form for end users to build many-to-many relationships without mucking about with dual webservers and javascript and such?
We need a tool to allow internal users (on Win boxes) to create the many-to-many relationships between items and objectives. The workflow is something like:
1) Get all items in an itemset
2) Search for potentially relevant objectives
3) Associate items with objectives
-- select an item
-- select one or more objectives
-- save
The backend is a MySQL DB.
Doing this via a web interface looks like it will necessitate a frameset and either a bunch of javascript or a lot of extra clicking.
The frameset means we can't integrate it with our actual site easily, since we're sticking a header and footer on every page in a manner that will be somewhat annoying to work around.
So the leading plan right now is to have a second Apache running on a box, not going through our usual framework, just handling this tool. In theory, I'm setting this up on my box today. But it seems like there must be a better way, an existing wheel, some way to create pretty forms for MySQL. On the other hand, I can see that there wouldn't be, for the same reasons it's taken so long to get Linux et al. anywhere close to Mom-and-Pop usable.
So how about it -- anything out there which will let me build a nice form for end users to build many-to-many relationships without mucking about with dual webservers and javascript and such?
