Menu
Menu
DaniWeb
Log In
Sign Up
Read
Contribute
Meet
Search
Search
About 638 results for
cfquery
- Page 1
CFQUERY
Programming
Web Development
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
Programming
Web Development
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
Programming
Web Development
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
Programming
Web Development
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
Programming
Web Development
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
Programming
Web Development
14 Years Ago
by Cheesecake87
…; SELECT * FROM ResMenuItems ORDER BY "ItemOrder" ASC </
cfquery
> <p>Output</p> <cfoutput…
CFQUERY Datatypes and Quotes
Programming
Web Development
13 Years Ago
by goxmedia
Hello, In
CFQUERY
operations, can someone advise as to the following: 1. What …
Re: CFQUERY
Programming
Web Development
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
Programming
Web Development
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
Programming
Web Development
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
Programming
Web Development
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
Programming
Web Development
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
Programming
Web Development
17 Years Ago
by zoid777
I found the solution it was the dots behind my declaration.:)
Re: <cfquery> Error
Programming
Web Development
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
Programming
Web Development
17 Years Ago
by zoid777
Nige thanks for your help, you where very helpful.
Re: <CFQUERY> and INSERT problem
Programming
Web Development
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
Programming
Web Development
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
Programming
Web Development
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
Programming
Web Development
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
Programming
Web Development
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
Programming
Web Development
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
Programming
Web Development
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
Programming
Web Development
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
Programming
Web Development
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
Programming
Web Development
17 Years Ago
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
17 Years Ago
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
15 Years Ago
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
14 Years Ago
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
14 Years Ago
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
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">…
1
2
3
11
Next
Last
Search
Search
Forums
Forum Index
Hardware/Software
Recommended Topics
Programming
Recommended Topics
Digital Media
Recommended Topics
Community Center
Recommended Topics
Latest Content
Newest Topics
Latest Topics
Latest Posts
Latest Comments
Top Tags
Topics Feed
Social
Top Members
Meet People
Community Functions
DaniWeb Premium
Newsletter Archive
Markdown Syntax
Community Rules
Developer APIs
Connect API
Forum API Docs
Tools
SEO Backlink Checker
Legal
Terms of Service
Privacy Policy
FAQ
About Us
Advertise
Contact Us
© 2025 DaniWeb® LLC