nohandlesleft254
IS-IT--Management
Im trying to use the code below and keep getting the error
' The start tag must have a matching end tag. An explicit end tag can be provided by adding </CFSCRIPT>.'
- But there is a </CFSCRIPT> closing tag...?
<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="FindLcornerDoors" datasource="#arguments.Datasource#" dbtype="#arguments.dbType#" maxrows="1">
#preserveSingleQuotes(arguments.SQLString)#
</cfquery>
<cfreturn RecordSet>
</cffunction>
<cfloop from="1" to="#FindSizeBigger.SizeBigger#" index="j">
<CFSCRIPT>
i = FindExtraPrice.Width;
do {
i = i + 1;
SQLString = "SELECT Code, Uprice1 FROM ITEMS WHERE Drang = '#GROUP1.DoorCode#' AND HEIGHT = '#FindExtraPrice.Height#' AND WIDTH = '#i#'";
DATASOURCE = "#Application.HansaData#";
FindLcornerDoors=CFQUERY(SQLString: SQLString,DATASOURCEATASOURCE);
while (FindLcornerDoors.RecordCount eq 0);
</CFSCRIPT>
</cfloop>
' The start tag must have a matching end tag. An explicit end tag can be provided by adding </CFSCRIPT>.'
- But there is a </CFSCRIPT> closing tag...?
<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="FindLcornerDoors" datasource="#arguments.Datasource#" dbtype="#arguments.dbType#" maxrows="1">
#preserveSingleQuotes(arguments.SQLString)#
</cfquery>
<cfreturn RecordSet>
</cffunction>
<cfloop from="1" to="#FindSizeBigger.SizeBigger#" index="j">
<CFSCRIPT>
i = FindExtraPrice.Width;
do {
i = i + 1;
SQLString = "SELECT Code, Uprice1 FROM ITEMS WHERE Drang = '#GROUP1.DoorCode#' AND HEIGHT = '#FindExtraPrice.Height#' AND WIDTH = '#i#'";
DATASOURCE = "#Application.HansaData#";
FindLcornerDoors=CFQUERY(SQLString: SQLString,DATASOURCEATASOURCE);
while (FindLcornerDoors.RecordCount eq 0);
</CFSCRIPT>
</cfloop>