[ot] where to get car data

2009-06-18 Thread Tom Chiverton
Has anyone had to get a list of car makes and model's before ? Where did you get them from ? I need UK/Euro ones, so things like http://www.pluup.com/car-make-models.php are unfortunately not going to work. -- Helping to professionally orchestrate dot-com best-of-breed functionalities as part

Re: email and encrypt

2009-06-18 Thread Tom Chiverton
On Tuesday 16 Jun 2009, Chad Gray wrote: Someone could put ID=5 in there and validate someone else's account. Only if they knew the matching email address to that number, or you could verify that from the logged session or something. -- Helping to authoritatively exploit clicks-and-mortar

Re: Ubuntu - how WinXP compatible?

2009-06-18 Thread Tom Chiverton
On Wednesday 17 Jun 2009, Peter Boughton wrote: You can get emulators (e.g. WINE) Wine Is Not an Emulator :-) A better choice these days is a virtual machine (e.g VirtualBox, VMWare, etc) that allows you to run actual Windows on virtual hardware - this is likely to cope with most things,

Re: cfencode.solaris not working on our CF8-Solaris server

2009-06-18 Thread Tom Chiverton
On Wednesday 17 Jun 2009, Ian Skinner wrote: ld.so.1: cfencode.solaris: fatal: libporting.so: open failed: No such Get your sysadmin to install that package :-) -- Helping to completely orchestrate design-patterns as part of the IT team of the year, '09 and '08

Re: Full screen?

2009-06-18 Thread Casey Dougall
On Wed, Jun 17, 2009 at 10:54 PM, Don L do...@yahoo.com wrote: Hulu movie has a full screen option, I'm wondering if we could also easily implement that for a cf web app? Has anyone done something like that? Note, Flash Full Screen mode does NOT allow you to work on another monitor while

RE: Application Scope Problem

2009-06-18 Thread Paul Alkema
Has anyone else experienced this issue before with the application scope? So if I ripped this out of the application scope you think it the issue I am having would be fixed correct? Also, please explain what you mean by ensuring that the arguments parameters aren't sticky? Do you mean

RE: Application Scope Problem

2009-06-18 Thread Paul Alkema
Has anyone else experienced this issue before with the application scope? So if I ripped this out of the application scope you think it the issue I am having would be fixed correct? Also, please explain what you mean by ensuring that the arguments parameters aren't sticky? Do you mean

Re: Ubuntu - how WinXP compatible?

2009-06-18 Thread Matthew Williams
One hurdle to consider is how supported is your hardware. I really wanted to move to Ubuntu (I was upgrading drives anyway), but hit problem after problem on my Dell 1501 using the 8.10 release. It seems that the 1501 just has craptastic time of it based on the amount of reports I found

RE: Application Scope Problem

2009-06-18 Thread Dawson, Michael
We have had instances where a component, stored in the application scope, could not be found. It is weird, because it works 99% of the time. Thanks, Mike -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Thursday, June 18, 2009 7:54 AM To: cf-talk

RE: Application Scope Problem

2009-06-18 Thread Adrian Lynch
How are you setting the component in the app scope? -Original Message- From: Dawson, Michael [mailto:m...@evansville.edu] Sent: 18 June 2009 14:20 To: cf-talk Subject: RE: Application Scope Problem We have had instances where a component, stored in the application scope, could

RE: Application Scope Problem

2009-06-18 Thread Jason Fisher
Sticky, meaning that a variable holds the same value across multiple calls, because it's in the application scope, and therefore shared across all users of that application. The 'arguments' scope should be used within the body of the function, not the CFARGUMENT tag. So, this is fine:

RE: Application Scope Problem

2009-06-18 Thread Paul Alkema
Code Example !--- Start set application in scope --- cfset application.translator=createObject(component,'packages.translator.transla tor') !--- End set application in scope --- !--- Start function --- cffunction access=public name=lookup

RE: Application Scope Problem

2009-06-18 Thread Adrian Lynch
Sorry Paul, I was talking to Michael. Just wanted to see how it was set because I've had similar errors but I put it down to OnApplicationStart only partially completing because of an error so some init code wasn't reached. Adrian -Original Message- From: Paul Alkema

Re: Deploying to a server farm

2009-06-18 Thread Wil Genovese
We have 6 CF servers that span our application. Internally I can access each server on the private network by IP address. Our servers also share a single file system so the files are all ways in sync. I wrote code that can be called from any server that then lets me pick any one or more servers

RE: Application Scope Problem

2009-06-18 Thread Dawson, Michael
Well, it's different than I thought. I think, at one time, we had the component in the application scope, but took it out because of similar errors. Now, the component is only created on the few pages where it is required. Still, we have the intermittant errors. Here is one of the error

Re: CFC and jQuery

2009-06-18 Thread James White
Just to give you another way of looking at it. JSON is just a string format, much like WDDX is (although a lot less verbose). Without parsing, it's still just a string. The manual way of converting JSON to a JS data struct is by calling eval() on it - like so: var data = eval(myJSONString);

Re: CFC and jQuery

2009-06-18 Thread James White
1) Add dataType:'json' as an attribute of your ajax call, or use $. getJSON 2) use Firebug / console.log to examine the response, make sure DATA is a valid property of the response JSON -- Josh I am trying to call a query from a CFC using jQuery with the following code:

Re: Ubuntu - how WinXP compatible?

2009-06-18 Thread Tom Chiverton
On Thursday 18 Jun 2009, Matthew Williams wrote: This doesn't mean that linux (or Ubuntu) is bad, just that for this particular laptop it wasn't worth it. Aye, and that's why trying with a LiveCD is a must to check things out. Pity Vista/Windows 8 don't allow that, eh. -- Helping to

JS Question: How to include a parameter when assigning a function to an event.

2009-06-18 Thread Ian Skinner
I have this code that is assigning a JS function to the onClick events of elements. container.childNodes[i].onclick = openClose; I would like to assign parameters so that the openClose function of different elements function on specific items. I recoginize that this syntax is not going to

CFHTTP post modifying strings on form post? CF vs PHP

2009-06-18 Thread Anthony Webb
I have a CF page with this: cfhttp method=POST url=http://test.local/test.php; cfhttpparam type=formField name=msg value=I \ am /cfhttp cfoutput#cfhttp.filecontent#/cfoutput And a PHP receiving page: you said: ?php echo $_POST['msg']; ? The output of the CFML page is: you said: I \\ am So, who

Re: Another excel file reading question

2009-06-18 Thread Dan Baughman
Excellent observation. I've altered the code to close the connection as well as the resultset and will respond back to confirm that change does allow another dynamic odbc connection to be opened without restarting coldfusion. I do not use dynamic odbc excel connections much. But one thing

Re: JS Question: How to include a parameter when assigning a function to an event.

2009-06-18 Thread Ian Skinner
I finally found the right combination of Google Search terms and following other links to find at least one solution: container.childNodes[i].onclick = function() {openClose('hello world')}; I would be interesting in hearing if there are other solutions or any difficulties I might have with

RE: CFC and jQuery

2009-06-18 Thread Josh Nathanson
Well eval is essentially a string-to-json conversion. Are you sure your json is valid? Try going here and pasting in your string: http://www.jsonlint.com/ Also, in your jQuery ajax call, it has to be dataType with the capital T - javascript is case sensitive. Josh, I tried datatype:

Re: CFHTTP post modifying strings on form post? CF vs PHP

2009-06-18 Thread Anthony Webb
The wireshark dump confirmed that it WAS NOT cfhttp doing this, but rather a feature of php called magic quotes More info posted here: http://help.imified.com/faqs/building-imified-bots/backslashses-are-inserted-before-certain-characters-when-my-bot-replies I have a CF page with this: cfhttp

Re: JS Question: How to include a parameter when assigning a function to an event.

2009-06-18 Thread cold.fusion
Other solutions? Use JQuery or Ext Core for this type of binding. Makes it very simple, and avoids any cross browser issues. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book

Re: multiple session instances

2009-06-18 Thread Richard White
found out the reason why the onsessionend was not always getting called - i had structclear(session) in the log out code which causes the onsessionend not to fire: here is a good site that i got all the info from to get it working:

Re: JS Question: How to include a parameter when assigning a function to an event.

2009-06-18 Thread Tony Bentley
Use JQuery and then check out the documentation on binding an event. A classic example is passing the id to a function to identify that element inside of the function: $(#TheButton).bind(click,function(el){openClose( $(this).attr(id) )}); function openClose(el){ if($(el).is(.closed)){

Re: captcha

2009-06-18 Thread Phillip Vector
I started to put in this system and ran into an error.. It may be that I'm adapting it to Fusebox, but perhaps not.. On the processing page, I get.. Could not find the ColdFusion Component or Interface cfformprotect.cffpVerify. Ensure that the name is correct and that the component or

css and cfdocument...grrr

2009-06-18 Thread Judah McAuley
Ok, I know cfdocument is finicky about the html it tries to render into a pdf. I have a template I'm putting together and it validates xhtml transitional, it uses both @import and link to include the stylesheet (just in case), I use a standard Yahoo supplied reset css file and the resulting html

RE: css and cfdocument...grrr

2009-06-18 Thread Andy Matthews
Also, floats don't work correctly in cfdocument. -Original Message- From: Judah McAuley [mailto:ju...@wiredotter.com] Sent: Thursday, June 18, 2009 1:17 PM To: cf-talk Subject: css and cfdocument...grrr Ok, I know cfdocument is finicky about the html it tries to render into a pdf. I

RE: css and cfdocument...grrr

2009-06-18 Thread Mark Kruger
This is pretty old but it might be helpful. http://www.coldfusionmuse.com/index.cfm/2006/2/16/cfdocument.performance The main thing to realize is that converting HTML to PDF is really a trick - going from a fluid medium to a very staticky and specific medium. Unless your HTML is already pretty

Re: css and cfdocument...grrr

2009-06-18 Thread Judah McAuley
The CSS file is definitely being included, so that's good. And I haven't tried to do anything with images yet, thankfully. Perhaps I need to move to a fixed-width layout using inches as units instead of percentages. Or maybe tables. Blech. Thanks for that link though, I haven't looked at that

Re: css and cfdocument...grrr

2009-06-18 Thread Randi Knutson
I use an alternate style sheet that sets fonts to a point size instead of em and has a fixed width. Even then, I sometimes run into an odd scaling down effect if there is too much data. Also, if you have images that you are resizing for the web, make an alternate actual size image for the pdf.

Re: css and cfdocument...grrr

2009-06-18 Thread Judah McAuley
Font sizes I specified in pt instead of em and I tried to do everything in percentages with no px definitions under the theory that pdf is a vector format. No love. Thanks for all the ideas being tossed out though. Judah On Thu, Jun 18, 2009 at 12:00 PM, Randi Knutson rknut...@otan.us wrote:

Re: captcha

2009-06-18 Thread Dave Watts
I started to put in this system and ran into an error.. It may be that I'm adapting it to Fusebox, but perhaps not.. On the processing page, I get..  Could not find the ColdFusion Component or Interface cfformprotect.cffpVerify. Ensure that the name is correct and that the component or

Re: css and cfdocument...grrr

2009-06-18 Thread Randi Knutson
I should have mentioned that I had to put everything in tables for layout. I also removed every non-basic CSS thing I had. I ended up with a print version and a simle print style sheet and the web version with its own nicer style sheet. My client had what is basically an accounting spreadsheet

Converted Application.cfm to Application.cfc and Having Problems

2009-06-18 Thread Dawson, Michael
I have a server with several web sites on it. One site was built with legacy code and the old Application.cfm file. Because of that, I had some mappings and custom tag paths set up in the CF administrator for the entire server. I ran into some conflicts with a new site I'm building. I found

RE: Converted Application.cfm to Application.cfc and Having Problems

2009-06-18 Thread Dawson, Michael
BTW, this is all I have in the Application.cfc at this moment. cfcomponent output=false cfset this.name = AceLink cfset this.customTagPaths = D:\Inetpub\AceLink\custtags,D:\Inetpub\AceLink cfset this.mappings[/] = D:\Inetpub\AceLink cfset this.sessionManagement = true cfset

Re: captcha

2009-06-18 Thread Phillip Vector
Can you tell me what file sets this? On Thu, Jun 18, 2009 at 12:12 PM, Dave Wattsdwa...@figleaf.com wrote: I started to put in this system and ran into an error.. It may be that I'm adapting it to Fusebox, but perhaps not.. On the processing page, I get..  Could not find the ColdFusion

pagination and large recordsets (mysql)

2009-06-18 Thread Mike Little
hey guys, came across the following blog post... http://www.webveteran.com/blog/index.php/web-coding/coldfusion/mysql-and-coldfusion-pagination-version-2/ it is really great and works very fast indeed on a large amount of data. however i was wondering if anyone has seen a similar concept in

Re: ajaxCFC Access Denied

2009-06-18 Thread David Torres
Sorry for that! Hey, I don't know why I didn't see about the mapping thing, that the dots means the level of the folder. Still funny, but I was able to make some pages to work after deleting and uploading the ajax.cfc from the root to the components folder. Still a mistery, but it's working

RE: pagination and large recordsets (mysql)

2009-06-18 Thread Josh Nathanson
There is a pagination cfc at cflib.org. As for that link...oh my gosh...sql injection anyone? -- Josh -Original Message- From: Mike Little [mailto:m...@nzsolutions.co.nz] Sent: Thursday, June 18, 2009 1:20 PM To: cf-talk Subject: pagination and large recordsets (mysql) hey guys,

Re: captcha

2009-06-18 Thread Dave Watts
Can you tell me what file sets this? It's controlled by mappings in the CF Administrator. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago,

Re: pagination and large recordsets (mysql)

2009-06-18 Thread Mike Little
haha - that was my though exactly !! thanks for the link. mike There is a pagination cfc at cflib.org. As for that link...oh my gosh...sql injection anyone? -- Josh hey guys, came across the following blog post...

Re: pagination and large recordsets (mysql)

2009-06-18 Thread Nathan Strutz
Mike, The idea is pretty good - in fact, the mysql function found_rows() is very intriguing. Now, with the code example, I would say that is really, really bad SQL, putting the entire where clause in the URL - you're right to be suspicious. I am sure you could just rig up the query to use

Re: pagination and large recordsets (mysql)

2009-06-18 Thread C S
As for that link...oh my gosh...sql injection anyone? +1 The estimation using LIMIT and FOUND_ROWS() seems okay. But I would re-write the where clause logic to make it safer, and definitely use cfqueryparam. ~| Want to

Re: captcha

2009-06-18 Thread Phillip Vector
Ah.. That would explain it. My hosting plan can't set mapping. Though, I wouldn't think it would be a mapping issue, but *shrugs* On Thu, Jun 18, 2009 at 1:49 PM, Dave Wattsdwa...@figleaf.com wrote: Can you tell me what file sets this? It's controlled by mappings in the CF Administrator.

Re: pagination and large recordsets (mysql)

2009-06-18 Thread Gerald Guido
http://paginationcfc.riaforge.org/ Works like a charm. On Thu, Jun 18, 2009 at 4:19 PM, Mike Little m...@nzsolutions.co.nz wrote: hey guys, came across the following blog post... http://www.webveteran.com/blog/index.php/web-coding/coldfusion/mysql-and-coldfusion-pagination-version-2/ it

Re: pagination and large recordsets (mysql)

2009-06-18 Thread Mike Little
that's great thanks nathan. i too was intrigued by his code - and it really does work fast (i connect to mysql from a local development server for testing at the moment and the query works faster than anything else on the site ha!) i will check out your project for sure. cheers guys. i

Exporting to csv. Every other row is empty.

2009-06-18 Thread Ray Meade
I've spent days trying to set up a simple export to a .csv file with no luck. cffile keeps saving it in html format so I'm using another solution I found online. It seems to work a lot better than cffile, but when I open the .csv file in MS Excel, every other row is blank. When I open it with

Re: css and cfdocument...grrr

2009-06-18 Thread Judah McAuley
I'm getting closer to what I want with a table layout. One thing I can't seem to get so far is a solid background behind table headers. border-collapse works in a browser but isn't supported by the cfdocument. Setting border-spacing, padding and margin all to 0 doesn't seem to do it either. Any

Re: captcha

2009-06-18 Thread Ryan Stille
Phillip I haven't followed this whole thread, but can you really not set mappings or do you just not have access to the Administrator? In CF8, Railo and OpenBD you can set mappings in your Application.cfc file. -Ryan Phillip Vector wrote: Ah.. That would explain it. My hosting plan can't

RE: Converted Application.cfm to Application.cfc and Having Problems

2009-06-18 Thread Dawson, Michael
After some basic testing, I narrowed the issue down to the call of the onSessionStart method. However, it did not appear to have anything to do with the user.cfc component. Once I put everything back, the web site is faster than teflon snot on a banana peel. Unless someone has any advice on

Re: captcha

2009-06-18 Thread Phillip Vector
On the hosting I have, I can not access cf administrator. On Thu, Jun 18, 2009 at 2:24 PM, Ryan Stiller...@cfwebtools.com wrote: Phillip I haven't followed this whole thread, but can you really not set mappings or do you just not have access to the Administrator?  In CF8, Railo and OpenBD

RE: ajaxCFC Access Denied

2009-06-18 Thread brad
Did you check to make sure that the stored procedure in your production environment is identical to the one on your dev environment? If I had to guess, I would say that the 5th parameter to your proc (results) is not an OUTPUT parameter. Are you using SQL Server? If so, your procedure should

Re: css and cfdocument...grrr

2009-06-18 Thread Randi Knutson
Solid background behind table headers?.must be the pm slump because I can't think what you mean, but maybe the stuff below will help. I am using border-collapse and setting borders on all my table cells, like this: table style=border-collapse:collapse; border=0 cellpadding=2 cellspacing=0

Re: css and cfdocument...grrr

2009-06-18 Thread Judah McAuley
Ah, I had forgotten about border=0 on the table tag. I was setting border properties and such via css on the table cells but had forgotten about the old school table html tag options. Show's how much table layout I'm doing these days. Your suggestion seems to be solving my problem. And by solid

Re: ajaxCFC Access Denied

2009-06-18 Thread David Torres
Hello Brad, To your questions: The server uses MySQL. I wish I can use SQL Server. Here is the PROC. DELIMITER $$ DROP PROCEDURE IF EXISTS `afmcorporate`.`sp_updateBasePKG` $$ CREATE definer=`afmcorpora...@`%` PROCEDURE `sp_updateBasePKG`( IN in_table VARCHAR(128),

Re: Converted Application.cfm to Application.cfc and Having Problems

2009-06-18 Thread Michael Dinowitz
Are you using the per-app settings right? The docs are a little wonky. I have a writeup on blog of fusion but the basics are below http://www.blogoffusion.com/032508-coldfusion-8-per-app-settings--mappings.cfm This is what the docs say cfset this.mappings[MyMap]=c:\inetpub\myStuff This is what

Re: Exporting to csv. Every other row is empty.

2009-06-18 Thread Peter Boughton
You've got: cfoutput query=qMembers [content] /cfoutput Which is: cfoutput query=qMembersNEWLINE[content]NEWLINE/cfoutput Hence why you're getting empty lines. You need your content to start on the same line as the opening cfoutput, or end the tag on the same line as the content.

RE: ajaxCFC Access Denied

2009-06-18 Thread brad
Hmmm, can you confirm for certain if the error is happening before or after the proc gets called? Can you provide us with a stack trace of where the error happened? Also, is this the null pointer error or are you still having that permissions denied one you started the thread with? As far as

Re: Full screen?

2009-06-18 Thread Don L
On Wed, Jun 17, 2009 at 10:54 PM, D Hulu movie has a full screen option, I'm wondering if we could also easily implement that for a cf web app? Has anyone done something like that? Note, Flash Full Screen mode does NOT allow you to work on another monitor while it's in full screen mode.

RE: Converted Application.cfm to Application.cfc and Having Problems

2009-06-18 Thread Dawson, Michael
Yes, the per-app setting is enabled and I have specified my mappings and custom tag paths in the application.cfc file. The weird thing is that it works the majority of the time, but, man, the performance certainly sucks, not to mention the intermittent I can't find the custom tag errors. I

Re: Converted Application.cfm to Application.cfc and Having Problems

2009-06-18 Thread Michael Dinowitz
Maybe those per app settings are being overwritten in some other part of the app. On Thu, Jun 18, 2009 at 10:23 PM, Dawson, Michael m...@evansville.eduwrote: Yes, the per-app setting is enabled and I have specified my mappings and custom tag paths in the application.cfc file. The weird