It's been deprecated? Okay.. I'll do the CfQuery route.. <CFINSERT> was just soooo clean...
Derek -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dan Blackman Sent: Friday, December 20, 2002 11:15 AM To: [EMAIL PROTECTED] Subject: RE: <cfinsert> Short answer to long question...Don't use CFINSERT...It's been deprecated for a reason. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of derek bumpas Sent: Friday, December 20, 2002 11:07 AM To: [EMAIL PROTECTED] Subject: <cfinsert> Okay Gurus, Here is stumper for me, perhaps an issue that you all have come across in the past. SQL Server 2000 ColdFusionMX My Table: TestTable Field Type ---------------- myData int My code: <CFSET FORM.MyData=1> <cfinsert username="testUser" password="testPassword" datasource="drmx" tablename="testTable" dbtype="ODBC" formfields="myData"> Facts: 1. The DB has a u: / p: set on it which I am passing through via username and password attributes in the CFInsert. 2. CFInsert will throw a permission error each time. 3. CFQuery works fine. 4. Adding the login information into the DSN allows the above code to work, but opens security issues. WHAT's up with CFINSERT? Thanks ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
