So clean'n'slow The last thing we need is to _further_ abstract the CF language.
<cfwebsite banners="true" personalized="true" databasefunctionality="true" guestbook="true" pressreleases="true" contactus="false"> yeah! ----- Original Message ----- From: "derek bumpas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 20, 2002 11:34 AM Subject: RE: <cfinsert> > 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 > ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
