There is something wrong with my syntax. I just converted my Access database over to
mySQL. Whats wrong with the <cfqueryparam>?
I get "?" question marks inserted into the database when I execute the updated code.
Before:
---------
<cfquery name="update_alias" DATASOURCE="Alias">
Insert into alias
(env_var, destination)
VALUES
('#FORM.env_var#', '#FORM.destination#')
</cfquery>
After:
-------
<cfquery name="update_alias" DATASOURCE="Alias">
Insert into alias
(env_var, destination)
VALUES
('<cfqueryparam value="#FORM.env_var#" cfsqltype="CF_SQL_LONGVARCHAR">',
'<cfqueryparam value="#FORM.destination#" cfsqltype="CF_SQL_LONGVARCHAR">')
</cfquery>
---------------------------------------------------
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
