RE: Preventing Link-Builders

2010-02-15 Thread Hugo Ahlenius
Kris Jones wrote on 2010-02-12: We've got a very busy legacy home-grown forum that since late August 2009 or so has been getting hit heavily by the Link-Building industry. Posting requires membership, which requires a captcha to be entered, and a confirmation email link to be clicked.

Re: java assistance

2010-02-15 Thread James Holmes
You need Java EE to compile these. This is not included in the standard JDK. Download Java EE and you should be ok to compile the code. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 15 February 2010 09:45, Eric Roberts w...@witchnet.org wrote: We are

coldfusion for medical research

2010-02-15 Thread Richard White
Hi, our company builds software with coldfusion for charitable institutions/universities who store information for medical research purposes. i understand there is a free license for educational purposes but is there a free or discounted license for this scenario? thanks

Re: coldfusion for medical research

2010-02-15 Thread Peter Boughton
You'd be best talking to your local Adobe rep about this. Something on this page will probably give details for that: http://www.adobe.com/support/contact/ If Adobe can't provide you with a price you're happy with, you might want to consider Railo (http://www.gerailo.com) and OpenBD

Re: Broken images in CFADMIN

2010-02-15 Thread Kumar Shah
I had this issue while installing CF9 64-bit on Win 7 64-bit. For me the solution was to uninstall CF9 then uninstall IIS, then reinstall IIS and CF9. Although I am guessing there is an easier solution out there. On Sat, Feb 13, 2010 at 6:49 PM, ColdFusion Developer cfdev2...@gmail.comwrote:

RE: Possible switch to CFEclipse

2010-02-15 Thread Paul Alkema
Hey Gerald, I definitely agree with Kevin, If you're looking for a great CFML engine to run on your server and don't have the $$ for Adobe's ColdFusion, look into Railo. I develop on both and have found Railo to be very comparable to Adobe's Coldfusion.

Re: The JVM library could not be found. SOLVED

2010-02-15 Thread Claude Schnéegans
and you wouldn't want all of them to set global environment variables. Well, actually I don't care, all I want is that a piece of soft I do not want installs itself correctly if it is needed by some other soft I want. The problem was also (as very often) that the error message was

RE: java assistance

2010-02-15 Thread Eric Roberts
James I tried that and I am just fighting against my inexperience with Java outside of CF and in doing it with Eclipse. I have touched pure Java in about 11 or 12 years and we didn't have eclipse back then. A friend of mine suggested that I just call the servlet within a cf page as Java in

Re: cfwindow looks different in cf9

2010-02-15 Thread John Pullam
I did some css overwrites to force my app to remain similar. The ext- css file in CF has darn near every HTML tag listed in there and zeroed out. Sent from my iPhone On Feb 13, 2010, at 4:12 PM, John Pullam jpul...@mcleansystems.com wrote: That makes a lot of sense and is consistent

Re: Possible switch to CFEclipse

2010-02-15 Thread Adrocknaphobia
We are working to find an alternative way to license ColdFusion to hosting companies that is more cost effective for the smaller shops. However, it's a common misconception that the price of ColdFusion is proportionate to the cost of hosting. Hosting companies don't pay anywhere near list price.

Total Two Field From Two Tables

2010-02-15 Thread Barry Mcconaghey
Hello Everybody. I have been thinking and working on this for three days now. I'm looking for some help totaling two fields from two tables. Here is what I have: Sample Tables: Table - fdd_directory fdd_name (Example: ACME Fire Dept) fdd_state (Example: PA) fdd_zip (Example: 12345) Table

Re: CFDOCUMENT CF 8

2010-02-15 Thread Bryan Stevenson
Bump ;-) If anyone needs further clarificationplease ask On Sun, 2010-02-14 at 17:41 -0800, Bryan Stevenson wrote: Hey All, Here's my sample code: -- cfdocument format=FlashPaper pagetype=letter

Re: Total Two Field From Two Tables

2010-02-15 Thread Barney Boisvert
Just add: (select count(*) from articles where zipcode = fddirectory.fdd_zip) as articleCount to the end of your SELECT clause: SELECT fddirectory.fdd_id, fddirectory.fdd_name, fddirectory.fdd_zip, fddirectory.fdd_state, states.abrev , (select count(*) from articles where zipcode =

Re: Total Two Field From Two Tables

2010-02-15 Thread Barry Mcconaghey
Thanks Barney B. ERROR Message: Syntax error or access violation: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select count(*) from articles where zipcode = fddirectory.fdd_z Here is the cfquery:

Re: Preventing Link-Builders

2010-02-15 Thread Kris Jones
Thanks for this Hugo. Taking a look at it. Do wonder if we'd end-up doing way more insertions into the system than positive resolutions though. Once I'm back in the office tomorrow, I'll do some checks on the addresses I've already inactivated. Cheers, Kris On Mon, Feb 15, 2010 at 4:54 AM,

Re: Total Two Field From Two Tables

2010-02-15 Thread Barney Boisvert
What version of MySQL are you using? If it's a really old one that doesn't support subqueries, check out the MySQL docs. They have a section about rewriting subqueries into JOINs. cheers, barneyb On Mon, Feb 15, 2010 at 9:16 AM, Barry Mcconaghey bmcconag...@gmail.com wrote: Thanks Barney B.

Phantom Scheduled Tasks

2010-02-15 Thread Bryan S
I have a scheduled task that starts a report every 12 minutes. Sometimes a report is started 5 minutes after the scheduled report starts. There is no evidence anywhere of the scheduled task being fired. There is no manual process starting the report. I have discovered long ago that modifying a

Re: Total Two Field From Two Tables

2010-02-15 Thread Barry Mcconaghey
I'm using MySQL 4.0.20. Is there any other way to total these two fields? Barry What version of MySQL are you using? If it's a really old one that doesn't support subqueries, check out the MySQL docs. They have a section about rewriting subqueries into JOINs. cheers, barneyb

Re: CF8 - Google Maps - Center zoom

2010-02-15 Thread Paul Ihrig
Eric. Thank You! After some fiddling, i got it. script type=text/javascript //![CDATA[ function load() { if (GBrowserIsCompatible()) { // It is necessary to make a setCenter call of some description before adding markers // At this point we dont know

Re: Total Two Field From Two Tables

2010-02-15 Thread Barney Boisvert
You just need a JOIN and GROUP BY clause. Check out the subquery-to-join docs on MySQL's site. They have examples of how to do exactly what you want. cheers, barneyb On Mon, Feb 15, 2010 at 11:19 AM, Barry Mcconaghey bmcconag...@gmail.com wrote: I'm using MySQL 4.0.20. Is there any other

CF Server Outages/ Stops Responding

2010-02-15 Thread SANJEEV SINGLA
Hi All, We have a Coldfusion Application. We recently migrated to CF 8.01 as we were having server outage issues with CF MX 6.1. We thought that problems will be resolved but it didn't. We are having same outage issues. We don't know what happens (CF hangs, Jrun freezes etc.) in background

Re: CFDOCUMENT CF 8

2010-02-15 Thread Bryan Stevenson
Hey All, Can anyone at least confirm/deny that a page break (or something) is added after each CFDOCUMENTSECTION block? It seems that if my first CFDOCUMENTSECTION block ends half way down a page, the next CFDOCUMENTSECTION block will ALWAYS start its display at the top of the next page

Re: CF Server Outages/ Stops Responding

2010-02-15 Thread Alan Rother
Off the top of my head, there are THOUSANDS of possibilities in what could be wrong here: - Your database could be overwhelmed by too much traffic. Have you tracked it's current load? - You database design could be horribly flawed. Have you had a a DBA check your design and index

Re: CFDOCUMENT CF 8

2010-02-15 Thread Bryan Stevenson
OK...found it buried in the docsit does force a page break at the end of each document sectionpure insanity that this isn't optional!! Does anyone know of a way to override this behavior or are we simply stuck with creating docs with tonnes of whitespace and thus wasted paper when users

Re: Total Two Field From Two Tables

2010-02-15 Thread Barry Mcconaghey
Thanks Barney! The JOIN and GROUP clause might be over my head. Do I use a RecordCount? Barry You just need a JOIN and GROUP BY clause. Check out the subquery-to-join docs on MySQL's site. They have examples of how to do exactly what you want. cheers, barneyb

Re: CF Server Outages/ Stops Responding

2010-02-15 Thread Wil Genovese
You should also read the JVM Tuning section on my blog. It's free help that may get you going it the right direction. http://www.trunkful.com/index.cfm/JVM-Tuning Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing

Re: Total Two Field From Two Tables

2010-02-15 Thread Barry Mcconaghey
I think I'm getting closer. This code below works but I don't know how to total each fdd_name. For Example: ACME FD1 (38) ACME FD2 (30) ACME FD3 (20) cfquery name=Zip datasource=#dsn# SELECT a.zipcode, f.fdd_zip, f.fdd_name, a.IsPublished, a.IsActive, f.fdd_state FROM articles a, fddirectory

Re: cfwindow looks different in cf9

2010-02-15 Thread Kevin Pepperman
some css overwrites? CF has darn near every HTML tag listed in there and zeroed out. Since cfwindow uses a type of reset css all the main tags padding, margins, padding, borders etc have been reset to 0, and the default inheritance tree from the browsers defaults have been reset to 0

PCI Compliance Help

2010-02-15 Thread Deanna Schwint
We just had a PCI Compliance scan done through SecurityMetrics and have one issue: Synopsis: The remote web server generates predictable session IDs Description: The remote web server generates a session ID for each connection. A

RE: Total Two Field From Two Tables

2010-02-15 Thread Dave Phillips
Barry, Try this: cfquery name=Zip datasource=#dsn# SELECT a.zipcode, f.fdd_zip, f.fdd_name, a.IsPublished, a.IsActive, f.fdd_state, count(distinct a.zipcode) as zip_count FROM articles a, fddirectory f WHERE a.zipcode = f.fdd_zip AND f.fdd_state = cfqueryparam cfsqltype=cf_sql_varchar

Re: Total Two Field From Two Tables

2010-02-15 Thread Barry Mcconaghey
Hi Dave. Thanks for the code! Those two did not work. I got two queries to work perfect but I don't know how to display them. !---Get all data--- cfquery name=Story datasource=#request.dsn# SELECT F.fdd_id, F.fdd_name, F.fdd_zip, S.statename, S.abrev FROMfddirectory F, states S WHERE

Re: PCI Compliance Help

2010-02-15 Thread Brad Wood
PCI reports that I've seen show the cookie in question that they think you are using to identify your sessions. The fact of the matter is how can the scanning company know what cookie values you are using to track sessions unless they can see your code. They can't unless they can

Re: Broken images in CFADMIN

2010-02-15 Thread Brad Wood
In my experience this happens when your CFIDE folder is not web-accessable, but you have a mapping for CFIDE in ColdFusion. The .cfm pages are resolving becuase CF is using the mapping it has, but when IIS is asked for an image (which doesn't involve CF), the path is non-existant. You need

RE: Total Two Field From Two Tables

2010-02-15 Thread Dave Phillips
What didn't work with the second set of queries? Did you get an error message? That logic is sound. There might be some syntax issues as I didn't test it... Dave -Original Message- From: Barry Mcconaghey [mailto:bmcconag...@gmail.com] Sent: Monday, February 15, 2010 10:28 PM To:

Re: Total Two Field From Two Tables

2010-02-15 Thread Barry Mcconaghey
Here is the error message: The string qZipTotals is not a valid ColdFusion variable name. Valid variable names must start with a letter and can only contain letter, numbers, and underscores. Barry ~| Want to reach the

Re: CF Server Outages/ Stops Responding

2010-02-15 Thread Brad Wood
We are having same outage issues. We don't know what happens (CF hangs, Jrun freezes etc.) in background but CF just stops processing requests. 1) Buy SeeFusion for all you servers. 2) Configure database logging and active monitoring alerts 3) Analyze your traffic, memory, slow pages, slow

Re: Total Two Field From Two Tables

2010-02-15 Thread Barry Mcconaghey
Hi Dave. I fixed the last error message. There was a space here: name= qZipTotals Now the data is displaying but it is not correct. This code below (ZIP)is correct: !---Count each fdd_name--- cfquery name=Zip datasource=#request.dsn# SELECT a.zipcode, f.fdd_zip, f.fdd_name, f.fdd_state,