ColdFusion Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Programming Languages - More > ColdFusion Development
Reload this Page

cfgrid problem

Discuss cfgrid problem in the ColdFusion Development forum on Dev Shed.
cfgrid problem ColdFusion Development forum discussing CFML coding practices, tips on CFML, and other CFML related topics. Find out why ColdFusion is the tool of choice for many e-commerce developers.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old February 19th, 2005, 10:56 AM
Panther893's Avatar
Panther893 Panther893 is offline
MostarDesigns.com
Dev Shed Novice (500 - 999 posts)
  
Join Date: Mar 2004
Posts: 821 Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level) 
Time spent in forums: 5 Days 21 h 15 m 58 sec
Reputation Power: 56
Send a message via MSN to Panther893
cfgrid problem
ok when i use cfgrid i have a problem, it doesnt show anything, what im trieing to do is show the number of clicks per IP address stored in my database, here is the code i have:

Code:
<cfquery name="clicks" blockfactor="100" datasource="#datasourcename#">
SELECT ID, ipnumber
FROM clicks
</cfquery>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
  <cfoutput>
  <tr>
    <td width="50" align="center" bgcolor="488BE2" class="welcome"><strong>ID</strong></td>
    <td width="250" bgcolor="488BE2" class="welcome"><strong>IP Address</strong></td>
	<td width="100" bgcolor="488BE2" class="welcome"><strong>Total Clicks:</strong> #clicks.recordcount#</td>
  </tr>
  </cfoutput>
  <tr>
    <td align="center" colspan="3">
	<cfgraph type="HorizontalBar" 
    query="clicks" 
    valueColumn="ipnumber" 
    itemColumn="ipnumber" 
    showValueLabel="rollover" 
	graphHeight="450" 
	graphWidth="500" 
	depth="3" 
    title="Total Clicks by IP Address">
	</cfgraph>
	</td>
  </tr>
</table>
Reply With Quote
  #2  
Old February 20th, 2005, 02:11 PM
kiteless kiteless is offline
Moderator
Dev Shed Expert (3500 - 3999 posts)
  
Join Date: Jun 2002
Location: Raleigh, NC
Posts: 3,655 kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level)kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level)kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level)kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level)kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level)kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 1 Week 4 Days 13 h 29 m 8 sec
Reputation Power: 53
I think you must be talking about cfgraph, not cfgrid? cfgraph has been depricated, graphs are created with cfchart on CFMX (assuming you're on CFMX)? I'd check the relevant documentation:
http://livedocs.macromedia.com/cold...g.htm#wp1156498
__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian.
How to Post a Question in the Forums
Reply With Quote
  #3  
Old February 20th, 2005, 04:07 PM
Panther893's Avatar
Panther893 Panther893 is offline
MostarDesigns.com
Dev Shed Novice (500 - 999 posts)
  
Join Date: Mar 2004
Posts: 821 Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level) 
Time spent in forums: 5 Days 21 h 15 m 58 sec
Reputation Power: 56
Send a message via MSN to Panther893
yeah cfgraph, my fault, im not on cfmx this time, the customer has opted out for paying extra for cfmx, i based my code on that documentation but for some reason its not coming up
Reply With Quote
  #4  
Old February 20th, 2005, 05:56 PM
kiteless kiteless is offline
Moderator
Dev Shed Expert (3500 - 3999 posts)
  
Join Date: Jun 2002
Location: Raleigh, NC
Posts: 3,655 kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level)kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level)kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level)kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level)kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level)kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 1 Week 4 Days 13 h 29 m 8 sec
Reputation Power: 53
Reply With Quote
  #5  
Old February 21st, 2005, 06:25 AM
Panther893's Avatar
Panther893 Panther893 is offline
MostarDesigns.com
Dev Shed Novice (500 - 999 posts)
  
Join Date: Mar 2004
Posts: 821 Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level) 
Time spent in forums: 5 Days 21 h 15 m 58 sec
Reputation Power: 56
Send a message via MSN to Panther893
ok ok i see my problem now, but how would i go about gathering a recordcount of each IP that is entered into the db??
Reply With Quote
  #6  
Old February 21st, 2005, 09:42 AM
kiteless kiteless is offline
Moderator
Dev Shed Expert (3500 - 3999 posts)
  
Join Date: Jun 2002
Location: Raleigh, NC
Posts: 3,655 kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level)kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level)kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level)kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level)kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level)kiteless User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 1 Week 4 Days 13 h 29 m 8 sec
Reputation Power: 53
That sounds like a separate issue from the graph problem. But you probably want to look at the count() aggregate SQL function.
Reply With Quote
  #7  
Old February 21st, 2005, 02:48 PM
Panther893's Avatar
Panther893 Panther893 is offline
MostarDesigns.com
Dev Shed Novice (500 - 999 posts)
  
Join Date: Mar 2004
Posts: 821 Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level)Panther893 User rank is Second Lieutenant (5000 - 10000 Reputation Level) 
Time spent in forums: 5 Days 21 h 15 m 58 sec
Reputation Power: 56
Send a message via MSN to Panther893
i just opted to redo my database and part of my code so it adds up the clicks when it updates the database...
Reply With Quote
Reply

Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > cfgrid problem

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway.