If I'm running a query on a database
and limit the records returned to 10,
what's the best way to get the record count
for the entire dataset if everything was
return and not just the first 10 records?
I can re-rerun the query without the 10-record
limit, but that seems like a ridiculous
Do a first quesrt using sql count
On Jan 26, 2013 12:41 PM, Rick Faircloth r...@whitestonemedia.com wrote:
If I'm running a query on a database
and limit the records returned to 10,
what's the best way to get the record count
for the entire dataset if everything was
return and not just
and limit the records returned to 10,
what's the best way to get the record count
for the entire dataset if everything was
return and not just the first 10 records?
I can re-rerun the query without the 10-record
limit, but that seems like a ridiculous
approach, just to get the record count
That worked! Learn something new every day!
Thanks, Gerald and Brian for the tips!
Rick
-Original Message-
From: Gerald Guido [mailto:gerald.gu...@gmail.com]
Sent: Saturday, January 26, 2013 5:45 PM
To: cf-talk
Subject: Re: Getting Record Count
Something like this perhaps
Hi
I need to access a recordcount from within a javascript function, is this
possible?
script
function checkBoxValidate(cb) {
for (j = 0; j RECORD COUNT OF QUERY TO GO HERE; j++) {
if (eval(document.addCust.ckbox[ + j + ].checked) == true) {
document.addCust.ckbox[j].checked = false;
if (j
a javascript function, is this
possible?
script
function checkBoxValidate(cb) {
for (j = 0; j RECORD COUNT OF QUERY TO GO HERE; j++) {
if (eval(document.addCust.ckbox[ + j + ].checked) == true) {
document.addCust.ckbox[j].checked = false;
if (j == cb) {
document.addCust.ckbox[j].checked = true
--
/script
/cfoutput
On Tue, Feb 3, 2009 at 4:47 AM, Jason Congerton
ja...@jasoncongerton.co.ukwrote:
Hi
I need to access a recordcount from within a javascript function, is this
possible?
script
function checkBoxValidate(cb) {
for (j = 0; j RECORD COUNT OF QUERY TO GO HERE; j++) {
if (eval
...@jasoncongerton.co.ukwrote:
Hi
I need to access a recordcount from within a javascript function, is this
possible?
script
function checkBoxValidate(cb) {
for (j = 0; j RECORD COUNT OF QUERY TO GO HERE; j++) {
if (eval(document.addCust.ckbox[ + j + ].checked) == true
Hi Thanks to you all,
I was just missing the cfoutput tags!
Thanks!!
Jason,
It's important to remember that Javascript is commonly rendered AFTER
Coldfusion has compiled the page. This allows you to use Coldfusion to help
render such content.
Here is a basic request cycle to help show this:
I am using spry to display subcategories based on a selected category in
a drop down. I need a way to display this div divThere were no
subcategories found for the selected category/div when there was no
subcategories found and then if there were to display the div below. So
far it works fine when
PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, April 24, 2007 1:40 PM
Subject: SPRY record count
I am using spry to display subcategories based on a selected category in
a drop down. I need a way to display this div divThere were no
subcategories found for the selected category/div
Do you have an example of this.
-Original Message-
From: Massimo Foti [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 24, 2007 7:56 AM
To: CF-Talk
Subject: Re: SPRY record count
You should be able to do that using a spry:if condition
Massimo Foti, web
Do you have an example of this.
The doc below is a fundamental reading if you want to use Spry's datasets:
http://labs.adobe.com/technologies/spry/articles/data_set_overview/
The part on conditional processing:
I'm looking for a way of obtaining a count of records from a query where
only one particular field has data...
I don't want to create a separate query for this just addressing this
field (ie. do recordcount where field NEQ or some variation) but
would like to utilize an existing query that
what dbms? mysql? mssql? oracle? access?
On Fri, 17 Dec 2004 12:28:34 -0500, Tim Laureska [EMAIL PROTECTED] wrote:
I'm looking for a way of obtaining a count of records from a query where
only one particular field has data...
I don't want to create a separate query for this just addressing
If I understand you correctly, you have already run the query in a
cfquery/ tag and have a recordset, no?
If so, you could do a simple Query of Queries on this to further
interrogate your results.
e.g.
cfquery name=rsNew dbtype=query
SELECT COUNT( something ) AS somethingCount
QofQ?
--Ben
Tim Laureska wrote:
I'm looking for a way of obtaining a count of records from a query where
only one particular field has data...
I don't want to create a separate query for this just addressing this
field (ie. do recordcount where field NEQ or some variation) but
would
access
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Friday, December 17, 2004 12:21 PM
To: CF-Talk
Subject: Re: record count
what dbms? mysql? mssql? oracle? access?
On Fri, 17 Dec 2004 12:28:34 -0500, Tim Laureska [EMAIL PROTECTED]
wrote:
I'm looking
-
From: Anthony Cooper [mailto:[EMAIL PROTECTED]
Sent: Friday, December 17, 2004 12:37 PM
To: CF-Talk
Subject: Re: record count
If I understand you correctly, you have already run the query in a
cfquery/ tag and have a recordset, no?
If so, you could do a simple Query of Queries on this to further
[mailto:[EMAIL PROTECTED]
Sent: 17 December 2004 19:05
To: CF-Talk
Subject: RE: record count
Thanks Anthony... but where is that any different from just doing
another query such as ...
~|
Special thanks to the CF Community
[mailto:[EMAIL PROTECTED]
Sent: Friday, December 17, 2004 12:37 PM
To: CF-Talk
Subject: Re: record count
If I understand you correctly, you have already run the query in a
cfquery/ tag and have a recordset, no?
If so, you could do a simple Query of Queries on this to further
interrogate your
Is there a way to see how many (if any) records an update query has updated
after it runs? Recordcount doesn't work.. Is there a way without doing another
query?
Thanks,
Chris
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
be a better way, but that gets you what you need.
-Original Message-
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: 2/13/04 9:05 AM
Subject: Update query record count?
Is there a way to see how many (if any) records an update query has
updated
after it runs? Recordcount doesn't work
I had in working in a 2 part w/ select, but was hoping to cut down to 1 query
since it's being hit on every page to lower the DB load if possible.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
have good indexes and a cached query plan(stored proc or cfqueryparam).Can another cf guru on the list verify?
-Original Message-
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: 2/13/04 9:19 AM
Subject: Re: Update query record count?
I had in working in a 2 part w/ select, but was hoping to cut
://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, 14 February 2004 1:05 AM
To: CF-Talk
Subject: Update query record count?
Is there a way
of 5000?---
CFOUTPUT#(Len(NarrativeGet.EduLevelNarrative[I])#
/CFOUTPUT
/CFLOOP
Thanks,
j
-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 11, 2003 5:17 PM
To: CF-Talk
Subject: RE: Character count on record count??/
: 2. count the characters used in each
Why can't you just use SQL?
SELECT LEN(yourfield) AS 'Length'
Neil
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]
Sent: 12 March 2003 14:27
To: CF-Talk
Subject: RE: Character count on record count??/
Maybe I'm making this harder than it is (that's usual for me
: !---Here is my test output of the data- it shows correctly the length of
: each narrative-
: So the question is how do I get a sum or/do narrative + narrative
: +narrative
: to get blocks of 5000?---
: CFOUTPUT#(Len(NarrativeGet.EduLevelNarrative[I])#
: /CFOUTPUT
Initialize a temp variable to
PROTECTED]
Sent: Wednesday, March 12, 2003 9:48 AM
To: CF-Talk
Subject: RE: Character count on record count??/
: !---Here is my test output of the data- it shows correctly the length of
: each narrative-
: So the question is how do I get a sum or/do narrative + narrative
: +narrative
: to get blocks
Programmer General Lackey
Moonbow Software, Inc
: -Original Message-
: From: Janine Jakim [mailto:[EMAIL PROTECTED]
: Sent: Wednesday, March 12, 2003 11:06 AM
: To: CF-Talk
: Subject: RE: Character count on record count??/
:
:
: Well the page part was easy enough to do.
: It's
equal
Narrative1/Narrative2/Narrativd3
Does that make sense?
-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 11:24 AM
To: CF-Talk
Subject: RE: Character count on record count??/
Why not just keep a running total inside the loop, as I thought I
: Running a cfoutput TotalLen/Narrative[I] looks fine on a regular display.
: I think it's the behavior of activepdf that is the problem.
: Each [i] must be identified/hardcoded on the pdf ie: Narrative1,
: narrative2,
: Narrative3, Narrative4
: So on my action page up to 5000 characters may make
/etc...)What I want to do is figure out- how to put these narratives
together without a bunch of space between the entries. (ie: we discussed
blocks of 1250 characters, but that may look odd if teachers do not write
much)
1. record count of narratives (know how to do that)
2. count the characters
: 2. count the characters used in each narrative.
Retrieve the narratives and use len() on them. Probably add some to it to
allow a break between narratives.
: 3. Output the narratives in chuncks of 5000 characters. (or to the
: narratives that come close to 5000) For example
:
Ok this is going to sound a bit odd since i am not sure how to word it.
i have my little query: [in my admin page for viewing who has signed up for
the class]
[[from dataview01.cfm]]
cfquery name="rsSignedUP" datasource="practice"
SELECT tbl_Employee.EmployeeID, tbl_Employee.LastName,
Katrina Chapman
Consultant
Ameriquest Mortgage
Paul Ihrig [EMAIL PROTECTED]
07/12/00 09:13 AM
Please respond to cf-talk
To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED]
cc:
Subject: How to Count? or Record Count?
Ok this is going to sound a b
Ok.
I am able to get one class id inserted besed on the record count.
My problem now is at the bottom of this page.
it needs to be conditional on wether the insert is for date/time 01 or
date/time 02.
But how is my form suposed to know what date has been selected befor the
actual submit button
AM Delete
Thank a bunch!
-paul
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, July 12, 2000 1:33 PM
To: [EMAIL PROTECTED]
Subject: Re: How to Count? or Record Count?
I could be totally wrong here but I'm assuming
39 matches
Mail list logo