Search DaniWeb - cfquery

CFQUERY 15 Years Ago by sudheerkeshetty … help me i am using the [COLOR="Red"]cfquery[/COLOR] tag for executing a select query and getting the… Re: <cfquery> Undefined 17 Years Ago by cmhampton … name, moon ) VALUES( '#Trim(Form.name)#', '#Trim(Form.moon)#' ) </cfquery> <cfelse> This Record Already Exists <cfinclude… SCOPE_IDENTITY() AS RecordID END ELSE SELECT NULL AS RecordID </cfquery> <cfif qryCool.RecordID EQ "">… <cfquery> Undefined 17 Years Ago by zoid777 I need some help with <cfquery>, I want to authenticate an add form … so I used recordcount like this [code=ColdFusion]<cfquery name="cool.recordcount" datasource="#Request.proto…quot;adduser.cfm"> </cfif> </cfquery>[/code] but it throws an error like [B]… name cool, it is already defined in the cfquery? <cfquery> Error 17 Years Ago by zoid777 … could anyone tell me what I did wrong!!!! [code]<cfquery name="update student" datasource="#Request.super#"… = #Trim(Form.oldstudent)#,(THIS IS WHERE THE ERROR IS) </cfquery> <cflocation url="Finished.cfm?msg=#URLEncodedFormat('#Form… <CFQUERY> and INSERT problem 16 Years Ago by OWL76 …(form,"fileUpload") and len(form.fileUpload)> <cfquery datasource="wpan7608"> INSERT INTO Photos('Photo') VALUES…('#Trim(FORM.Photo)#') </cfquery> </cfif> <!DOCTYPE html PUBLIC "-//W3C… cfquery not sorting MySQL output or loop 14 Years Ago by Cheesecake87 …; SELECT * FROM ResMenuItems ORDER BY "ItemOrder" ASC </cfquery> <p>Output</p> <cfoutput… CFQUERY Datatypes and Quotes 13 Years Ago by goxmedia Hello, In CFQUERY operations, can someone advise as to the following: 1. What … Re: CFQUERY 15 Years Ago by buddylee17 So you want to add a static row after the query output? Post some code to give an idea of what you are trying to accomplish. Re: <cfquery> Undefined 17 Years Ago by zoid777 Thanks cmhampton the Direct SQL version worked, I just modified the cfif at the buttom and it works. Re: <cfquery> Error 17 Years Ago by mbogdanovich Hello Zoid, You might try single qoutes in around your variable. Hopefully that will do it. Matt Re: <cfquery> Error 17 Years Ago by zoid777 [QUOTE=mbogdanovich;527397]Hello Zoid, You might try single qoutes in around your variable. Hopefully that will do it. Matt[/QUOTE] Hi Matt, thanks for the post. I tried single quotes but it still gave the same error Re: <cfquery> Error 17 Years Ago by zoid777 Still need help!!!! I am using a single table with Mysql 5.0.45 and it says check syntax error. is this a bug or I am using the wrong syntax. Re: <cfquery> Error 17 Years Ago by zoid777 I found the solution it was the dots behind my declaration.:) Re: <cfquery> Error 17 Years Ago by Nige Ridd Erm can I make a suggestion that you look at using cfqueryparam as well, if anyone ever put a ' in any of the fields on the screen they can then do some nasty SQL injection into your code. Nige ( See many references on the web about SQL Injection inculding [url]http://msdn.microsoft.com/msdnmag/issues/04/09/SQLInjection/[/url] ) Re: <cfquery> Error 17 Years Ago by zoid777 Nige thanks for your help, you where very helpful. Re: <CFQUERY> and INSERT problem 16 Years Ago by freshfitz What error are you geting I think your insert should be [QUOTE]INSERT INTO Photos(Photo) [/QUOTE] Re: <CFQUERY> and INSERT problem 16 Years Ago by danarashad Move your insert statement below the file upload section. Then insert file.ServerFile as the name. Re: cfquery not sorting MySQL output or loop 14 Years Ago by arrgh [quote]ORDER BY "ItemOrder" ASC[/quote] Don't use quotes. If you do, your db will treat ItemOrder as a string, not a [I]column name[/I]. It's like saying [code]ORDER BY "IHaveNoIdeaWhyThisIsntWorkingThisIsNotARealColumn";[/code] It may execute ... but it won't sort anything. ;-) Re: cfquery not sorting MySQL output or loop 14 Years Ago by Cheesecake87 [QUOTE=arrgh;1392222]Don't use quotes. If you do, your db will treat ItemOrder as a string, not a [I]column name[/I]. It's like saying [code]ORDER BY "IHaveNoIdeaWhyThisIsntWorkingThisIsNotARealColumn";[/code] It may execute ... but it won't sort anything. ;-)[/QUOTE] HAHA, thanks man Re: CFQUERY Datatypes and Quotes 13 Years Ago by cfwebdeveloper It is best to always use cfqueryparam because it not only for a performance boost but to protect the database from SQL injections always. Usually when using the cfqueryparam you do not need to worry about when to use single or double quotes. If you have data that has single of double quotes then you can use the perservesinglequotes() function. [url… Re: CFQUERY Datatypes and Quotes 13 Years Ago by arrgh Huh? In one breadth you preach protection against sql injection, and in the next you recommend a function that encourages sql injection ;-) - [I]DO[/I] use cfqueryparam for sql injection protection - [B]DO NOT[/B] use perservesinglequotes, it risks sql injection [quote]If you have data that has single of double quotes then you can use the … Re: CFQUERY Datatypes and Quotes 13 Years Ago by cfwebdeveloper lol thanks Arrrgh, very true. Wasn't thinking straight when I wrote that post. Thanks for the backup. zZzZz :) Re: Simple Query to Variable Array 13 Years Ago by cfwebdeveloper cfquery returns information as a structure so if you want to … is returning by doing cfdump(#at#). Line 6 errors because cfquery does not return a list, it is a structure. If… HELP! need help adding text to slideshow 18 Years Ago by shaggysc96 …subcategory where catid = '#catid#' </CFQUERY> <CFQUERY DATASOURCE="#DSN#" NAME="showitems&…catproducts1 where category = '#category#' </CFQUERY> <CFQUERY DATASOURCE="#DSN#" NAME="descrip&…where category = '#url.category#' </CFQUERY> <CFQUERY DATASOURCE="#DSN#" NAME="descrip&… survey code not working 17 Years Ago by krazykrisi …code: [code=coldfusion] <cfquery datasource="PFB" name="RatingsQ"> SELECT…Questions ORDER BY RatingID, QuestionID </cfquery>  <cfquery datasource="PFB" name="…gt; SELECT ID, Age FROM Age ORDER BY ID </cfquery> <html> <body> <… Re: survey code not working 17 Years Ago by cmhampton … [code=ColdFusion]  <cfquery datasource="PFB" name="RatingsQ"> SELECT… ORDER BY RatingID, QuestionID </cfquery>  <cfquery datasource="PFB" name="…; SELECT ID, Age FROM Age ORDER BY ID </cfquery> <html> <body> <… Data Update Fails 16 Years Ago by SQL_n00b … = #FORM.field# WHERE ID = #URL.ID# </cfquery> <cfquery name="compareValues">  <cfquery name="qLanguage" datasource="#request.DSN…LanguageCode, LanguageName from Language </cfquery>  <cfquery name="qVersion" datasource…gt; Select ClientTypeID, ClientType from ClientType </cfquery>  <cfquery name="qLanguage" datasource="#request.DSN#"…, LanguageName from Language </cfquery>  <cfquery name="qVersion" datasource…gt; Select ClientTypeID, ClientType from ClientType </cfquery> <!--- This Script Checks that … retreive and update from check boxes 18 Years Ago by pmayadun …="studyabroad"> SELECT * FROM AreaOfStudy </cfquery> <cfquery name="gradID" datasource="studyabroad">…SELECT * FROM gradschoolsabroad WHERE GradschoolsAbroadProgramID = #SESSION.Auth.GradschoolsAbroadProgramID# </cfquery> <cfquery name="gradarea" datasource="studyabroad">…