Actually the power source for the my rack has been down for a week. Hopefully it will be back up next week. Has not really been a big priority of mine to bug the guy who needs to fix it. Also kind of the joys of "free hosting" .net .com and .info should all be pointing to the same IP which is the web server on that rack.
Good luck with the Oracle, I did this switch over a few years back and was not too bad at all. Toad really does help out a lot, I still do not know half of its functionality. On Fri, 7 Jan 2005 09:31:06 -0500, Stuart Kidd <[EMAIL PROTECTED]> wrote: > Thanks for that Aaron, that should certainly put me on the right track. > > Out of curiosity i couldn't help but try and access your website... but... > the firewall of this very large financial company in London blocked it. It > let me look at happyhacker.org though, maybe because it's ORGanised > happyhacking! ;) > > Saturday > > ---------- Original Message ---------------------------------- > From: Aaron Rouse <[EMAIL PROTECTED]> > Reply-To: cf-talk@houseoffusion.com > Date: Fri, 7 Jan 2005 08:21:23 -0600 > > >To do "autonumbering" you have to create a sequence and a trigger, to > >the best of my knowledge Toad does not provide a shortcut to creating > >these. I just edit a small snippet of code to reflect whatever table > >i need it for, such as: > > > > > >CREATE SEQUENCE SEQ_ACTIVITYLOG > > START WITH 1 > > MAXVALUE 1E27 > > MINVALUE 1 > > NOCYCLE > > CACHE 20 > > NOORDER; > > > >CREATE OR REPLACE TRIGGER ITM.TRG_ACTIVITYLOG > > BEFORE INSERT ON ITM.ACTIVITYLOG REFERENCING OLD AS OLD NEW AS > > NEW > > FOR EACH ROW > >DECLARE > > x INTEGER; > >BEGIN > > IF :new.ID is null THEN > > SELECT SEQ_ACTIVITYLOG.NEXTVAL INTO x FROM DUAL; > > :new.ID := x; > > END IF; > >END; > > > >I just dumped those out of Toad, but at least put you down the right > >path, you probably can find countless examples of this via a google > >search. > > > >As far as the CFQUERies, your functions are going to be different > >between the two databases and the way you do joins might end up > >needing some changes. Will depend on what version of Oracle as to how > >different joins might need to be done. > > > >-- > >Aaron Rouse > >http://www.happyhacker.com/ > > > >On Fri, 7 Jan 2005 09:13:47 -0500, Stuart Kidd <[EMAIL PROTECTED]> wrote: > >> Hi guys, > >> > >> I'm about to start on a new project at my current contract for which i've > >> had them buy CF (and for once i didn't take too much convincing). > >> > >> In the past (and present) I connect to an MS-SQL database which i've grown > >> to love. > >> > >> At work however, it's all Oracle. I've connected it using the CF > >> Administrator and am using TOAD to add tables etc. > >> > >> Before i start coding i'm wondering if my CFQUERYies will be different to > >> those I have created for MS-SQL in anyway? > >> > >> Thanks for your help, > >> > >> Stu > >> > >> ps: also, does anyone know how to create an incremental number for an INT > >> in TOAD (it's for an PK id)? > >> > >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189636 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
