Hi All,
I am reviewing CF and working on a small site to get my skills back up to
par.
Here is what I have:
<CFSET theSQL = "SELECT queryName, title, content FROM content WHERE
queryName = '#URL.queryName#'" >
<cfquery name="getContent" datasource="indie">#theSQL#</cfquery>
<CFOUTPUT>#theSQL#</CFOUTPUT>
I am getting an error about SQL Statement being invalid:
<CFSET theSQL = "SELECT queryName, title, content FROM content WHERE
queryName = '#URL.queryName#'" >
11 :
12 : <cfquery name="getContent" datasource="indie">#theSQL#</cfquery>
13 :
14 : <CFOUTPUT>#theSQL#</CFOUTPUT>
SQLSTATE 42000
SQL SELECT queryName, title, content FROM content WHERE queryName =
''PrivacyPolicy''
VENDORERRORCODE 1064
DATASOURCE indie
Notice that PrivacyPolicy has ³² around it..I am not putting it there. If I
put this statement in a SQL editor and run it it is invalid and it I swithc
to like I think I am doing in the CFSET it works.
What am I doing wrong?
-Jason
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317683
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
