Well, paint me stupid.
Thanks,
Howie
----- Original Message -----
From: Greg Stewart
To: CF-Talk
Sent: Wednesday, August 18, 2004 10:53 AM
Subject: Re: Query from within a cfscript
True but you still need to cerate a function called cfquery, here is
the code from the article:
<cffunction name="CFQUERY" access="public" returntype="query">
<cfargument name="SQLString" type="string" required="yes">
<cfargument name="Datasource" type="string" required="yes">
<cfargument name="dbType" type="string" default="">
<cfquery name="RecordSet" datasource="#arguments.Datasource#"
dbtype="#arguments.dbType#">
#preserveSingleQuotes(arguments.SQLString)#
</cfquery>
<cfreturn RecordSet>
</cffunction>
You'll need to have that somewhere in your template or application.cfm
Cheers
G
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- Query from within a cfscript Howie Hamlin
- Re: Query from within a cfscript Greg Stewart
- Re: Query from within a cfscript Howie Hamlin
- RE: Query from within a cfscript Tangorre, Michael
- Re: Query from within a cfscript Howie Hamlin
- RE: Query from within a cfscript Adrian Lynch
- Re: Query from within a cfscript Howie Hamlin
- RE: Query from within a cfscript Adrian Lynch
- Re: Query from within a cfscri... Howie Hamlin
- Re: Query from within a cfscript Greg Stewart
- Howie Hamlin