what was it? -----Original Message----- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 16:19 To: CF-Talk Subject: RE: CF and mySQL
Got it. Thanks On Tue, 03 Dec 2002 11:07:55 -0500, FlashGuy wrote: > Correct. Thats the reason for the <cfqueryparam...> > > > On Tue, 3 Dec 2002 15:49:04 -0000, Robertson-Ravo, Neil (RX) wrote: > > > doesn't mySQL use \ for something internally? I had a problem with it ages > > back.... can't remember what it was though! > > > > -----Original Message----- > > From: FlashGuy [mailto:[EMAIL PROTECTED]] > > Sent: 03 December 2002 15:45 > > To: CF-Talk > > Subject: RE: CF and mySQL > > > > > > Yes, the "FORM.destination" but thats the reason for the "<cfqueryparam > > value="#FORM.destination#" cfsqltype="CF_SQL_LONGVARCHAR">" > > > > Yet the "?" are being inserted. > > > > On Tue, 3 Dec 2002 15:26:18 -0000, Robertson-Ravo, Neil (RX) wrote: > > > > > do any of the variables contain "\" > > > -----Original Message----- > > > From: FlashGuy [mailto:[EMAIL PROTECTED]] > > > Sent: 03 December 2002 15:17 > > > 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm