Expression error when using ListAppend

[blues77]

Hello,

I'm using the ListAppend function and am encountering an expression error (shown below). I'm hopeing someone can point out where I've made my mistake. Any and all help is greatly appreciated.

<CFQUERY DATASOURCE="#Request.MMSDataSource#" NAME="ESNQuery">
								 SELECT s.SerialNumber from saleitems s
									where s.VinSaleNumber = '#report_query.vinSaleNumber#'
									and (s.SKUnumber = '#report_query.SKUnumber#')
									and (s.SerialNumber NOT IN ('#ListChangeDelims(previousSerialNumbers, "','")#'))
									LIMIT 1
							  </CFQUERY>

							  <CFIF ESNQuery.RecordCount GT 0>
							  <TD VALIGN="top">
								 <CFOUTPUT QUERY="ESNQuery">
									<CFSET previousSerialNumbers = ListAppend(previousSerialNumbers, "#ESNQuery.SerialNumber#">
									#ESNQuery.SerialNumber#
								 </CFOUTPUT>
							  </TD>
							  <CFELSE>
								 <TD></TD>
						      </CFIF>

Here is the error that I am getting.

Problem occurred while parsing, previousSerialNumbers = ListAppend(previousSerialNumbers, "#ESNQuery.SerialNumber#

 

[TruthInSatire]

you're missing your end pren

<CFSET previousSerialNumbers = ListAppend(previousSerialNumbers, "#ESNQuery.SerialNumber#")>


We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.