Hi
I am using the same procedure you mentioned, but somehow am
missing something.. can you pls.help me
here is my query
<cfloop list="#temp_country#" index="TAB_LIST"
delimiters="#chr(13)#">
<CFQUERY NAME="INSERT_DATA" datasource="#dsn#">
INSERT INTO ##ddtempC
(THEATER_CODE,
COUNTRY_CODE,
COUNTRY_NAME)
VALUES (
<CFSET a = 1>
<cfloop list="#TAB_LIST#" index="FIELD_VALUE"
delimiters="#chr(9)#" >
<cfqueryparam value="#FIELD_VALUE#"
cfsqltype="CF_SQL_VARCHAR" list="Yes" separator="#chr(9)#">
<cfif a LT 3>,</cfif>
<CFSET a = a + 1>
</cfloop>
)
</CFQUERY>
</cfloop>
error am getting is
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect
syntax near ')'.
The error occurred in
\\FILER01\nas\hosted\dev\webapps\vPortal4\portals\vsearch\core\www\data\userReports.cfm:
line 78
76 : <CFSET a = a + 1>
77 :
78 : </cfloop>
79 : )
80 : </CFQUERY>
SQL
INSERT INTO
#ddtempC (THEATER_CODE, COUNTRY_CODE, COUNTRY_NAME) VALUES ( (param
1) , )