Hosted and maintained by Ben Forta. Designed by Trilemetry.

Language:			© 2002-2007 Ben Forta. All Rights Reserved


<Home> <FAQ> <Question>			<About>

Question

	When and why are quotes needed in <CFQUERY> SQL statements?
		All content in between <CFQUERY> and </CFQUERY> is sent to the database via the database driver as is. Unlike CFML, SQL is not typeless, and so SQL statements must be complete and valid as per SQL syntax specifications. All strings (or variables being used as string values) must be enclosed within singe quotes. Similarly, all numeric values must not be within quotes, and all dates and times must be formatted as valid date and time values.

Comments