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/

Reply via email to