try using sql so it would look like this: <cfquery etcetc...> INSERT INTO soldSteel (list of table fields) VALUES (#form.type_id#, etc etc ) </cfquery>
I've found cfinsert to be a bit strange in the past and using straight SQL normally sorts it out. Just make sure that the VALUES match the list of table fields otherwise you'll be putting data into teh wrong fields. hth Doug -----Original Message----- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: 19 September 2002 15:52 To: CF-Talk Subject: RE: Just curious possible problem I place the info in a form and then do this cfinsert <CFINSERT datasource="brinventory" tablename="soldSteel" formfields="type_id, desc, typeid, width, weight, length, quantity, price, method, location, comments, companyname, invoiceno, datesold, pono"> desc is the problem.. -----Original Message----- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 9:35 AM To: CF-Talk Subject: RE: Just curious possible problem What code are you using to perform the copy? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -----Original Message----- > From: Webmaster [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 19, 2002 10:35 AM > To: CF-Talk > Subject: Just curious possible problem > > > I noticed if I have a set of text example: " s3 10 X 50" 120 pcs". I have > this in an access database without the quotes, but when I try to copy that > information to anew table it stops where the first space begins. So when I > am looking at what copied into the new table is just "s3".. What > am I doing > wrong besides using access.. I am also using cf 4.5.. > > ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists