wow! jamming! Usualy I use this in oracle for sequences. First I have a sequence created called say seq_myseq. Then for table foo an insert would look like INSERT INTO foo (pk, col1, col2) VALUES (seq_myseq.nextval, 'data1','data2')
I suppose if you gave a choice for this in your wizard, you could ask for the sequence name an duse the above for inserts. HTH DK On 11/30/05, Stan Winchester <[EMAIL PROTECTED]> wrote: > I just uploaded a new version that now supports the following primary keys: > max_id, autonumber, uuid, guid, text user defined, and I suppose I should add > a numeric user defined. The download can be found at: > http://www.aftershockweb.net/forums/messages.cfm/ThreadId/50 > > Also, could someone send me an example of Oracle numeric sequenced primary > keys? > > Thanks > > >I just put a FREE new HomeSite+/ColdFusion Studio Wizard that builds a CFC > >based CRUD application. Please feel free to download and use it. If you use > >it, please let me know. If you have any comments, suggestions, complaints, > >or whatever, please post them to on: > >http://www.aftershockweb.net/forums/forums.cfm/ConferenceId/8 > > > >Here is a link to the thread containing the download: > >http://www.aftershockweb.net/forums/messages.cfm/ThreadId/50 > > > >I know there is a lot of work to do to it still, but it is a start. > > > >Thank you, > >Aftershock Web Design, Inc. > >by: Stan Winchester > >President/Developer > >[EMAIL PROTECTED] > >http://www.aftershockweb.com/ > >Phone 503-244-3440 > >Fax 503-244-3454 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225859 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54