Shoot - well, I'm out of ideas <g>. -----Original Message----- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 10:07 AM To: CF-Talk Subject: RE: CF and mySQL
Yes I'm sure. I removed the "env_var = <cfqueryparam value="#FORM.env_var#" cfsqltype="CF_SQL_LONGVARCHAR">" and put it back the way I had it before to "env_var = '#FORM.env_var#'. Now this field gets inserted properly but the "destination = <cfqueryparam value="#FORM.destination#" cfsqltype="CF_SQL_LONGVARCHAR">" gets inserted as a "?" It has to be the syntax of the SQL statement? I'm using the <cfqueryparam on another database and it works great. On Tue, 3 Dec 2002 09:58:05 -0600, Mark A. Kruger - CFG wrote: > Hmmmm..... > > Are you sure. Delete them all manually and try again. > > -----Original Message----- > From: FlashGuy [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 03, 2002 9:47 AM > To: CF-Talk > Subject: RE: CF and mySQL > > > 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 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