So in this lovely new module, I have an auto-increment table for the proposals that will be entered. All well and good, except that some of the proposals are going to be re-submitted in the future, because people may be asked for more information. Both proposals need to be available but linked.
If we were doing this by hand, we'd just call them 110 and 110R. However, that breaks down on the auto-increment level.
Any thoughts? The only thing I can think of would be a "resubmitted" table, and just do a couple of queries to get all the proposals. Or something like that. I'm drawing a total blank. Probably a symptom of it being Friday. :)
Forum Activity
- shyra posted »MenuTree Mystery« 19:50h
- dks answered »include a file« 18:22h
- dks answered ».764 -> 1.1.1, Can't add new blocks« 17:33h
- craigh posted »PostCalendar 5.5.0RC1 needs testers and translators« 17:24h
- bartl answered »Upgrading 1.0.2 --> 1.1.1« 15:02h
- Charlie-otb answered »SafeHTML output filter and youtube« 10:02h
- dl7und answered »Adding an "About Us" page« 03:34h
Login
Auto-increment-related question
-
- Rank: Helper
- Registered: 15.11.04
- last visit: 12.03.07
- Posts: 387
Posted: 25.02.2005, 21:30
-
- Rank: Helper
- Registered: 07.02.03
- last visit: 12.06.08
- Posts: 226
Posted: 25.02.2005, 21:51
I would add a second field called something like base_proposal. In your example above the original proposal would have zero in the base_proposal field and the resubmitted proposal would have 110 in the base_proposal field. No change to the auto-increment logic. This would tie all of the resubmitted proposals to the original. -
- Rank: Legend
- Registered: 31.12.69
- last visit: 30.06.09
- Posts: 6766
Posted: 25.02.2005, 22:23
Either that or allow for "resubmit" on the proposal, and use a revison field to store which revision it is.
- Moderated by :
- Support
