Chart and Gaph Utilites
I am developing a ColdFusion application that needs the ability to chart and graph data pulled dynamically from a database. I need to be able to generate bar, pie and line charts. One that I found on the web is Easy Charts by ObjectPlanet. Does anyone have any experience with this Java component or any others to recommend? Sincerely, Gary J. Groomer DesignFirst, a web design and consulting firm E-mail: [EMAIL PROTECTED] Web: www.DesignFirst.com (503) 723-0964 (Voice or Fax) -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Need Help With a Query
I am having a problem pulling what I want from a couple of tables and any help would be greatly appreciated. Find below a simple synopsis of the two tables. Table(A) - CategoryName CategoryID --- CategoryName11 CategoryName22 CategoryName33 Table(B) - CategoryIDItemID 120 220 120 335 CategoryID is the common key. What I want to do is pull a list of CategoryNames from Table(A) where the ItemID in Table(B) = 20. I want the CategoryName returned once. Every way that I have tried it, I get the CategoryName repeated for each entry in Table(B). Query: SELECT a.CategoryName FROM Table(A) a, Table(B) b WHERE a.CategoryId = b.CategoryID AND b.ItemID = 20 Results returned:Desired Results: - CategoryName1CategoryName1 CategoryName1CategoryName2 CategoryName2 Again, any help would be greatly appreciated. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Need Help With a Query
That did it. Thanks, Gary - Original Message - From: "Tom Muck" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 10, 2000 10:50 AM Subject: Re: Need Help With a Query Try SELECT DISTINCT a.CategoryName FROM Table(A) a, Table(B) b WHERE a.CategoryId = b.CategoryID AND b.ItemID = 20 tom - Original Message - From: "Gary J. Groomer" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 10, 2000 1:43 PM Subject: Need Help With a Query I am having a problem pulling what I want from a couple of tables and any help would be greatly appreciated. Find below a simple synopsis of the two tables. Table(A) - CategoryName CategoryID --- CategoryName11 CategoryName22 CategoryName33 Table(B) - CategoryIDItemID 120 220 120 335 CategoryID is the common key. What I want to do is pull a list of CategoryNames from Table(A) where the ItemID in Table(B) = 20. I want the CategoryName returned once. Every way that I have tried it, I get the CategoryName repeated for each entry in Table(B). Query: SELECT a.CategoryName FROM Table(A) a, Table(B) b WHERE a.CategoryId = b.CategoryID AND b.ItemID = 20 Results returned:Desired Results: - CategoryName1CategoryName1 CategoryName1CategoryName2 CategoryName2 Again, any help would be greatly appreciated. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Scheduled Task
Does anyone know how to run a "CFM" file, periodically, without the use of ColdFusion's scheduled task functions? For example, every 24-hours at a specified time. My web site is hosted on a shared server and the hosting company won't allow the use of the CF Administrator's scheduled tasks, nor will they allow the use of CFSCHEDULE. They say that both modify the registry and modification of the registry has been disabled for security reasons. Any ideas would be greatly appreciated. Gary Groomer -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!!
I put my custom tags in the folder with the templates that call them. CF looks there first. I tried having my ISP put them in the CustomTags folder on the server, but somehow they would periodically vanish. Gary Groomer - Original Message - From: [EMAIL PROTECTED] To: : Sent: Thursday, August 10, 2000 7:25 PM Subject: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!! hey All, I just signed up with an ISP that does shared web hosting. i use to a stand alone machine and inserting my custom tags in the /customtags directory under my CF install. How would/should an ISP implement this kind of capability on a shared service where multiple sites are using one install of CF? Please help. - D -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Fusion Authority Weekly News Letter
This is a multi-part message in MIME format. --=_NextPart_000_0060_01BFE409.04993010 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Somehow, I am subscribed to multiple issues of the Fusion Authority = Weekly News Letter. I have tried unsubscribing, but all that does is = add another issue. Does anyone know how to reduce this to one issue per = week? Gary Groomer --=_NextPart_000_0060_01BFE409.04993010 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Somehow, I am subscribed to multiple = issues of the=20 Fusion Authority Weekly News Letter.nbsp; I have tried unsubscribing, = but all=20 that does is add another issue.nbsp; Does anyone know how to reduce = this to one=20 issue per week?/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Gary Groomer/FONT/DIV/BODY/HTML --=_NextPart_000_0060_01BFE409.04993010-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
