What DBMS are you using? MSSQL, MYSQL, Access (bleeackk!), other?
MSSQL uses single quotes in the WHERE clause. However, if you use
cfqueryparam for all of your where clause pieces, single quotes in your
strings should pass through in the database request just fine.
What is the data type of t
FROM PlaysCalled
WHERE PlaysCalled.Formation =
AND PlaysCalled.Play =
AND PlaysCalled.BallCarrier =
From: "Jim Brundle"
Sent: Friday, June 10, 2011 9:15 AM
To: "cf-talk"
Subject: CFQuery Select and single quotes in st
I'm doing a look up like this:
SELECT Formation, Play, BallCarrier, YardsGained, Result
FROM PlaysCalled
WHERE (((PlaysCalled.Formation)="#Form.Formation#") AND
((PlaysCalled.Play)="#Form.Play#") AND
((PlaysCalled.BallCarrier)="#Form.BallCarrier#"));
In some cases, the Ball Carrier's
3 matches
Mail list logo
