cfquery from a cfquery
hi.. i try to search for this from archives but unsuccessful so any can teach me how can i do it..?? eg. Select intCustomerID from tblCustomer Where UPPER(strCustomerName) Like '%#CustomerName#%' order by intCustomerID . SELECT intCustomerID from tblprospectdetails where intCustomerID = '#CustomerExist.intCustomerID#' and is it this way..?? cheers han __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfquery from a cfquery
Han, To do a query from a query, you'd do something like this: SELECT Something FROM SomeTable THEN SELECT Something FROM Query (The first query name goes here) Does this help? J. -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 9:56 PM To: CF-Talk Subject: cfquery from a cfquery hi.. i try to search for this from archives but unsuccessful so any can teach me how can i do it..?? eg. Select intCustomerID from tblCustomer Where UPPER(strCustomerName) Like '%#CustomerName#%' order by intCustomerID SELECT intCustomerID from tblprospectdetails where intCustomerID = '#CustomerExist.intCustomerID#' and is it this way..?? cheers han __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfquery from a cfquery
This is not a query of queries. Change the 2nd CFQUERY to SELECT intCustomerID from tblprospectdetails where intCustomerID IN #QuotedValueList(CustomerExist.intCustomerID)# and Depending on what you want to do, you can probably do One query using a join or a subquery. PS I see you are using application.DSN, so dont forget to put a around all your queries. This is a hughe performance loss, so I would suggest switching to request.DSN. Pascal -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: woensdag 30 januari 2002 3:56 To: CF-Talk Subject: cfquery from a cfquery hi.. i try to search for this from archives but unsuccessful so any can teach me how can i do it..?? eg. Select intCustomerID from tblCustomer Where UPPER(strCustomerName) Like '%#CustomerName#%' order by intCustomerID SELECT intCustomerID from tblprospectdetails where intCustomerID = '#CustomerExist.intCustomerID#' and is it this way..?? cheers han __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfquery from a cfquery
hihi.. thanks for yr reply. sorry.. i dont know how to use request.DSN.. so how do i declare it..? and.. if i use request.DSN... does it mean i dont need to use CFLOCK..? cheers han - Original Message - From: "Pascal Peters" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 30, 2002 4:57 PM Subject: RE: cfquery from a cfquery > This is not a query of queries. Change the 2nd CFQUERY to > > SELECT intCustomerID from tblprospectdetails > where intCustomerID IN #QuotedValueList(CustomerExist.intCustomerID)# > and > > Depending on what you want to do, you can probably do One query using a > join or a subquery. > > PS I see you are using application.DSN, so dont forget to put a > around all your queries. This is a hughe performance loss, so I would > suggest switching to request.DSN. > > Pascal > > -Original Message- > From: han peng [mailto:[EMAIL PROTECTED]] > Sent: woensdag 30 januari 2002 3:56 > To: CF-Talk > Subject: cfquery from a cfquery > > > hi.. i try to search for this from archives but unsuccessful > > so any can teach me how can i do it..?? > > eg. > > > Select intCustomerID from tblCustomer > Where UPPER(strCustomerName) Like '%#CustomerName#%' > order by intCustomerID > > > > > > SELECT intCustomerID from tblprospectdetails > where intCustomerID = '#CustomerExist.intCustomerID#' > and > > > > is it this way..?? > > > cheers > han > > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfquery from a cfquery
No need to lock request scope, only SESSION, APPLICATION & SERVER. Info about locking: http://www.macromedia.com/v1/handlers/index.cfm?ID=20370&Method=Full -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: woensdag 30 januari 2002 10:45 To: CF-Talk Subject: Re: cfquery from a cfquery hihi.. thanks for yr reply. sorry.. i dont know how to use request.DSN.. so how do i declare it..? and.. if i use request.DSN... does it mean i dont need to use CFLOCK..? cheers han - Original Message - From: "Pascal Peters" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 30, 2002 4:57 PM Subject: RE: cfquery from a cfquery > This is not a query of queries. Change the 2nd CFQUERY to > > SELECT intCustomerID from tblprospectdetails > where intCustomerID IN #QuotedValueList(CustomerExist.intCustomerID)# > and > > Depending on what you want to do, you can probably do One query using a > join or a subquery. > > PS I see you are using application.DSN, so dont forget to put a > around all your queries. This is a hughe performance loss, so I would > suggest switching to request.DSN. > > Pascal > > -Original Message- > From: han peng [mailto:[EMAIL PROTECTED]] > Sent: woensdag 30 januari 2002 3:56 > To: CF-Talk > Subject: cfquery from a cfquery > > > hi.. i try to search for this from archives but unsuccessful > > so any can teach me how can i do it..?? > > eg. > > > Select intCustomerID from tblCustomer > Where UPPER(strCustomerName) Like '%#CustomerName#%' > order by intCustomerID > > > > > > SELECT intCustomerID from tblprospectdetails > where intCustomerID = '#CustomerExist.intCustomerID#' > and > > > > is it this way..?? > > > cheers > han > > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFQUERY
Hello All, This might be a stupid question, but I can not figure it out. The following code SELECT User_Name FROM TableName WHERE (#Time_Start# - User_Data) LT #Active# The problem I am getting is the point of WHERE (#Time_Start# - User_Data) LT #Active# It is telling me that User_Data (which is a column in my access DB) is not found. How would I make this work??? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFQUERY
Is there a way to do multiple delete queries in one cfquey tag. and I need to surround it in a transaction. How can I do this? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfquery??
>http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm What the table on that page says about cfquery is not that the tag itself as a whole is deprecated, but that some of its attributes are deprecated. The venerable cfquery is alive and well ;-) Mike Mertsock Alfred University Web Team >So, if cfquery is a deprecated tag, what should we be using in its >place?? > >Anyone heard anything about this? > > >http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm > >Candace K. Cottrell, Web Developer >The Children's Medical Center >One Children's Plaza >Dayton, OH 45404 >937-641-4293 >http://www.childrensdayton.org > > >[EMAIL PROTECTED] > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
cfquery??
So, if cfquery is a deprecated tag, what should we be using in its place?? Anyone heard anything about this? http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
cfquery??
I had heard this from one of my cfug members who said she saw it in the document that cfquery was deprecated. Ok, thanks for clearing that up however, I find this to be a little misleading and can definitely see where it got twisted. Deprecated tags, attributes, and values The following tags, attributes, and attribute values are deprecated. Do not use them in ColdFusion applications. They might not work, and might cause an error, in releases later than ColdFusion MX. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
cfquery
Hi guys, I have this query: SELECT PropertyDataID, PropertyAgentID, PropertyDataAgentReference, PropertyDataFlatNumberHouseName, PropertyDataStreetNumber, PropertyDataStreetName, PropertyDataVillageTown, PropertyDataCountyState, PropertyDataPostcodeZip, PropertyDataCountry, PropertyDataNumberofBedrooms, PropertyDataNumberofBathrooms, PropertyDataHouseType, PropertyDataPrice, PropertyDataDurationType, PropertyDataDescription, PropertyDataDateAdded FROM PropertyData WHERE PropertyDataID = #URL.PropertyDataID# AND PropertyAgentID = Say if a user got to this page with a URL.PropertyID which equaled something in the database I thought that it wouldn't matter because of the rest of the WHERE clause stating that PropertyAgentID = Client.PropertyAgentID. When i try and access the page being a different client.PropertyAgentID, the page still displays but without the fields filled in, so i guess it works but wouldn't it be better if an error appeared. I thought that because the WHERE clause is false an error would occur but it doesn't. Anyone know a simple way to make an error occur when a user somehow gets to run this query not being the correct client for that propertydataid (via a url)? Cheers, Stuart [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFQuery
I know you can return the execution time of a query, but how do you return what the query ran is? Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFQUERY
This is a multi-part message in MIME format. --=_NextPart_000_0010_01C046BB.86149B60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi If I have a form and post a value - say to a receiving page = with a query as: select handle, domain, tld from domains WHERE domain=3D'#form.domain#' This works however the domain in the form is actually both the value in = the databae "domain" and "tld" so if I was to search hotchilli that would be fine - but I post the FQDN = so "hotchilli.com" so I would need something like this: select handle, domain, tld from domains WHERE domain AND tld=3D'#form.domain#' WHERE domain AND tld=3D'#form.domain#' Anyone have a solution to the above clause. Any ideas Thanks Tony Hotchilli Internet Solutons --=_NextPart_000_0010_01C046BB.86149B60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi If I have a form and post a value - = say=20 <cfinput name=3D"domain" required=3D"yes" = message=3D"=20 Please enter FQDN"> to a receiving page with a query = as: <cfquery = name=3D"get_handle"=20 datasource=3D"testds">select handle, domain, = tldfrom=20 domainsWHERE = domain=3D'#form.domain#'</cfquery> This works however the domain in the = form is=20 actually both the value in the databae "domain" and=20 "tld" so if I was to search hotchilli that = would be=20 fine - but I post the FQDN so "hotchilli.com" so I would need=20 something like this: <cfquery = name=3D"get_handle"=20 datasource=3D"testds">select handle, domain, = tldfrom=20 domainsWHERE domain AND=20 tld=3D'#form.domain#'</cfquery> WHERE domain AND tld=3D'#form.domain#' Anyone have a solution to the above=20 clause. Any ideas Thanks Tony Hotchilli Internet=20 Solutons --=_NextPart_000_0010_01C046BB.86149B60-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
cfquery
select address + ' ' + address2 + ' ' + address3 + ',' + city + ',' + state + ',' + city as office_address, (select first + ' ' + last as full from user_info where user_id =lead_mgr ) as leadmgr, (here if user_id neq lead_mgr i have to return lead_note column) how to do this...please help me (select first + ' ' + last as full from user_info where user_id = AREA_MGR_RDO ) as director, (select first + ' ' + last as full from user_info where user_id = SDIR_NDIR) as SDIRNDIR, (select first + ' ' + last as full from user_info where user_id = VICE_PRE ) as VICEPRE, (select first + ' ' + last as full from user_info where user_id = FAST_MGR ) as FASTMGR from sourcebook_1 where active = 1 and office_id not in(36,37,38,73) order by office_number ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324789 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFQuery
Hi All, I am reviewing CF and working on a small site to get my skills back up to par. Here is what I have: #theSQL# #theSQL# I am getting an error about SQL Statement being invalid: 11 : 12 : #theSQL# 13 : 14 : #theSQL# SQLSTATE 42000 SQL SELECT queryName, title, content FROM content WHERE queryName = ''PrivacyPolicy'' VENDORERRORCODE 1064 DATASOURCE indie Notice that PrivacyPolicy has ³² around it..I am not putting it there. If I put this statement in a SQL editor and run it it is invalid and it I swithc to like I think I am doing in the CFSET it works. What am I doing wrong? -Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317683 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Faster - cfquery cache or cfquery->application scope?
Which would be faster: - Using cfquery to cache data for e.g. a day. - Using cfquery to load data to the application scope, only reloading after a set period of time (). -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 "Nothing endures but change." - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Javascript Cfquery
Hi All - I am trying to do the following: function abc(arg1, arg2) { <cfquery name="q" datasource=".."> select * from table1 where col1 = arg1 </cfquery> .. } Is it possible to pass javascript arguments to a coldfusion query which is in turn present in the javascript block? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfquery - subquerie>
How would I go about combining these 2 queries into a single query? Or would it be best to leave it seperated into 2. Thx, Dave SELECT employee_number,emp_last_name, emp_preferred_name, sup_short_name, email_id FROM tbl_Employee WHERE employee_number = #FORM.EmployeeName# SELECT email_id FROM tbl_Employee WHERE emp_short_name = '#Trim(qEmployeeList.sup_short_name)#' HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| 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
Using CfQuery
I am trying to do a cfquery without setting up a DSN on the CF Admin. I am using CF 5. I pasted the code that I am using below. It works fine in most instances however, when using a query that uses the CreateODBCDateTime I get an error: Malformed GUID. in query expression. I am using Access 97 and 2000. This query works fine when I set up the DSN in the Admin. This is my code: ~| 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 Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFQUERY
Replace LT with "<". (LT is a CF operator, not a SQL operator) SELECT User_Name FROM TableName WHERE (#Time_Start# - User_Data) < #Active# -Matt > -Original Message- > From: Joel Blanchette [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 6:17 PM > To: CF-Talk > Subject: CFQUERY > > > Hello All, > This might be a stupid question, but I can not figure it out. > > The following code > > > > > SELECT User_Name FROM TableName > WHERE (#Time_Start# - User_Data) LT #Active# > > > The problem I am getting is the point of > > WHERE (#Time_Start# - User_Data) LT #Active# > > It is telling me that User_Data (which is a column in my access DB) is > not found. How would I make this work??? > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFQUERY
you must set the user_data as somethign first in the query. like this... SELECT User_Name, User_Data as thisUserData FROM TableName WHERE (#Time_Start# - thisUserData) LT #Active# im pretty sure this will work! if not, then heck, even im stumped. tw -Original Message- From: Joel Blanchette [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 6:17 PM To: CF-Talk Subject: CFQUERY Hello All, This might be a stupid question, but I can not figure it out. The following code SELECT User_Name FROM TableName WHERE (#Time_Start# - User_Data) LT #Active# The problem I am getting is the point of WHERE (#Time_Start# - User_Data) LT #Active# It is telling me that User_Data (which is a column in my access DB) is not found. How would I make this work??? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFQUERY
you must also change the LT to < since like someone else has replied LT is a cf thingie :) tw -Original Message- From: Joel Blanchette [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 6:17 PM To: CF-Talk Subject: CFQUERY Hello All, This might be a stupid question, but I can not figure it out. The following code SELECT User_Name FROM TableName WHERE (#Time_Start# - User_Data) LT #Active# The problem I am getting is the point of WHERE (#Time_Start# - User_Data) LT #Active# It is telling me that User_Data (which is a column in my access DB) is not found. How would I make this work??? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFQUERY BLOCKFACTOR
CF Docs on the Subject are as follows: "Optional. Specifies the maximum number of rows to fetch at a time from the server. The range is 1 (default) to 100. This parameter applies to ORACLE native database drivers and to ODBC drivers. Certain ODBC drivers may dynamically reduce the block factor at runtime." A recent article in SQL Server Magazine (October 2000, p 75) discusses "BLOCKING FACTOR" "BLOCKING FACTOR" bears some resemblance to "BLOCKFACTOR," but I'm not sure how close it is. BLOCKING FACTOR appears to be determined by the width of a RECORD, as it exists in the DB (that is, it includes all columns). I've assumed BLOCKFACTOR to be determined by the width of the RETURNED DATA in each record, which does not have to include all columns. I further assumed a CFQUERY that returned a single column of integers could have BLOCKFACTOR set at the maximum of 100, without fear of loss of efficiency as in those cases where 100 happened to be too large and CF would then have to try 99, then 98, etc. So the question is: Is 100 ALWAYS OK when CFQUERY returns a single column of integers? best, paul PS> Keeping in mind that CF4.01 Administrator (but not 4.51 Administrator) is now known to have incorrectly stated there to be limit of 100 cached queries, whereas there really is no fixed limit, is BLOCKFACTOR _really_ limited to 100? == Paul Smith, Web/Database Droid A: SupportNet, Inc, 3871 Piedmont Ave, Oakland, CA 94611 (There, there, there; there's, there, there) P: (510) 763-2358 C: (510) 205-6755 F: (510) 763-2370 E: [EMAIL PROTECTED] W: http://www.support.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFQUERY
> Is there a way to do multiple delete queries in one cfquey tag. and I > need to surround it in a transaction. How can I do this? No, but if you supply a where clause, you can delete everything from one table in one go (and if you have cascading deletes, just go for the parent-most records). DELETE FROM x WHERE ... DELETE FROM y WHERE ... -- Aidan Whitehall <[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 _ This message has been checked for all known viruses by Star Internet delivered through the MessageLabs Virus Scanning Service. For further information visit http://www.star.net.uk/stats.asp or alternatively call ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFQUERY
what is a cascading delete? - Original Message - From: "Aidan Whitehall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 17, 2001 12:45 PM Subject: RE: CFQUERY > > Is there a way to do multiple delete queries in one cfquey tag. and I > > need to surround it in a transaction. How can I do this? > > No, but if you supply a where clause, you can delete everything from one > table in one go (and if you have cascading deletes, just go for the > parent-most records). > > > > > DELETE > FROM x > WHERE ... > > > > DELETE > FROM y > WHERE ... > > > > -- > Aidan Whitehall <[EMAIL PROTECTED]> > Macromedia ColdFusion Developer > Fairbanks Environmental +44 (0)1695 51775 > > _ > This message has been checked for all known viruses by Star Internet > delivered through the MessageLabs Virus Scanning Service. For further > information visit http://www.star.net.uk/stats.asp or alternatively call > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFQUERY
>> Is there a way to do multiple delete queries in one cfquey tag. > No Actually, multiple deletes/inserts/updates within one query tag do work whether it's intended to or not. Just stick the seperate SQL statements right in there and go for it. Now, anybody know if this is intended or just an unreliable mistake that works? Ken ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFQUERY
It's intended, kind of. does not really care what the statement is (or if it is even legal). It just passes it to ODBC (or whatever data source is being used) for processing. So, if the drivers and databases support it then you can do it, and if not then not. --- Ben -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, December 17, 2001 2:39 PM To: CF-Talk Subject: RE: CFQUERY >> Is there a way to do multiple delete queries in one cfquey tag. > No Actually, multiple deletes/inserts/updates within one query tag do work whether it's intended to or not. Just stick the seperate SQL statements right in there and go for it. Now, anybody know if this is intended or just an unreliable mistake that works? Ken ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFQUERY
> what is a cascading delete? In a "parent-child" data relationship, you can specify that deleting a "parent" record deletes all of it's associated "child" records. It makes sure your database maintains its "referential integrity". It also makes deleting records from multiple tables a doddle, as you just delete the parent-most record and the DBMS ripples the deletes through its children. -- Aidan Whitehall <[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 _ This message has been checked for all known viruses by Star Internet delivered through the MessageLabs Virus Scanning Service. For further information visit http://www.star.net.uk/stats.asp or alternatively call Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFQUERY Update......
Hi all, I am trying to update a table using CFQUERY. I do not see any error when the query is excuted in CF and I can see the query is correct in the debug mode. But somehow the data is not updated. When I run the same query in SQL Server, the data is updated. Does anybody know why? I am using CF 4.5 and SQL Server 7.0 The query is like this.. UPDATE User SET newpassword = 'arenofun' WHERE ID = 1614 Thanks in advance J ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
sorting CFQUERY
I'm keeping track of e-mail and phone directories for 3 different offices in a SQL 2k database. I have my SQL queries setup to display the data but each office has it's own e-mail and phone directory. How do I adjust this query to display only a certain office's personnel? Here are my queries. The below Query and Output are for the DIT office phone directory. The other offices are OCTO, ETS and EIS. Phone Query SELECT office, first_name, last_name, title, phone FROM dbo.octo_emp Phone Output #qDITPhone.title# #qDITPhone.first_name# #qDITPhone.last_name# #qDITPhone.phone# How do I tell the queries to only find rows that contain a certain offices value? thanks, Iain Iain Burns Web Development (CTO) D.C. Public Schools [EMAIL PROTECTED] Tel (202)442-5664 (direct line) -Original Message- From: Novak Banda [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 11:25 AM To: CFDJList Subject: [cfdjlist] RE: 128 bit encryption 1024 bit encryption doesn't mean much anymore... didn't you see "Swordfish"? ;-) -N - Original Message - From: "A. Carcieri" <[EMAIL PROTECTED]> To: "CFDJList" <[EMAIL PROTECTED]> Sent: Thursday, June 14, 2001 5:24 AM Subject: [cfdjlist] RE: 128 bit encryption > Nathan, > > If I remember correctly, banks and the military actually use 1024 bit > encryption. That sort of encryption is only available to those institutions > and I believe it was developed as a joint venture by the NSA, DOD, and the > mapping agency that think they found the Mars Polar Lander. > > -Original Message- > From: Nathan Jones [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, June 14, 2001 8:28 AM > To: CFDJList > Subject: [cfdjlist] 128 bit encryption > > > Morning, Gang, > > All this talk of security made me wonder ... I know of 128-bit encryption > protection for our sites (primarily banks), but is there something greater > than that? > > I heard a reference to 156 or 164, but in research can't find any > literature > on it. > > Thanks! > > Nathan > > > CFDJList brought to you by http://www.sys-con.com/coldfusionedge/ > To change your membership options, refer to: > http://www.sys-con.com/coldfusion/list.cfm > http://www.sys-con.com/coldfusion/ > > > CFDJList brought to you by http://www.sys-con.com/coldfusionedge/ > To change your membership options, refer to: > http://www.sys-con.com/coldfusion/list.cfm > http://www.sys-con.com/coldfusion/ CFDJList brought to you by http://www.sys-con.com/coldfusionedge/ To change your membership options, refer to: http://www.sys-con.com/coldfusion/list.cfm http://www.sys-con.com/coldfusion/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFQuery Error
Any idea what this error means? CFQuery Retrieval of cached query failed ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFQUERY question
hey can i do Full SQL programming inside cfquery tags? or is it limited to inserts updates, and such? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Encrypting cfquery
I am looking into encrypting the data that goes from the application server to the db server. Does anyone have any experience in doing something like this. I am searching around the net to see whats out there, so anything else I could get here would be greatly appreciated. Thanks Mike __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFQUERY - cachedwithin
When you have used cachedwithin in CFQUERY, is it possible to override that before the cachedtime is up? For example, ...BLAH... ...BLAH... Here, it'd be great if I could 'reset' the query so that if I've defined somewhere else on the site that the query has changed using the application variable, I can get it to use the new query results and cache that for next time, instead. Thanks! - Yahoo! Plus - For a better Internet experience ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
using cfquery
Sorry for what is probably the easiest question for you folks but hey I'm new to this. Short and sweet. Do I have to create the query in the database itself and then use the name in the or does CF just tell the DB what the query is in its own language? - Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! ~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfquery question???
SELECT title,template,layout,meta_description,short_description,keywords,conten t,image_a,image_b,image_c, build_date,state FROM #request.departmentTable# WHERE id = #url.id# how could this query above possibly bomb when in cfquery tag, yet not in query analyzer when i know that url.id = 175 and that the column type is int? thanks tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFQuery Param ?
Suffice it to say, best practive would be to utilize this not only on selects, but inserts and updates as well, correct? Thanks! Regards, Eric J. Hoffman DataStream Connexion www.datastreamconnexion.com ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfquery??
I don't think that page says the TAG is deprecated. Only the ATTRIBUTES connectString, dbName, dbServer, provider, providerDSN, sql, and some of the dbType attributes. -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:17 AM To: CF-Talk Subject: cfquery?? So, if cfquery is a deprecated tag, what should we be using in its place?? Anyone heard anything about this? http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: cfquery??
Candace, CFQUERY is certainly NOT deprecated. The ability to use the "connectstring" and associated attributes to make a dbtype="dynamic" connection (a la asp) has been deprecated since the original "MX" release of cf. -Mark -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 1:17 PM To: CF-Talk Subject: cfquery?? So, if cfquery is a deprecated tag, what should we be using in its place?? Anyone heard anything about this? http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: cfquery??
The tag isnt depreciated... Just the attributes listed (such as connectstring) HTH Mikey -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Thursday, September 4, 2003 19:17 To: CF-Talk Subject: cfquery?? So, if cfquery is a deprecated tag, what should we be using in its place?? Anyone heard anything about this? http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: cfquery??
Tried to post via the web interface, but no luck... Anyway, I said thanks for clearing that up. A lady in my cfug asked me about it because she said she heard from a very respected CF guru to go out and look at the depracated tags and that she found cfquery on the list. So, I decided to go out there and check it out, but read the top of the page: Deprecated tags, attributes, and values The following tags, attributes, and attribute values are deprecated. Do not use them in ColdFusion applications. They might not work, and might cause an error, in releases later than ColdFusion MX. and saw cfquery on the list it kinda freaked me out. Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
re: cfquery??
Original Message: > From: "Candace Cottrell" <[EMAIL PROTECTED]> > So, if cfquery is a deprecated tag, what should we be using in its > place?? > > Anyone heard anything about this? > > > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm It's not cfquery that's deprecated. It's the specified attributes within cfquery that are deprecated. Deprecated tags would say something like "All Values" under attributes. (see as an example). Scott --- Scott Brady http://www.scottbrady.net/ ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: cfquery??
cfquery isn't deprecated - the connectstring attribute of cfquery is. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Candace Cottrell [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 04, 2003 12:17 PM > To: CF-Talk > Subject: cfquery?? > > > So, if cfquery is a deprecated tag, what should we be using > in its place?? > > Anyone heard anything about this? > > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: cfquery??
Hehe...just the attributes that are listed are deprecated, not the whole tag...that was good for a chuckle-> Tyler -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 2:17 PM To: CF-Talk Subject: cfquery?? So, if cfquery is a deprecated tag, what should we be using in its place?? Anyone heard anything about this? http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: cfquery??
Candace, it's the "connectString" attribute that is deprecated. -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 2:17 PM To: CF-Talk Subject: cfquery?? So, if cfquery is a deprecated tag, what should we be using in its place?? Anyone heard anything about this? http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: cfquery??
So when i am coding what should I use? Or is it going to be that all you need to do is name and datasource? Dave Watts wrote: >>So, if cfquery is a deprecated tag, what should we be using >>in its place?? >> >>Anyone heard anything about this? >> >>http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm >> >> > >I think you're misreading that. To me, it looks like they're saying that the >CONNECTSTRING, DBNAME, DBSERVER, PROVIDER, PROVIDERDSN, and SQL attributes >are deprecated, along with most values for DBTYPE. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: cfquery??
ah... just re-read. cfquery isn't deprecated...just specific attributes thereof :) charlie - Original Message - From: "Candace Cottrell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 04, 2003 11:16 AM Subject: cfquery?? > So, if cfquery is a deprecated tag, what should we be using in its > place?? > > Anyone heard anything about this? > > > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm > > Candace K. Cottrell, Web Developer > The Children's Medical Center > One Children's Plaza > Dayton, OH 45404 > 937-641-4293 > http://www.childrensdayton.org > > > [EMAIL PROTECTED] > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: cfquery??
wow... glad to see cfinsert and cfupdate on the list... but cffile and cfquery? i've not heard anything either, but am pretty curious now :) charlie - Original Message - From: "Candace Cottrell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 04, 2003 11:16 AM Subject: cfquery?? > So, if cfquery is a deprecated tag, what should we be using in its > place?? > > Anyone heard anything about this? > > > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm > > Candace K. Cottrell, Web Developer > The Children's Medical Center > One Children's Plaza > Dayton, OH 45404 > 937-641-4293 > http://www.childrensdayton.org > > > [EMAIL PROTECTED] > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: cfquery??
> So, if cfquery is a deprecated tag, what should we be using > in its place?? > > Anyone heard anything about this? > > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm I think you're misreading that. To me, it looks like they're saying that the CONNECTSTRING, DBNAME, DBSERVER, PROVIDER, PROVIDERDSN, and SQL attributes are deprecated, along with most values for DBTYPE. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: cfquery??
Certain attributes of are deprecated not the tag itself (as with other tags on the list). Johan Steenkamp www.assetnow.com - Original Message - From: "Candace Cottrell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, September 05, 2003 6:16 AM Subject: cfquery?? > So, if cfquery is a deprecated tag, what should we be using in its > place?? > > Anyone heard anything about this? > > > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm > > Candace K. Cottrell, Web Developer > The Children's Medical Center > One Children's Plaza > Dayton, OH 45404 > 937-641-4293 > http://www.childrensdayton.org > > > [EMAIL PROTECTED] > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: cfquery??
It's not the tag that's deprecated. It's those attributes within the tag. -d - Original Message - From: "Candace Cottrell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 04, 2003 1:16 PM Subject: cfquery?? > So, if cfquery is a deprecated tag, what should we be using in its > place?? > > Anyone heard anything about this? > > > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm > > Candace K. Cottrell, Web Developer > The Children's Medical Center > One Children's Plaza > Dayton, OH 45404 > 937-641-4293 > http://www.childrensdayton.org > > > [EMAIL PROTECTED] > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: cfquery??
Not the whole tag, just the specified attributes of the tag are deprecated. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:17 AM To: CF-Talk Subject: cfquery?? So, if cfquery is a deprecated tag, what should we be using in its place?? Anyone heard anything about this? http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: cfquery??
for the dbtype attribute for instance, every value other than "query" has been deprecated... so in cfmx, it's proper to use dbtype="query" but improper to use dbtype="anything but query" ... the other attributes listed have been deprecated in their entirety... somehow I thought the sql attribute had been deprecated in an earlier version... nobody's really used it in years... ike -- Original Message -- From: Mike Mertsock <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Sep 04, 2003 02:31 PM Subject: Re: cfquery?? >>http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm > >What the table on that page says about cfquery is not that the tag itself as a whole >is deprecated, but that some of its attributes are deprecated. The venerable cfquery >is alive and well ;-) > >Mike Mertsock >Alfred University Web Team > >>So, if cfquery is a deprecated tag, what should we be using in its >>place?? >> >>Anyone heard anything about this? >> >> >>http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm >> >>Candace K. Cottrell, Web Developer >>The Children's Medical Center >>One Children's Plaza >>Dayton, OH 45404 >>937-641-4293 >>http://www.childrensdayton.org >> >> >>[EMAIL PROTECTED] >> > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: cfquery??
isnt it just showing what attributes of the cfquery tag are deprecated, not the whole tag. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 3:12 PM To: CF-Talk Subject: Re: cfquery?? wow... glad to see cfinsert and cfupdate on the list... but cffile and cfquery? i've not heard anything either, but am pretty curious now :) charlie - Original Message - From: "Candace Cottrell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 04, 2003 11:16 AM Subject: cfquery?? > So, if cfquery is a deprecated tag, what should we be using in its > place?? > > Anyone heard anything about this? > > > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm > > Candace K. Cottrell, Web Developer > The Children's Medical Center > One Children's Plaza > Dayton, OH 45404 > 937-641-4293 > http://www.childrensdayton.org > > > [EMAIL PROTECTED] > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: cfquery??
i can answer this one.. is all i have used since day 1. now, you may need to use username/password for some odd reason...but thats it :)! tony -Original Message- From: Gary Hotko [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 3:59 PM To: CF-Talk Subject: Re: cfquery?? So when i am coding what should I use? Or is it going to be that all you need to do is name and datasource? Dave Watts wrote: >>So, if cfquery is a deprecated tag, what should we be using >>in its place?? >> >>Anyone heard anything about this? >> >>http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm >> >> > >I think you're misreading that. To me, it looks like they're saying that the >CONNECTSTRING, DBNAME, DBSERVER, PROVIDER, PROVIDERDSN, and SQL attributes >are deprecated, along with most values for DBTYPE. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: cfquery??
Does anyone know when Macromedia posted the depreciation (a date would help?) Tony Weeg wrote: >i can answer this one.. > > > > >is all i have used since day 1. > >now, you may need to use username/password for some odd >reason...but thats it :)! > >tony > >-Original Message- >From: Gary Hotko [mailto:[EMAIL PROTECTED] >Sent: Thursday, September 04, 2003 3:59 PM >To: CF-Talk >Subject: Re: cfquery?? > > >So when i am coding what should I use? > >Or is it going to be that all you need to do is name and datasource? > >Dave Watts wrote: > > > >>>So, if cfquery is a deprecated tag, what should we be using >>>in its place?? >>> >>>Anyone heard anything about this? >>> >>>http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm >>> >>> >>> >>> >>I think you're misreading that. To me, it looks like they're saying >> >> >that the > > >>CONNECTSTRING, DBNAME, DBSERVER, PROVIDER, PROVIDERDSN, and SQL >> >> >attributes > > >>are deprecated, along with most values for DBTYPE. >> >>Dave Watts, CTO, Fig Leaf Software >>http://www.figleaf.com/ >>voice: (202) 797-5496 >>fax: (202) 797-5444 >> >> >> >> > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: cfquery??
I think that the ColdFusion Administrator DataSource control panel has been elevated to a degree where you can enter most of these values directly into the datasource setup screen. Unless you are in a hosted environment you should have more control over these settings. If not at least try to ensure that your host can set default username/password values to avoid hardcoding it within your templates. If they cannot or will not do that then use the request scope in the Application.com file, eg: HTH. Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ == Analust - word meaning a Analyst (like myself) seeking work as an analyst/programmer. -Original Message- From: Gary Hotko [mailto:[EMAIL PROTECTED] Sent: Friday, 5 September 2003 4:13 PM To: CF-Talk Subject: Re: cfquery?? Does anyone know when Macromedia posted the depreciation (a date would help?) Tony Weeg wrote: >i can answer this one.. > > > > >is all i have used since day 1. > >now, you may need to use username/password for some odd >reason...but thats it :)! > >tony > >-Original Message- >From: Gary Hotko [mailto:[EMAIL PROTECTED] >Sent: Thursday, September 04, 2003 3:59 PM >To: CF-Talk >Subject: Re: cfquery?? > > >So when i am coding what should I use? > >Or is it going to be that all you need to do is name and datasource? > >Dave Watts wrote: > > > >>>So, if cfquery is a deprecated tag, what should we be using >>>in its place?? >>> >>>Anyone heard anything about this? >>> >>>http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm >>> >>> >>> >>> >>I think you're misreading that. To me, it looks like they're saying >> >> >that the > > >>CONNECTSTRING, DBNAME, DBSERVER, PROVIDER, PROVIDERDSN, and SQL >> >> >attributes > > >>are deprecated, along with most values for DBTYPE. >> >>Dave Watts, CTO, Fig Leaf Software >>http://www.figleaf.com/ >>voice: (202) 797-5496 >>fax: (202) 797-5444 >> >> >> >> > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: cfquery??
> So when i am coding what should I use? > > Or is it going to be that all you need to do is name > and datasource? Usually, that's all you've ever needed anyway - name and datasource. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: cfquery
Why would an error occur in a perfectly valid query? You can simply have an alternate display if the query is empty: > -Original Message- > From: Stuart Kidd [mailto:[EMAIL PROTECTED] > Sent: dinsdag 24 februari 2004 16:16 > To: CF-Talk > Subject: cfquery > > Hi guys, > > I have this query: > > SELECT > PropertyDataID, PropertyAgentID, PropertyDataAgentReference, > PropertyDataFlatNumberHouseName, PropertyDataStreetNumber, > PropertyDataStreetName, PropertyDataVillageTown, > PropertyDataCountyState, PropertyDataPostcodeZip, > PropertyDataCountry, PropertyDataNumberofBedrooms, > PropertyDataNumberofBathrooms, PropertyDataHouseType, > PropertyDataPrice, PropertyDataDurationType, > PropertyDataDescription, PropertyDataDateAdded FROM > PropertyData WHERE PropertyDataID = #URL.PropertyDataID# AND > PropertyAgentID = > value="#client.propertyagentid#"> > > Say if a user got to this page with a URL.PropertyID which > equaled something in the database I thought that it wouldn't > matter because of the rest of the WHERE clause stating that > PropertyAgentID = Client.PropertyAgentID. When i try and > access the page being a different client.PropertyAgentID, the > page still displays but without the fields filled in, so i > guess it works but wouldn't it be better if an error > appeared. I thought that because the WHERE clause is false > an error would occur but it doesn't. > > Anyone know a simple way to make an error occur when a user > somehow gets to run this query not being the correct client > for that propertydataid (via a url)? > > Cheers, > > Stuart > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery
> I have this query: > > > SELECT PropertyDataID, PropertyAgentID, > PropertyDataAgentReference, PropertyDataFlatNumberHouseName, > PropertyDataStreetNumber, PropertyDataStreetName, > PropertyDataVillageTown, PropertyDataCountyState, > PropertyDataPostcodeZip, PropertyDataCountry, > PropertyDataNumberofBedrooms, PropertyDataNumberofBathrooms, > PropertyDataHouseType, PropertyDataPrice, > PropertyDataDurationType, PropertyDataDescription, > PropertyDataDateAdded FROM PropertyData WHERE PropertyDataID > = #URL.PropertyDataID# AND PropertyAgentID = > cfsqltype="cf_sql_integer" value="#client.propertyagentid#"> > On a COMPLETELY different note - the URL.PropertyDataID is the thing you REALLY want to put in a CFQUERYPARAM Otherwise I could put "1;delete%20from%20PropertyData%20//" and it would kill your data [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery
Thanks Philip and Pascal, I've fixed it up so now I have a cfquery param on url.propertydataid (making sure it's only an integer which is processed) and also checked if the recordcount is gt 0 then display the form otherwise display a message saying that "You don't have user rights to edit this record". When I get some spare time i'm going to go through all my code and put cfqueryparams everywhere. One thing I don't understand is though, if i put a cfqueryparam on PropertyDataVillageTown for instance, this will be any type of string inputed therefore couldn't a hacker still put his/her malicious stuff in? Or will it block '%', '<', '>' and that sort of stuff? SELECT PropertyDataID, PropertyAgentID, PropertyDataAgentReference, PropertyDataFlatNumberHouseName, PropertyDataStreetNumber, PropertyDataStreetName, PropertyDataVillageTown, PropertyDataCountyState, PropertyDataPostcodeZip, PropertyDataCountry, PropertyDataNumberofBedrooms, PropertyDataNumberofBathrooms, PropertyDataHouseType, PropertyDataPrice, PropertyDataDurationType, PropertyDataDescription, PropertyDataDateAdded FROM PropertyData WHERE PropertyDataID = AND PropertyAgentID = Thanks guys. -- Original Message -- From: "Pascal Peters" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 24 Feb 2004 16:24:04 +0100 >Why would an error occur in a perfectly valid query? You can simply have >an alternate display if the query is empty: > > > > > > > >> -Original Message----- >> From: Stuart Kidd [mailto:[EMAIL PROTECTED] >> Sent: dinsdag 24 februari 2004 16:16 >> To: CF-Talk >> Subject: cfquery >> >> Hi guys, >> >> I have this query: >> >> SELECT >> PropertyDataID, PropertyAgentID, PropertyDataAgentReference, >> PropertyDataFlatNumberHouseName, PropertyDataStreetNumber, >> PropertyDataStreetName, PropertyDataVillageTown, >> PropertyDataCountyState, PropertyDataPostcodeZip, >> PropertyDataCountry, PropertyDataNumberofBedrooms, >> PropertyDataNumberofBathrooms, PropertyDataHouseType, >> PropertyDataPrice, PropertyDataDurationType, >> PropertyDataDescription, PropertyDataDateAdded FROM >> PropertyData WHERE PropertyDataID = #URL.PropertyDataID# AND >> PropertyAgentID = >> value="#client.propertyagentid#"> >> >> Say if a user got to this page with a URL.PropertyID which >> equaled something in the database I thought that it wouldn't >> matter because of the rest of the WHERE clause stating that >> PropertyAgentID = Client.PropertyAgentID. When i try and >> access the page being a different client.PropertyAgentID, the >> page still displays but without the fields filled in, so i >> guess it works but wouldn't it be better if an error >> appeared. I thought that because the WHERE clause is false >> an error would occur but it doesn't. >> >> Anyone know a simple way to make an error occur when a user >> somehow gets to run this query not being the correct client >> for that propertydataid (via a url)? >> >> Cheers, >> >> Stuart >> >> >> > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery
> From: Stuart Kidd > > When I get some spare time i'm going to go through all my > code and put cfqueryparams everywhere. One thing I don't > understand is though, if i put a cfqueryparam on > PropertyDataVillageTown for instance, this will be any type > of string inputed therefore couldn't a hacker still put > his/her malicious stuff in? Or will it block '%', '<', '>' > and that sort of stuff? No - the CFQUERYPARAM passes the data as a parameter, and it forces it to be a string that the database can handle - so anything in there is always entered into the field correctly (or used as a WHERE CFQUERYPARAM is the best way to "protect" your database from malicious attacks, although you have to "trap" for wrong datatypes outside of the query [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery
Thanks for that Philip, that gives me a better understanding. But I suppose trapping for wrong datatypes outside of the query opens a whole new can of worms?... -- Original Message -- From: "Philip Arnold" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 24 Feb 2004 11:07:31 -0500 >> From: Stuart Kidd >> >> When I get some spare time i'm going to go through all my >> code and put cfqueryparams everywhere. One thing I don't >> understand is though, if i put a cfqueryparam on >> PropertyDataVillageTown for instance, this will be any type >> of string inputed therefore couldn't a hacker still put >> his/her malicious stuff in? Or will it block '%', '<', '>' >> and that sort of stuff? > >No - the CFQUERYPARAM passes the data as a parameter, and it forces it >to be a string that the database can handle - so anything in there is >always entered into the field correctly (or used as a WHERE > >CFQUERYPARAM is the best way to "protect" your database from malicious >attacks, although you have to "trap" for wrong datatypes outside of the >query > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery
> From: Stuart Kidd > > Thanks for that Philip, that gives me a better understanding. No problems, glad to help > But I suppose trapping for wrong datatypes outside of the > query opens a whole new can of worms?... It throws an error, so you'd have to do a CFTRY, CFCATCH to check that the error thrown is of the correct type, and then either report it or just re-run the query with data you want to pass it All part of the joys of error trapping [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfquery + list
Hello, Let's say I have a list: How can I do a query that would take that list and do a not in? select PKID from myTable where name not in ('#attributes.myList#') (This codes doesn't work) CF 5.0 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFQuery
I guess this is what you need http://cflib.org/udf.cfm?ID=686 - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 10:21:43 -0500 Subject: CFQuery To: CF-Talk <[EMAIL PROTECTED]> I know you can return the execution time of a query, but how do you return what the query ran is? Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
Reply, not quite, this only works when an error has occurred. I would like to do this even if an error has not occurred. Select * from table #Output Query Ran# Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 10:37 AM To: CF-Talk Subject: Re: CFQuery I guess this is what you need http://cflib.org/udf.cfm?ID=686 - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 10:21:43 -0500 Subject: CFQuery To: CF-Talk <[EMAIL PROTECTED]> I know you can return the execution time of a query, but how do you return what the query ran is? Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFQuery
As far as I can tell after looking at the UDF, it doesn't require an error to occur before it returns the sql statement. the only requirement I see is that debugging must be turned on on the server for this to work. since I am not the author of this udf, I might completely be wrong - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 12:00:39 -0500 Subject: RE: CFQuery To: CF-Talk <[EMAIL PROTECTED]> Reply, not quite, this only works when an error has occurred. I would like to do this even if an error has not occurred. Select * from table #Output Query Ran# Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 10:37 AM To: CF-Talk Subject: Re: CFQuery I guess this is what you need http://cflib.org/udf.cfm?ID=686 - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 10:21:43 -0500 Subject: CFQuery To: CF-Talk <[EMAIL PROTECTED]> I know you can return the execution time of a query, but how do you return what the query ran is? Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFQuery
it does require debug to be on though for sure, not a good thing for production systems, eh? try the long hand way #PreserveSingleQuotes(varaibles.sql)# of course you may need to name your sql var different for multiple queries. Doug - Original Message - From: Qasim Rasheed <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 13:10:30 -0400 Subject: Re: CFQuery To: CF-Talk <[EMAIL PROTECTED]> As far as I can tell after looking at the UDF, it doesn't require an error to occur before it returns the sql statement. the only requirement I see is that debugging must be turned on on the server for this to work. since I am not the author of this udf, I might completely be wrong - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 12:00:39 -0500 Subject: RE: CFQuery To: CF-Talk <[EMAIL PROTECTED]> Reply, not quite, this only works when an error has occurred. I would like to do this even if an error has not occurred. Select * from table #Output Query Ran# Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 10:37 AM To: CF-Talk Subject: Re: CFQuery I guess this is what you need http://cflib.org/udf.cfm?ID=686 - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 10:21:43 -0500 Subject: CFQuery To: CF-Talk <[EMAIL PROTECTED]> I know you can return the execution time of a query, but how do you return what the query ran is? Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
Hello all, In my page, clicking on a name brings up another window where you can edit their information (their address is shown below their name). The addressID for each address is also stored in a variable (addressIDList). Clicking on a button gets the the current information from the database - the processing is done in an iframe and addressIDList is passed in the URL. I would like to have _javascript_ write this new information to the screen. I do not want the entire screen to be reloaded though, just certain information. The proper text is surounded by (for the city and state text): ... ... ... Everything works like it should except that I cannot get _javascript_ to update the page because of some syntax errors. I am trying to use JS.innertext to write the new information (i.e. for the city):
parent['city'+#addressid#].innerText =
#evaluate(city&addressid)#;
...
What is wrong with this syntax? What should it be instead? I appreciate any help... Thank you - Frank [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
Yes, you are correct, but the requesting IPAddress has to be in the debugging IP Addresses. otherwise IsDebugMode returns false. This brings up an interesting question though, if my ip is not in the list then I don't get debug information and debug mode is turned off, so why is debugging being enabled on a production machine bad? This is near the top of my page also. I would also like to know of some way to return the query as well. And yes, I understand I can rewrite all of queries as strings, but was really hoping to not do that since most of them are going to become stored procs pretty soon anyway. Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 12:11 PM To: CF-Talk Subject: Re: CFQuery As far as I can tell after looking at the UDF, it doesn't require an error to occur before it returns the sql statement. the only requirement I see is that debugging must be turned on on the server for this to work. since I am not the author of this udf, I might completely be wrong - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 12:00:39 -0500 Subject: RE: CFQuery To: CF-Talk <[EMAIL PROTECTED]> Reply, not quite, this only works when an error has occurred. I would like to do this even if an error has not occurred. Select * from table #Output Query Ran# Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 10:37 AM To: CF-Talk Subject: Re: CFQuery I guess this is what you need http://cflib.org/udf.cfm?ID=686 - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 10:21:43 -0500 Subject: CFQuery To: CF-Talk <[EMAIL PROTECTED]> I know you can return the execution time of a query, but how do you return what the query ran is? Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFQuery
> so why is debugging being enabled on a production machine bad? it takes up valuable time slices :) Doug - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 13:34:52 -0500 Subject: RE: CFQuery To: CF-Talk <[EMAIL PROTECTED]> Yes, you are correct, but the requesting IPAddress has to be in the debugging IP Addresses. otherwise IsDebugMode returns false. This brings up an interesting question though, if my ip is not in the list then I don't get debug information and debug mode is turned off, so why is debugging being enabled on a production machine bad? This is near the top of my page also. I would also like to know of some way to return the query as well. And yes, I understand I can rewrite all of queries as strings, but was really hoping to not do that since most of them are going to become stored procs pretty soon anyway. Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 12:11 PM To: CF-Talk Subject: Re: CFQuery As far as I can tell after looking at the UDF, it doesn't require an error to occur before it returns the sql statement. the only requirement I see is that debugging must be turned on on the server for this to work. since I am not the author of this udf, I might completely be wrong - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 12:00:39 -0500 Subject: RE: CFQuery To: CF-Talk <[EMAIL PROTECTED]> Reply, not quite, this only works when an error has occurred. I would like to do this even if an error has not occurred. Select * from table #Output Query Ran# Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 10:37 AM To: CF-Talk Subject: Re: CFQuery I guess this is what you need http://cflib.org/udf.cfm?ID=686 - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 10:21:43 -0500 Subject: CFQuery To: CF-Talk <[EMAIL PROTECTED]> I know you can return the execution time of a query, but how do you return what the query ran is? Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
> Yes, you are correct, but the requesting IPAddress has to > be in the > debugging IP Addresses. otherwise IsDebugMode returns > false. This > brings up an interesting question though, if my ip is not > in the list > then I don't get debug information and debug mode is > turned off, so why > is debugging being enabled on a production machine bad? > This is near > the top of my page also. I would also like to know of > some way to > return the query as well. And yes, I understand I can > rewrite all of > queries as strings, but was really hoping to not do that > since most of > them are going to become stored procs pretty soon anyway. At which point you won't get to see any of the sql by collecting it from CF... I wouldn't be surprised if debugging inflates execution times whether it's used on a given request or not -- although I haven't tested it, so I couldn't tell you for certain if that's the case. I do know that having debugging enabled and doing nothing but displaying execution times inflates the execution times being displayed by almost an order of magnitude when I tested it. (Though the specific code being executed likely varries those results quite a bit.) s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
> This brings up an interesting question though, if my ip is not > in the list then I don't get debug information and debug mode > is turned off, so why is debugging being enabled on a production > machine bad? My understanding is that simply gathering debug statistics incurs a performance penalty, whether you actually show those statistics to anyone or not. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFQuery
If debugging is turned on in the admin debuging routines are ALWAYS run. IsDebugMode() returns for the specific instance weather YOU will see degubbing or not. Debuging from my expeince does use a good bit of processing time. However that asside somehow the debugging information is pulling the SQL syntax form something, so it might be possible find it. I've been trying to figure this out for fun in my spare time but I haven't gotten anywhere with it. The only thing I have come up with,which is discourgaging, is in the java.sql.statement a method execute exists. I am figuring ColdFusion uses that and might be checking if debuging is on prior to making a call to it and storing the SQL string in an array in the ServiceFactory. I have had no luck retrieving the java.SQL.statement object for a query even though there is a getstatement method in the coldfusion.sql.QueryTable (atleast I think thats the object that has the method) Adam H On Tue, 31 Aug 2004 16:22:43 -0400, Dave Watts <[EMAIL PROTECTED]> wrote: > > This brings up an interesting question though, if my ip is not > > in the list then I don't get debug information and debug mode > > is turned off, so why is debugging being enabled on a production > > machine bad? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
If you are using CFMX you can get at the query information using the service factory. I posted a function on my blog (http://blog.mxconsulting.com). I'm sorry if someone has already mentioned this - it's been around for a while and resurfaces every few months. I think I originally got it from one of you guys ... or it might have been ben forta - can't remember. -Mark -Original Message- However that asside somehow the debugging information is pulling the SQL syntax form something, so it might be possible find it. I've been trying to figure this out for fun in my spare time but I haven't gotten anywhere with it. The only thing I have come up with,which is discourgaging, is in the java.sql.statement a method execute exists. I am figuring ColdFusion uses that and might be checking if debuging . [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFQuery
>> so why is debugging being enabled on a production machine >> bad? > it takes up valuable time slices :) > Doug Personally I find time difficult to slice ... I can never seem to find a knife sharp enough to penetrate its fabric. :) s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
The way that Forta wrote a UDF though implies that you have to have debugging enable to use the service.factory. If this is not true, let me know please. Christian -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 3:37 PM To: CF-Talk Subject: RE: CFQuery If you are using CFMX you can get at the query information using the service factory. I posted a function on my blog (http://blog.mxconsulting.com). I'm sorry if someone has already mentioned this - it's been around for a while and resurfaces every few months. I think I originally got it from one of you guys ... or it might have been ben forta - can't remember. -Mark -Original Message- However that asside somehow the debugging information is pulling the SQL syntax form something, so it might be possible find it. I've been trying to figure this out for fun in my spare time but I haven't gotten anywhere with it. The only thing I have come up with,which is discourgaging, is in the java.sql.statement a method execute exists. I am figuring ColdFusion uses that and might be checking if debuging . [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
Ah.. is that dilemna - sorry, I misread. -Original Message- From: Christian Watt [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 3:55 PM To: CF-Talk Subject: RE: CFQuery The way that Forta wrote a UDF though implies that you have to have debugging enable to use the service.factory. If this is not true, let me know please. Christian -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 3:37 PM To: CF-Talk Subject: RE: CFQuery If you are using CFMX you can get at the query information using the service factory. I posted a function on my blog (http://blog.mxconsulting.com). I'm sorry if someone has already mentioned this - it's been around for a while and resurfaces every few months. I think I originally got it from one of you guys ... or it might have been ben forta - can't remember. -Mark -Original Message- However that asside somehow the debugging information is pulling the SQL syntax form something, so it might be possible find it. I've been trying to figure this out for fun in my spare time but I haven't gotten anywhere with it. The only thing I have come up with,which is discourgaging, is in the java.sql.statement a method execute exists. I am figuring ColdFusion uses that and might be checking if debuging . [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
If you are trying to pull it the way I did in that UDF, then yes, debugging must be on. I have not yet found a way to get this without debugging enabled. --- Ben _ From: Christian Watt [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 4:55 PM To: CF-Talk Subject: RE: CFQuery The way that Forta wrote a UDF though implies that you have to have debugging enable to use the service.factory. If this is not true, let me know please. Christian -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 3:37 PM To: CF-Talk Subject: RE: CFQuery If you are using CFMX you can get at the query information using the service factory. I posted a function on my blog (http://blog.mxconsulting.com). I'm sorry if someone has already mentioned this - it's been around for a while and resurfaces every few months. I think I originally got it from one of you guys ... or it might have been ben forta - can't remember. -Mark -Original Message- However that asside somehow the debugging information is pulling the SQL syntax form something, so it might be possible find it. I've been trying to figure this out for fun in my spare time but I haven't gotten anywhere with it. The only thing I have come up with,which is discourgaging, is in the java.sql.statement a method execute exists. I am figuring ColdFusion uses that and might be checking if debuging . _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
Thanks Ben, that is what I was afraid of. Christian -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 4:09 PM To: CF-Talk Subject: RE: CFQuery If you are trying to pull it the way I did in that UDF, then yes, debugging must be on. I have not yet found a way to get this without debugging enabled. --- Ben _ From: Christian Watt [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 4:55 PM To: CF-Talk Subject: RE: CFQuery The way that Forta wrote a UDF though implies that you have to have debugging enable to use the service.factory. If this is not true, let me know please. Christian -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 3:37 PM To: CF-Talk Subject: RE: CFQuery If you are using CFMX you can get at the query information using the service factory. I posted a function on my blog (http://blog.mxconsulting.com). I'm sorry if someone has already mentioned this - it's been around for a while and resurfaces every few months. I think I originally got it from one of you guys ... or it might have been ben forta - can't remember. -Mark -Original Message- However that asside somehow the debugging information is pulling the SQL syntax form something, so it might be possible find it. I've been trying to figure this out for fun in my spare time but I haven't gotten anywhere with it. The only thing I have come up with,which is discourgaging, is in the java.sql.statement a method execute exists. I am figuring ColdFusion uses that and might be checking if debuging . _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
Let me add to this one and see if anyone knows how to output the parameters passed to a stored proc as well. Without having debuggin enabled also. Christian -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 3:50 PM To: CF-Talk Subject: Re: CFQuery >> so why is debugging being enabled on a production machine >> bad? > it takes up valuable time slices :) > Doug Personally I find time difficult to slice ... I can never seem to find a knife sharp enough to penetrate its fabric. :) s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
> Let me add to this one and see if anyone knows how to > output the > parameters passed to a stored proc as well. Without > having debuggin > enabled also. Use a function or custom tag to call all your stored procedures and store the arguments or attributes for later use. It would be pretty easy to modify the onTap framework to do this. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFQUERY Timeout
Hello All, My host has issues from time to time I get a CFQUERY timeout. But when I rerun the query it works (most times). What type of CFCATCH type would this be? Here is my error Error Occurred While Processing Request The request has exceeded the allowable time limit Tag: CFQUERY Thanks in Advance, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFQUERY problem
Hi, I'm trying to build a dynamically filled drop down select box. However, I keep getting an error message which I cannot resolve, and I'd appreciate some advice. The error message is: "ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. SQL = "SELECT JokeTitle FROM Text" Data Source = "Jokes" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (3:14). " The code for the form is below. Please note that the name of the table is 'text'. SELECT JokeTitle FROM Text Jokes JOKES Please select the joke titles from the contents of the select boxes below. You may select up to five titles at a time. Joke title #1: #Titles# Thanks. Sincerely, --- Hubert Earl ICQ#: 16199853 I develop & maintain web sites internationally. I also build web applications using CGI scripts written in Perl. I accept subcontracting work. **Personal web site: http://www.geocities.com/SiliconValley/Peaks/8702/ (please remember to view this with a sense of humour!) **Business web page: http://home.talkcity.com/MigrationPath/hearl/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFQUERY problem
Hi, I'm trying to build a dynamically filled drop down select box. However, I keep getting an error message which I cannot resolve, and I'd appreciate some advice. The error message is: "ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. SQL = "SELECT JokeTitle FROM Text" Data Source = "Jokes" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (3:14). " The code for the form is below. Please note that the name of the table is 'text'. SELECT JokeTitle FROM Text Jokes JOKES Please select the joke titles from the contents of the select boxes below. You may select up to five titles at a time. Joke title #1: #Titles# Thanks. Sincerely, --- Hubert Earl ICQ#: 16199853 I develop & maintain web sites internationally. I also build web applications using CGI scripts written in Perl. I accept subcontracting work. **Personal web site: http://www.geocities.com/SiliconValley/Peaks/8702/ (please remember to view this with a sense of humour!) **Business web page: http://home.talkcity.com/MigrationPath/hearl/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFQUERY question
I've got a field in a database that is a list of id numbers. When creating a query how do I say pull all records that have an id of "whatever" in that list? I don't want to use CONTAINS since the id could be "1" and any number with "1" in it could return the record like "142,3,8,76". Any thoughts? Joby Bednar Director of Internet Design iNEOgroup.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfquery result
Hi, i hope this is a very simple question! but i want to be able to call a query but i want the result of the query to be stored in a structure format so that i can use in cfscript, the only examples i can find is if the result is used in a http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257494 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfquery result=""
This is probably a dumb question, but I'll ask just to make sure. Does someone have a 6.1 box they can test something on for me? I just want to know if you have a cfquery tag with a result attribute if it will fail on 6.1? Im sure it will, but it would be awesome if it didn't... -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225665 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
cfquery help
hi - just wondering of I can include server specific SQL in a cfquery tag? I want to use some of MySQL's row locking features with an InnoDB table. Can I include the MySQL lock commands in the cfquery tag before an update statement ? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197400 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CFQUERY help
Trying to run this but it keeps on failing.I got the right permissions because I can run this fine in SQL Query Analyzer. BULK INSERT stgContacts FROM 'C:\CFusionMX\wwwroot\ileaflet\clients\1\contacts.txt' WITH (FIELDTERMINATOR = '|') ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273648 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFQuery Question
Does anyone know how to delete duplicate records from a table and leave only one record in the table using . ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192100 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
re: cfquery
I think you want it this way, using a CASE statement for the leadmgr column. I also moved all your subselects into left joins, which should give a bit better performance. select s.address + ' ' + s.address2 + ' ' + s.address3 + ',' + s.city + ',' + s.state + ',' + s.city as office_address, leadmgr = case when (lm.user_id is null) then lm.lead_note else lm.first + ' ' + lm.last end, amr.first + ' ' + amr.last as director, sn.first + ' ' + sn.last as SDIRNDIR, vp.first + ' ' + vp.last as VICEPRE, fm.first + ' ' + fm.last as FASTMGR from sourcebook_1 s left outer join user_info lm on s.lead_mgr = lm.user_id left outer join user_info amr on s.area_mgr_rdo = amr.user_id left outer join user_info sn on s.sdir_ndir = sn.user_id left outer join user_info vp on s.vice_pre = vp.user_id left outer join user_info fm on s.fast_mgr = fm.user_id where active = 1 and office_id not in (36,37,38,73) order by office_number ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324792 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery
select iif(lm.user_id = s.lead_mgr, (lm.first + ' ' + lm.last) , s.lead_note) as leadMgr, iif(lm.user_id = s.AREA_MGR_RDO, lm.first + ' ' + lm.last , s.Area_Note) as director , iif(lm.user_id = s.sdir_ndir, lm.first + ' ' + lm.last , s.sdir_note) as sndir , iif(lm.user_id = s.vice_pre, lm.first + ' ' + lm.last , s.vice_note) as vicePre , iif(lm.user_id = s.fast_mgr, lm.first + ' ' + lm.last , s.fast_note) as fastMgr , from sourcebook_1 s,user_info lm where s.active = 1 and (lm.user_id = s.lead_mgr or lm.user_id = s.AREA_MGR_RDO or lm.user_id = s.sdir_ndir or lm.user_id = s.vice_pre or lm.user_id = s.fast_mgr) and s.office_id not in(36,37,38,73) order by s.office_number i am writing like this, it is working fine, thanks for your response >I think you want it this way, using a CASE statement for the leadmgr >column. I also moved all your subselects into left joins, which should >give a bit better performance. > > >select >s.address + ' ' + s.address2 + ' ' + s.address3 + ',' + s.city + ',' + >s.state + ',' + s.city as office_address, >leadmgr = case >when (lm.user_id is null) then lm.lead_note >else lm.first + ' ' + lm.last >end, >amr.first + ' ' + amr.last as director, >sn.first + ' ' + sn.last as SDIRNDIR, >vp.first + ' ' + vp.last as VICEPRE, >fm.first + ' ' + fm.last as FASTMGR >from sourcebook_1 s left outer join >user_info lm on s.lead_mgr = lm.user_id left outer join >user_info amr on s.area_mgr_rdo = amr.user_id left outer join >user_info sn on s.sdir_ndir = sn.user_id left outer join >user_info vp on s.vice_pre = vp.user_id left outer join >user_info fm on s.fast_mgr = fm.user_id >where active = 1 >and office_id not in (36,37,38,73) >order by office_number > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324803 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFQUERY Question
I'm running into an odd behavior with CFQUERY (at least I think it is odd) I have the following code (example) SELECT blah FROM blah WHERE blah = 1 12345 if the query blahName returns no results, I thought i would still be able to access blahName.recordCount Am I wrong on this, or is there something else I am overlooking? Thanks -Dave ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332498 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFQUERY Question
I have a SQL statement that is easier to build and save as a variable but it throws an error when I do this: #strSQL2# The error says it is trying to insert the values with two '': SQL: INSERT INTO users(userName) VALUES(''andrew'') If I put the SQL code into the CFQUERY tag it is fine. Why is this and can I fix it? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317533 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFQuery
> I am reviewing CF and working on a small site to get my skills back up to > par. > > Here is what I have: > > > >#theSQL# > >#theSQL# > > I am getting an error about SQL Statement being invalid: > > ... > > Notice that PrivacyPolicy has ³² around it..I am not putting it there. If I > put this statement in a SQL editor and run it it is invalid and it I swithc > to like I think I am doing in the CFSET it works. > > What am I doing wrong? You are doing two things wrong. First, if you want to use a single-quoted string like you're doing, you need to use PreserveSingleQuotes: #PreserveSingleQuotes(theSQL)# Second, and more importantly, using raw data from the browser like that is a serious security vulnerability. Whenever you use unsafe data within a query, you should build a prepared statement using the CFQUERYPARAM tag: http://www.adobe.com/devnet/coldfusion/articles/cfqueryparam.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317684 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFQuery
Hi Dave, Thanks for the reply. >Second, and more importantly, using raw data from the browser like >that is a serious security vulnerability. Whenever you use unsafe data >within a query, you should build a prepared statement using the >CFQUERYPARAM tag: > >http://www.adobe.com/devnet/coldfusion/articles/cfqueryparam.html Thanks for the link. I see that you authored this article. Very well laid out. I understand SQL Injection and qhy to use CFQUERYPARAM. What I did not see in the article was how to take a CFSET statement that builds a SQL String and put CFQUERYPARAMS into it and make it work. Like: '" > How does one accomplish this? Thanks! -Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317688 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFQuery
> Thanks for the link. I see that you authored this article. Very well > laid out. I understand SQL Injection and qhy to use CFQUERYPARAM. > What I did not see in the article was how to take a CFSET statement > that builds a SQL String and put CFQUERYPARAMS into it and make it > work. > > Like: > > >'" > > > How does one accomplish this? You can't really do it like that... you can never put cf tags inside a string literal and have them work (except in the case of code generation, which isn't what you want). (Also the double-quotes would need to be escaped ("") in order to embed them in a string.) The reason why the cfquery tag has an end-tag however is actually to eliminate the need to build sql statements using string literals like this. So normally you would use this: SELECT queryName, title, content FROM content WHERE queryName = Note that when you use a cfqueryparam tag you omit the single-quotes around the parameter. The parameter will handle the quotes for you if they're needed. Having said that, the DataFaucet ORM actually does use a technique which allows it to have just one pair of cfquery tags in the entire framework, which behaves similarly to what you're describing. They don't work on a string literal however, they work on an array which contains some strings and some structures, where the structures contain the attributes that will go into cfqueryparam tags. That looks similar to this: #preserveSingleQuotes(sql[x])# Other mechanisms within the ORM framework help to prevent SQL injection -- with just a small number of rules to follow regarding the things you should not do with the ORM to prevent opening yourself to attacks. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317694 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
evaluate() inside of CFQUERY vs outside of CFQUERY
Why would evaluate function differently inside of a CFQUERY vs outside? Specifically relating to the processing of text containing single quote marks. This code works: UPDATE NewsItemLinks SET LinkURL='#evaluate("form.LinkURLx" & ThisKey)#', LinkName='#variables.linkname#' WHERE key=#thiskey# But this code fails if the contents of the form field being referenced contains a single quote: UPDATE NewsItemLinks SET LinkURL='#evaluate("form.LinkURLx" & ThisKey)#', LinkName='#evaluate("form.LinkNameX" & ThisKey)#' WHERE key=#thiskey# The failure is an SQL parsing error, and in the displayed SQL, the single quote in the text string is clearly the problem. If the text doesn't contain a single quote, then both pieces of code work just fine. I've obviously found the "fix" but I'm curious as to what's going on here. This looks to me to be more of a CFQUERY problem/aspect/feature than a problem with evaluate, since as far as I can see it's returning the exact same string in both cases. thanks all, -reed FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists