hehe..... Get rid of the single quotes around your <cfqueryparam> it should
NOT be:
('<cfqueryparam value="#FORM.env_var#" cfsqltype="CF_SQL_LONGVARCHAR">',
it SHOULD be
(<cfqueryparam value="#FORM.env_var#" cfsqltype="CF_SQL_LONGVARCHAR">,
You are inserting the placeholder.
-Mark
-----Original Message-----
From: FlashGuy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 9:17 AM
To: CF-Talk
Subject: CF and mySQL
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
