Try memNumber NUMBER(0,0) > Patrick Harkins > Research Application Support Specialist > Shur-Gain > 150 Research Lane Suite 200 > Guelph ON > N1G 4T2 > (519) 823-7017
> -----Original Message----- > From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 16, 2002 4:18 PM > To: CF-Community > Subject: RE: Db merge question > > > AHA! Ok, I stopped processing part way through and looked at the temp > table... > It is creating the memNumbers field as number double, not number long > integer...now how the hell do I force it to be number long integer? > Anybody know? > Just this one last thing and I will be done with this app... > > > ~~ > Stephenie > > > > > > |-----Original Message----- > > |From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] > > |Sent: Wednesday, October 16, 2002 4:11 PM > > |To: CF-Community > > |Subject: RE: Db merge question > > | > > | > > |Well I have converted the new db memNumber field to a number > > |instead of text...they will just have to change it on their > > |end. But now when I import the rows from the new db into a > > |tmpMember field in the old db... The memNumber is coming out > > |like this: 5102.0 5593.0 5594.0 5595.0 > > | > > |I can't figure out how to get rid of the decimal place as > > |that is throwing off my insert statement with a data type > > |mismatch...arg! > > | > > |Here is the query snippet for creating the tmpMembers table > > |for that field MemNumber NUMBER NULL > > | > > |Is there any way in this create table statement to specify 0 > > |for decimal places? > > | > > |<hating access> > > | > > |~~ > > |Stephenie > > | > > | > > | > > | > > | > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.401 / Virus Database: 226 - Release Date: 10/9/2002 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
