CFQUERY Programming Web Development by sudheerkeshetty … help me i am using the [COLOR="Red"]cfquery[/COLOR] tag for executing a select query and getting the… Re: <cfquery> Undefined Programming Web Development 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 Programming Web Development 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 Programming Web Development 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 Programming Web Development 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 Programming Web Development by Cheesecake87 …; SELECT * FROM ResMenuItems ORDER BY "ItemOrder" ASC </cfquery> <p>Output</p> <cfoutput… CFQUERY Datatypes and Quotes Programming Web Development by goxmedia Hello, In CFQUERY operations, can someone advise as to the following: 1. What … Re: CFQUERY Programming Web Development 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 Programming Web Development by zoid777 Thanks cmhampton the Direct SQL version worked, I just modified the cfif at the buttom and it works. Re: <cfquery> Error Programming Web Development by mbogdanovich Hello Zoid, You might try single qoutes in around your variable. Hopefully that will do it. Matt Re: <cfquery> Error Programming Web Development 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 Programming Web Development 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 Programming Web Development by zoid777 I found the solution it was the dots behind my declaration.:) Re: <cfquery> Error Programming Web Development 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 Programming Web Development by zoid777 Nige thanks for your help, you where very helpful. Re: <CFQUERY> and INSERT problem Programming Web Development by freshfitz What error are you geting I think your insert should be [QUOTE]INSERT INTO Photos(Photo) [/QUOTE] Re: <CFQUERY> and INSERT problem Programming Web Development 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 Programming Web Development 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 Programming Web Development 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 Programming Web Development 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 Programming Web Development 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 Programming Web Development 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 Programming Web Development 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 Programming Web Development 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 Programming Web Development by krazykrisi …code: [code=coldfusion]<!--- Get ratings ---> <cfquery datasource="PFB" name="RatingsQ"> SELECT…Questions ORDER BY RatingID, QuestionID </cfquery> <!--- Get genders ---> <cfquery datasource="PFB" name="…gt; SELECT ID, Age FROM Age ORDER BY ID </cfquery> <html> <body> <… Re: survey code not working Programming Web Development by cmhampton … [code=ColdFusion] <!--- Get ratings ---> <cfquery datasource="PFB" name="RatingsQ"> SELECT… ORDER BY RatingID, QuestionID </cfquery> <!--- Get genders ---> <cfquery datasource="PFB" name="…; SELECT ID, Age FROM Age ORDER BY ID </cfquery> <html> <body> <… Data Update Fails Programming Web Development by SQL_n00b … = #FORM.field# WHERE ID = #URL.ID# </cfquery> <cfquery name="compareValues"> <!--- Compare Values 1… SET column3 = #FORM.field# WHERE ID = #URL.ID# </cfquery> </cfif> </cfoutput> [/code] ----------------------------------------------------------------------------- BTW,… Help with CF code Programming Web Development by leemyers …me! [code]<!--- GetLanguage ---> <cfquery name="qLanguage" datasource="#request.DSN…LanguageCode, LanguageName from Language </cfquery> <!--- GetVersion ---> <cfquery name="qVersion" datasource…gt; Select ClientTypeID, ClientType from ClientType </cfquery> <!--- This Script Checks that the… CF Invalid object name 'Language'. Programming Web Development by leemyers …datasource= [code]<!--- GetLanguage ---> <cfquery name="qLanguage" datasource="#request.DSN#"…, LanguageName from Language </cfquery> <!--- GetVersion ---> <cfquery name="qVersion" datasource…gt; Select ClientTypeID, ClientType from ClientType </cfquery> <!--- This Script Checks that … retreive and update from check boxes Programming Web Development 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">…