cfscript and database

Posts: 98 · Posted: Sat Mar 10, 2007 1:11 am

How can I do an Insert to my DB inside of a <cfscript>

Posts: 547 · Posted: Sat Mar 10, 2007 1:27 am

Not sure it's worth doing.. I much rather prefer a simple <cfquery> But here you go. This should work.. I hardly ever use CFScript. It's been shown and proven (I think) to not be any faster than standard CFML in versions 6+.

Code:

<CFSCRIPT>
SQLString = "Select * From Products where ProductID = 52112";
DATASOURCE = "CompanyInfo";
checkUser=CFQUERY(SQLString: SQLString, DATASOURCE: DATASOURCE);

if (checkUser.recordCount neq 0) {
CFOUTPUT("query returned" & checkUser.recordcount);
} else {
CFOUTPUT("no results returned");
}
</CFSCRIPT>

Posts: 98 · Posted: Sat Mar 10, 2007 2:07 am

Thank you... well I never used <cfscript> for DB but I'm fixing some bug on someone else code and they did some of the code using <cfscript>