Ingres stored-proc/query column rename in CFMX7

2005-05-03 Thread Peter Boughton
Hi, I've got a problem with the following function, which seems to have been caused by upgrading to CFMX7 - it is now only returning an empty query with a single COL_NAMES column, rather than a proper set of data. The theQuery variable is the result of an Ingres stored procedure. The purpose of

Ingres stored-proc/query column rename in CFMX7

2005-05-04 Thread Peter Boughton
Managed to determine that the problem isn't with this function (which is actually much simpler than it first seems), but that the problem is with the dbproc/arguments used. Once I'd solved that problem, the rename started working as it should. Hi, I've got a problem with the following

Strange web service problem.

2006-09-14 Thread Peter Boughton
Here's a piece of code calling a web service: cfinvoke webservice=http://localhost/path/WS.cfc?wsdl; method=X returnvariable=Countries cfinvokeargument name=A value=Codes/ cfinvokeargument name=B value=listCountries/ cfinvokeargument name=C value=#StructNew()#/

Re: Strange web service problem.

2006-09-14 Thread Peter Boughton
The solution was to go into CF Administrator and in Web Services (under Data Services), select Refresh (middle icon) for the appropriate web service. The initial problem was caused by a CF feature/bug that prevents you from using class or method as web service argument names. For the former

Cross-server CFC/WS implementation.

2006-09-18 Thread Peter Boughton
Hello. We are re-building a couple of systems. An internal backend system, and the public website that goes with it. The two systems will be on seperate servers, seperated by a firewall. All the backend logic is to go in CFCs, with the intention that the public website can then just use them

Re: Cross-server CFC/WS implementation.

2006-09-18 Thread Peter Boughton
September 2006 16:00, Peter Boughton wrote: But as I said I don't like it and I'm sure it will cause problems six months down the line. What we do is have our service layer invoke managers from an application-scope'd ColdSpring factory. ColdSpring takes care of making sure

Re: OT: scrolling table

2006-09-19 Thread Peter Boughton
Couldn't see if Jim's link had a solution on it, so here's one that definitely is: http://www.imaputz.com/cssStuff/bigFourVersion.html Anyone have a good solution to have the header row of a table stay where it is and make the data in the table scroll? Kind of like Excel... if you freeze

Re: OT: scrolling table

2006-09-19 Thread Peter Boughton
Ah, I see. Still doesn't hurt to have two options. :) Peter Boughton wrote: Couldn't see if Jim's link had a solution on it, so here's one that definitely is: The scrolling one was called Grayed Out, which is the one I linked to (for examples, that site just reloads the same table

Re: How do I use JS to let someone know a test question needs to be answered

2006-09-22 Thread Peter Boughton
To add to Charlie's response... use a type=button not submit then put an onlcick that will submit() the form so without JS, they cant submit it so they can't circumvent your timer by simply turning off JS Just typing javascript:doSubmit=null; into the address bar will circumvent it, and allow

Re: Designing for Integration

2006-09-22 Thread Peter Boughton
Write all your functions inside CFCs, and use the access=Remote attribute to expose them as web services. Here are some URLs which may be useful: http://www.adobe.com/devnet/coldfusion/articles/intro_cfcs.html http://www.adobe.com/devnet/coldfusion/cfcs.html

Re: Designing for Integration

2006-09-22 Thread Peter Boughton
they will be sharing certain data that is in their databases. so does this mean i have to find out what services they have exposed and then program my application to interact with those web services? Yup - if they've already done that part, you can just consume their web services instead.

Re: cfset hyperlink

2006-09-26 Thread Peter Boughton
Look at the XmlFormat/XmlParse/ToString functions for converting from and to entities. Thanks everyone. I used cfset as an example, but it's actualy going through an admin tool. It's being store in the database as ... Click here to download your free couopn. a href=http://www.site.

Re: OT: Debugging JavaScript

2006-09-28 Thread Peter Boughton
I discovered DP_Debug a few days ago, and I've found it useful for dumping objects (ie: the results of a JS http request to a web service) http://www.depressedpress.com/Content/Development/JavaScript/Extensions/DP_Debug/Index.cfm One of my worst nightmares is having to debug JavaScript. The

Re: CF vs. .NET presentations?

2006-09-29 Thread Peter Boughton
This has never failed to work for me: Slide 1: .NET is a pile of poo! Slide 2: CF is wonderful!!! The End. ;) Alternatively, you could go for the both option, with BlueDragon.NET http://www.newatlanta.com/products/bluedragon/index.cfm Hi, Have any of you done a presentation to justify

Re: Hash Sha-1

2006-10-02 Thread Peter Boughton
Are you certain that the VB.NET output is SHA-1 and that you've copied the complete input string correctly? Here's how I would do what you've got in VB with CF: cfscript testString = SENTRYORD01154321SENTRYORD01154321; HashValue = Hash(testString,'SHA-1','UTF-8'); sa =

Re: JSMX cfchart

2006-10-02 Thread Peter Boughton
I think it's probably simpler to put the cfchart in its own script that is called by an IFRAME and just reload that page by changing the IFRAME src as appropriate. JSMX (and AJAX in general) is designed to transfer ASCII data (XML, JS, etc), not a binary Flash file (which I think is what

Re: Hash Sha-1

2006-10-02 Thread Peter Boughton
Ah, it looks like VB.NET uses 160-bit SHA-1, which is 20 bytes/characters, compared to CF's 28 characters. As pointed out by Greg, Adobe Exchange has a SHA-1 custom tag, and that is 160-bit so should match the value that VB.NET is producing:

Re: JSMX cfchart

2006-10-02 Thread Peter Boughton
If it's a JPEG then you could just have an IMG tag, and change the SRC. ie: img id=mychart src=http://myserver.com/generate_chart.cfm/chart.jpg?params=1/ select onchange=showGraph(this.value) option value=1Something/option option value=2Something Else/option option value=3Another Thing/option

Re: JSMX cfchart

2006-10-03 Thread Peter Boughton
The /chart.jpg suffix is a fix for any buggy software that use file extension instead of mime-type for deciding if something is an image or not. (Plus it helps indicate/remind other programmers and users what the script is doing.) What it actually is a CGI variable called Path Info - anything

Re: Advice on debugging

2006-10-03 Thread Peter Boughton
You can get browser plugins (esp. for Firefox) that help with JavaScript debugging. I think the favourite one is FireBug. For CF debugging, there are a couple of tools that you can pay for (FusionDebug and FusionReactor), but I've no idea how good they might be. Personally, for CF I mainly

Re: The beginnings -- YahooAPI for BBAuth and YahooPhotos

2006-10-04 Thread Peter Boughton
My guess is that nobody has specifically asked for one yet? Check the lsat question of the FAQ though - at least they are aware that CF exists. I went over to the http://developer.yahoo.com/photos/ page just to have a look at what it was all about and couldn't help noticed that there are the

Re: FlashPaper vs PDF

2006-10-04 Thread Peter Boughton
Is there a reason you can't give the choice to the user? Just have a pair of icons and let them choose the one they want. I've got to provide a downloadable and printable form to fill in. I am wondering which route to go down between flashpaper and pdf. Is there any generally accepted

Re: Quicky question re: cfdocument and fonts

2006-10-04 Thread Peter Boughton
What about if you try using span style=font: Whatever;../span ? Howdy -- I'm making my first use of cfdocument (no jokes about being behind the times, please -- I've been busy with other things), and it seems that no matter what I specify in the font tag inside the cfdocument, the

Re: FlashPaper vs PDF

2006-10-04 Thread Peter Boughton
, Peter Boughton [EMAIL PROTECTED] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http

Re: application servers

2006-10-06 Thread Peter Boughton
TomCat is free. However, unless there's a specific reason for using an app server, I'd just recommend sitting it atop Apache. I've not personally been lucky enough to experience 500 concurrent requests, but Apache should certainly be able to handle that many, and a well-written CF application

OT: Weird IIS 503 problem

2006-10-24 Thread Peter Boughton
Hello, apologies if this is not actually CF-related, but I haven't got the foggiest idea what to do next. We've been having a problem where a page was being executed twice, and thus duplicating everything. I managed to track this down to the IIS logs, where I find that for some (but not all)

Re: ColdFusion Template Engine?

2006-10-31 Thread Peter Boughton
Is there something specificly SMARTY-like you're trying to do? Only I can't see any relevant benefit in using obscure PHP-like syntax for this. I would d suggest just using regular variables and packaged custom tags, eg: t:section name=sec1 loop=contacts phone: #phone#br/ fax:

common funcs in custom tags / auto-execute on cfimport?

2006-10-31 Thread Peter Boughton
I have a custom tag package for form controls, which I'm defining like so: cfimport prefix=form taglib=/common/customtags/form/ Most of the custom tags in the package share a common function, which I simply store in the Request scope. Usually this is fine because each page starts form:main and

Re: OT - CSS Float Image Bottom Right corner of DIV

2006-10-31 Thread Peter Boughton
That'll be because you float to the left or the right - there's no facility to float up or down. If you want an image placed in the bottom right, you can set the containers style to be background: url(imagename) no-repeat bottom right; padding-bottom: 100px; (where 100px is the height of the

Re: Fusebox 5 and preprocess in circuit.xml

2006-10-31 Thread Peter Boughton
section and a plugin point, and should therefore only exist in fusebox.xml. cheers, barneyb On 10/31/06, Peter Boughton [EMAIL PROTECTED] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up

Re: Fusebox 5 and preprocess in circuit.xml

2006-10-31 Thread Peter Boughton
meet the need, and can be as simple as prefixing your private fuseactions with an underscore, or as complex as using a separate circuit for private stuff. cheers, barneyb On 10/31/06, Peter Boughton [EMAIL PROTECTED] wrote

Fusebox 5 and preprocess in circuit.xml

2006-10-31 Thread Peter Boughton
Hello. Apologies for cross-posting (from http://www.fusebox.org/forums/messageview.cfm?catid=31threadid=5787), but this is annoying me and I need it fixed ASAP. I have a Fusebox application. It has a circuit.xml which has a preprocess section in it. The preprocess tags are apparently being

Re: date format problem

2006-10-31 Thread Peter Boughton
Here, we always use dd-mmm-. Prevents any ambiguity from incorrect ordering. For user input, we accept dd/mm/yy, but format it onBlur with JavaScript to dd-mmm- (for our Dallas-based office we use a different JS function) Also, within CF, always keep dates as Date Objects, not Strings;

Re: Problem using CreateObject

2006-10-31 Thread Peter Boughton
Not sure if DPI is stored in EXIF (or even if you're only using JPGs), but if so this page might help: http://www.leavethatthingalone.com/blog/index.cfm/2006/5/16/Using-ColdFusion-to-Read-EXIF-Information-from-JPEGs I'm working on an application that needs to be able to find the Dpi of an

Re: common funcs in custom tags / auto-execute on cfimport?

2006-10-31 Thread Peter Boughton
That could work for this instance, but I'd like to have the package indepedant of framework - ie: I want it to work with FB, but not rely on it. How about defining/checking for the function in a prefuse action? On 31/10/06, Peter Boughton [EMAIL PROTECTED] wrote

Re: common funcs in custom tags / auto-execute on cfimport?

2006-10-31 Thread Peter Boughton
. For example: main.cfm/input.cfm/select.cfm/etc. cfif NOT structKeyExists(request, __form_tag_library_initialized) cfinclude template=_init.cfm / /cfif ... _init.cfm cffunction name=... ... /cffunction cfset request. = / ... cheers, barneyb On 10/31/06, Peter Boughton [EMAIL PROTECTED

Re: Fusebox 5 and preprocess in circuit.xml

2006-10-31 Thread Peter Boughton
circuit for private stuff. cheers, barneyb On 10/31/06, Peter Boughton [EMAIL PROTECTED] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers

Re: Fusebox 5 and preprocess in circuit.xml

2006-10-31 Thread Peter Boughton
On 10/31/06, Peter Boughton [EMAIL PROTECTED] wrote: -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard

Re: Fusebox 5 and preprocess in circuit.xml

2006-10-31 Thread Peter Boughton
explicit way: use a per-request flag. cheers, barneyb On 10/31/06, Peter Boughton [EMAIL PROTECTED] wrote: -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Introducing

Re: common funcs in custom tags / auto-execute on cfimport?

2006-10-31 Thread Peter Boughton
That isn't my problem. Okay, I'll explain things using a simple example... Two custom tags, tagA and tagB. Either could be used first on different pages. Both tags use a function Func1. If I define Func1 in tagA, it doesn't exist when tagB is called first. If I define Func1 in tagB, it

Re: FW: Server setup

2006-11-01 Thread Peter Boughton
We've had plenty of problems with IIS5 on Win2k. Most times, there appears to be a simple solution, but it only applies to IIS6, which requires Win2003. So, if you're going Win2003 then IIS is probably fine. Though I've had zero problems with a regular Apache+CF configuration, so I'd probably

Re: Calling a function on a regex backreference

2006-11-02 Thread Peter Boughton
It will work on the whole string, not just the back reference. Ryan, I don't think it's something that can be done with CF, but it might be possible to use Java's regex instead. Have a look at these two blog entries which might help: http://www.bennadel.com/index.cfm?dax=blog:301.view

Re: Google''s Custom Search engine for CF web development

2006-11-02 Thread Peter Boughton
Looks like you're nine days too slow... http://www.usefulconcept.com/index.cfm/2006/10/24/CFHunt--coldfusion-search-engine http://www.cfhunt.com :) Hi Folks I just set up one of those new Google Co-op Custom Search Engines for CF and javascript (DHTML, DOM, etc):

Anyone interested in Railo hosting?

2007-02-06 Thread Peter Boughton
Hello. In a month or two I'll be getting a dedicated server, and I've had a thought: maybe I should go for the next server spec up, get Railo Enterprise, and offer Railo hosting. (for those unaware of what Railo is, it's a really excellent CFML engine, better than all other CFML engines in

Re: Anyone interested in Railo hosting?

2007-02-07 Thread Peter Boughton
Yikes, wasn't expecting this big a response! (If only it was full of people saying YES!) Matt Quackenbush wrote: At the risk of sounding like a complete [EMAIL PROTECTED]!, why would anyone want to go backwards and use Railo? I mean, it's still not even compatible with CF MX. I'm sure

Re: Anyone interested in Railo hosting?

2007-02-07 Thread Peter Boughton
Will you be waiting for version 1.1? I believe that will be very close to Adobe CF 7 I'll be going with the latest stable release. Whether that starts of being 1.1 depends on how soon that is released and how long it takes to get myself sorted. If I'm ready before 1.1 then I'll start with 1.0

Re: Anyone interested in Railo hosting?

2007-02-07 Thread Peter Boughton
You can read the full thing here: http://blog.bpsite.net/index. php/Why%20Railo.html?itemid=24 Ooops, URL got chopped. Should be everything inside the brackets... [ http://blog.bpsite.net/index.php/Why%20Railo.html?itemid=24 ]

Re: Anyone interested in Railo hosting?

2007-02-07 Thread Peter Boughton
Flash Remoting? Not sure I consider that an /important/ feature myself. Eitherway, I think its fair to say that CFMX is always going to be best option for anyone doing Flash/Flex integration stuff. Event Gateway? Ok, but one could argue that this is also absent from CFMX standard. Recordsets

Re: Anyone interested in Railo hosting?

2007-02-07 Thread Peter Boughton
In 1.0 it is possible to call stored procedures in cfquery. Railo 1.1 will support cfstoredproc* I thought that was the case, but I did a quick test with MySQL 5 and it didn't appear to work. The procedure was just a sample one I found: CREATE PROCEDURE molo() SELECT 'Molo'; And when trying

Re: URI trailing question mark.

2007-02-08 Thread Peter Boughton
Not sure I understand your question. If you want to include a quesiton mark on a URL, you must use the url encoded version: page.cfm?variable1=ItemKey%3F If you want to include another query string variable, you do not delimit with quesion marks. The most common delimiter used is ampersand.

Re: A little CSS help

2007-02-08 Thread Peter Boughton
style type=text/css ..col2 {width: 50%; margin: 0px; border-width: 0px; padding: 0px;} ..left {float: left; clear: left;} ..right {float: right; clear: right;} ..break {float: none; clear: both;} /style br class=break/ div class=col2 left [content for left side goes here] /div div class=col2

Re: js to cfscript ? but new issue

2007-02-11 Thread Peter Boughton
There appears to be a fatal flaw in your knowledge of client-side and server-side scripting: they don't happen at the same time or in the same place. When a user enters a url (or clicks a link/etc), the browser sends a request to the server saying give me [whatever]. If the page is associated

Re: Debugging CSS

2007-02-11 Thread Peter Boughton
Definitely Firebug. http://www.getfirebug.com Hey all, How do I go about debugging CSS issues? For example, the two headers in the left and right columns of the content areas of this web site are aligned right, but I don't know why. http://www.countryclubheights.org/index.cfm I

regular expression - callback function

2007-02-12 Thread Peter Boughton
Hello. Does anyone know how I can implement a regex callback? ie: I have the following code: cfset Content = REReplace(Content,'''cfif \(Var\(([^,]+),([^]+))\) ([A-Z]+) ([^]+\)', '''cfif (Var(\1),\2)) \3 \4', all)/ And I need to run a function on \1, \3 and \4 as they are replaced. I'm fairly

Re: regular expression - callback function

2007-02-12 Thread Peter Boughton
. . Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: Monday, February 12, 2007 10:41 AM To: CF-Talk Subject: regular expression

Re: Querying Using List Input To Field

2007-02-12 Thread Peter Boughton
Take the single quotes out. Better still, use CFQP... WHERE vols_volcat.VolCatID IN (cfqueryparam value=#form.VolCatID# cfsqltype=CF_SQL_INTEGER list=true/) Howdy, I'm having a bit of a brain fart trying to figure this out. I want to join four tables to find a user/volunteer that is

Re: Anyone doing anything with wireless scanners and CF?

2007-02-12 Thread Peter Boughton
I think you need to expand on what you're asking. (You are asking a question, right?) Putting data into a database is simple enough with CF, but you need a way to provide CF with the data in the first place. The scanner should have documentation of some sort which explains how it can provide

Re: cfcUnit Configuration Management

2007-02-12 Thread Peter Boughton
I think I had similar problems with cfcUnit and Apache. I 'solved' the problem by going to something stupid like localhost/cfcunit/cfcunit - this was despite having a mapping pointing to (i think) {webroot}/cfcunit/org/cfcunit. With regards to metadata, my personal preferences is to exclude all

Re: cfmx java update for dst

2007-02-12 Thread Peter Boughton
Something like that. This page explains it: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=2d547983 What needs to be changed in CFMX 6.1 regarding the daylight saving time issue? Do I simply need to install the JDK 1.4.2_11 and change the JVM location in CF Admin (Java and JVM

Re: try/catch inside a cfscript tag

2007-02-12 Thread Peter Boughton
My guess would be its not working because trying to add strings is failing at compile time rather than runtime? Try changing it to j = j Mid(chars,i,1); I am trying to figure out why my try/catch is not working inside the following code example below. Can someone please clue me in on

Re: CFFORMS XML Error message appears again .... HELP!

2007-02-13 Thread Peter Boughton
fckeditor is a WYSIWYG editor. It has nothing to do with Adobe/cfforms. Get the Firebug plugin for Firefox, and open the offending pages, and it should be able to identify where the scripts/styles are coming from. I'm getting this error again - i thought it had gone away but its re-appeared

Re: cache one big query or many smaller ones

2007-02-19 Thread Peter Boughton
How do people cache queries when using cfqueryparam? Store the query and creation time in the Application scope? eg, something along the lines of... cfif NOT StructKeyExists(Application.CachedTime,'Whatever') OR DateDiff(h, Application.CachedTime.Whatever, Now()) GTE 4 cfquery

Re: Help with single quote in QofQ

2007-02-19 Thread Peter Boughton
cfqueryparam? Hi, I have a query on which I'm doing a query of queries to find specific values. One of my values has a single quote in it. When I dump the query, I can see the value with the single quote. But when I do a Q of Q on it to find the specific record based on a string comparison,

CFML Hosting Survey

2007-03-01 Thread Peter Boughton
. The survey is at http://www.hybridchill.com/cfml_hosting_survey.cfm If you're interested, please take a moment to fill in the survey. And if you know anyone off-list that might be interested, feel free to refer them to the survey. Thanks! Peter Boughton

Re: Regex question.

2007-03-01 Thread Peter Boughton
Not convinced this is the best way, but it works: cfset Result = REReplace(Data,'(\n([^]*?)([^2][0-9A-F]+|2[^0][0-9A-F]*|20[0-9A-F]+)[^\n]*)+',',','all')/ cfset Result = ListToArray(REReplace(Result,'\s*,\s*([^\s]*)[^,]*',',\1','all'))/ (First REReplace isolates any 20 lines, second one cuts

Re: Regex question.

2007-03-01 Thread Peter Boughton
as a space delimned list and trim(ListFirst(currentline, )). Maybe not as elegant, but at least you can read it. Mik At 05:02 PM 3/1/2007, Peter Boughton wrote: Not convinced this is the best way, but it works: cfset Result = REReplace(Data, '(\n([^]*?)([^2][0-9A-F]+|2[^0][0-9A-F]*|20[0

Re: Regex question.

2007-03-01 Thread Peter Boughton
it. Mik At 05:02 PM 3/1/2007, Peter Boughton wrote: Not convinced this is the best way, but it works: cfset Result = REReplace(Data, '(\n([^]*?)([^2][0-9A-F]+|2[^0][0-9A-F]*|20[0-9A-F]+)[^\n]*)+',', ', 'all')/ cfset Result = ListToArray(REReplace(Result,'\s*,\s*([^\s

Re: php equivalent of application.cfc

2007-03-02 Thread Peter Boughton
There isn't one. You can mimic it with Apache stuff - but why bother when its far better to stick to the glorious CFML and not have to worry about stuff like this. Perhaps you could say why you want to use PHP, so we can convince you that your reasons are worthless and you should stay with us.

Re: Fizzbuzz. Simple programming problems.

2007-03-02 Thread Peter Boughton
A slightly different method (simply because I felt like it). cfscript for (i=1; i LTE 100; i=i+1) { if (i\3 EQ i/3) WriteOutput('fizz'); if (i\5 EQ i/5) WriteOutput('buzz'); if (i\5 NEQ i/5 AND i\3 NEQ i/3) WriteOutput(i);

Re: php equivalent of application.cfc

2007-03-02 Thread Peter Boughton
Ah, I think that was the thing I was referring to with my Apache comment. Didn't realise it was actually a php.ini thing. That could work (as would the related require_once() function), but it's maintenance-intensive since it has to be explicitly included on every page. Look at the

Re: php equivalent of application.cfc

2007-03-02 Thread Peter Boughton
Ah, interesting... Did you see my survey about potential low-cost CFML hosting? /cheeky-plug :) heheh, Not my choice, working on a site where they can't afford to move the hosting... If it was my choice, I'd rewrite the damn thing from scratch in CF T On 2 Mar 2007, at 11:24, Peter Boughton

Re: php equivalent of application.cfc

2007-03-02 Thread Peter Boughton
. And it wouldn't be Adobe CF, it'd be Railo (because it's better, faster, and a lot less money.) But yeah, certainly a possibility. :) Heh, Can you 60 gigs a month bandwidth, 25 gigs webspace, with CF for less than £200 PA? T On 2 Mar 2007, at 13:26, Peter Boughton wrote

Re: php equivalent of application.cfc

2007-03-03 Thread Peter Boughton
] Sent: Friday, March 02, 2007 8:40 AM To: CF-Talk Subject: Re: php equivalent of application.cfc Heh, Can you 60 gigs a month bandwidth, 25 gigs webspace, with CF for less than £200 PA? T On 2 Mar 2007, at 13:26, Peter Boughton wrote

Re: Simple JS?

2007-03-05 Thread Peter Boughton
JavaScript has an annoying habit of treating numbers as strings. hrRate * OTRate + hrRate may well be concatenating the values, not adding them. I usually just divide appropriate values by one to force them to numbers (eg: hrRate/1), and it should then add them correctly. This is sooo simple

Re: ANN: CFEclipse 1.3.1

2007-03-05 Thread Peter Boughton
The manual install download is still only 1.3 - can it be updated to 1.3.1 please? Announcing CFEclipse 1.3.1 The CFEclipse Project is proud to present the latest release of the CFEclipse IDE. A lot of effort has gone into the project over the last few months and more releases will be

Re: ANN: CFEclipse 1.3.1

2007-03-05 Thread Peter Boughton
head up. So be prepared for a 1.3.1.1 fix :) MD On 5 Mar 2007, at 12:04, Peter Boughton wrote: The manual install download is still only 1.3 - can it be updated to 1.3.1 please? ~| Create robust enterprise, web RIAs

Re: GotCFM.com - Need Opinion on Whether to Approve a Site

2007-03-05 Thread Peter Boughton
Doesn't bother me either way, but if you're going to include them, you shouldn't make such an issue out of them. All (Non-Adult Themed) immediately makes one go 'huh?' and then selecting the drop down and Adult or Mature Themed (18 years or older required to view) instantly jumps out, with it

Re: Simple JS?

2007-03-05 Thread Peter Boughton
Well, actually, this has nothing to do with JavaScript The absense of seperate addition and concatenation operators in JavaScript is nothing to do with JavaScript? Within an HTML form, fields contain string values. Unless you do a*b or a-b, where it will convert the values to numbers. In the

Re: Dynamic Column Name

2007-03-05 Thread Peter Boughton
You want either... qry_Query['#company#_visitdate'] Or... qry_Query['#company#_visitdate'][RowNumber] (Depending on context) You could use this... Evaluate(qry_Query.#company#_visitdate) But I don't know anyone who would recommend that method. Hi, I want to output a dynamic column name.

Re: Text Similarity Algorithm

2007-03-06 Thread Peter Boughton
What sort of text? If it's long written stuff, I'd split it into paragraphs then loop through each paragraph and split into sentences, then loop through each sentence and split into words - count the number of matches of words in the related sentence in the original text and if a sentence a

Re: udf var

2007-03-07 Thread Peter Boughton
You're mixing up the global Form scope, with your Arguments.Form struct, and the idea of var scoping function-local variables. You're also missing half the point of creating functions: abstracting and modularising common functionality - what happens if you want to trim another scope or

Re: CFML Hosting Survey

2007-03-07 Thread Peter Boughton
in the survey. And if you know anyone off-list that might be interested, feel free to refer them to the survey. Thanks! Peter Boughton ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create

Re: List Question-

2007-03-09 Thread Peter Boughton
Convert to an array like this: cfset MyArray = MyList.split('|')/ Then insert a null like this: cfqueryparam value=#MyArray[i]# null=#NOT Len(MyArray[i])# cfsqltype=CF_SQL_VARHCHAR/ HI I have this pipe delimited list suppose A||C Now the middle one is blank. How can i store this list so

Re: List Question-

2007-03-09 Thread Peter Boughton
VARHCHAR - I have no idea how I wrote that. :'( Just to note that the cfqueryparam would of course be on the value side of an appropriate insert/update SQL statement within a cfquery, etc. Convert to an array like this: cfset MyArray = MyList.split('|')/ Then insert a null like this:

Re: List Question-

2007-03-09 Thread Peter Boughton
Needs to happen twice - since if you have ab then it'll come out as a| || |b the first time, so it needs doing again to ensure any middle bits get done. Which is why its better to simply use the list_string.split('|') method I've already provided above. replace(list_string,||,| |,all)

Re: display Blob field

2007-03-09 Thread Peter Boughton
This should work: cfsetting showdebugoutput=no/ cfheader name=Content-Disposition value=attachment; filename=myword.doc / cfcontent reset=yes type=application/msword variable=#db_field# / Hi, All: If I store files in Blob field in Oracle(10g), is there a way to output the

Re: How to turn this into a REGEX for use in javascript?

2007-03-10 Thread Peter Boughton
Odd way of doing things? I'd switch it to something like this: cfif NOT REFind('[^0-9.$,]', Form.Sale_Price) /cfif Which (I think) can be translated into this JS: if (sale_price.match(/[^0-9.$,]/) == false) { } Hi, all. I've been tinkering with validation using js and would like to

Re: How to turn this into a REGEX for use in javascript?

2007-03-10 Thread Peter Boughton
, is that, then, what your JS version is doing? Checking to make sure there's nothing but digits 0-9, periods, dollar signs, and commas in the entry? Thanks for the help... Rick -Original Message- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: Saturday, March 10, 2007 2:22 PM To: CF

Re: SQL - slightly OT

2007-03-10 Thread Peter Boughton
You need brackets around the ORs, otherwise it'll only join correctly on the first condition, and not the second two: SELECT * FROM tbl_meddelregos m, tbl_mdconfregoptions r WHERE m.confregoptionid = r.confregoptionid AND (m.confregoptionid = 1 OR m.confregoptionid = 6 OR cocktailparty

Re: Escaping ampersands

2007-03-11 Thread Peter Boughton
Assuming what you're actually asking is how to escape any ampersands that are not part of an existing entity, try this... REReplace(Text,(?!([##A-Za-z0-9]{2,6};)),amp;,all) (because any non-entity ampersands must be escaped everywhere, not just in links) Okay, I can usually figure out my

Re: Escaping ampersands

2007-03-11 Thread Peter Boughton
Hmm, the result argument is displaying as just [ampersand], but I definitely put [ampersand]amp; in it. :/ Assuming what you're actually asking is how to escape any ampersands that are not part of an existing entity, try this... REReplace(Text,(?!([##A-Za-z0-9]{2,6};)),amp;,all)

Re: Escaping ampersands

2007-03-11 Thread Peter Boughton
Hmmm, in that case I'd probably replace out any JS ones first, then run the above, then swap back in the JS ones. And the easiest way of doing that would probably be something like this: cfset Text = JREReplace(Text,(?=script[^]*).*?(?=/script),RemoveJsAmp,all)/ [code from above] cfset Text =

Re: variables scope app.cfc methods

2007-03-12 Thread Peter Boughton
Um, put it in the Request scope? Does anyone know how to write a variables.var in the onRequestStart() and be able to read it onRequest()? The usual suspects don't seem to work. Oblio This email message may contain privileged and/or confidential information. If you are not the

Re: variables scope app.cfc methods

2007-03-12 Thread Peter Boughton
-Original Message- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 10:01 AM To: CF-Talk Subject: Re: variables scope app.cfc methods Um, put it in the Request scope? Does anyone know how to write a variables.var in the onRequestStart() and be able

Re: variables scope app.cfc methods

2007-03-12 Thread Peter Boughton
. If it can't be done, I'd rather know that. Oblio -Original Message- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 10:01 AM To: CF-Talk Subject: Re: variables scope app.cfc methods Um, put it in the Request scope? Does anyone know how to write a variables.var

Re: db locking

2007-03-12 Thread Peter Boughton
You don't need those hashes in the CFSETs. Can't fully answer your question, but have a look at the ISOLATION attribute of CFTRANSACTION for a start. Hi. I have a database table with a single row and following columns: TotalMembers RegisteredToday NewestMember I update this row everytime

Firebug Layout Visualisor - for IE?

2007-03-13 Thread Peter Boughton
I need something that will quickly and easily let me traverse the tags in a document and see the margin, border, padding, width and height values. Exactly like the layout tab in Firebug. Except I need it for IE, and Firebug is Firefox-only. So, does anyone have any recommendations for IE tools?

Re: Firebug Layout Visualisor - for IE?

2007-03-13 Thread Peter Boughton
That's not what I need, and is specifically why I said that IEDT doesn't do what I'm asking. (I did actually download and check the latest version before making my post!) -Original Message- I think the IE Developer Toolbar should do what you need (and more). DOM explorer/highlighter

Re: Firebug Layout Visualisor - for IE?

2007-03-13 Thread Peter Boughton
Would be [more] useful if it worked like Firebug's one, showing all declarations applying to it and putting a strikethrough on properties that have been overridden. (As opposed to just linking to the declaration line in the original stylesheet). Still not at all what I'm looking for though - I

Re: Another captcha alternative

2007-03-13 Thread Peter Boughton
It's a grid of about 25 images, with a different number of cats in each set. I haven't read the entire site you pointed to, but since it's only asking the user to identify whether the photo is of a cat or a dog, doesn't that give bots a 50-50 chance of getting the answer correct? Like I said,

  1   2   3   4   5   >