Re: OT: SQL - Selecting a Month
What John says is correct...your syntax will work in SQL Server. If you are using some other database you will probably want to look at datepart(). -- jon mailto:[EMAIL PROTECTED] Wednesday, September 3, 2003, 4:56:31 PM, you wrote: BG I know there is an easy answer to this that's escaping me at the moment. BG CF has a function Month() which will pull the number of the month out of a BG date. Is there a similar function to use in a SELECT statement that works BG the same way? BG Here's what I want: BG SELECT My_Date BG FROM All_Dates BG WHERE Month(My_Date) = 8 BG Returns all entires from All_Dates that are August. Easy? BG Thanks! ~| 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: SQL - Selecting a Month
Yep, should work. SQL Server Books Online says: MONTH Returns an integer that represents the month part of a specified date. Syntax MONTH ( date ) Looks the same to me! -Original Message- From: B G [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 1:57 PM To: CF-Talk Subject: OT: SQL - Selecting a Month I know there is an easy answer to this that's escaping me at the moment. CF has a function Month() which will pull the number of the month out of a date. Is there a similar function to use in a SELECT statement that works the same way? Here's what I want: SELECT My_Date FROM All_Dates WHERE Month(My_Date) = 8 Returns all entires from All_Dates that are August. Easy? Thanks! BG _ MSN 8: Get 6 months for $9.95/month http://join.msn.com/?page=dept/dialup ~| 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: request vs application scope
-Original Message- From: Mauricio Giraldo [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 11:58 PM To: CF-Talk Subject: request vs application scope Hi We are developing this web-based HTML editor: http://www.elefectoaxe.com.co/spaw/test.cfm It uses CFCs and has several configuration variables (default language, folder to place images into, etc) that are created in a couple of configuration templates. Right now we handle these configuration variables in the REQUEST scope. Would it be a better idea to handle them in the APPLICATION or some other scope? What is the criteria for scope choosing? This is a SourceForge project and once we upload it you can take a look at the code. I talk about this quite a bit in my guide to CF variables here: http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Guides/V ariables/Index.cfm In general, when using CFCs I would recommend creating the variables inside the CFCs as instance variables upon invocation rather than look out of the CFC to external data. That being said and from the little you've said it seems like the Application makes the most sense. Using the Application scope means that these variables will be created once, and only once, and use up only that much RAM for all users. Using the Request scope would mean that each request would have to create these variables and that the RAM usage would be greater (each request having its own copy of the data). Using the Request scope made a LOT of sense in CF 5 and below as using the Application scope meant a lot of locking. The Request scope was more resource intensive, but allowed for simpler code less likely to fall prey to deadlocks or resource contention. With MX's low-level locking server stability from lack of locking has disappeared. Its now safe to store this kind of information in the Application scope and access it directly. In a sense the Request scope, which in 4.5 and 5.0 became a nice replacement for the Application scope for many things, has now be superseded by the improved Application scope. Jim Davis ~| 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: OT: SQL Query
Jeff Chastain wrote: Table 1 (key,name) - 1,test 2,test2 Table 2 (key,thread,timestamp) - 1,1,1/1/2003 1,2,1/2/2003 2,3,1/1/2003 1,2,1/4/2003 The desired result set, passing in a key = 1 parameter, would be key,name,numthreads,timestamp 1,test,2,1/4/2004 The difference I am seeing between this and your code is that it appears your code counts the number of instances of a given key in table 2 instead of the number of distinct threads per key in table 2. SELECT t1.key, t1.name, COUNT(DISTINCT t2.thread) AS numThreads MAX(t2.timeStamp) AS timestamp FROM t1 INNER JOIN t2 ON t1.key = t2.key GROUP BY t1.key, t1.name Jochem ~| 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
Error when trying to create a datasource from the CFMX Administrator
yes I have recently upgraded to 6.1 from updater 3. I entered a new datasource name, selected Microsoft SQL Server from the driver drop-down, entered the database, server, login, password details and on hitting the submit button I get the error. I did what you asked me to, deleting all the class files from the cfusionmx\web-inf\cfclasses folder and restarted all the cf services, I still get the error. Did you recently upgrade the server to a different version of CF? I saw a couple of people reporting this after the 6.1...I don't know how it was resolved, but if the old compiled class files for those admin pages are still hanging around and this isJ2EE function didn't exist previously, that could be the problem. If so, restarting the service and making sure cfusionmx\web-inf\cfclasses is empty of files should clear the problem up. -- jon mailto:[EMAIL PROTECTED] Wednesday, September 3, 2003, 10:19:17 AM, you wrote: CP SQL Server What kind of database? -- jon mailto:[EMAIL PROTECTED] Wednesday, September 3, 2003, 9:55:40 AM, you wrote: AC I get this error when I try to create a data source AC from the CFMX Administrator. AC Element ISJ2EE is undefined in DS. AC The error occurred in AC D:\CFusionMX\wwwroot\CFIDE\administrator\datasources\index.cfm: AC line 448 AC Called from AC D:\CFusionMX\wwwroot\CFIDE\administrator\datasources\index.cfm: AC line 434 AC Called from AC D:\CFusionMX\wwwroot\CFIDE\administrator\datasources\index.cfm: AC line 371 AC Called from AC D:\CFusionMX\wwwroot\CFIDE\administrator\datasources\index.cfm: AC line 1 AC Can somebody please tell me how to correct this AC __ AC Do you Yahoo!? AC Yahoo! SiteBuilder - Free, easy-to-use web site design software AC http://sitebuilder.yahoo.com AC CP ~| 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: DWMX 2004 - Whats new for us?
On Wednesday 03 Sep 2003 19:39 pm, [EMAIL PROTECTED] wrote: some of us dont know what that is matt. a lot of us dont know java maybe dont have time to learn it. a lot of us need cffile. gawd knows i do:) I'm sure somewhere there must be a cf_file that works like cffile, but uses Java's i/o layer inside. -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| 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 syntax
Hi, What's wrong with the below syntax? I think the single quotes around the commalist is throwing it for a loop? How can I get around this? If I use double quotes I'll run into the same problem around the ListGetAt... code. cfquery name=Insert datasource=prefs UPDATE tblProfiles SET strSelect='cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR' WHERE strUsername='#auth#' /cfquery ~| 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 syntax
I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? Do I need the cfqueryparam? On Thu, 04 Sep 2003 07:55:24 -0400, Bushy wrote: Hi, What's wrong with the below syntax? I think the single quotes around the commalist is throwing it for a loop? How can I get around this? If I use double quotes I'll run into the same problem around the ListGetAt... code. cfquery name=Insert datasource=prefs UPDATE tblProfiles SET strSelect='cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR' WHERE strUsername='#auth#' /cfquery ~| 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
OT: Firefly
Does anyone know of how I can get hold of MM Firefly? It appears that no trial downloads are available from MM until Flash MX 2004 is out. Does anyone know any different? Neil ~| 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 syntax
I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? If you look at debug output for an SQL statement that's using CFQUERYPARAM, you'll see question marks in the SQL, which are used as placeholders. You may want to remove the quotes around the CFQUERYPARAM tag in your case. Do I need the cfqueryparam? It's not absolutely necessary, but it is a really good idea to use it whenever possible. 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 syntax
I'm getting a little further but now I get this error. What does this mean? Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type text to data type nvarchar, table 'prefs.dbo.tblprofiles', column 'strSelect'. Use the CONVERT function to run this query. On Thu, 4 Sep 2003 08:46:33 -0400, Dave Watts wrote: I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? If you look at debug output for an SQL statement that's using CFQUERYPARAM, you'll see question marks in the SQL, which are used as placeholders. You may want to remove the quotes around the CFQUERYPARAM tag in your case. Do I need the cfqueryparam? It's not absolutely necessary, but it is a really good idea to use it whenever possible. 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: Firefly
I believe you have to buy FireFly to get it. There is no trial download. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 13:09 To: CF-Talk Subject: OT: Firefly Does anyone know of how I can get hold of MM Firefly? It appears that no trial downloads are available from MM until Flash MX 2004 is out. Does anyone know any different? Neil ~| 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 syntax
what does your query look like? I usually get that error when I try to do an insert of text characters into a INT type field in the db. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:52 AM To: CF-Talk Subject: RE: cfquery syntax I'm getting a little further but now I get this error. What does this mean? Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type text to data type nvarchar, table 'prefs.dbo.tblprofiles', column 'strSelect'. Use the CONVERT function to run this query. On Thu, 4 Sep 2003 08:46:33 -0400, Dave Watts wrote: I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? If you look at debug output for an SQL statement that's using CFQUERYPARAM, you'll see question marks in the SQL, which are used as placeholders. You may want to remove the quotes around the CFQUERYPARAM tag in your case. Do I need the cfqueryparam? It's not absolutely necessary, but it is a really good idea to use it whenever possible. 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
CFMX and JTOpen
I am running CFMX 6.1 on my local machine on Win XP Professional. I am having problems using the JTOpen Driver to connect to an AS/400. Is there anyone running under similar conditions that has successfully made a connection? James Taavon Senior Web Developer Department of Labor, Licensing and Regulation 1100 N. Eutaw Street Room 203 Baltimore, MD 21201 Ph: 410 767-8190 Fx: 410 333-5203 ~| 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 syntax
what is the datatype in the db for this field you are trying to update? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 7:55 AM To: CF-Talk Subject: re: cfquery syntax Hi, What's wrong with the below syntax? I think the single quotes around the commalist is throwing it for a loop? How can I get around this? If I use double quotes I'll run into the same problem around the ListGetAt... code. cfquery name=Insert datasource=prefs UPDATE tblProfiles SET strSelect='cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR' WHERE strUsername='#auth#' /cfquery ~| 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: Firefly
I believe you have to buy FireFly to get it. There is no trial download. FireFly, as a stand-alone product, is gone: http://www.macromedia.com/software/dataconnection/ Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| 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 syntax
Speaking of this.. can someone clear this up for me? I thought I read somewhere that you can not use cached queries when you use cfqueryparam. Is this true? Thanks, Dave Fafard snip Do I need the cfqueryparam? It's not absolutely necessary, but it is a really good idea to use it whenever possible. 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 syntax
On Thu, 4 Sep 2003 09:02:14 -0400, Tony Weeg wrote: what does your query look like? I usually get that error when I try to do an insert of text characters into a INT type field in the db. Below is my query. The Data Type for all fields is nvarchar cfquery name=Update datasource=prefs UPDATE tblProfiles SET strSelect=cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR WHERE strUsername='#auth#' /cfquery tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:52 AM To: CF-Talk Subject: RE: cfquery syntax I'm getting a little further but now I get this error. What does this mean? Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type text to data type nvarchar, table 'prefs.dbo.tblprofiles', column 'strSelect'. Use the CONVERT function to run this query. On Thu, 4 Sep 2003 08:46:33 -0400, Dave Watts wrote: I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? If you look at debug output for an SQL statement that's using CFQUERYPARAM, you'll see question marks in the SQL, which are used as placeholders. You may want to remove the quotes around the CFQUERYPARAM tag in your case. Do I need the cfqueryparam? It's not absolutely necessary, but it is a really good idea to use it whenever possible. 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 syntax
You see the ? BECAUSE of the cfqueryparam and this is not an error. It is just a placeholder for the value. And you should ALWAYS use cfqueryparam The only exception you can make is for static values like isActive = 1 or something. And even then you can't go wrong using them. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 14:06 To: CF-Talk Subject: re: cfquery syntax I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? Do I need the cfqueryparam? On Thu, 04 Sep 2003 07:55:24 -0400, Bushy wrote: Hi, What's wrong with the below syntax? I think the single quotes around the commalist is throwing it for a loop? How can I get around this? If I use double quotes I'll run into the same problem around the ListGetAt... code. cfquery name=Insert datasource=prefs UPDATE tblProfiles SET strSelect='cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR' WHERE strUsername='#auth#' /cfquery ~| 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 syntax
No quotes around cfqueryparam cfquery name=Insert datasource=prefs UPDATE tblProfiles SET strSelect=cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR WHERE strUsername=cfqueryparam value=#auth# cfsqltype=CF_SQL_VARCHAR /cfquery -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 13:55 To: CF-Talk Subject: re: cfquery syntax Hi, What's wrong with the below syntax? I think the single quotes around the commalist is throwing it for a loop? How can I get around this? If I use double quotes I'll run into the same problem around the ListGetAt... code. cfquery name=Insert datasource=prefs UPDATE tblProfiles SET strSelect='cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR' WHERE strUsername='#auth#' /cfquery ~| 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 syntax
It's true in cf 5.0. Not sure about newer versions. -Deanna - Original Message - From: David Fafard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:06 AM Subject: Re: cfquery syntax Speaking of this.. can someone clear this up for me? I thought I read somewhere that you can not use cached queries when you use cfqueryparam. Is this true? Thanks, Dave Fafard snip Do I need the cfqueryparam? It's not absolutely necessary, but it is a really good idea to use it whenever possible. 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 syntax
just for shites and giggles...have ya tried... cfquery name=Update datasource=prefs UPDATE tblProfiles SET strSelect='#ListGetAt(commalist,1,'|')#' WHERE strUsername='#auth#' /cfquery just wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:08 AM To: CF-Talk Subject: RE: cfquery syntax On Thu, 4 Sep 2003 09:02:14 -0400, Tony Weeg wrote: what does your query look like? I usually get that error when I try to do an insert of text characters into a INT type field in the db. Below is my query. The Data Type for all fields is nvarchar cfquery name=Update datasource=prefs UPDATE tblProfiles SET strSelect=cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR WHERE strUsername='#auth#' /cfquery tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:52 AM To: CF-Talk Subject: RE: cfquery syntax I'm getting a little further but now I get this error. What does this mean? Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type text to data type nvarchar, table 'prefs.dbo.tblprofiles', column 'strSelect'. Use the CONVERT function to run this query. On Thu, 4 Sep 2003 08:46:33 -0400, Dave Watts wrote: I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? If you look at debug output for an SQL statement that's using CFQUERYPARAM, you'll see question marks in the SQL, which are used as placeholders. You may want to remove the quotes around the CFQUERYPARAM tag in your case. Do I need the cfqueryparam? It's not absolutely necessary, but it is a really good idea to use it whenever possible. 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 syntax
why should one ALWAYS use cfqueryparam? I havent, EVER and have many apps, on many servers and no problemsjust wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:14 AM To: CF-Talk Subject: RE: cfquery syntax You see the ? BECAUSE of the cfqueryparam and this is not an error. It is just a placeholder for the value. And you should ALWAYS use cfqueryparam The only exception you can make is for static values like isActive = 1 or something. And even then you can't go wrong using them. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 14:06 To: CF-Talk Subject: re: cfquery syntax I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? Do I need the cfqueryparam? On Thu, 04 Sep 2003 07:55:24 -0400, Bushy wrote: Hi, What's wrong with the below syntax? I think the single quotes around the commalist is throwing it for a loop? How can I get around this? If I use double quotes I'll run into the same problem around the ListGetAt... code. cfquery name=Insert datasource=prefs UPDATE tblProfiles SET strSelect='cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR' WHERE strUsername='#auth#' /cfquery ~| 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: Firefly
Ah yes, its being whacked into Flash MX 2004 Professional -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:05 To: CF-Talk Subject: Re: Firefly I believe you have to buy FireFly to get it. There is no trial download. FireFly, as a stand-alone product, is gone: http://www.macromedia.com/software/dataconnection/ Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| 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 syntax
Yes, it is -Original Message- From: David Fafard [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 15:07 To: CF-Talk Subject: Re: cfquery syntax Speaking of this.. can someone clear this up for me? I thought I read somewhere that you can not use cached queries when you use cfqueryparam. Is this true? Thanks, Dave Fafard snip Do I need the cfqueryparam? It's not absolutely necessary, but it is a really good idea to use it whenever possible. 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 syntax
1. Performance 2. Security Check out http://www.macromedia.com/devnet/mx/coldfusion/articles/cfqueryparam.htm l http://www.macromedia.com/devnet/server_archive/articles/cfqueryparam_or acle_databases.html -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 15:16 To: CF-Talk Subject: RE: cfquery syntax why should one ALWAYS use cfqueryparam? I havent, EVER and have many apps, on many servers and no problemsjust wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 ~| 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: Firefly
Seems kinda weird to drop it before the replacement is readywe want to start looking at firefly and, at the moment, it would seem there is no way of doing it. Anyone know the ETA of Flash 2004? Neil I believe you have to buy FireFly to get it. There is no trial download. FireFly, as a stand-alone product, is gone: http://www.macromedia.com/software/dataconnection/ ~| 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 syntax
I just tried the below and get a totally different error message now. I guess the cfparam must do something with the data being truncated? ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (70:2) to (70:43 On Thu, 4 Sep 2003 09:13:26 -0400, Tony Weeg wrote: just for shites and giggles...have ya tried... cfquery name=Update datasource=prefs UPDATE tblProfiles SET strSelect='#ListGetAt(commalist,1,'|')#' WHERE strUsername='#auth#' /cfquery just wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:08 AM To: CF-Talk Subject: RE: cfquery syntax On Thu, 4 Sep 2003 09:02:14 -0400, Tony Weeg wrote: what does your query look like? I usually get that error when I try to do an insert of text characters into a INT type field in the db. Below is my query. The Data Type for all fields is nvarchar cfquery name=Update datasource=prefs UPDATE tblProfiles SET strSelect=cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR WHERE strUsername='#auth#' /cfquery tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:52 AM To: CF-Talk Subject: RE: cfquery syntax I'm getting a little further but now I get this error. What does this mean? Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type text to data type nvarchar, table 'prefs.dbo.tblprofiles', column 'strSelect'. Use the CONVERT function to run this query. On Thu, 4 Sep 2003 08:46:33 -0400, Dave Watts wrote: I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? If you look at debug output for an SQL statement that's using CFQUERYPARAM, you'll see question marks in the SQL, which are used as placeholders. You may want to remove the quotes around the CFQUERYPARAM tag in your case. Do I need the cfqueryparam? It's not absolutely necessary, but it is a really good idea to use it whenever possible. 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 syntax
You must be trying to put in more text than the field can hold, that's all that error messsage means. Either increase the no of chars the field can hold or make it 'text'. And btw, don't use nvarchar unless your storing or planning to store unicode strings, varchar would be the correct data type unless the string is REALLY big, in which case you'd probably be better off with 'text' (not 'ntext', for the same unicode reason) -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:19 To: CF-Talk Subject: RE: cfquery syntax I just tried the below and get a totally different error message now. I guess the cfparam must do something with the data being truncated? ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (70:2) to (70:43 On Thu, 4 Sep 2003 09:13:26 -0400, Tony Weeg wrote: just for shites and giggles...have ya tried... cfquery name=Update datasource=prefs UPDATE tblProfiles SET strSelect='#ListGetAt(commalist,1,'|')#' WHERE strUsername='#auth#' /cfquery just wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:08 AM To: CF-Talk Subject: RE: cfquery syntax On Thu, 4 Sep 2003 09:02:14 -0400, Tony Weeg wrote: what does your query look like? I usually get that error when I try to do an insert of text characters into a INT type field in the db. Below is my query. The Data Type for all fields is nvarchar cfquery name=Update datasource=prefs UPDATE tblProfiles SET strSelect=cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR WHERE strUsername='#auth#' /cfquery tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:52 AM To: CF-Talk Subject: RE: cfquery syntax I'm getting a little further but now I get this error. What does this mean? Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type text to data type nvarchar, table 'prefs.dbo.tblprofiles', column 'strSelect'. Use the CONVERT function to run this query. On Thu, 4 Sep 2003 08:46:33 -0400, Dave Watts wrote: I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? If you look at debug output for an SQL statement that's using CFQUERYPARAM, you'll see question marks in the SQL, which are used as placeholders. You may want to remove the quotes around the CFQUERYPARAM tag in your case. Do I need the cfqueryparam? It's not absolutely necessary, but it is a really good idea to use it whenever possible. 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 syntax
Because it's safer and faster and is therefore considered best practice. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:16 To: CF-Talk Subject: RE: cfquery syntax why should one ALWAYS use cfqueryparam? I havent, EVER and have many apps, on many servers and no problemsjust wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:14 AM To: CF-Talk Subject: RE: cfquery syntax You see the ? BECAUSE of the cfqueryparam and this is not an error. It is just a placeholder for the value. And you should ALWAYS use cfqueryparam The only exception you can make is for static values like isActive = 1 or something. And even then you can't go wrong using them. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 14:06 To: CF-Talk Subject: re: cfquery syntax I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? Do I need the cfqueryparam? On Thu, 04 Sep 2003 07:55:24 -0400, Bushy wrote: Hi, What's wrong with the below syntax? I think the single quotes around the commalist is throwing it for a loop? How can I get around this? If I use double quotes I'll run into the same problem around the ListGetAt... code. cfquery name=Insert datasource=prefs UPDATE tblProfiles SET strSelect='cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR' WHERE strUsername='#auth#' /cfquery ~| 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 syntax
Speaking of this.. can someone clear this up for me? I thought I read somewhere that you can not use cached queries when you use cfqueryparam. Is this true? Yes, this is true. 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: Firefly
I can tell you from getting it with our DevNet, that it would be best to wait until Flash 2004 because the current FireFly is a pian to work with. Remoting is more stable and a whole lot easier to work with at this point. Clint [EMAIL PROTECTED] wrote: Seems kinda weird to drop it before the replacement is readywe want to start looking at firefly and, at the moment, it would seem there is no way of doing it. Anyone know the ETA of Flash 2004? Neil ~| 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: Firefly
Seems kinda weird to drop it before the replacement is readywe want to start looking at firefly and, at the moment, it would seem there is no way of doing it. If you look at the last two faqs on MM's website you will see that stuff created with FireFly aren't going to have an easy migration path to Flash 2004... I would guess MM took it out from the market to minimize the pain... Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| 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 syntax
faster than the raw data being in there? how can that be? that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or less, enough of them could be slower? im not sure I get that logic? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:23 AM To: CF-Talk Subject: RE: cfquery syntax Because it's safer and faster and is therefore considered best practice. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:16 To: CF-Talk Subject: RE: cfquery syntax why should one ALWAYS use cfqueryparam? I havent, EVER and have many apps, on many servers and no problemsjust wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:14 AM To: CF-Talk Subject: RE: cfquery syntax You see the ? BECAUSE of the cfqueryparam and this is not an error. It is just a placeholder for the value. And you should ALWAYS use cfqueryparam The only exception you can make is for static values like isActive = 1 or something. And even then you can't go wrong using them. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 14:06 To: CF-Talk Subject: re: cfquery syntax I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? Do I need the cfqueryparam? On Thu, 04 Sep 2003 07:55:24 -0400, Bushy wrote: Hi, What's wrong with the below syntax? I think the single quotes around the commalist is throwing it for a loop? How can I get around this? If I use double quotes I'll run into the same problem around the ListGetAt... code. cfquery name=Insert datasource=prefs UPDATE tblProfiles SET strSelect='cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR' WHERE strUsername='#auth#' /cfquery ~| 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 syntax
Try this.. cfset variables.strSelect = ListGetAt(commalist,1,'|') cfquery name=Insert datasource=prefs UPDATE tblProfiles SET strSelect = cfqueryparam cfsqltype=CF_SQL_LONGVARCHAR value=#variables.strSelect# WHERE strUsername = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#auth# /cfquery -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 12:55 To: CF-Talk Subject: re: cfquery syntax Hi, What's wrong with the below syntax? I think the single quotes around the commalist is throwing it for a loop? How can I get around this? If I use double quotes I'll run into the same problem around the ListGetAt... code. cfquery name=Insert datasource=prefs UPDATE tblProfiles SET strSelect='cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR' WHERE strUsername='#auth#' /cfquery ~| 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 syntax
That means your form value lenght exceeds the database field length. Example: FORM.FIELD_1 Length = 250 characters DATABASE Field Length = 100 characters Thus the form field would be truncated to fit the database table. [EMAIL PROTECTED] 09/04/03 09:19AM I just tried the below and get a totally different error message now. I guess the cfparam must do something with the data being truncated? ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (70:2) to (70:43 On Thu, 4 Sep 2003 09:13:26 -0400, Tony Weeg wrote: just for shites and giggles...have ya tried... cfquery name=Update datasource=prefs UPDATE tblProfiles SET strSelect='#ListGetAt(commalist,1,'|')#' WHERE strUsername='#auth#' /cfquery just wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:08 AM To: CF-Talk Subject: RE: cfquery syntax On Thu, 4 Sep 2003 09:02:14 -0400, Tony Weeg wrote: what does your query look like? I usually get that error when I try to do an insert of text characters into a INT type field in the db. Below is my query. The Data Type for all fields is nvarchar cfquery name=Update datasource=prefs UPDATE tblProfiles SET strSelect=cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR WHERE strUsername='#auth#' /cfquery tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:52 AM To: CF-Talk Subject: RE: cfquery syntax I'm getting a little further but now I get this error. What does this mean? Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type text to data type nvarchar, table 'prefs.dbo.tblprofiles', column 'strSelect'. Use the CONVERT function to run this query. On Thu, 4 Sep 2003 08:46:33 -0400, Dave Watts wrote: I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? If you look at debug output for an SQL statement that's using CFQUERYPARAM, you'll see question marks in the SQL, which are used as placeholders. You may want to remove the quotes around the CFQUERYPARAM tag in your case. Do I need the cfqueryparam? It's not absolutely necessary, but it is a really good idea to use it whenever possible. 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 syntax
So then you gain one benefit but lose the other. Will using cfqueryparam give a performance boost equal to using cachedwithin? If not, I imagine you would NOT want to use cfqueryparam everywhere. Dave Fafard - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:34 AM Subject: RE: cfquery syntax Speaking of this.. can someone clear this up for me? I thought I read somewhere that you can not use cached queries when you use cfqueryparam. Is this true? Yes, this is true. 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
Fusebox Classifieds App
Anyone know of a Classified Ads App done in Fusebox? I didn't have much luck googling it. Greg ~| 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 syntax
the data is too long for the field? can you increase the size allotment for this field? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:19 AM To: CF-Talk Subject: RE: cfquery syntax I just tried the below and get a totally different error message now. I guess the cfparam must do something with the data being truncated? ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (70:2) to (70:43 On Thu, 4 Sep 2003 09:13:26 -0400, Tony Weeg wrote: just for shites and giggles...have ya tried... cfquery name=Update datasource=prefs UPDATE tblProfiles SET strSelect='#ListGetAt(commalist,1,'|')#' WHERE strUsername='#auth#' /cfquery just wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:08 AM To: CF-Talk Subject: RE: cfquery syntax On Thu, 4 Sep 2003 09:02:14 -0400, Tony Weeg wrote: what does your query look like? I usually get that error when I try to do an insert of text characters into a INT type field in the db. Below is my query. The Data Type for all fields is nvarchar cfquery name=Update datasource=prefs UPDATE tblProfiles SET strSelect=cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR WHERE strUsername='#auth#' /cfquery tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:52 AM To: CF-Talk Subject: RE: cfquery syntax I'm getting a little further but now I get this error. What does this mean? Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type text to data type nvarchar, table 'prefs.dbo.tblprofiles', column 'strSelect'. Use the CONVERT function to run this query. On Thu, 4 Sep 2003 08:46:33 -0400, Dave Watts wrote: I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? If you look at debug output for an SQL statement that's using CFQUERYPARAM, you'll see question marks in the SQL, which are used as placeholders. You may want to remove the quotes around the CFQUERYPARAM tag in your case. Do I need the cfqueryparam? It's not absolutely necessary, but it is a really good idea to use it whenever possible. 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
Firefly
MM stated in the big user group presentation that they were hoping for mid month availability. You may want to try contacting customer support. Maybe they will let you put in an order for the new studio and give you a copy of firefly to test and play with in the meantime. ~| 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 syntax
faster than the raw data being in there? Yes. how can that be? Because, by separating values from the rest of the SQL, the database won't have to do that for you, and may be able to use a cached execution plan if one exists. that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or less, enough of them could be slower? im not sure I get that logic? It doesn't make your CF code, specifically, faster - it makes your database respond faster. 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 syntax
really. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:51 AM To: CF-Talk Subject: RE: cfquery syntax faster than the raw data being in there? Yes. how can that be? Because, by separating values from the rest of the SQL, the database won't have to do that for you, and may be able to use a cached execution plan if one exists. that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or less, enough of them could be slower? im not sure I get that logic? It doesn't make your CF code, specifically, faster - it makes your database respond faster. 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 syntax
That was it. I changed the datatype to text and ewverything is OK now. THanks guys! On Thu, 4 Sep 2003 14:26:12 +0100, Craig Dudley wrote: You must be trying to put in more text than the field can hold, that's all that error messsage means. Either increase the no of chars the field can hold or make it 'text'. And btw, don't use nvarchar unless your storing or planning to store unicode strings, varchar would be the correct data type unless the string is REALLY big, in which case you'd probably be better off with 'text' (not 'ntext', for the same unicode reason) -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:19 To: CF-Talk Subject: RE: cfquery syntax I just tried the below and get a totally different error message now. I guess the cfparam must do something with the data being truncated? ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (70:2) to (70:43 On Thu, 4 Sep 2003 09:13:26 -0400, Tony Weeg wrote: just for shites and giggles...have ya tried... cfquery name=Update datasource=prefs UPDATE tblProfiles SET strSelect='#ListGetAt(commalist,1,'|')#' WHERE strUsername='#auth#' /cfquery just wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:08 AM To: CF-Talk Subject: RE: cfquery syntax On Thu, 4 Sep 2003 09:02:14 -0400, Tony Weeg wrote: what does your query look like? I usually get that error when I try to do an insert of text characters into a INT type field in the db. Below is my query. The Data Type for all fields is nvarchar cfquery name=Update datasource=prefs UPDATE tblProfiles SET strSelect=cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR WHERE strUsername='#auth#' /cfquery tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:52 AM To: CF-Talk Subject: RE: cfquery syntax I'm getting a little further but now I get this error. What does this mean? Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type text to data type nvarchar, table 'prefs.dbo.tblprofiles', column 'strSelect'. Use the CONVERT function to run this query. On Thu, 4 Sep 2003 08:46:33 -0400, Dave Watts wrote: I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? If you look at debug output for an SQL statement that's using CFQUERYPARAM, you'll see question marks in the SQL, which are used as placeholders. You may want to remove the quotes around the CFQUERYPARAM tag in your case. Do I need the cfqueryparam? It's not absolutely necessary, but it is a really good idea to use it whenever possible. 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: Firefly
Flash 2004 is expected later this month (I believe) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:22 To: CF-Talk Subject: RE: Firefly Seems kinda weird to drop it before the replacement is readywe want to start looking at firefly and, at the moment, it would seem there is no way of doing it. Anyone know the ETA of Flash 2004? Neil I believe you have to buy FireFly to get it. There is no trial download. FireFly, as a stand-alone product, is gone: http://www.macromedia.com/software/dataconnection/ ~| 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 syntax
So then you gain one benefit but lose the other. Yes, although there are other ways to gain the other benefit. Will using cfqueryparam give a performance boost equal to using cachedwithin? No, probably not in most cases. It will generally speed the execution of your SQL by the database, in addition to filtering potentially harmful database input. If not, I imagine you would NOT want to use cfqueryparam everywhere. Not if you're using CACHEDWITHIN/CACHEDAFTER, perhaps. You may consider caching your queries in persistent memory scopes (Session, Application, Server) instead, though. 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: DWMX 2004 - Whats new for us?
I'm sure somewhere there must be a cf_file that works like cffile, but uses Java's i/o layer inside. CFMX compiles CFML into Java, so cffile in fact just uses java.io.File. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| 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: DWMX 2004 - Whats new for us?
On Thursday 04 Sep 2003 14:53 pm, Matt Liotta wrote: I'm sure somewhere there must be a cf_file that works like cffile, but uses Java's i/o layer inside. CFMX compiles CFML into Java, so cffile in fact just uses java.io.File. Right. But if your hosting provider has wiped out cffile ... ? -- Tom Chiverton (sorry 'bout sig.) Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| 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: Zipcode lookup Which query?
Well I didn't get a response to my question but I fixed my problem and wanted to post what I ended up using. I also want to mention that this calculates in miles not kilometers. To use kilometers, change 3963 to 6378.7. First I query the db to get the lat long for the zipcode. cfquery name=passedzip datasource= SELECT zip, lat, long, city, state FROM zips WHERE zip='#form.passedzipcode#' /cfquery Then I query my dealer table to get the dealers in the specified range. cfquery datasource= name=getlocs SELECT lat, long, name, city, state, zipcode, area_code, phone, 3963 * (ACOS((SIN(#passedzip.lat#/57.2958) * SIN(lat/57.2958)) + (COS(#passedzip.lat#/57.2958) * COS(lat/57.2958) * COS(long/57.2958 - #passedzip.long#/57.2958 AS distance FROM dealers_geo WHERE 3963 * (ACOS((SIN(#passedzip.lat#/57.2958) * SIN(lat/57.2958)) + (COS(#passedzip.lat#/57.2958) * COS(lat/57.2958) * COS(long/57.2958 - #passedzip.long#/57.2958 = #form.passedradius# ORDER BY distance /cfquery The 3963 is the assumed radius of the earth in miles. 6378.7 is the radius in kilometers. The value of 57.2958 is used to convert lat and long into radians. I have to say that I am very impressed with the speed of the query. If you have any questions let me know. Phillip B. www.LoungeRoyale.com www.FillWorks.com - Original Message - From: Phillip B [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 2:49 PM Subject: Zipcode lookup Which query? I have a stored procedure that someone wrote for me. This is the core of the sql from it SELECT TOP 10 dbo.dealers_geo.*, SQRT(SQUARE(69.1 * (lat - @lat)) + SQUARE(69.1 * (long - @long) * COS (@lat / 57.3))) AS DistanceMiles FROM dbo.dealers_geo ORDER BY DistanceMiles I found a site that shows to do it using this sql SELECT zip, lat, long, state, city, 3963 * (ACOS((SIN(#passedzip.lat#/57.2958) * SIN(lat/57.2958)) + (COS(#passedzip.lat#/57.2958) * COS(lat/57.2958) * COS(long/57.2958 - #passedzip.long#/57.2958 AS distance FROM zips WHERE (lat = #passedzip.lat# - (#form.passedradius#/69)) And (lat = #passedzip.lat# + (#form.passedradius#/69)) AND (long = #passedzip.long# - (#form.passedradius#/69)) AND (long = #passedzip.long# + (#form.passedradius#/69)) ORDER BY distance I believe that the second is more accurate. The problem is I cant seem to get the second to work correctly. :-/ Something with the radius part causing it to get weird results. If they both worked, which do you think is the best to use? I would be really happy if you can help make the second query work. I'm using CF5 and SQL 2000. Also, I will be willing more than willing to share the finial SQL once I have it working. :) Phillip B. www.LoungeRoyale.com www.FillWorks.com ~| 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 syntax
Tony, It's faster for the database, not necessarily for CF. In Oracle, there's this chunk of memory used for sql snippets. When a new query comes in, it looks there first, to see if it already exists. If it does, it yanks the data from there, instead of re-running/re-optimzing the query. (I would imagine there's something similar in other databases.) Anyway, using queryparam makes it so that two queries searching for different values in the where clause look like the same query to Oracle. In other words: select * from mytable where id = 1 is not the same as select * from mytable where id =2 But, if you use queryparams... select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=1 is the same to the query pool as select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=2 The query param gets translated to a bind variable, and Oracle knows that it's the same query except for this one variable. That's what makes it faster. -d - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:38 AM Subject: RE: cfquery syntax faster than the raw data being in there? how can that be? that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or less, enough of them could be slower? im not sure I get that logic? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:23 AM To: CF-Talk Subject: RE: cfquery syntax Because it's safer and faster and is therefore considered best practice. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:16 To: CF-Talk Subject: RE: cfquery syntax why should one ALWAYS use cfqueryparam? I havent, EVER and have many apps, on many servers and no problemsjust wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:14 AM To: CF-Talk Subject: RE: cfquery syntax You see the ? BECAUSE of the cfqueryparam and this is not an error. It is just a placeholder for the value. And you should ALWAYS use cfqueryparam The only exception you can make is for static values like isActive = 1 or something. And even then you can't go wrong using them. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 14:06 To: CF-Talk Subject: re: cfquery syntax I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? Do I need the cfqueryparam? On Thu, 04 Sep 2003 07:55:24 -0400, Bushy wrote: Hi, What's wrong with the below syntax? I think the single quotes around the commalist is throwing it for a loop? How can I get around this? If I use double quotes I'll run into the same problem around the ListGetAt... code. cfquery name=Insert datasource=prefs UPDATE tblProfiles SET strSelect='cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR' WHERE strUsername='#auth#' /cfquery ~| 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
CFObject Creation Count
I have a JavaBean API that i use to Connect to our DB via an Object Server(RedBack
Business Objects)
The Constructor Increments a Static variable everytime an Object is Instanciated from
the API.
private static int objCount;
public RedBackObect{
objCount++;
}
I am looking track DB Usage from the NO of Objects created and do some stess testing
as well.
Now.. If the objects are invoked in a CFC - CFFunctions like
cfset var rbo = /
cfscript
rbo = createObect(Java,RedBackObject).init(); // this should call the default
contructor
//do some stuff with the rbo.
objCount = rbo.getObjectCount(); // static method in API
rbo.closeObj();
rbo=;
/cfscript
objCount = 1, which is not right cause the object was instantiated several times.
rbo = createObect(Java,RedBackObject).init(); AND rbo =
createObect(Java,RedBackObject)
Both call the default contructor right Or do you have to explicitly say init()?
If the Class gets loaded only once, then i should get the correct object count.
Can anybody explain whats going on in CF Object Creation?
Thanks,
Joe Eugene
~|
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: DWMX 2004 - Whats new for us?
Right. But if your hosting provider has wiped out cffile ... ? Then I am sure they won't let you install a CFX that does the same thing. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| 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 syntax
but what impact does it have on sql server 2000 ent edition. we don't use oracle...does this same logic apply? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:30 AM To: CF-Talk Subject: Re: cfquery syntax Tony, It's faster for the database, not necessarily for CF. In Oracle, there's this chunk of memory used for sql snippets. When a new query comes in, it looks there first, to see if it already exists. If it does, it yanks the data from there, instead of re-running/re-optimzing the query. (I would imagine there's something similar in other databases.) Anyway, using queryparam makes it so that two queries searching for different values in the where clause look like the same query to Oracle. In other words: select * from mytable where id = 1 is not the same as select * from mytable where id =2 But, if you use queryparams... select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=1 is the same to the query pool as select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=2 The query param gets translated to a bind variable, and Oracle knows that it's the same query except for this one variable. That's what makes it faster. -d - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:38 AM Subject: RE: cfquery syntax faster than the raw data being in there? how can that be? that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or less, enough of them could be slower? im not sure I get that logic? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:23 AM To: CF-Talk Subject: RE: cfquery syntax Because it's safer and faster and is therefore considered best practice. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:16 To: CF-Talk Subject: RE: cfquery syntax why should one ALWAYS use cfqueryparam? I havent, EVER and have many apps, on many servers and no problemsjust wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:14 AM To: CF-Talk Subject: RE: cfquery syntax You see the ? BECAUSE of the cfqueryparam and this is not an error. It is just a placeholder for the value. And you should ALWAYS use cfqueryparam The only exception you can make is for static values like isActive = 1 or something. And even then you can't go wrong using them. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 14:06 To: CF-Talk Subject: re: cfquery syntax I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? Do I need the cfqueryparam? On Thu, 04 Sep 2003 07:55:24 -0400, Bushy wrote: Hi, What's wrong with the below syntax? I think the single quotes around the commalist is throwing it for a loop? How can I get around this? If I use double quotes I'll run into the same problem around the ListGetAt... code. cfquery name=Insert datasource=prefs UPDATE tblProfiles SET strSelect='cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR' WHERE strUsername='#auth#' /cfquery ~| 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: CFMX and JTOpen
having problems using the JTOpen Driver to connect to an AS/400. You must have a problem with your Connection Parameters. Post your connection parameters. Joe Eugene - Original Message - From: James Taavon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:04 AM Subject: CFMX and JTOpen I am running CFMX 6.1 on my local machine on Win XP Professional. I am having problems using the JTOpen Driver to connect to an AS/400. Is there anyone running under similar conditions that has successfully made a connection? James Taavon Senior Web Developer Department of Labor, Licensing and Regulation 1100 N. Eutaw Street Room 203 Baltimore, MD 21201 Ph: 410 767-8190 Fx: 410 333-5203 ~| 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 syntax
Yes, it should be the same for all the big databases. Even is it wasn't any faster, the data type validation using queryparam provides makes it more than worthwhile. SQL injection attacks are potentially fatal for your db server and you should not risk it. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:33 To: CF-Talk Subject: RE: cfquery syntax but what impact does it have on sql server 2000 ent edition. we don't use oracle...does this same logic apply? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:30 AM To: CF-Talk Subject: Re: cfquery syntax Tony, It's faster for the database, not necessarily for CF. In Oracle, there's this chunk of memory used for sql snippets. When a new query comes in, it looks there first, to see if it already exists. If it does, it yanks the data from there, instead of re-running/re-optimzing the query. (I would imagine there's something similar in other databases.) Anyway, using queryparam makes it so that two queries searching for different values in the where clause look like the same query to Oracle. In other words: select * from mytable where id = 1 is not the same as select * from mytable where id =2 But, if you use queryparams... select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=1 is the same to the query pool as select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=2 The query param gets translated to a bind variable, and Oracle knows that it's the same query except for this one variable. That's what makes it faster. -d - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:38 AM Subject: RE: cfquery syntax faster than the raw data being in there? how can that be? that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or less, enough of them could be slower? im not sure I get that logic? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:23 AM To: CF-Talk Subject: RE: cfquery syntax Because it's safer and faster and is therefore considered best practice. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:16 To: CF-Talk Subject: RE: cfquery syntax why should one ALWAYS use cfqueryparam? I havent, EVER and have many apps, on many servers and no problemsjust wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:14 AM To: CF-Talk Subject: RE: cfquery syntax You see the ? BECAUSE of the cfqueryparam and this is not an error. It is just a placeholder for the value. And you should ALWAYS use cfqueryparam The only exception you can make is for static values like isActive = 1 or something. And even then you can't go wrong using them. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 14:06 To: CF-Talk Subject: re: cfquery syntax I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? Do I need the cfqueryparam? On Thu, 04 Sep 2003 07:55:24 -0400, Bushy wrote: Hi, What's wrong with the below syntax? I think the single quotes around the commalist is throwing it for a loop? How can I get around this? If I use double quotes I'll run into the same problem around the ListGetAt... code. cfquery name=Insert datasource=prefs UPDATE tblProfiles SET strSelect='cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR' WHERE strUsername='#auth#' /cfquery ~| 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 syntax
As far as I know, yes -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 16:33 To: CF-Talk Subject: RE: cfquery syntax but what impact does it have on sql server 2000 ent edition. we don't use oracle...does this same logic apply? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:30 AM To: CF-Talk Subject: Re: cfquery syntax Tony, It's faster for the database, not necessarily for CF. In Oracle, there's this chunk of memory used for sql snippets. When a new query comes in, it looks there first, to see if it already exists. If it does, it yanks the data from there, instead of re-running/re-optimzing the query. (I would imagine there's something similar in other databases.) Anyway, using queryparam makes it so that two queries searching for different values in the where clause look like the same query to Oracle. In other words: select * from mytable where id = 1 is not the same as select * from mytable where id =2 But, if you use queryparams... select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=1 is the same to the query pool as select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=2 The query param gets translated to a bind variable, and Oracle knows that it's the same query except for this one variable. That's what makes it faster. -d ~| 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
CFC/Object Best Practice
Ok, I think I have a pretty good handle on how to code inheritance with CFC's, but I'm not so sure how you do aggregation and/or composition (still learning the concepts of Object orientated programming as well as cfc's themselves). Anyway, using the ever present car object example. You have a car class/object that contains an engine class/object. What is the best practice to code this relationship in an CFC. How would the car code send and receive messages to the engine code? Thanks -- Ian Skinner Web Programmer BloodSource Sacramento, CA ~| 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 syntax
aight, im sold. GREAT. conversion timeWOO WOO WOO! thanks guys and gal, for the insight. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:35 AM To: CF-Talk Subject: RE: cfquery syntax Yes, it should be the same for all the big databases. Even is it wasn't any faster, the data type validation using queryparam provides makes it more than worthwhile. SQL injection attacks are potentially fatal for your db server and you should not risk it. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:33 To: CF-Talk Subject: RE: cfquery syntax but what impact does it have on sql server 2000 ent edition. we don't use oracle...does this same logic apply? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:30 AM To: CF-Talk Subject: Re: cfquery syntax Tony, It's faster for the database, not necessarily for CF. In Oracle, there's this chunk of memory used for sql snippets. When a new query comes in, it looks there first, to see if it already exists. If it does, it yanks the data from there, instead of re-running/re-optimzing the query. (I would imagine there's something similar in other databases.) Anyway, using queryparam makes it so that two queries searching for different values in the where clause look like the same query to Oracle. In other words: select * from mytable where id = 1 is not the same as select * from mytable where id =2 But, if you use queryparams... select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=1 is the same to the query pool as select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=2 The query param gets translated to a bind variable, and Oracle knows that it's the same query except for this one variable. That's what makes it faster. -d - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:38 AM Subject: RE: cfquery syntax faster than the raw data being in there? how can that be? that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or less, enough of them could be slower? im not sure I get that logic? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:23 AM To: CF-Talk Subject: RE: cfquery syntax Because it's safer and faster and is therefore considered best practice. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:16 To: CF-Talk Subject: RE: cfquery syntax why should one ALWAYS use cfqueryparam? I havent, EVER and have many apps, on many servers and no problemsjust wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:14 AM To: CF-Talk Subject: RE: cfquery syntax You see the ? BECAUSE of the cfqueryparam and this is not an error. It is just a placeholder for the value. And you should ALWAYS use cfqueryparam The only exception you can make is for static values like isActive = 1 or something. And even then you can't go wrong using them. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 14:06 To: CF-Talk Subject: re: cfquery syntax I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? Do I need the cfqueryparam? On Thu, 04 Sep 2003 07:55:24 -0400, Bushy wrote: Hi, What's wrong with the below syntax? I think the single quotes around the commalist is throwing it for a loop? How can I get around this? If I use double quotes I'll run into the same problem around the ListGetAt... code. cfquery name=Insert datasource=prefs UPDATE tblProfiles SET strSelect='cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR' WHERE strUsername='#auth#' /cfquery ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe:
query output to Excel file
What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| 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: query output to Excel file
id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| 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: query output to Excel file
We simply use cfsavecontent as HTML and let Excel convert it. -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:45 To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| 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: query output to Excel file
You can just save it in csv format but with a .xls extension, it works, Excel opens them up np. -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:45 To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| 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: query output to Excel file
neil. what do you put in the cfsavecontent? the query object or some sort of outputted formatted data? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file We simply use cfsavecontent as HTML and let Excel convert it. -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:45 To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| 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: CFC/Object Best Practice
practice to code this relationship in an CFC. How would the car code send and receive messages to the engine code? Objects talk to each other by invoking their instance methods. themselves). Anyway, using the ever present car object example. You have a car class/object that contains an engine class/object I think you might be trying real hard to apply inheritance above(Car - Engine), to me this is more of abstraction - divide and conquer... not really inheritance. An example of Inheritance would be some like Dog - Hunting dog - Pet dog Both Hunting dog and Pet dog inherit the properties of DOG...(ie all Dogs have 4 legs, 2 eyes, nose etc) while Hunting dog itself has the extensive properties/features of a Hunting Dog(vigilant ...) Joe Eugene - Original Message - From: Ian Skinner [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:42 AM Subject: CFC/Object Best Practice Ok, I think I have a pretty good handle on how to code inheritance with CFC's, but I'm not so sure how you do aggregation and/or composition (still learning the concepts of Object orientated programming as well as cfc's themselves). Anyway, using the ever present car object example. You have a car class/object that contains an engine class/object. What is the best practice to code this relationship in an CFC. How would the car code send and receive messages to the engine code? Thanks -- Ian Skinner Web Programmer BloodSource Sacramento, CA ~| 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: query output to Excel file
Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| 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: query output to Excel file
Assuming SQL Server, the easiest way would be to do a DTS export directly an excel file. If you are not using SQL Server, then there really isn't an easy way. Clint ~| 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: query output to Excel file
trouble is, I cant do it all in 1 query, I have cf logic that HAS to be there, and it is then emailed to a client :( so, is there a way to take a cfquery object that is returned, and just dump that into something, and send it, versus writing line by line by line tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| 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: query output to Excel file
Well, for the moment is pretty ugly, but it workswe just output HTML outputted content from a cfloop. Works ok for thousands of records. no complaints so far and no issues with timeout. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:59 To: CF-Talk Subject: RE: query output to Excel file neil. what do you put in the cfsavecontent? the query object or some sort of outputted formatted data? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file We simply use cfsavecontent as HTML and let Excel convert it. -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:45 To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| 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
cookies
i need some help understanding cookies. why would internet explorer set a cookie if i call the page using the ip address instead of the dns name? for an example check out http://www.empower-xl.com/empowernew http://www.empower-xl.com/empowernew log in as and then go to http://209.104.158.69/empowernew http://209.104.158.69/empowernew and do the same thing. you can get to the main screen logging in both ways. however, if you try a menu item it acts like the cookie isn't there (which is true). if you go to your cookies folder you will notice that internet explorer only set the cookie when you go to 209.104.158.69/empowernew. i'm running windows 2000, iis, cfmx 6.1 tia Steven D Dworman Macromedia Certified Developer - Senior Information Technology Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com http://www.comspecinternational.com/ phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com http://www.empower-xl.com/ ~| 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 syntax
Tony: check out this article by Mr Forta. pretty good on explaining the reasons for using cfqueryparam: http://www.macromedia.com/devnet/mx/coldfusion/articles/ben_forta_faster.html as far as never having used it and not having probs...well, the same thing can be said about cflock. you don't *have* to lock your shared scope vars. your app will still run. but *should* you lock your shared scope vars? yes. I know where you're coming from. i only recently started using it. it wasn't around when i started CF, and I'm a creature of habit. found it difficult to even justify writing the extra code, which just seemed to make my SQL code that much more difficult to read. after reading enough articles like ben's above (our own Dave W. has one as well at http://www.macromedia.com/devnet/mx/coldfusion/articles/cfqueryparam.html that's worth a read), i started to force myself in the interest of writing better code. now, i see a query without cfqueryparam (usually my own old code), and i cringe. it's a difficult transition to make, i know, when you're used to just banging out SQL (and it works). but this transition is well worth the effort, in my opinion (for whatever that's worth) :) charlie - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 7:32 AM Subject: RE: cfquery syntax but what impact does it have on sql server 2000 ent edition. we don't use oracle...does this same logic apply? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:30 AM To: CF-Talk Subject: Re: cfquery syntax Tony, It's faster for the database, not necessarily for CF. In Oracle, there's this chunk of memory used for sql snippets. When a new query comes in, it looks there first, to see if it already exists. If it does, it yanks the data from there, instead of re-running/re-optimzing the query. (I would imagine there's something similar in other databases.) Anyway, using queryparam makes it so that two queries searching for different values in the where clause look like the same query to Oracle. In other words: select * from mytable where id = 1 is not the same as select * from mytable where id =2 But, if you use queryparams... select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=1 is the same to the query pool as select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=2 The query param gets translated to a bind variable, and Oracle knows that it's the same query except for this one variable. That's what makes it faster. -d - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:38 AM Subject: RE: cfquery syntax faster than the raw data being in there? how can that be? that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or less, enough of them could be slower? im not sure I get that logic? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:23 AM To: CF-Talk Subject: RE: cfquery syntax Because it's safer and faster and is therefore considered best practice. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:16 To: CF-Talk Subject: RE: cfquery syntax why should one ALWAYS use cfqueryparam? I havent, EVER and have many apps, on many servers and no problemsjust wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:14 AM To: CF-Talk Subject: RE: cfquery syntax You see the ? BECAUSE of the cfqueryparam and this is not an error. It is just a placeholder for the value. And you should ALWAYS use cfqueryparam The only exception you can make is for static values like isActive = 1 or something. And even then you can't go wrong using them. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 14:06 To: CF-Talk Subject: re: cfquery syntax I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? Do I need the cfqueryparam? On Thu, 04 Sep 2003 07:55:24 -0400, Bushy wrote: Hi, What's
Re: DWMX 2004 - Whats new for us?
On Thursday 04 Sep 2003 15:32 pm, Matt Liotta wrote: Right. But if your hosting provider has wiped out cffile ... ? Then I am sure they won't let you install a CFX that does the same thing. I don't think they'd have any choice. Of course, what they should do, is provide a cf_file which is a wrapper round cffile, but appends your hosted directory path to all the path/filename arguments or something. -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| 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: query output to Excel file
im good on dts, that's cool, just never considered that as an option...too many options too many things to code, cant think of 'em all...thats what I have cftalk :) all these good ideas... tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| 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: SQL or CF Code help with extracting distinct values from a list
Sorry for the late response... I didn't understand the whole situation from the first message or 2 -- and have been sort of in and out a lot lately... If you could create a separate table to hold just the bird names -- or a separate query in cf you could still use sql to get it all with a single query using an inner join... cfquery ... select birds.birdname as parent_answer, survey.answer, count(survey.answer) from birds, survey where ',' || survey.parent_answer || ',' like '%,' || birds.birdname ',%' group by birds.birdname, survey.answer order by birds.birdname, survey.answer /cfquery You may need to use a sub-query instead of the like in the where clause... I can't remember off the top of my head how that subquery is phrased, but I'm pretty sure I've done it before in sql server if not oracle, so I suspect it can also be done either in oracle or cf... s. isaac dealey972-490-6624 team macromedia volunteer http://www.macromedia.com/go/team chief architect, tapestry cms http://products.turnkey.to onTap is open source http://www.turnkey.to/ontap Meaning you have a single entry with a list of parent answers in one column? ... Yes... Sorry Isaac, I know it's not normalised, believe me, I've sat down with the DBA's over this problem and this solution is the best of a bad bunch in terms of method... it's a long and complicated story that I can't go into right now, but I have to work with what I have it's not big, not pretty but all I got :-( This is the end result of a whole heap of custom questionnaire's that a user can build any way they want using the standard HTML form controls (ie a form editor)... we're trying to cater for everyone and every type of form that can be built and provide reporting tools it was all going fine until the realisation of checkbox's being able to contain multiple values and the introduction of the concept of a parent answer into the pot Assuming of course that the parent_answer and answer columns contain only the bit of information you're trying to get at and not a list of different bits, and the QofQ follows normal SQL rules, which it's supposed to. The column contains a list of values and I can't change it now :-( Psudeo logic for what I am doing here (and it is pretty horrendous now)... 1. For each question 2. Query the database table for the relevant answers (which can be at a module, course, school, faculty OR uni level, hence the massive reports) 3. Using QoQ, get all the distinct parentAnswers 4. If no parentAnswers, Skip to step 7 5. If parentAnswers, for each distinct parentAnswer (I get the distinct parentAnswer list by passing in the distinct parentAnswer Query into a UDF) 6. Use QoQ to get all the answers that had a parentAnswer containing this particular distinct parentAnswer 7. Do count of the actual Answers (as opposed to parentAnswer) 8. Display On reflection, we would probably do lots of it different ways and the reporting side I would be looking to go down the route you have suggested... but time, resources, the voices from above... I'm sure you've been there ;-) Isaac, cheers for your time, I really do appreciate it but I am now halfway built on a method as time is now short. cheers DC -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: 03 September 2003 14:21 To: CF-Talk Subject: RE: SQL or CF Code help with extracting distinct values from a list Isaac, Don't worry about it but I thought I would answer your post since it would be impolite not too :-) The parentAnswer is a list of values, I need to be able to group per distinct value in that parentAnswer list for all the responses for that question. I am retrieving all the answers for a particular question in a query and then using QoQ to break it down further so full on SQL is just not possible... ie if I have the following answers which have been queried from a single table (columns missed out to keep it readable) PARENT_ANSWER_LIST RESAREA_VALUE Sparrows,Bluetit,CrowWell Sparrows,Pigeons,Robins,Bluetit,Crow Very Well Sparrows,Pigeons,Bluetit Well I need it to come back with the following as an answer... BIRD VALUE COUNT Sparrow Well2 Sparrow Very Well 1 Bluetit Well2 Bluetit Very Well 1 Crow Well1 Crow Very Well 1 Pigeons Well1 Pigeons Very Well 1 The way I am looking at your query (and I have tried something similar) is that where the parentAnswer is 'Sparrows,Bluetit,Crow' your query will count the 'Sparrows,Bluetit,Crow as a distinct answer and will not split it up into its list values. Meaning you have a single entry with a list of parent
RE: query output to Excel file
interesting... may have to try that as an avenue ;) thanks! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:59 AM To: CF-Talk Subject: Re: query output to Excel file Assuming SQL Server, the easiest way would be to do a DTS export directly an excel file. If you are not using SQL Server, then there really isn't an easy way. Clint ~| 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 syntax
thanks charlie ill do some more research and then make the transition slowly thanks again! 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 11:09 AM To: CF-Talk Subject: Re: cfquery syntax Tony: check out this article by Mr Forta. pretty good on explaining the reasons for using cfqueryparam: http://www.macromedia.com/devnet/mx/coldfusion/articles/ben_forta_faster .html as far as never having used it and not having probs...well, the same thing can be said about cflock. you don't *have* to lock your shared scope vars. your app will still run. but *should* you lock your shared scope vars? yes. I know where you're coming from. i only recently started using it. it wasn't around when i started CF, and I'm a creature of habit. found it difficult to even justify writing the extra code, which just seemed to make my SQL code that much more difficult to read. after reading enough articles like ben's above (our own Dave W. has one as well at http://www.macromedia.com/devnet/mx/coldfusion/articles/cfqueryparam.htm l that's worth a read), i started to force myself in the interest of writing better code. now, i see a query without cfqueryparam (usually my own old code), and i cringe. it's a difficult transition to make, i know, when you're used to just banging out SQL (and it works). but this transition is well worth the effort, in my opinion (for whatever that's worth) :) charlie - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 7:32 AM Subject: RE: cfquery syntax but what impact does it have on sql server 2000 ent edition. we don't use oracle...does this same logic apply? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:30 AM To: CF-Talk Subject: Re: cfquery syntax Tony, It's faster for the database, not necessarily for CF. In Oracle, there's this chunk of memory used for sql snippets. When a new query comes in, it looks there first, to see if it already exists. If it does, it yanks the data from there, instead of re-running/re-optimzing the query. (I would imagine there's something similar in other databases.) Anyway, using queryparam makes it so that two queries searching for different values in the where clause look like the same query to Oracle. In other words: select * from mytable where id = 1 is not the same as select * from mytable where id =2 But, if you use queryparams... select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=1 is the same to the query pool as select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=2 The query param gets translated to a bind variable, and Oracle knows that it's the same query except for this one variable. That's what makes it faster. -d - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:38 AM Subject: RE: cfquery syntax faster than the raw data being in there? how can that be? that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or less, enough of them could be slower? im not sure I get that logic? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:23 AM To: CF-Talk Subject: RE: cfquery syntax Because it's safer and faster and is therefore considered best practice. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:16 To: CF-Talk Subject: RE: cfquery syntax why should one ALWAYS use cfqueryparam? I havent, EVER and have many apps, on many servers and no problemsjust wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:14 AM To: CF-Talk Subject: RE: cfquery syntax You see the ? BECAUSE of the cfqueryparam and this is not an error. It is just a placeholder for the value. And you should ALWAYS use cfqueryparam The only exception you can make is for static values like isActive = 1 or something. And even then you can't go wrong using them. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september
Re: cfquery syntax
I would imagine that SQL Server has a similar cached query pool but I really don't know, as I don't use it. I can tell you that our DBA's really really like us when we use it, and really really don't when we don't use it. ;) -d - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:32 AM Subject: RE: cfquery syntax but what impact does it have on sql server 2000 ent edition. we don't use oracle...does this same logic apply? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:30 AM To: CF-Talk Subject: Re: cfquery syntax Tony, It's faster for the database, not necessarily for CF. In Oracle, there's this chunk of memory used for sql snippets. When a new query comes in, it looks there first, to see if it already exists. If it does, it yanks the data from there, instead of re-running/re-optimzing the query. (I would imagine there's something similar in other databases.) Anyway, using queryparam makes it so that two queries searching for different values in the where clause look like the same query to Oracle. In other words: select * from mytable where id = 1 is not the same as select * from mytable where id =2 But, if you use queryparams... select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=1 is the same to the query pool as select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=2 The query param gets translated to a bind variable, and Oracle knows that it's the same query except for this one variable. That's what makes it faster. -d - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:38 AM Subject: RE: cfquery syntax faster than the raw data being in there? how can that be? that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or less, enough of them could be slower? im not sure I get that logic? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:23 AM To: CF-Talk Subject: RE: cfquery syntax Because it's safer and faster and is therefore considered best practice. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:16 To: CF-Talk Subject: RE: cfquery syntax why should one ALWAYS use cfqueryparam? I havent, EVER and have many apps, on many servers and no problemsjust wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:14 AM To: CF-Talk Subject: RE: cfquery syntax You see the ? BECAUSE of the cfqueryparam and this is not an error. It is just a placeholder for the value. And you should ALWAYS use cfqueryparam The only exception you can make is for static values like isActive = 1 or something. And even then you can't go wrong using them. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 14:06 To: CF-Talk Subject: re: cfquery syntax I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? Do I need the cfqueryparam? On Thu, 04 Sep 2003 07:55:24 -0400, Bushy wrote: Hi, What's wrong with the below syntax? I think the single quotes around the commalist is throwing it for a loop? How can I get around this? If I use double quotes I'll run into the same problem around the ListGetAt... code. cfquery name=Insert datasource=prefs UPDATE tblProfiles SET strSelect='cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR' WHERE strUsername='#auth#' /cfquery ~| 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: CFC/Object Best Practice
practice to code this relationship in an CFC. How would the car code send and receive messages to the engine code? Objects talk to each other by invoking their instance methods. And how would this look in the code of a CFC? I think you might be trying real hard to apply inheritance above (Car - Engine), to me this is more of abstraction - divide and conquer... not really inheritance. Exactly, I have a pretty good idea of how to code and use inheritance (designing them is another story). My example was supposed to be an example of relationship that WAS NOT inheritance, and how would one code cfc's for this relationship? -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:01 AM To: CF-Talk Subject: Re: CFC/Object Best Practice practice to code this relationship in an CFC. How would the car code send and receive messages to the engine code? Objects talk to each other by invoking their instance methods. themselves). Anyway, using the ever present car object example. You have a car class/object that contains an engine class/object I think you might be trying real hard to apply inheritance above(Car - Engine), to me this is more of abstraction - divide and conquer... not really inheritance. An example of Inheritance would be some like Dog - Hunting dog - Pet dog Both Hunting dog and Pet dog inherit the properties of DOG...(ie all Dogs have 4 legs, 2 eyes, nose etc) while Hunting dog itself has the extensive properties/features of a Hunting Dog(vigilant ...) Joe Eugene - Original Message - From: Ian Skinner [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:42 AM Subject: CFC/Object Best Practice Ok, I think I have a pretty good handle on how to code inheritance with CFC's, but I'm not so sure how you do aggregation and/or composition (still learning the concepts of Object orientated programming as well as cfc's themselves). Anyway, using the ever present car object example. You have a car class/object that contains an engine class/object. What is the best practice to code this relationship in an CFC. How would the car code send and receive messages to the engine code? Thanks -- Ian Skinner Web Programmer BloodSource Sacramento, CA ~| 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 syntax
One more tip: If you're using CF Studio/HomeSite, create a few Code Templates (snippets) and you'll save some awkward typing (and some reference lookups - I've only seen the cfsqltypes defined for the major DBs in Forta's WACKs, and they differ between the dbs and even from common sense in some of the cases). I have the following set up for MS-SQL data types: qpbit - cfqueryparam cfsqltype=CF_SQL_BIT value=#|# qpblob - cfqueryparam cfsqltype=CF_SQL_BLOB value=#|# qpdate - cfqueryparam cfsqltype=CF_SQL_TIMESTAMP value=#|# (datetime, smalldatetime) qpint - cfqueryparam cfsqltype=CF_SQL_INTEGER value=#|# qplong - cfqueryparam cfsqltype=CF_SQL_LONGVARCHAR value=#|# (text) qpvar - cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#|# Then, all you gotta do is type the first abbr and hit ctrl + j and fill in the value...enjoy- Tyler -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:44 AM To: CF-Talk Subject: RE: cfquery syntax aight, im sold. GREAT. conversion timeWOO WOO WOO! thanks guys and gal, for the insight. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:35 AM To: CF-Talk Subject: RE: cfquery syntax Yes, it should be the same for all the big databases. Even is it wasn't any faster, the data type validation using queryparam provides makes it more than worthwhile. SQL injection attacks are potentially fatal for your db server and you should not risk it. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:33 To: CF-Talk Subject: RE: cfquery syntax but what impact does it have on sql server 2000 ent edition. we don't use oracle...does this same logic apply? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:30 AM To: CF-Talk Subject: Re: cfquery syntax Tony, It's faster for the database, not necessarily for CF. In Oracle, there's this chunk of memory used for sql snippets. When a new query comes in, it looks there first, to see if it already exists. If it does, it yanks the data from there, instead of re-running/re-optimzing the query. (I would imagine there's something similar in other databases.) Anyway, using queryparam makes it so that two queries searching for different values in the where clause look like the same query to Oracle. In other words: select * from mytable where id = 1 is not the same as select * from mytable where id =2 But, if you use queryparams... select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=1 is the same to the query pool as select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=2 The query param gets translated to a bind variable, and Oracle knows that it's the same query except for this one variable. That's what makes it faster. -d - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:38 AM Subject: RE: cfquery syntax faster than the raw data being in there? how can that be? that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or less, enough of them could be slower? im not sure I get that logic? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:23 AM To: CF-Talk Subject: RE: cfquery syntax Because it's safer and faster and is therefore considered best practice. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:16 To: CF-Talk Subject: RE: cfquery syntax why should one ALWAYS use cfqueryparam? I havent, EVER and have many apps, on many servers and no problemsjust wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:14 AM To: CF-Talk Subject: RE: cfquery syntax You see the ? BECAUSE of the cfqueryparam and this is not an error. It is just a placeholder for the value. And you should ALWAYS use cfqueryparam The only exception you can make is for static values like isActive = 1 or something. And even then you can't go wrong using them. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 14:06 To: CF-Talk Subject: re: cfquery syntax I checked the database and there seems to be something
RE: query output to Excel file
STORED PROCEDURE -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 16:13 To: CF-Talk Subject: RE: query output to Excel file trouble is, I cant do it all in 1 query, I have cf logic that HAS to be there, and it is then emailed to a client :( so, is there a way to take a cfquery object that is returned, and just dump that into something, and send it, versus writing line by line by line tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| 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: query output to Excel file
The problem you will have about the excel file is that it usually writes to the SQL server local dir. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 16:09 To: CF-Talk Subject: RE: query output to Excel file interesting... may have to try that as an avenue ;) thanks! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:59 AM To: CF-Talk Subject: Re: query output to Excel file Assuming SQL Server, the easiest way would be to do a DTS export directly an excel file. If you are not using SQL Server, then there really isn't an easy way. Clint ~| 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: query output to Excel file
You can point to any excel file that the SQL Server can see. I can pump a DTS export to any excel file on our network. Clint Robertson-Ravo, Neil (RX) wrote: The problem you will have about the excel file is that it usually writes to the SQL server local dir. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 16:09 To: CF-Talk Subject: RE: query output to Excel file interesting... may have to try that as an avenue ;) thanks! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:59 AM To: CF-Talk Subject: Re: query output to Excel file Assuming SQL Server, the easiest way would be to do a DTS export directly an excel file. If you are not using SQL Server, then there really isn't an easy way. Clint ~| 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
Macromedians - Whitespace in CFMAIL?
Greetings, Some time ago a request was put through for a future release of CFMX to contain support for Whitespace in CFMAIL even when Whitespace Management is turned on in the Administrator. With all of the overhauls and improvements made to CFMAIL, why not add this small bit of functionality? It's such a pain to have to hack around the Whitespace Management function just to send properly formatted email. Granted, it's still easier than any other language, guess I'm just spoiled. How does Macromedia handle this for their outgoing mail? Or do you use something other than CFMAIL? Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://www.garrisonenterprises.net/ [EMAIL PROTECTED] (704) 569-0801 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to mailto:[EMAIL PROTECTED] [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 syntax
One thing, in addition to the no-caching with QPs, is that CF has had a bug with queryparam since at least version 5, where you can't use string functions within the value attribute...so instead of this: cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#Trim(attributes.Whatever)# You should do this: script attributes.Whatever=Trim(attributes.Whatever); /cfscript cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#attributes.Whatever# This is a good idea anyways, because you can handle all server side validation before your query inserts/updates/etc. Other than that, QPs absolutely rock: forced validation and faster execution makes your servers really happy- Tyler -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:44 AM To: CF-Talk Subject: RE: cfquery syntax aight, im sold. GREAT. conversion timeWOO WOO WOO! thanks guys and gal, for the insight. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:35 AM To: CF-Talk Subject: RE: cfquery syntax Yes, it should be the same for all the big databases. Even is it wasn't any faster, the data type validation using queryparam provides makes it more than worthwhile. SQL injection attacks are potentially fatal for your db server and you should not risk it. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:33 To: CF-Talk Subject: RE: cfquery syntax but what impact does it have on sql server 2000 ent edition. we don't use oracle...does this same logic apply? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:30 AM To: CF-Talk Subject: Re: cfquery syntax Tony, It's faster for the database, not necessarily for CF. In Oracle, there's this chunk of memory used for sql snippets. When a new query comes in, it looks there first, to see if it already exists. If it does, it yanks the data from there, instead of re-running/re-optimzing the query. (I would imagine there's something similar in other databases.) Anyway, using queryparam makes it so that two queries searching for different values in the where clause look like the same query to Oracle. In other words: select * from mytable where id = 1 is not the same as select * from mytable where id =2 But, if you use queryparams... select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=1 is the same to the query pool as select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=2 The query param gets translated to a bind variable, and Oracle knows that it's the same query except for this one variable. That's what makes it faster. -d - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:38 AM Subject: RE: cfquery syntax faster than the raw data being in there? how can that be? that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or less, enough of them could be slower? im not sure I get that logic? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:23 AM To: CF-Talk Subject: RE: cfquery syntax Because it's safer and faster and is therefore considered best practice. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:16 To: CF-Talk Subject: RE: cfquery syntax why should one ALWAYS use cfqueryparam? I havent, EVER and have many apps, on many servers and no problemsjust wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:14 AM To: CF-Talk Subject: RE: cfquery syntax You see the ? BECAUSE of the cfqueryparam and this is not an error. It is just a placeholder for the value. And you should ALWAYS use cfqueryparam The only exception you can make is for static values like isActive = 1 or something. And even then you can't go wrong using them. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 14:06 To: CF-Talk Subject: re: cfquery syntax I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to
Re: query output to Excel file
Tony, You can do anything you need to do in the cf template, writing it out as you would normal html. Excel can open an html file (formatted like a table) and it will function exactly like excel. The following code will trick the browser into thinking it's dealing with excel: CFHEADER NAME=Content-Disposition VALUE=attachment; filename=sample.xls CFCONTENT TYPE=application/excel If you're going to email the file to someone, I would think that you could use cffile to write the content (using cfsavecontent to build the page). -Deanna - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:13 AM Subject: RE: query output to Excel file trouble is, I cant do it all in 1 query, I have cf logic that HAS to be there, and it is then emailed to a client :( so, is there a way to take a cfquery object that is returned, and just dump that into something, and send it, versus writing line by line by line tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| 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: query output to Excel file
'xplainplease. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:40 AM To: CF-Talk Subject: RE: query output to Excel file STORED PROCEDURE -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 16:13 To: CF-Talk Subject: RE: query output to Excel file trouble is, I cant do it all in 1 query, I have cf logic that HAS to be there, and it is then emailed to a client :( so, is there a way to take a cfquery object that is returned, and just dump that into something, and send it, versus writing line by line by line tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| 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 syntax
If you are using SQL Server, then you may as well just up to using Stored Procedures. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 16:09 To: CF-Talk Subject: Re: cfquery syntax Tony: check out this article by Mr Forta. pretty good on explaining the reasons for using cfqueryparam: http://www.macromedia.com/devnet/mx/coldfusion/articles/ben_forta_faster.htm l as far as never having used it and not having probs...well, the same thing can be said about cflock. you don't *have* to lock your shared scope vars. your app will still run. but *should* you lock your shared scope vars? yes. I know where you're coming from. i only recently started using it. it wasn't around when i started CF, and I'm a creature of habit. found it difficult to even justify writing the extra code, which just seemed to make my SQL code that much more difficult to read. after reading enough articles like ben's above (our own Dave W. has one as well at http://www.macromedia.com/devnet/mx/coldfusion/articles/cfqueryparam.html that's worth a read), i started to force myself in the interest of writing better code. now, i see a query without cfqueryparam (usually my own old code), and i cringe. it's a difficult transition to make, i know, when you're used to just banging out SQL (and it works). but this transition is well worth the effort, in my opinion (for whatever that's worth) :) charlie - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 7:32 AM Subject: RE: cfquery syntax but what impact does it have on sql server 2000 ent edition. we don't use oracle...does this same logic apply? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:30 AM To: CF-Talk Subject: Re: cfquery syntax Tony, It's faster for the database, not necessarily for CF. In Oracle, there's this chunk of memory used for sql snippets. When a new query comes in, it looks there first, to see if it already exists. If it does, it yanks the data from there, instead of re-running/re-optimzing the query. (I would imagine there's something similar in other databases.) Anyway, using queryparam makes it so that two queries searching for different values in the where clause look like the same query to Oracle. In other words: select * from mytable where id = 1 is not the same as select * from mytable where id =2 But, if you use queryparams... select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=1 is the same to the query pool as select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=2 The query param gets translated to a bind variable, and Oracle knows that it's the same query except for this one variable. That's what makes it faster. -d - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:38 AM Subject: RE: cfquery syntax faster than the raw data being in there? how can that be? that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or less, enough of them could be slower? im not sure I get that logic? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:23 AM To: CF-Talk Subject: RE: cfquery syntax Because it's safer and faster and is therefore considered best practice. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:16 To: CF-Talk Subject: RE: cfquery syntax why should one ALWAYS use cfqueryparam? I havent, EVER and have many apps, on many servers and no problemsjust wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:14 AM To: CF-Talk Subject: RE: cfquery syntax You see the ? BECAUSE of the cfqueryparam and this is not an error. It is just a placeholder for the value. And you should ALWAYS use cfqueryparam The only exception you can make is for static values like isActive = 1 or something. And even then you can't go wrong using them. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 14:06 To: CF-Talk Subject: re: cfquery syntax I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields
COOKIES
i need some help understanding cookies. why would internet explorer set a cookie if i call the page using the ip address instead of the dns name? you can get to the main screen logging in both ways. however, if you try a menu item it acts like the cookie isn't there (which is true). this only seems to happen when i create new sites in IIS. i'm running windows 2000, iis, cfmx 6.1 tia Steven D Dworman Macromedia Certified Developer - Senior Information Technology Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com http://www.comspecinternational.com/ phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com http://www.empower-xl.com/ ~| 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 syntax
so in this scenario... select * from reports where date = '#date#' and IpAddressNumber in (#IpAddressNumberString#) what would I use? select * from reports where date = '#date#' and IpAddressNumber in (cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#ipAddressNumberString#) where ipAddressNumberString is simply a comma delimited list? thanks... tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:30 AM To: CF-Talk Subject: RE: cfquery syntax One more tip: If you're using CF Studio/HomeSite, create a few Code Templates (snippets) and you'll save some awkward typing (and some reference lookups - I've only seen the cfsqltypes defined for the major DBs in Forta's WACKs, and they differ between the dbs and even from common sense in some of the cases). I have the following set up for MS-SQL data types: qpbit - cfqueryparam cfsqltype=CF_SQL_BIT value=#|# qpblob - cfqueryparam cfsqltype=CF_SQL_BLOB value=#|# qpdate - cfqueryparam cfsqltype=CF_SQL_TIMESTAMP value=#|# (datetime, smalldatetime) qpint - cfqueryparam cfsqltype=CF_SQL_INTEGER value=#|# qplong - cfqueryparam cfsqltype=CF_SQL_LONGVARCHAR value=#|# (text) qpvar - cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#|# Then, all you gotta do is type the first abbr and hit ctrl + j and fill in the value...enjoy- Tyler -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:44 AM To: CF-Talk Subject: RE: cfquery syntax aight, im sold. GREAT. conversion timeWOO WOO WOO! thanks guys and gal, for the insight. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:35 AM To: CF-Talk Subject: RE: cfquery syntax Yes, it should be the same for all the big databases. Even is it wasn't any faster, the data type validation using queryparam provides makes it more than worthwhile. SQL injection attacks are potentially fatal for your db server and you should not risk it. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:33 To: CF-Talk Subject: RE: cfquery syntax but what impact does it have on sql server 2000 ent edition. we don't use oracle...does this same logic apply? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:30 AM To: CF-Talk Subject: Re: cfquery syntax Tony, It's faster for the database, not necessarily for CF. In Oracle, there's this chunk of memory used for sql snippets. When a new query comes in, it looks there first, to see if it already exists. If it does, it yanks the data from there, instead of re-running/re-optimzing the query. (I would imagine there's something similar in other databases.) Anyway, using queryparam makes it so that two queries searching for different values in the where clause look like the same query to Oracle. In other words: select * from mytable where id = 1 is not the same as select * from mytable where id =2 But, if you use queryparams... select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=1 is the same to the query pool as select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=2 The query param gets translated to a bind variable, and Oracle knows that it's the same query except for this one variable. That's what makes it faster. -d - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:38 AM Subject: RE: cfquery syntax faster than the raw data being in there? how can that be? that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or less, enough of them could be slower? im not sure I get that logic? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:23 AM To: CF-Talk Subject: RE: cfquery syntax Because it's safer and faster and is therefore considered best practice. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:16 To: CF-Talk Subject: RE: cfquery syntax why should one ALWAYS use cfqueryparam? I havent, EVER and have many apps, on many servers and no problemsjust wondrin' tony weeg sr. web
RE: query output to Excel file
you would first create it in the sql server, then you can actually kickstart it using that weird string it creates to reference itself... the one that looks like this... EXECUTE master.dbo.xp_sqlmaint N'-PlanID A173BEC9-1178-4B2D-91A4-5ED8B2DCB2B8 -To Admin EMail -VrfyBackup -BkUpMedia DISK -BkUpLog H:\transactionLogBackup -DelBkUps 3HOURS -BkExt TRN' I think. I know someone talked about it at some point on here...but that's a way to do it, I think. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:33 AM To: CF-Talk Subject: query output to Excel file What is a DTS export? Is it something that can be kicked off by cf, or is it just a manual export? Assuming SQL Server, the easiest way would be to do a DTS export directly an excel file. If you are not using SQL Server, then there really isn't an easy way. Clint ~| 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: DWMX 2004 - Whats new for us?
Thomas Chiverton wrote: On Thursday 04 Sep 2003 15:32 pm, Matt Liotta wrote: Right. But if your hosting provider has wiped out cffile ... ? Then I am sure they won't let you install a CFX that does the same thing. I don't think they'd have any choice. Of course, what they should do, is provide a cf_file which is a wrapper round cffile, but appends your hosted directory path to all the path/filename arguments or something. What they should do is not disable cffile in the first place, but secure it. Jochem ~| 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: COOKIES
Because cookies are uniquely identified by the domain name. They aren't complicated, and don't look up or store the IP of what that domain name resolves to. And because of that, there's no way for a cookie to know that the content at address X is the same as that at address Y. It would certainly be possible for browsers to be accommodating and when they hit a domain and do a dns/ip lookup then they could look for a match for either name or address, but they don't have to and as you've seen you obviously can't count on it. -Kevin - Original Message - From: Steve Dworman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:35 AM Subject: COOKIES i need some help understanding cookies. why would internet explorer set a cookie if i call the page using the ip address instead of the dns name? you can get to the main screen logging in both ways. however, if you try a menu item it acts like the cookie isn't there (which is true). this only seems to happen when i create new sites in IIS. i'm running windows 2000, iis, cfmx 6.1 tia Steven D Dworman Macromedia Certified Developer - Senior Information Technology Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com http://www.comspecinternational.com/ phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com http://www.empower-xl.com/ ~| 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: DWMX 2004 - Whats new for us?
Better yet, why can't MM add some hosting-friendly options to the server global settings so that they can address a need for a major customer segment? Does a list of potential options exist? If we don't ask as a group with a unified voice, the request will never work its way to the top of the To-Do list. Kevin -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:20 AM To: CF-Talk Subject: Re: DWMX 2004 - Whats new for us? I don't think they'd have any choice. Of course, what they should do, is provide a cf_file which is a wrapper round cffile, but appends your hosted directory path to all the path/filename arguments or something. ~| 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
meeting room booking application
Anybody know of a 'meeting room booking' application in CF? I've done some searches but not found quite the right thing. Seems to me it must be a common kind of requirement to manage shared resources on an intranet. Of course if we had the time we could write one... ;-) Michael Traher Systems Manager ~| 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: Macromedians - Whitespace in CFMAIL?
Why not simply manage your whitespace yourself using cfsetting? === 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: Joshua Miller [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:24 AM To: CF-Talk Subject: Macromedians - Whitespace in CFMAIL? Greetings, Some time ago a request was put through for a future release of CFMX to contain support for Whitespace in CFMAIL even when Whitespace Management is turned on in the Administrator. With all of the overhauls and improvements made to CFMAIL, why not add this small bit of functionality? It's such a pain to have to hack around the Whitespace Management function just to send properly formatted email. Granted, it's still easier than any other language, guess I'm just spoiled. How does Macromedia handle this for their outgoing mail? Or do you use something other than CFMAIL? Thanks, ~| 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 syntax
Tony, The cfqueryparam tag supports list syntax - use a LIST=YES attribute a la: cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#ipAddressNumberString# LIST=YES -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:58 AM To: CF-Talk Subject: RE: cfquery syntax so in this scenario... select * from reports where date = '#date#' and IpAddressNumber in (#IpAddressNumberString#) what would I use? select * from reports where date = '#date#' and IpAddressNumber in (cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#ipAddressNumberString#) where ipAddressNumberString is simply a comma delimited list? thanks... tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:30 AM To: CF-Talk Subject: RE: cfquery syntax One more tip: If you're using CF Studio/HomeSite, create a few Code Templates (snippets) and you'll save some awkward typing (and some reference lookups - I've only seen the cfsqltypes defined for the major DBs in Forta's WACKs, and they differ between the dbs and even from common sense in some of the cases). I have the following set up for MS-SQL data types: qpbit - cfqueryparam cfsqltype=CF_SQL_BIT value=#|# qpblob - cfqueryparam cfsqltype=CF_SQL_BLOB value=#|# qpdate - cfqueryparam cfsqltype=CF_SQL_TIMESTAMP value=#|# (datetime, smalldatetime) qpint - cfqueryparam cfsqltype=CF_SQL_INTEGER value=#|# qplong - cfqueryparam cfsqltype=CF_SQL_LONGVARCHAR value=#|# (text) qpvar - cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#|# Then, all you gotta do is type the first abbr and hit ctrl + j and fill in the value...enjoy- Tyler -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:44 AM To: CF-Talk Subject: RE: cfquery syntax aight, im sold. GREAT. conversion timeWOO WOO WOO! thanks guys and gal, for the insight. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:35 AM To: CF-Talk Subject: RE: cfquery syntax Yes, it should be the same for all the big databases. Even is it wasn't any faster, the data type validation using queryparam provides makes it more than worthwhile. SQL injection attacks are potentially fatal for your db server and you should not risk it. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:33 To: CF-Talk Subject: RE: cfquery syntax but what impact does it have on sql server 2000 ent edition. we don't use oracle...does this same logic apply? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:30 AM To: CF-Talk Subject: Re: cfquery syntax Tony, It's faster for the database, not necessarily for CF. In Oracle, there's this chunk of memory used for sql snippets. When a new query comes in, it looks there first, to see if it already exists. If it does, it yanks the data from there, instead of re-running/re-optimzing the query. (I would imagine there's something similar in other databases.) Anyway, using queryparam makes it so that two queries searching for different values in the where clause look like the same query to Oracle. In other words: select * from mytable where id = 1 is not the same as select * from mytable where id =2 But, if you use queryparams... select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=1 is the same to the query pool as select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=2 The query param gets translated to a bind variable, and Oracle knows that it's the same query except for this one variable. That's what makes it faster. -d - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:38 AM Subject: RE: cfquery syntax faster than the raw data being in there? how can that be? that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or less, enough of them could be slower? im not sure I get that logic? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:23 AM To: CF-Talk Subject: RE: cfquery syntax Because it's safer and faster and is therefore considered best
query output to Excel file
What is a DTS export? Is it something that can be kicked off by cf, or is it just a manual export? ~| 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 syntax
cool. maybe its just time to read up on the details. esp. since im breaking down and taking the cfmx exam @ max2003 DAMMIT! must read2E tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 12:12 PM To: CF-Talk Subject: RE: cfquery syntax Tony, The cfqueryparam tag supports list syntax - use a LIST=YES attribute a la: cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#ipAddressNumberString# LIST=YES -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:58 AM To: CF-Talk Subject: RE: cfquery syntax so in this scenario... select * from reports where date = '#date#' and IpAddressNumber in (#IpAddressNumberString#) what would I use? select * from reports where date = '#date#' and IpAddressNumber in (cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#ipAddressNumberString#) where ipAddressNumberString is simply a comma delimited list? thanks... tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:30 AM To: CF-Talk Subject: RE: cfquery syntax One more tip: If you're using CF Studio/HomeSite, create a few Code Templates (snippets) and you'll save some awkward typing (and some reference lookups - I've only seen the cfsqltypes defined for the major DBs in Forta's WACKs, and they differ between the dbs and even from common sense in some of the cases). I have the following set up for MS-SQL data types: qpbit - cfqueryparam cfsqltype=CF_SQL_BIT value=#|# qpblob - cfqueryparam cfsqltype=CF_SQL_BLOB value=#|# qpdate - cfqueryparam cfsqltype=CF_SQL_TIMESTAMP value=#|# (datetime, smalldatetime) qpint - cfqueryparam cfsqltype=CF_SQL_INTEGER value=#|# qplong - cfqueryparam cfsqltype=CF_SQL_LONGVARCHAR value=#|# (text) qpvar - cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#|# Then, all you gotta do is type the first abbr and hit ctrl + j and fill in the value...enjoy- Tyler -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:44 AM To: CF-Talk Subject: RE: cfquery syntax aight, im sold. GREAT. conversion timeWOO WOO WOO! thanks guys and gal, for the insight. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:35 AM To: CF-Talk Subject: RE: cfquery syntax Yes, it should be the same for all the big databases. Even is it wasn't any faster, the data type validation using queryparam provides makes it more than worthwhile. SQL injection attacks are potentially fatal for your db server and you should not risk it. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:33 To: CF-Talk Subject: RE: cfquery syntax but what impact does it have on sql server 2000 ent edition. we don't use oracle...does this same logic apply? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:30 AM To: CF-Talk Subject: Re: cfquery syntax Tony, It's faster for the database, not necessarily for CF. In Oracle, there's this chunk of memory used for sql snippets. When a new query comes in, it looks there first, to see if it already exists. If it does, it yanks the data from there, instead of re-running/re-optimzing the query. (I would imagine there's something similar in other databases.) Anyway, using queryparam makes it so that two queries searching for different values in the where clause look like the same query to Oracle. In other words: select * from mytable where id = 1 is not the same as select * from mytable where id =2 But, if you use queryparams... select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=1 is the same to the query pool as select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=2 The query param gets translated to a bind variable, and Oracle knows that it's the same query except for this one variable. That's what makes it faster. -d - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:38 AM Subject: RE: cfquery syntax faster than the raw data being in there? how can that be? that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or
Version Specific Software
Does anyone know of software like MS Visual Source Safe that would work for CF? Dan Phillips www.CFXHosting.com 1-866-239-4678 [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 syntax
that makes sense ;) tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:28 AM To: CF-Talk Subject: Re: cfquery syntax I would imagine that SQL Server has a similar cached query pool but I really don't know, as I don't use it. I can tell you that our DBA's really really like us when we use it, and really really don't when we don't use it. ;) -d - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:32 AM Subject: RE: cfquery syntax but what impact does it have on sql server 2000 ent edition. we don't use oracle...does this same logic apply? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:30 AM To: CF-Talk Subject: Re: cfquery syntax Tony, It's faster for the database, not necessarily for CF. In Oracle, there's this chunk of memory used for sql snippets. When a new query comes in, it looks there first, to see if it already exists. If it does, it yanks the data from there, instead of re-running/re-optimzing the query. (I would imagine there's something similar in other databases.) Anyway, using queryparam makes it so that two queries searching for different values in the where clause look like the same query to Oracle. In other words: select * from mytable where id = 1 is not the same as select * from mytable where id =2 But, if you use queryparams... select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=1 is the same to the query pool as select * from mytable where id = cfqueryparam cfsqltype=cf_sql_integer value=2 The query param gets translated to a bind variable, and Oracle knows that it's the same query except for this one variable. That's what makes it faster. -d - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:38 AM Subject: RE: cfquery syntax faster than the raw data being in there? how can that be? that's just one more tag that cfserver has to interpret process etc...albeit a millisecond or less, enough of them could be slower? im not sure I get that logic? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:23 AM To: CF-Talk Subject: RE: cfquery syntax Because it's safer and faster and is therefore considered best practice. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:16 To: CF-Talk Subject: RE: cfquery syntax why should one ALWAYS use cfqueryparam? I havent, EVER and have many apps, on many servers and no problemsjust wondrin' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:14 AM To: CF-Talk Subject: RE: cfquery syntax You see the ? BECAUSE of the cfqueryparam and this is not an error. It is just a placeholder for the value. And you should ALWAYS use cfqueryparam The only exception you can make is for static values like isActive = 1 or something. And even then you can't go wrong using them. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 14:06 To: CF-Talk Subject: re: cfquery syntax I checked the database and there seems to be something wrong with the cfqueryparam because when I check the fields using SQL Query Analyzer there are question marks ? in the fields which I think is an error trying to update the fields? Do I need the cfqueryparam? On Thu, 04 Sep 2003 07:55:24 -0400, Bushy wrote: Hi, What's wrong with the below syntax? I think the single quotes around the commalist is throwing it for a loop? How can I get around this? If I use double quotes I'll run into the same problem around the ListGetAt... code. cfquery name=Insert datasource=prefs UPDATE tblProfiles SET strSelect='cfqueryparam value=#ListGetAt(commalist,1,'|')# cfsqltype=CF_SQL_LONGVARCHAR' WHERE strUsername='#auth#' /cfquery ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription:
RE: urlSessionFormat
Yeah, IIS doesn't support URL parameters in that format. Your mileage may vary with other web servers though. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 9:56 PM To: CF-Talk Subject: RE: urlSessionFormat Nevermind... I found out it's correct, but throws a 404 in IIS. -Brad -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 5:27 PM To: CF-Talk Subject: urlSessionFormat Sorry... Outlook interpreted enter as send message NOW! Why would I get the following: index.cfm;jsessionid=d0301063761062624168989 Where would the ; be coming from? The code is simply: cfoutput#urlSessionFormat(index.cfm)#/cfoutput -Brad ~| 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
performance of ThisTag.GeneratedContent
Hi, This is a question regarding the *performance* of using ThisTag.GeneratedContent inside a custom tag Here is an example: cf_pageBody lots of generated html code (worst case: say an online report: 1-2 MB) . /cf_pageBody Will ColdFusion save this very big string chunk into a new variable ThisTag.GeneratedContent for use in the custom tag? If so, is this a big hit on performance and memory? (think in terms of traffic / site load). OR: is the ColdFusion engine doing some trick by placing pointers around some output stack (in order to save on performance/memory) Next, does it make a difference if I dont reference the ThisTag.GeneratedContent inside my custom tag? (in other words, I just let coldfusion automatically dump the generated content out ) Basically, my tag would do the following: cfif ThisTag.ExecutionMode IS START body !--- my body header --- cfelseif ThisTag.ExecutionMode IS END !--- coldfusion automatically dumps generated content --- !--- my body footer --- /body /cfif would the above avoid a performance/memory hit? or will any ThisTag.GeneratedContent performance hit be incurred even if its not referenced? .. basically, because some blocks would contain large html files (online reports), I wanted to know if ThisTag.GeneratedContent would slow things down, especially with increasing traffic/load. To get around any performance hit, there would be two alternate solutions: (1) cf_pageBody_start my html body cf_pageBody_end (2) body cfinclude = body_header.cfm my html body cfinclude = body_header.cfm /body I would much prefer using cf_pageBody/cfpageBody if the performance hit is negligible. Thank you for reading this long post!! Any insights are greatly appreciated! Michael _ Compare Cable, DSL or Satellite plans: As low as $29.95. https://broadband.msn.com ~| 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
