I keep getting this error when ever I try to update or delete a record from my site. The error that I keep getting is "The string is not closed" I have use an example straight from the book so I don't know where to go. Here is my code

<cfsetting showdebugoutput="yes">
<!--check to see if we are deleting recrod-->
<cfif (IsDefined('form.delete') and Trim(form.delete) EQ "Delete")>
<!--query to delete record by ID-->
<cfquery name="DeleteBusRecord" datasource="Rumors_Forms">
				 DELETE FROM BusTable
				 WHERE ID = #ID#
</cfquery>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Rumors Bar & Grill | Review Entry</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="style.css" type="text/css">

<body>


	<div id="page">
	
    <div id="header"><img src="Images/top3.jpg"></div>
			    
        	
    <div id="nav" bordercolor="ffffff"> <cfinclude template="navigation.cfm"> </div>
			    	
    	   	
    <div id="content" valign="top"> 
    <br>
				<h1>The Record has been deleted!</h1>
    </div>
		    	    
    <div id="right" valign="top">and here is extra, maybe an ad or something</div>
		
		<!--<div id="footer">copyright and what not</div>-->
		
	</div>
</body>
</html>

<cfelse>
<!-- If bus is not booked insert into DB using the following query -->
<cfquery name="UpdateBus" datasource="Rumors_Forms">
				 UPDATE BusTable
				 SET 	Name='#form.Name#',
				 		 Req_Date='#form.Month#/#form.Day#/form.Year#',
						 Req_Time='#form.Req_Time#',
						 Address='#form.Address#',
						 Email='#form.Email#',
						 PhoneNumber='#form.PhoneNumber#',
						 Reason='#form.Reason#'
				WHERE ID =#form.ID#
</cfquery>


<!-- query to select updated record -->
<cfquery name="GetBusRecord" datasource="Rumors_Forms">
	SELECT ID, Name, Req_Date, Req_Time, Address, Email, PhoneNumber, Reason
	FROM BusTable
	WHERE ID =#form.ID#
</cfquery>
<!-- Mail resuts to myself and form.email -->
<cfmail query="GetBusRecord"
				from="donotreply@rumorssportsbar.com"
				to="#form.Email#"
				bcc="ericstauss@gmail.com"
				subject="Bus reservation update
				type="html">

				<table border="1" cellpadding="0">
				 <tr><h3>Here are the details...</h3></tr>
				 <tr>
				 		 <th>Confirmation Number</th>
						 <th>Name</th>
						 <th>Date</th>
						 <th>Time</th>
						 <th>Address</th>
						 <th>E-mail</th>
						 <th>Phone Number</th>
						 <th>Purpose of Rental</th>
				 </tr>
				 
				 <tr>
				 		 <td>#ID#</td>
						 <td>#Name#</td>
						 <td>#Req_Date#</td>
						 <td>#Req_Time#</td>
						 <td>#Address#</td>
						 <td>#Email#</td>
						 <td>#PhoneNumber#</td>
						 <td>#Reason#</td>
				 </tr>								
</cfmail>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Rumors Bar & Grill | Review Entry</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="style.css" type="text/css">

<body>


	<div id="page">
	
    <div id="header"><img src="Images/top3.jpg"></div>
			    
        	
    <div id="nav" bordercolor="ffffff"> <cfinclude template="navigation.cfm"> </div>
			    	
    	   	
    <div id="content" valign="top"> 
				 <br>
				 <table border="1" cellpadding="0">
				 <h3>Here are the details...</h3>
				 
				 <tr>
				 		 <th>Confirmation Number</th>
						 <th>Name</th>
						 <th>Date</th>
						 <th>Time</th>
						 <th>Address</th>
						 <th>E-mail</th>
						 <th>Phone Number</th>
						 <th>Purpose of Rental</th>
				 </tr>
				 <cfoutput query="GetBusRecord">
				 <tr>
				 		 <td>#ID#</td>
						 <td>#Name#</td>
						 <td>#Req_Date#</td>
						 <td>#Req_Time#</td>
						 <td>#Address#</td>
						 <td>#Email#</td>
						 <td>#PhoneNumber#</td>
						 <td>#Reason#</td>
				 </tr>
				 </cfoutput>	
				 </table>
    </div>
		    	    
    <div id="right" valign="top">and here is extra, maybe an ad or something</div>
		
		<!--<div id="footer">copyright and what not</div>-->
		
	</div>
</body>
</html>
</cfif>

It highlights this line "Reason='#form.Reason#'" from my update query as the problem. Any help would be great.

Thanks

I found the problem.
I was missing a #sign in
Req_Date='#form.Month#/#form.Day#/form.Year#'
simple little mistakes :D

This question has already been answered. Start a new discussion instead.