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
