I did and I still get "?" inserted in the database?
<cfquery name="update_alias" DATASOURCE="Alias">
UPDATE alias
SET
env_var = <cfqueryparam value="#FORM.env_var#" cfsqltype="CF_SQL_LONGVARCHAR">,
destination = <cfqueryparam value="#FORM.destination#" cfsqltype="CF_SQL_LONGVARCHAR">
WHERE alias_ID = #FORM.alias_ID#
</cfquery>
On Tue, 3 Dec 2002 09:42:22 -0600, Mark A. Kruger - CFG wrote:
> 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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
