Re: What the heck is happening during CFQUERY?
On Sun, Mar 8, 2009 at 11:42 PM, Claude Schneegans wrote: I've always thought that all what CFQUERY was doing was to create some connection to the database, and then the actual content of all records would be read as needed during some loop on the result set. That would be impossible for CF to do because: - if the resultset were never used the query would never be run on the server; - if the resultset were used multiple times the query would be run multiple times on the server; - the number of records would be unknown. If you want that, declare a cursor and deal with those consequences yourself. SELECT armeId, armTexte FROM armesArmoriaux The query semms to take for ever. Actually, the output says: getArmes.recordCount = 303203 cfquery.ExecutionTime = 614469 More than 10 min. just to settle a result set? That does not make sense. Ok, armTexte is a memo field, but is CFQUERY supposed to read all of them? I do not think 2 ms per record is all that much for Access. So, what the heck CF is doing within CFQUERY? Read all content? That does not make sense. Is the problem with CF, or the ODBC driver? There is a reason the docs warn not to use ODBC But you might be trashing memory as well.. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320254 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: phpBB to Galleon migration?
I am not aware of anyone doing so - but if you are able to get it working, please contact me offlist. I could include the work, or maybe even just a description of the work, within the Galleon documentation. On Sun, Mar 8, 2009 at 1:12 PM, Seb Duggan s...@sebduggan.com wrote: Has anyone ever carried out a successful migration from phpBB to Galleon (or even any other CF-based forum)? After wasting nearly a whole Sunday trying to get PHP installed and running on a new web server (just to transfer across an existing phpBB forum), I've really had enough of PHP (although it's working now.) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320255 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cftree not working on CF 8
On Friday 06 Mar 2009, N K wrote: I have menu list of items being displayed through CFtree using foramt=flash. The same code works on CF 7 but does not work on CF 8. Any idea what would lead to this? What is being output on the page ? Are all the referenced resources being loaded ? -- Tom Chiverton Helping to enthusiastically restore 24/7 web-readiness as part of the IT team of the year, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320256 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8 Image manipulation
Not sure if anyone else has posted this since I started reading this thread... http://www.webresourcesdepot.com/jquery-image-crop-plugin-jcrop/ Thanks, Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320257 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What the heck is happening during CFQUERY?
That doesn't work because getArmes contains only a count of the records in armesArmoriaux, not the actual records. -Original Message- From: Al Musella, DPM [mailto:muse...@virtualtrials.com] Sent: Sunday, March 08, 2009 7:37 PM To: cf-talk Subject: Re: What the heck is happening during CFQUERY? Change it to this and the time should go down by a factor of about 100,000 : CFQUERY NAME=getArmes DATASOURCE=Armoriaux SELECT count (*) as N FROM armesArmoriaux /CFQUERY CFOUTPUTgetArmes.recordCount = #getArmes.n#BR cfquery.ExecutionTime = #cfquery.ExecutionTime#BR/CFOUTPUTCFABORT ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320258 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Compare FieldValues with DataBase Values
I appologise if I really confused you and I am still learning the Coldfusion and I am unable to code in a proper way. These are my ColdFuion Fields in the Coldfusion page: FirstName, LastName,Address,PhoneNumber, EmployerID, DepartmentID , DepartmentName, EmployerID, Branch Sql Database Tables: Table1: Employer FirstName, LastName,Address,PhoneNumber, EmployerID (Primary Key) Daniel RayNJ 123-123-2123 1234 Ria ParksNj 124-123-1234 1221 EmloyerID is the Primary key. Table2: Department DepartmentID , DepartmentName, EmployerID, Branch, SNO(Unique Identifier) 12 Economics 1234NJ 111 13 Physics1234NJ 121 12 Economics 1221PA 123 EmployerID can be repeated but not SNO should be unique. I need to do two things. 1. Depending on the entry of the formfield values. The database tables should be either inserted or updated. If the row already exsist then the row should be inserted and if exsist row should be updated. eg: I need to add the Chemistry DepartmentNAme to the EmployerID 1234. I need to check before the insert statement whether or not the data in the table. How do I really check this. 2. Once the action takes place either update or delete, I need to display the list of the action taken place in the user session on the coldfusion page. Session is just the user session here. eg: DepartmentName for 1234 is insesrted Salary for 1221 has been updated . . . Hope I am very clear now... Thanks, Priya I have an issue and I am out of my mind.. to solve it. FieldNames: FirstName, LastName,Address,PhoneNumber, EmployerID, DepartmentID , DepartmentName, EmployerID, Branch Ok, what about these field names? Can you explain for us please? Are these columns in a table? Columns in a result set? Do you realize you have EmployerID in there twice?? Table Employee FirstName, LastName,Address,PhoneNumber, EmployerID Is EmployerID the primary key or a foreign key? I would have expected it to be called EmployeeID if it were the primary key, since an employer employs the employee. Table Department DepartmentID , DepartmentName, EmployerID, Branch I have a FirstName attribute in the table and I want to compare these attribute (FirstName) with the fieldvalue. What field value?? Is this in a ColdFusion page or a SQL statement? Where is the fieldvalue coming from? A form? The Url? In what way do you want to compare? Do you want to compare a single record, or more than one? ? I thought of using arrays but I don't know how to add database date to the array and compare. What is a database date? None of the columns you have mentioned so far seem to have anything to do with dates. Setting a date into an array is easy as cfset myArray = [now()] but I'm not sure where you are going with this. I also have one more issue. I am trying to insert data into the database and once the data is inserted the inserted (FirstName) should be displayed (Primary Key is EmployerID). What table is this? The employee table? If EmployerID is the primary key of the Employee table, why is that column also in the Department table? If two people are in the same department, do you have two department records with the same department name, but different EmployerIds? I'm quite confused. If I add n number of FirstNames in the table in the session then it should display those many New entry values in the main page. How can we do it? Is the table in session, or do you simply mean inserts into the database during a user's session? So you want to have a screen that shows someone the records they entered since their session started? You could store the data in a session variable, or store the primary key of the records they inserted. I'm not sure where you are headed, but this would also be possible if you had a userIDModified in the table and a datetimeCreated column. You could simply query out the records that user had inserted since the time their session started. Can anyone help me with this? Probably, but we need a bit more direction on what it is you are doing. I'm pretty bad at guessing. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
Yeah, but what are you going to do with 300,000 actual records in a single recordset? In his original post, Claude never specified what the requirements of his CFQUERY were - if we knew what he was trying to achieve, we could provide better advice on how to do it... On 9 Mar 2009, at 13:44, Billy Cox wrote: That doesn't work because getArmes contains only a count of the records in armesArmoriaux, not the actual records. -Original Message- From: Al Musella, DPM [mailto:muse...@virtualtrials.com] Sent: Sunday, March 08, 2009 7:37 PM To: cf-talk Subject: Re: What the heck is happening during CFQUERY? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320260 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cftree not working on CF 8
Nothing is displayed.Yes all the other part of the page is being displayed. The debugging section shows that the query is running,nothing seems to be wrong. On Friday 06 Mar 2009, N K wrote: I have menu list of items being displayed through CFtree using foramt=flash. The same code works on CF 7 but does not work on CF 8. Any idea what would lead to this? What is being output on the page ? Are all the referenced resources being loaded ? -- Tom Chiverton Helping to enthusiastically restore 24/7 web-readiness as part of the IT team of the year, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells. co ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320261 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare FieldValues with DataBase Values
one sure-fire way to check if the data exists in a table is to run a SELECT query to select that data. then check the recordcount of the select query - if it is 0 then no such data exists; otherwise the data is already there. depending on your db and exact requirements you may be able to use db-specific ways to do it. i.e. MySQL has a ON DUPLICATE KEY UPDATE clause one can use in an INSERT query which will update rows instead of inserting new rows if specified PK value already exists in a table. but since you seem to need to notify user of exact action taken (insert or update) that may not be useful in your case... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Priya Koya wrote: I appologise if I really confused you and I am still learning the Coldfusion and I am unable to code in a proper way. These are my ColdFuion Fields in the Coldfusion page: FirstName, LastName,Address,PhoneNumber, EmployerID, DepartmentID , DepartmentName, EmployerID, Branch Sql Database Tables: Table1: Employer FirstName, LastName,Address,PhoneNumber, EmployerID (Primary Key) Daniel RayNJ 123-123-2123 1234 Ria ParksNj 124-123-1234 1221 EmloyerID is the Primary key. Table2: Department DepartmentID , DepartmentName, EmployerID, Branch, SNO(Unique Identifier) 12 Economics 1234NJ 111 13 Physics1234NJ 121 12 Economics 1221PA 123 EmployerID can be repeated but not SNO should be unique. I need to do two things. 1. Depending on the entry of the formfield values. The database tables should be either inserted or updated. If the row already exsist then the row should be inserted and if exsist row should be updated. eg: I need to add the Chemistry DepartmentNAme to the EmployerID 1234. I need to check before the insert statement whether or not the data in the table. How do I really check this. 2. Once the action takes place either update or delete, I need to display the list of the action taken place in the user session on the coldfusion page. Session is just the user session here. eg: DepartmentName for 1234 is insesrted Salary for 1221 has been updated . . . Hope I am very clear now... Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320262 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What the heck is happening during CFQUERY?
More specifically, what are you going to do with 300,000 ntext fields ... that could potentially be many GB of data, which the server will be holding in active memory. As a general rule, I leave my ntext fields out of any query that's pulling a list of more than a few items. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320263 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare FieldValues with DataBase Values
Yes, I can use select statement but I am able to display only the latest taction taken to the coldfusion page but not all the list of actions taken in a user session. On Mon, Mar 9, 2009 at 9:40 AM, Azadi Saryev az...@sabai-dee.com wrote: one sure-fire way to check if the data exists in a table is to run a SELECT query to select that data. then check the recordcount of the select query - if it is 0 then no such data exists; otherwise the data is already there. depending on your db and exact requirements you may be able to use db-specific ways to do it. i.e. MySQL has a ON DUPLICATE KEY UPDATE clause one can use in an INSERT query which will update rows instead of inserting new rows if specified PK value already exists in a table. but since you seem to need to notify user of exact action taken (insert or update) that may not be useful in your case... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Priya Koya wrote: I appologise if I really confused you and I am still learning the Coldfusion and I am unable to code in a proper way. These are my ColdFuion Fields in the Coldfusion page: FirstName, LastName,Address,PhoneNumber, EmployerID, DepartmentID , DepartmentName, EmployerID, Branch Sql Database Tables: Table1: Employer FirstName, LastName,Address,PhoneNumber, EmployerID (Primary Key) Daniel RayNJ 123-123-2123 1234 Ria ParksNj 124-123-1234 1221 EmloyerID is the Primary key. Table2: Department DepartmentID , DepartmentName, EmployerID, Branch, SNO(Unique Identifier) 12 Economics 1234NJ 111 13 Physics1234NJ 121 12 Economics 1221PA 123 EmployerID can be repeated but not SNO should be unique. I need to do two things. 1. Depending on the entry of the formfield values. The database tables should be either inserted or updated. If the row already exsist then the row should be inserted and if exsist row should be updated. eg: I need to add the Chemistry DepartmentNAme to the EmployerID 1234. I need to check before the insert statement whether or not the data in the table. How do I really check this. 2. Once the action takes place either update or delete, I need to display the list of the action taken place in the user session on the coldfusion page. Session is just the user session here. eg: DepartmentName for 1234 is insesrted Salary for 1221 has been updated . . . Hope I am very clear now... Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What the heck is happening during CFQUERY?
It gets a connection from the pool, queries the DB, retrieves all the data and finally returns the connection to the pool. Well, I'm stunned. I was sure CF was better designed than that. I thought that data was retrieved as loops were going. Obviously course, with 300k records, CF is reading all data from disk, from a system especially designed to handle and retrieve data, put it back on disk, and then gets it back again into memory as loops goes. This is ridiculous. Even dBase was designed to retrieve data by chunks only when needed. I can't believe this. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320265 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
FYI: Windows DATE/TIME Glitch affecting CF DATE/TIME Functions
I noticed a little Windows bug this AM that may affect some of you. My system clock was showing the correct time, but my CF generated dates and times were an hour off (behind an hour). This was affecting data base postings, timestamps, etc. To correct this I had to turn off the systems Automatically Adjust for Daylight Savings Time option and manually reset the system date/time to the correct time. Apparently Windows adjusted only the clock display and not the system date/time. Everyone running Windows systems may want to check this if they are using CF date/time functions. I'm sure not all version of Windows have this issue, but apparently some do. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FYI: Windows DATE/TIME Glitch affecting CF DATE/TIME Functions
Is your version of Java patched for the latest daylight savings dates? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/3/10 Robert Harrison rob...@austin-williams.com: I noticed a little Windows bug this AM that may affect some of you. My system clock was showing the correct time, but my CF generated dates and times were an hour off (behind an hour). This was affecting data base postings, timestamps, etc. To correct this I had to turn off the systems Automatically Adjust for Daylight Savings Time option and manually reset the system date/time to the correct time. Apparently Windows adjusted only the clock display and not the system date/time. Everyone running Windows systems may want to check this if they are using CF date/time functions. I'm sure not all version of Windows have this issue, but apparently some do. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
I don't think this is unexpected behaviour It is not only unexpected, it is completely retarded. All ODBC/JDBC functions are designed so the database can be connected, then the SQL statement be compiled, then data retrieved row by row, as needed. Even dBase, Clipper, Foxpro worked this way. - you just need to examine what you actually require from the query Well, I made a request to get only the record Id, it take only 6 seconds, then I read again each record with the data I need in the loop. I am creating an index on words found in memo fields, and I need to loop on all records in the table. I'm doing this once for all on my development server, I don't care if it takes hours, but 10 min, just to create the query, it looked like infinity to me. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320268 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
There are a number of reasons why running the select directly in Access may appear much faster. 1) You are probably running it locally so there is no costly transfer of data between servers. I'm running the CF app locally also, so the difference does not come from connexion time. Anywa, the result is just a 2 lines message. 2) In my experience, Access spools the data behind the scenes and only loads in the records which are visible Of course, and there is nothing extraordinary there : ALL database systems work this way. They will get the records only when needed, and ODBC also has also been designed in that purpose. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320269 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
Change it to this and the time should go down by a factor of about 100,000 Thanks, you bet this is what I would have done if I only needed the number of records ;-) The output of recordCount was there only for illustration purpose. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320270 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What the heck is happening during CFQUERY?
On Mon, Mar 9, 2009 at 4:18 PM, Claude Schneegans wrote: All ODBC/JDBC functions are designed so the database can be connected, then the SQL statement be compiled, then data retrieved row by row, as needed. CF just needs all the records all the time because that is the only way to get a recordcount. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320271 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
More specifically, what are you going to do with 300,000 ntext fields I am creating a cross table index on word found in memo fields. Each memo field needs some special treatment and only some specific words are retrieved. So I need to simply read all records and loop on them. I found another way to read records one at a time. This is a one time job on a database. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320272 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
- if the resultset were never used the query would never be run on the server; Well, if the result set is not used, what is the advantage of having the query run anyway? - if the resultset were used multiple times the query would be run multiple times on the server; If the result set is too large to fit in memory, it will be rewritten and reread from disk every time anyway. - the number of records would be unknown. Most of the time, one only needs to know if there are records or not. This can be checked reading the first record only. May be some parameter in CFQUERY (ie RECORDS=onTheFly) could be used to create on the fly queries. It will be up to the programmer to use it if he expects the query to generate lots of data. In that sense, the parameter blockFactor in CFQUERY is missleading: it says Specifies the maximum number of rows to fetch at a time from the server. The range is 1 (default) So I thought that CF was getting rows one at a time. Apparently, it is getting all rows one at a time in the same time ;-) Doesn't make much sense to me ;-) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320273 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
CF just needs all the records all the time because that is the only way to get a recordcount. While I don't think that is quite true, I do think there is a good reason for having the resultset downloaded at once. ColdFusion expects you to use the recordset within the single request and this differs from an offline application where it can make sense to keep a connection open to a resultset. Indeed, while the initial query may take longer, it is perhaps better performing than hitting the db on each iteration within the request. Thoughts? Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320274 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What the heck is happening during CFQUERY?
just out of curiosity: did you try experimenting with BLOCKFACTOR attribute of cfquery? i am just curious, since you already are retrieving such a large dataset, if using blockfactor makes any difference at all on processing time... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Claude Schneegans wrote: Change it to this and the time should go down by a factor of about 100,000 Thanks, you bet this is what I would have done if I only needed the number of records ;-) The output of recordCount was there only for illustration purpose. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320275 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare FieldValues with DataBase Values
that's because you are probably over-writing some variable you created to hold the action with each subsequent action... use an array or structure to hold all your action, append each new action taken to this array/structure, then loop over it to display all actions taken Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Priya Koya wrote: Yes, I can use select statement but I am able to display only the latest taction taken to the coldfusion page but not all the list of actions taken in a user session. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320276 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What the heck is happening during CFQUERY?
IIRC, blockFactor is only relevant on the Oracle drivers, and it refers specifically to how Oracle expects to batch and return large recordsets. If Oracle is allowed to spool out large recordsets without returning them in blocks, it will often spin the DB server out of threads, which then cascades to the waiting app threads ... and then things die. Blockfactor, therefore, controls how the DB server batch responds to the request, but it does not impact how CF brings data back into its CFQUERY struct. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare FieldValues with DataBase Values
Yes, that was much clearer. Thank you :) Are you using the cfapplication tag in your application? Do you have session management enabled? If so, you can keep a list of the user's operations in a session variable. cfset session.array_of_user_actions = arrayNew(1) cfset arrayAppend(session.array_of_user_actions,User Inserted Record A) cfset arrayAppend(session.array_of_user_actions,User Updated Record B) cfset arrayAppend(session.array_of_user_actions,User Scratched His Head) This would create an array that you could append to as you saw fit with the user's actions. I don't neccessarily think it's the best way to audit your users actions, but it would work. Session variables do not get deleted at the end of your page request. They will be available on each subsequent request from the same user providing his session has not timed out. h3User's Activity During This Session/h3 cfloop array=#session.array_of_user_actions# index=this_action #this_action#br /cfloop As far as knowing whether you are inserting or updating-- Generally when a user is updating a record, he selects it from some list and you populate the values for it into a form. At that point simply place the primary key from that table in a hidden field in the form. When you submit the form, the processing page can look for the existence of that hidden form field. If the primary key was passed, it's an update, otherwise it's an insert. ~Brad - Original Message - From: Priya Koya priya23...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Monday, March 09, 2009 9:49 AM Subject: Re: Compare FieldValues with DataBase Values Yes, I can use select statement but I am able to display only the latest taction taken to the coldfusion page but not all the list of actions taken in a user session. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320278 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
because that is the only way to get a recordcount. A big price in efficiency to pay for something we use only sometimes. Most of the time, we only need to know if there are records or not. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320279 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
If that's all you need to know, use SELECT TOP 1... On Mon, Mar 9, 2009 at 11:05 AM, Claude Schneegans schneeg...@internetique.com wrote: because that is the only way to get a recordcount. A big price in efficiency to pay for something we use only sometimes. Most of the time, we only need to know if there are records or not. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320280 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FYI: Windows DATE/TIME Glitch affecting CF DATE/TIME Functions
Is your version of Java patched for the latest daylight savings dates? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320281 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
What we are really talking about here is having the right tool for the job. dBase, Clipper and FoxPro are all database management systems, and so are designed to work efficiently in examples like the one you are citing. ColdFusion is a Web Application server, designed to interact with a database to deliver web content. By the very nature of Web applications, you wouldn't want to be leaving open database connections all over the place - the surest way to crash a server under heavy load... Really, all the heavy lifting should be done within the database itself; but out of preference I don't think I'd be using Acces for this! However, you can do what you want using ColdFusion; I've done similar stuff in the past when the updating has required extra ColdFusion logic. I would just recommend doing it in chunks of data - maybe 5000 records at a time? Grab the first 5000 records; process them; then do the next 5000... I don't think this is unexpected behaviour It is not only unexpected, it is completely retarded. All ODBC/JDBC functions are designed so the database can be connected, then the SQL statement be compiled, then data retrieved row by row, as needed. Even dBase, Clipper, Foxpro worked this way. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320282 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare FieldValues with DataBase Values
ohh yes.. Thanks a lot. On Mon, Mar 9, 2009 at 10:56 AM, Azadi Saryev az...@sabai-dee.com wrote: that's because you are probably over-writing some variable you created to hold the action with each subsequent action... use an array or structure to hold all your action, append each new action taken to this array/structure, then loop over it to display all actions taken Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Priya Koya wrote: Yes, I can use select statement but I am able to display only the latest taction taken to the coldfusion page but not all the list of actions taken in a user session. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320283 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
Indeed, while the initial query may take longer, it is perhaps better performing than hitting the db on each iteration within the request. Thoughts? Perfectly right for small result sets. But as soon as the virtual memory must be used, each record will generate some read-write-reread action, pretty bad on performance indeed. IMHO, CF should should be able to buffer the record set, ie. read a certain number of records until a certain amount of memory is full, then do as usual if the whole record set fits in memory, and read the next buffer when needed. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320284 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
did you try experimenting with BLOCKFACTOR attribute of cfquery? i am just curious, since you already are retrieving such a large dataset, if using blockfactor makes any difference at all on processing time... The blockfactor is supposed to be one by default, but I tried it anyway, and no, it makes no difference. The blockfactor is either serving some other purpose and then not properly documented, or it is inoperant. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320285 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What the heck is happening during CFQUERY?
blockFactor is only relevant on the Oracle drivers CF 5 doc says This parameter applies to ORACLE native database drivers and to ODBC drivers This is ambiguous, If it applies only to Oracle, it should be stated: This parameter applies to ORACLE native database drivers and to ORACLE ODBC drivers And CF 7 : Might not be supported by some database systems. with no other details. IMO everything but ORACLE should not be called some database systems either... ;-/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320286 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Removing I.E. (At least the visible parts) doesn't break Windows after all?
http://apnews.myway.com/article/20090307/D96OSS8G1.html Microsoft to let PC users turn off IE Web browser -- A single check box deep in the guts of the next version of Windows is giving Microsoft Corp. watchers a peek at how the software maker plans to keep European antitrust regulators from marring a crucial software launch. ... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320287 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Cflayoutarea Question.
Hi, This is my first ever foray into ajax in CF. If I have a set up as below; cflayoutarea position=center name=center a href=## onclick=ColdFusion.navigate('page.cfm?id=#id#')nav 1/a /cflayoutarea cflayoutarea position=center name=center cflayoutarea title=TAB1 name=feedTabOne overflow=hidden / cflayoutarea title=TAB2 name=feedTabOne overflow=hidden / /cflayoutarea What do I do to make TAB2 opens when I click on the link, at the moment TAB2 does not open until I click on the TAB2 tab. Thanks, Matt ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320288 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
WRONG LIST was Re: Removing I.E. (At least the visible parts) doesn't break Windows after all?
Ian Skinner wrote: Stuff I meant to post to the community list. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320289 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What the heck is happening during CFQUERY?
On Mon, Mar 9, 2009 at 4:44 PM, Claude Schneegans wrote: - if the resultset were never used the query would never be run on the server; Well, if the result set is not used, what is the advantage of having the query run anyway? A select isn't necessarily idempotent (if CF were able to determine it was a select in the first place).. - if the resultset were used multiple times the query would be run multiple times on the server; If the result set is too large to fit in memory, it will be rewritten and reread from disk every time anyway. But if the query isn't deterministic you wouldn't necessarily get the same results each time. May be some parameter in CFQUERY (ie RECORDS=onTheFly) could be used to create on the fly queries. It will be up to the programmer to use it if he expects the query to generate lots of data. I'm not really interested in such a parameter, but if you submit it as a feature request you should consider naming it usecursor or something. That explains the way it would work much better. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320290 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
On Mon, Mar 9, 2009 at 5:05 PM, Claude Schneegans wrote: because that is the only way to get a recordcount. A big price in efficiency to pay for something we use only sometimes. Most of the time, we only need to know if there are records or not. That is what maxrows is for. The query will still execute to completion on the database server, but CF will stop fetching results after it has reached its maximum. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320291 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
On Mon, Mar 9, 2009 at 4:41 PM, Dominic Watson wrote: CF just needs all the records all the time because that is the only way to get a recordcount. While I don't think that is quite true It is not strictly true. You can declare a cursor, do a move end, read from the metadata how many records you moved forward, then do a move start and wait for the commands to fetch rows. But that is hardly portable and will perform even worse then just fetching everything into a detached recordset on the client. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320292 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
if cf did not get the full dataset from the db, would it still be able to show query debugging / execution times / etc, and would cf monitor still work and be able to show you long-running/unoptimized queries / etc? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320293 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What the heck is happening during CFQUERY?
(if CF were able to determine it was a select in the first place) Well, it must be able somehow to determine the query returns data, otherwise, how would it create a structure from any result set? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320294 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Structures.. brain fried
I've got a query that returns two fields for each record (id, name). There can be several records returned Because of the way that the site is set up I need to dump the results into the session scope and then loop over them on an output page I think I over complicated it by using Ben Nadel's QueryToStruct script. Is there a simple way to do this? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320295 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What the heck is happening during CFQUERY?
A cfquery tag can potentially contain any number of SQL commands which may or may not return a result set. CF doesn't do any parsing of the SQL contained within, it just runs it. (The only exception being the SELECT, UPDATE, DELETE, DROP etc security set up in your datasource settings-- but that's not bullet proof) Regardless, CF wouldn't know if the cfquery was going to return a result set until after it had sent the commands to the database for execution and waited for the results to come back, and that would sort of defeat the purpose, wouldn't it? ~Brad Original Message Subject: Re: What the heck is happening during CFQUERY? From: Claude Schneegans schneeg...@internetique.com Date: Mon, March 09, 2009 1:11 pm To: cf-talk cf-talk@houseoffusion.com (if CF were able to determine it was a select in the first place) Well, it must be able somehow to determine the query returns data, otherwise, how would it create a structure from any result set? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320296 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Structures.. brain fried
not seeing the need to convert the query to a struct. cfset session.myQuery = myQuery / cfoutput query=session.myQuery #session.myQuery.ID# #session.myQuery.name#br / (or, if you don't want to fully qualify the names...) #ID# #name#br / /cfoutput depending on how your app is structured, you may need to do some checking before placing the query into the session. maybe something like: cfif not structKeyExists(session, 'myQuery') cfset session.myQuery = myQuery / /cfif On Mon, Mar 9, 2009 at 11:33 AM, Scott Stewart sstwebwo...@bellsouth.netwrote: I've got a query that returns two fields for each record (id, name). There can be several records returned Because of the way that the site is set up I need to dump the results into the session scope and then loop over them on an output page I think I over complicated it by using Ben Nadel's QueryToStruct script. Is there a simple way to do this? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320297 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Structures.. brain fried
Probably you can just assign the query to a session variable: cfset session.myQuery = myQuery / Then output the query: cfoutput query=session.myQuery !--- do stuff --- /cfoutput You don't need to change the query itself into structures. -- Josh -Original Message- From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] Sent: Monday, March 09, 2009 11:33 AM To: cf-talk Subject: CF Structures.. brain fried I've got a query that returns two fields for each record (id, name). There can be several records returned Because of the way that the site is set up I need to dump the results into the session scope and then loop over them on an output page I think I over complicated it by using Ben Nadel's QueryToStruct script. Is there a simple way to do this? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320298 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF Structures.. brain fried
Charlie, Josh This worked perfectly... I didn't know that you just dump the query into the session scope Thanks a million sas -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: Monday, March 09, 2009 2:40 PM To: cf-talk Subject: Re: CF Structures.. brain fried not seeing the need to convert the query to a struct. cfset session.myQuery = myQuery / cfoutput query=session.myQuery #session.myQuery.ID# #session.myQuery.name#br / (or, if you don't want to fully qualify the names...) #ID# #name#br / /cfoutput depending on how your app is structured, you may need to do some checking before placing the query into the session. maybe something like: cfif not structKeyExists(session, 'myQuery') cfset session.myQuery = myQuery / /cfif On Mon, Mar 9, 2009 at 11:33 AM, Scott Stewart sstwebwo...@bellsouth.netwrote: I've got a query that returns two fields for each record (id, name). There can be several records returned Because of the way that the site is set up I need to dump the results into the session scope and then loop over them on an output page I think I over complicated it by using Ben Nadel's QueryToStruct script. Is there a simple way to do this? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320299 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cflayoutarea Question.
hi matt, the coldfusion.naviagte function takes a paramater where you can post and pass the tab name that you wish to post to. I think Ray did a good example a while back. It is documented in the docs, sorry I cant check at the moment I'm in the car stuck in traffic using my phone lol. Thanks Jose Diaz On Mon, Mar 9, 2009 at 5:27 PM, Matthew Allen a.matthe...@yahoo.com wrote: Hi, This is my first ever foray into ajax in CF. If I have a set up as below; cflayoutarea position=center name=center a href=## onclick=ColdFusion.navigate('page.cfm?id=#id#')nav 1/a /cflayoutarea cflayoutarea position=center name=center cflayoutarea title=TAB1 name=feedTabOne overflow=hidden / cflayoutarea title=TAB2 name=feedTabOne overflow=hidden / /cflayoutarea What do I do to make TAB2 opens when I click on the link, at the moment TAB2 does not open until I click on the TAB2 tab. Thanks, Matt ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320300 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Structures.. brain fried
Scott Stewart wrote: Charlie, Josh This worked perfectly... I didn't know that you just dump the query into the session scope You can dump anything into the session scope. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320301 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What the heck is happening during CFQUERY?
Regardless, CF wouldn't know if the cfquery was going to return a result set until after it had sent the commands to the database for execution and waited for the results to come back, and that would sort of defeat the purpose, wouldn't it? No, because the driver does not return the result set, but only the presence of a result set. It is then up to the application to get rows one by one: See http://msdn.microsoft.com/en-us/library/ms711012(VS.85).aspx In particular: If the statement is a SELECT statement, the application calls a CLI function to return the results in application buffers. Typically, this function returns one row or one column of data at a time. At least, this is how it works for ODBC, with native drivers, I don't know. Furthermore, if it is a SELECT statement, and if the application calls a CLI function to return the results, one may suppose that the application must know one way or another that there is some result set to get. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320302 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Structures.. brain fried
Scott Stewart wrote: Charlie, Josh This worked perfectly... I didn't know that you just dump the query into the session scope You can dump anything into the session scope. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320303 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Table with Fixed side columns instead of fixed headers
Has anyone done this before? I have an application that is like Microsoft Project. It shows a list of organizations on the left side and the dates (by day) to the right. The calendar is a set amount (ex.. October 2008 - August 2010). When the user scrolls to the right, I need the organization names to be visible. I could do this with seperate tables, but would rather see if I could freeze the left side like you can do with the top. Thanks! Brian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320304 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
tzupdater trouble
I am running MX7 on a linux server (ES4) and I am having trouble installing the DST patch tzupdater.jar. The java community seems to think its a result of the version of java I am running. (gnu.gcj). How do I go about updating the version of java I have. Just download and install it? Change any settings in CF? Any help would be greatly appreciated. Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320305 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Table with Fixed side columns instead of fixed headers
Brian Yager wrote: Has anyone done this before? Yes, if you don't have to support I.E. 6, never tried it with I.E. 7 or 8 this was before those existed. But I know longer have access to that code and only the vaguest idea that I did get it to work once. To make it work in I.E. 6, I ended up breaking the left header column into a separate table and just did some jury rigging to make all the rows the same height. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320306 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Table with Fixed side columns instead of fixed headers
Brian Yager wrote: Has anyone done this before? Yes, if you don't have to support I.E. 6, never tried it with I.E. 7 or 8 this was before those existed. But I know longer have access to that code and only the vaguest idea that I did get it to work once in Firefox type compliant browsers. To make it work in I.E. 6, I ended up breaking the left header column into a separate table and just did some jury rigging to make all the rows the same height. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320307 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cflayoutarea Question.
Thanks Jose, that was my thought also, I've tried all possible parameters of coldfusion.navigate, nothing seem to work, I'm sure I'm missing something very obvious, anyone? Thanks, Matt. On 9 Mar 2009, at 19:13, Jose Diaz bleached...@gmail.com wrote: hi matt, the coldfusion.naviagte function takes a paramater where you can post and pass the tab name that you wish to post to. I think Ray did a good example a while back. It is documented in the docs, sorry I cant check at the moment I'm in the car stuck in traffic using my phone lol. Thanks Jose Diaz On Mon, Mar 9, 2009 at 5:27 PM, Matthew Allen a.matthe...@yahoo.com wrote: Hi, This is my first ever foray into ajax in CF. If I have a set up as below; cflayoutarea position=center name=center a href=## onclick=ColdFusion.navigate('page.cfm?id=#id#')nav 1/a /cflayoutarea cflayoutarea position=center name=center cflayoutarea title=TAB1 name=feedTabOne overflow=hidden / cflayoutarea title=TAB2 name=feedTabOne overflow=hidden / /cflayoutarea What do I do to make TAB2 opens when I click on the link, at the moment TAB2 does not open until I click on the TAB2 tab. Thanks, Matt ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320308 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8 Image manipulation
Michael, Thanks for the reply. I already have that handled and it works great. I am drawing autocad type drawings using the new cf8 image tools and I was trying to find an easy way to add perspective, but now I am just going to force the user to be a little more precise by letting them define 3 points after they upload their photo along with the exact distances, then I can scale my drawings perfectly to their dimensions and problem solved. Coldfusion comes through again like always and thanks to everyone in CF-Talk as usual as you always start the juices flowing. Terry Troxel -Original Message- From: Dawson, Michael [mailto:m...@evansville.edu] Sent: Monday, March 09, 2009 6:26 AM To: cf-talk Subject: RE: CF8 Image manipulation Not sure if anyone else has posted this since I started reading this thread... http://www.webresourcesdepot.com/jquery-image-crop-plugin-jcrop/ Thanks, Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320309 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
It seems like you know a bit about databases. Why not write the looping code in the database using T-SQL, VB, or .NET and keep CF out of the picture entirely? What is CF providing that makes you want to use it for this index building task? It doesn't sound like you are serving up Web pages to users with this code, which is what CF is designed to do. -Mike Chabot ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320310 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cflayoutarea Question.
CF has a built-in ColdFusion.Layout.selectTab() function. read the docs for more info. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Matthew Allen wrote: Hi, This is my first ever foray into ajax in CF. If I have a set up as below; cflayoutarea position=center name=center a href=## onclick=ColdFusion.navigate('page.cfm?id=#id#')nav 1/a /cflayoutarea cflayoutarea position=center name=center cflayoutarea title=TAB1 name=feedTabOne overflow=hidden / cflayoutarea title=TAB2 name=feedTabOne overflow=hidden / /cflayoutarea What do I do to make TAB2 opens when I click on the link, at the moment TAB2 does not open until I click on the TAB2 tab. Thanks, Matt ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320311 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cflayoutarea Question.
the code you posted is invalid (probably just bad copy-paste?), so i will post working code for the test case: cflayout name=borders type=border cflayoutarea name=center position=left style=width:100px; cfoutputa href=## onclick=ColdFusion.navigate('page.cfm?id=#id#', 'feedTabTwo');ColdFusion.Layout.selectTab('tabs', 'feedTabTwo');nav 1/a/cfoutput /cflayoutarea cflayoutarea name=center2 position=center cflayout name=tabs type=tab cflayoutarea title=TAB1 name=feedTabOne overflow=hidden / cflayoutarea title=TAB2 name=feedTabTwo overflow=hidden / /cflayout /cflayoutarea /cflayout hth Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Matthew Allen wrote: Hi, This is my first ever foray into ajax in CF. If I have a set up as below; cflayoutarea position=center name=center a href=## onclick=ColdFusion.navigate('page.cfm?id=#id#')nav 1/a /cflayoutarea cflayoutarea position=center name=center cflayoutarea title=TAB1 name=feedTabOne overflow=hidden / cflayoutarea title=TAB2 name=feedTabOne overflow=hidden / /cflayoutarea What do I do to make TAB2 opens when I click on the link, at the moment TAB2 does not open until I click on the TAB2 tab. Thanks, Matt ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320312 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4