CFScript Inquiry

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Does anyone have examples of how to insert data into a database using cfscript. My other option is to try to and create a batch file and execute it with cfexecute. - -- Graham Pearson, System Administrator / Application Developer Northern Indiana

Re: CFScript Inquiry

IIRC, you'll need to write your own query function using cffunction and cfquery to get this to work. There is no built-in query function, only the tag. --Ben Graham Pearson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Does anyone have examples of how to insert data into a

Re: CFScript Inquiry

blatant_plug You could use my (free) Data Manager component. http://steve.coldfusionjournal.com/easier_inserts.htm Example: database: MS SQL table: MyTable with fields Field1 and Field2 cfscript DataMgr = CreateObject(component,com.sebtools.DataMgr_MSSQL).init(mydsn); DataMgr.load(myTable);