Hi,
I am getting an error when using ListAppend function.
Can anybody see whats wrong with this code?
I cannot figure out what the problem is.
<cfif cgi.http_referer CONTAINS "Corex1">
<cfparam name="mychanges" default="">
<cfif isDefined("Form.Programme_name") AND GetContent.Programme_name NEQ
"#Form.Programme_Name#">
<cfset mychanges = ListAppend(mychanges,'General Details - Programme
Name')>
</cfif>
The error that is occurring is as follows:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near ','.
The error occurred while processing an element with a general identifier
of (CFQUERY), occupying document position (20:1) to (20:70).
The error happens when I try to set the variable.
Any ideas?
Thanks for your help,
Regards,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
