Bah... (Monday morning)
#evaluate("qGetSomething." & application.dbsitePrefix & "ClientID")#
Or
#evaluate("qGetSomething.#application.dbsitePrefix#ClientID")#
-----Original Message-----
From: Adam Chapman
Sent: Monday, July 26, 2004 9:37 AM
To: CFAussie Mailing List
Subject: [cfaussie] RE: application and output
Hi Carl,
Gary made some good suggestions.. Just for your info, the Reason
clientID is undefined is because you are trying to Access a local
variable called "ClientID" rather than the
qGetSomething Query scoped field called "abcClientID"
You need to use the evaluate function.. Which should be Avoided..
#application.dbsitePrefix##ClientID#
Should be
#evaluate("qGetSomething." & application.dbsitePrefix & ClientID)#
Cheers,
Adam
-----Original Message-----
From: Carl [mailto:[EMAIL PROTECTED]
Sent: Friday, July 23, 2004 5:40 PM
To: CFAussie Mailing List
Subject: [cfaussie] application and output
Each site I have has siteVariables.cfm in it but the Some_Core_Page.cfm
page is one of the main components which is used across the sites but
keep on getting ClientID is undefined. Can anyone shed some light for me
please..
Thanks
(siteVariables.cfm)
<cfsetting enablecfoutputonly="Yes">
<cfscript>
application.dsn = "abc123";
application.dbsitePrefix = "abc";
</cfscript>
<cfsetting enablecfoutputonly="no">
(Some_Core_Page.cfm)
<cfquery name="qGetSomething" datasource="#application.dsn#">
SELECT
#application.dbsitePrefix#ClientID,
#application.dbsitePrefix#ClientBusinessName,
#application.dbsitePrefix#ClientNumber
FROM #application.dbsitePrefix#_Client
</cfquery>
*Here is where I have problems* saying ClientID is undefined, did I miss
something?
<cfoutput>
<cfloop query="qGetSomething"> #application.dbsitePrefix##ClientID# <br>
</cfloop> --->
</cfoutput>
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
