[cfaussie] Re: Accessing a specific row of a query?

And how nice it would be to actually have query.row[2] to return the entire row :-) -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Wednesday, 25 October 2006 1:21 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Accessi

[cfaussie] Re: Accessing a specific row of a query?

Ok there ya go. Another one of those Slap-The-Forehead moments. I KNEW THAT! Why didnt it come forth when i tried to think of it?? Thanks Steve. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, AS

[cfaussie] Re: Accessing a specific row of a query?

>>> [EMAIL PROTECTED] 25/10/2006 1:13 pm >>> Is there a way to acess a specific row in a query? For example i know the record i want is record number 2 in a query, so other than doing a select in a queryofqueries, is there a simple way to just refer to rownumber 2? The reason i dont reall

[cfaussie] Re: Accessing a specific row of a query?

Query.column[row] So if you wanted the second record in the result set you would do query.column[[2] Steve -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Wednesday, 25 October 2006 1:14 PM To: cfaussie@googlegroups.com Subject:

[cfaussie] Accessing a specific row of a query?

Is there a way to acess a specific row in a query? For example i know the record i want is record number 2 in a query, so other than doing a select in a queryofqueries, is there a simple way to just refer to rownumber 2? The reason i dont really want to use a queryofqueries is that i dont nec

[cfaussie] Re: Database deadlocks

You'll need to wrap the query/transaction in a cftry block and in the cfcatch, check for a deadlock and either wait a moment and retry the query or gracefully abort the query. Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group m: 0415 469 095 www.flashdev.org.au --~--~--

[cfaussie] Re: Database deadlocks

Hi, I get this error ALL too often. Its very difficult tracking down the problem on the database end... identifying what query is blocking the query that is terminated. It is not as simple as using the cftransaction tag. It 'can' help, but you will need to select the isolation level appropiat

[cfaussie] Re: Database deadlocks

  Asking about it I've been told that all SQL statements should be wrapped in transactions.  well, I'd say any related SQL statements (insert into master table, insert into children tables) should be wrapped although I can't really see the value in doing so for a single statement (pls correct if I

[cfaussie] Re: Advice on whether to store a large(ish) recordset in memory or not

We haven't done much work on CFHibernate in ages... You can get Hibernate running with the current code on CF with no issues, with no need to push it into the classPath, and Kurt W. has some code to make CFC's map to and from the database using Hibernate, but those two things have yet to be combi

[cfaussie] Database deadlocks

Hey all,   I've been getting this error on some of our busier sites:   - Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 227) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun

[cfaussie] Re: Advice on whether to store a large(ish) recordset in memory or not

This also begs the question: What's the state of the art wrt to persistence layers in CF these days? Hibernate for java takes care of a lot of things, including caching data (even in a clustered environment) and transparently translates between database data and data access objects. I've not

[cfaussie] Re: Advice on whether to store a large(ish) recordset in memory or not

On 10/24/06, neilza <[EMAIL PROTECTED]> wrote: > I am developing an online audit for approximately 1000 users. The > recordset I am working with contains 200,000 rows. I figured it would My initial thoughts are audits are not a static thing. The results may always yield 200k rows, but the query

[cfaussie] Re: Advice on whether to store a large(ish) recordset in memory or not

I'm an advocate of storing lots of CFC's in memory, and heavily accessed data. but 200,000 rows, how many columns? any idea of your row size? rule of thumb, object instanciation is expensive, so is database access. my only concern is that you've only got 1Gb of RAM. if you had 2 or more I'd say

[cfaussie] Advice on whether to store a large(ish) recordset in memory or not

Hi I wondered if anyone could give me advice on the following scenario I am developing an online audit for approximately 1000 users. The recordset I am working with contains 200,000 rows. I figured it would make sense to store this recordset in memory and then use a query of queries to pull out

[cfaussie] Re: JavaScript - testing for an exponential number

Heh, I like your thinking. That makes much more sense. Good one. Much easier. Thanks. Neil --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegr

[cfaussie] Re: best compromise? CF6.1 QueryOfQuery datatype mismatch.

if anyone is curious: casting everything as varchars was going to cause nasty grief everywhere. A solution is the same trick used on .NET (before generics in 2.0) - sentinal values around the display and before processing.