Re: getting date from dynamic date ranges

2007-10-23 Thread Ben Doom
datediff() is what you are looking for. --Ben Doom Andrew Whone wrote: > I retrieve a bunch of dynamic DateFroms and DateTos that a user has input > into a form. > > > > > > > > > > > > I want to know the DateFrom of

Re: Which query would be better?

2007-10-22 Thread Ben Doom
I assumed there would be as well, but when I looked it up, that's what the docs for MySQL 5 said. Specifically, I dug around until I found the limit on the IN clause. It said it was limited by max_allowed_packet, which I then looked up. Hence, "according to the docs". --Ben D

Re: UNZIP

2007-10-22 Thread Ben Doom
cfzip? :-) --Ben Doom Richard Colman wrote: > Can anyone recommend a tag for unzipping files programmatically? > > Rick Colman > > ~| Get involved in the latest ColdFusion discussions, product developme

Re: Which query would be better?

2007-10-22 Thread Ben Doom
Which, according to the docs, is only limited by max_allowed_packet. The default is 1Mb, but it can be set arbitrarily up to the size of available RAM if that becomes a problem. --BenD Tom Chiverton wrote: > On Monday 22 Oct 2007, [EMAIL PROTECTED] wrote: >> Also, regardless of the performance

Re: Which query would be better?

2007-10-22 Thread Ben Doom
Offhand, I'd guess using the "in" syntax, if only because it makes your million-line query smaller. However, if you really want to know, write it each way, populate a db with a million rows of fake data, and time it. --BenD Will Tomlinson wrote: > MySQL 5. > > Which would be the better choic

Re: IN CF 7 and beying - using smallint instead of bit - true?

2007-10-18 Thread Ben Doom
s any effect on efficiency. --Ben Doom [EMAIL PROTECTED] wrote: > Another CF developer mentioned to me the other day that it's better to > store 1,0 values in a smallint compared to using bit value for on of off > functionality within an app in CF7 or greater. >

Re: SOT: DNS not specific to ColdFusion

2007-10-17 Thread Ben Doom
Yarr! What webserver be you sailing, me hearty? --Ben Doom Ian Skinner wrote: > So many of you are so knowledgeable, it makes this list piratically > one-stop shopping. > > Simple question hard to Google. Where does one configure ones systems > so that users do not have to

Re: text search in txt file

2007-10-17 Thread Ben Doom
Well, since you are already pulling it into a variable, you can just do a find() or refind() to locate your IP. Which you would use depends, in large part, on whether you are looking for a specific IP or IPs in general. --Ben Doom Orlini, Robert wrote: > I have a cfexecute w/cffile t

Re: Am I going mad

2007-10-17 Thread Ben Doom
be called by something that expects a query object instead of a Group object, so this is a way to convert the results (which, it would appear, don't need converting). Either way, I'd clean the code on a development box and see if anything breaks. If not, then you are clearly

Re: Row total columns

2007-10-17 Thread Ben Doom
I'm a little unclear on what you are asking for. Are you trying to sum all the columns in a row, or all the rows in a column? Is this for manipulation, or just display? --Ben Doom Peter Tanswell wrote: > Hi there > > > I have a program which produces

Re: Creating replicated sites with coldfusion

2007-10-16 Thread Ben Doom
that's actually a very elegant solution. > Also, I will be using an IIS server, not apache, and I don't think there is a > mod_rewrite equivalent with IIS, hopefully somebody can prove me wrong > though! I've never used one, but there were a couple brought up on the

Enabling RDS and/or configuring Report Builder (RDS 404)

2007-10-15 Thread Ben Doom
eport Builder when I try to connect to the IP. Am I missing a step when trying to enable RDS? Does Report Builder require more information that the IP and password? Some third option? --Ben Doom ~| Download the latest ColdFus

Re: Creating replicated sites with coldfusion

2007-10-15 Thread Ben Doom
Well, I can think of a number of ways. All of the ones I'm thinking of offhand require that you have access to your webserver. Basically, they are (in descending order of preference) mod_rewrite or the IIS equivalent, virtual directories, and a custom 404. --Ben Doom Jessica Kennedy

Re: column totals

2007-10-15 Thread Ben Doom
I don't know about actual cycle efficiency, but arraysum(query['row']) is what I use. Very good on typing efficiency. :-) --Ben Doom Toby King wrote: > Hi there > > I have an application where I am outputing a number of sales figures for a > year for various depa

Re: SOT: How do you version control with your CF code?

2007-10-05 Thread Ben Doom
Subversion is pretty cool. Without knowing anything about your servers, I'll say this: It's kind of a pain to set up on a Win server (never tried on a *nix server) but totally worth it. --Ben Doom J W wrote: > I am looking to have better version control at our company and

Re: I'm completely Stumped - All I want to do is ...

2007-10-05 Thread Ben Doom
Can't you dump the mousex, mousey variables into form variables onclick, then submit the form (or something similar)? --Ben Doom [EMAIL PROTECTED] wrote: > All, Sorry for the repeat post. I've searched all day for a solution and > can't find anything. > I want to capt

Re: Best Instant Messanger to Use With CF 8

2007-10-05 Thread Ben Doom
IIRC, CF uses XMPP. The only one I know of (which is not to say it's the only one out there) is Pidgin (http://pidgin.im) or Adium for Mac (which is basically a mac native version of Pidgin). HTH. --Ben Doom Eron Cohen wrote: > Can anyone recommend the best free instant messenger s

Re: Running an exe file without CFEXECUTE

2007-09-28 Thread Ben Doom
to flash. I'm sure the Adobe site can tell you more about it. --Ben Doom Mike Kear wrote: > I dont know .. what's Captivate? > > Can it record someone working an interactive flash gizmo? can you add > captions and speech bubbles etc once you have done that? > > Sorr

Re: Running an exe file without CFEXECUTE

2007-09-28 Thread Ben Doom
Captivate? --Ben Doom Mike Kear wrote: > What's the best way to do these things nowdays?The best way to > record a 'click this button, enter your purchase order number here, > click this choice, select a colour from here, click that button ..."

Re: minus 30

2007-09-27 Thread Ben Doom
I'm not entirely sure why (perhaps CF is counting 20 million seconds) but if you punctuate the date, eg 2007/09/27, it works. --Ben Doom Orlini, Robert wrote: > I tried: #dateformat(DATEADD("m",-1,enddate),"MMDD")# > > If enddate is 20070927: I get: 5685

Re: Horrible condition join

2007-09-27 Thread Ben Doom
So can you not do something like: select whatever from pur right join pro on pur.reg_firmno = pro.reg_firmno (might be left -- I sometimes mix them up) Or is that not supported? Sorry, not a SQL expert and never used Oracle. --Ben Doom Ian Skinner wrote: > "Are there instanc

Re: Horrible condition join

2007-09-27 Thread Ben Doom
Are there instances where pur.reg_firmno is not null but that there is no matching pro.reg_firmno? If so, do you *not* want to pull these records? --Ben Doom Ian Skinner wrote: > I would guess you could rewrite the last bit as > and (pur.reg_firmno is null OR pur.reg_firmno = pro.reg_

Re: Horrible condition join

2007-09-26 Thread Ben Doom
I would guess you could rewrite the last bit as and (pur.reg_firmno is null OR pur.reg_firmno = pro.reg_firmno) or something similar. Is that what you were asking? --Ben Doom Ian Skinner wrote: > I have inherited an ugly database design and need to make do the best I > can within SQL.

Re: CFFILE - alternatives?

2007-09-26 Thread Ben Doom
I would guess that it's not a limitation of CF, but a setting in IIS or Apache or whatever your webserver is. --Ben Doom Kim Hoopingarner wrote: > For some odd reason there seems to be a problem using CFFILE with my host > site when trying to upload files larger than 1.5M. I know i

Package functions getting published?

2007-09-26 Thread Ben Doom
ted/wanted behavior? Can I do something simple to change this? Short of a simple answer, my plan is to rewrite the invoice CFC to be data-only, then write a wrapper CFC for the utility functions. If I have to resort to it, is this a sound plan? CF8, btw.

Re: String validation HELP!!!!

2007-09-25 Thread Ben Doom
That's Perlish for replacing Bobby with Ben. :-) --Ben "Not Bobby" Doom Kenny Kinds wrote: > Is that your suggestion? > >> r/(.*)Bobby(.*)/$1Ben$2/ig >> >> --Ben "Shadow RegEx" Doom >> >> Will Tomlinson wrote: Being the RegEx Ninja, my first thought is to use a regex: >>> How can *you

Re: Permutation problem

2007-09-25 Thread Ben Doom
1! = 7!/6! = 7 for 7 numbers, choose 5 7 choose 5 = 7!/5!(7-5)! = 7!/5!*2! = 7 * 6 / 2 = 7 * 3 = 21 Hopefully, that made some sense. I missed that part in my original post. --Ben Doom Christopher Jordan wrote: > I'm curious why in your case 1,2,3,4,5,6 is considered to be the same as >

Re: String validation HELP!!!!

2007-09-25 Thread Ben Doom
Kung Fu is an idiom. Literally, it means more or less "hard work". I learned the ancient Perl forms. I studied under Dinowitz, O'Reilly, Jochem. I faced the dreaded CF5 POSIX forms and was victorious. Yeah. I worked hard for it. --Ben Doom Kenny Kinds wrote: > This guy&#

Re: String validation HELP!!!!

2007-09-25 Thread Ben Doom
r/(.*)Bobby(.*)/$1Ben$2/ig --Ben "Shadow RegEx" Doom Will Tomlinson wrote: >> Being the RegEx Ninja, my first thought is to use a regex: >> > > How can *you* be the regex ninja when Bobby thinks *he* is. :) > > > ~| Get the

Re: String validation HELP!!!!

2007-09-25 Thread Ben Doom
chars repeated: ([a-z0-9]{3})\1 Is that what you were asking? --Ben Doom Kenny Kinds wrote: > One more question for you. Initially I stated that I was looking for double > characters when i actually i need to search for 3 characters in a row. > Everything i've tried doesn't

Re: String validation HELP!!!!

2007-09-25 Thread Ben Doom
Little do you know, that code lets me exploit holes in your server's ozone with my nuclear bit bucket. Bwah, hahahahahah! --Ben Doom Kenny Kinds wrote: > You guys are awesome! > > Thanks alot. > > Doom, you're not as bad as the

Re: String validation HELP!!!!

2007-09-25 Thread Ben Doom
Sorry, should have been ([a-z0-9]{2}).*\1 ? means 0 or 1, * means 0 or more. --Ben Doom Kenny Kinds wrote: > Doom > > It seems to be working fine except if there is more than one character > between the sets, it one return the proper count. ie. it won't find the sets. &

Re: Permutation problem

2007-09-25 Thread Ben Doom
permute of the remaining list, and length l-1. That is, permute("1,2,3", 2)= 1 + permute("2,3", 1) and 2 + permute("1,3", 1) and 3 + permute("1,2", 1) Make sense? --Ben Doom Ken Fassman wrote: > Hi, > I have a problem I'm struggling to solve

Re: String validation HELP!!!!

2007-09-24 Thread Ben Doom
Not tested, YMMV) --Ben "HoF Regex Ninja" Doom Kenny Kinds wrote: >> Being the RegEx Ninja, my first thought is to use a regex: >> >> ([a-z0-9])\1 >> >> will find any instance of a character next to itself, so if you refind() >> for it across your st

Re: #$^%& Forms!

2007-09-24 Thread Ben Doom
d gotten nothing but praise back. --Ben Doom Michael David wrote: > Ok, I admit it; I hate developing forms! > > There's not one part of the process that I find even remotely > interesting, enlightening, or fulfilling. > > Forms suck. > > Now that I got that off o

Re: CFDocument Question

2007-09-24 Thread Ben Doom
According to the docs, cfdocument supports page-break-before and page-break-after CSS styles. You might want to try using one of those, instead of or in addition to breaking it into items. --Ben Doom Bruce Sorge wrote: > I checked the docs and I don't think that this is possibl

Re: String validation HELP!!!!

2007-09-24 Thread Ben Doom
Being the RegEx Ninja, my first thought is to use a regex: ([a-z0-9])\1 will find any instance of a character next to itself, so if you refind() for it across your string, you can find the repeating chars. --Ben Doom Kenny Kinds wrote: > I'm writing code to verify if a string that is

Re: Darn syntax

2007-09-20 Thread Ben Doom
cachedwithin="#CreateTimeSpan(cache_time)#" This should work. Untested. --Ben Doom ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs

Re: Scrambling data...

2007-09-20 Thread Ben Doom
want them more "randomized" then sort the rows in the query by your PK, or some other column, then only sort either the first or last name column alphabetically. --Ben Doom Will Tomlinson wrote: >> Better living through chemistry. >> >> What do you mean bu "scram

Re: CF makes an appearance on Daily WTF

2007-09-20 Thread Ben Doom
Worse Than Failure. They post examples of terrible code, useless/amusing errors, etc. --Ben Doom Bobby Hartsfield wrote: > Wtf is wtf > > ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://

Re: Wildcard SSL cert

2007-09-20 Thread Ben Doom
No, he used to live in Kentucky. Also, he doesn't really pay attention to sports. Maybe, someday, he will learn to stop teasing people. --Ben Doom Matthew Williams wrote: > I think he meant that pansy blue color that NC state boasts ;). What he > really meant to say was &qu

Re: CF5 Regex Help

2007-09-20 Thread Ben Doom
loop list=yourtext delimiter=chr(10) index = i rereplace(i, "(|)+(.?)(|)+.*", "\2") /loop Not tested, and there is probably a better way. If this were brought up on CF-RegEx, I think I can guarantee a lively (and nostalgic) discussion of CF5 workarounds. --Ben "the out-of-practice RegEx Ninja"

Re: OT: Wildcard SSL cert

2007-09-20 Thread Ben Doom
Wildcard certs only go one level deep. I recently looked into them, and learned this. Also, Duke sucks. Go Big Blue. :-) --Ben Doom Rick Root wrote: > Okay so our IT Guy bought a wildcard certificate for *.duke.edu for > our web server today. We host numerous subdomains > >

Re: Scrambling data...

2007-09-20 Thread Ben Doom
Better living through chemistry. What do you mean bu "scramble" data? Resort two columns so that they dont' line up anymore? Make the data in them unreadable? Generate anagrams? --Ben Doom Will Tomlinson wrote: > I need to scramble data in a few columns for a demo, so i

Re: Forums?

2007-09-19 Thread Ben Doom
rum post, etc.) that rewrites part of your page. It can, for example, redirect forms by overwriting the action on the form. Someone else can probably give better information, though. --Ben Doom NUGROHO NOTO wrote: > Hi, > Can anyone share their thought about this foru

Re: Get Next Scheduled Date

2007-09-18 Thread Ben Doom
I've had to calculate "first Tuesday" and "every other thursday" etc. There isn't a really clean way to do it that I found. I ended up doing a bit of math on day(date) and the number of days in a month. I'm not sure if your way is better or not. --Ben Doom

Re: cfform format=flash not appearing outside of firewall

2007-09-13 Thread Ben Doom
It shows up. It's just really slow. Which is a different problem altogether. --Ben Doom Rebecca Wells wrote: >> No, not really. Whether it's a physical or a virtual directory, you need to >> allow public access to /CFIDE/scripts, or use the SCRIPTSRC attribute of >&g

Re: [SOT] Downloading a zip file using web service

2007-09-13 Thread Ben Doom
PDF via the webservice, then grabbing the PDF via a standard HTTP download. HTH. --Ben Doom Web Specialist wrote: > Hi all. > > we have a client with a zip file which we need to be downloaded to our > network. That client provides only web service access to your network. Is it &

Re: Error creating dir with period/full stop in CF8 and IIS

2007-09-11 Thread Ben Doom
This is a known issue with IIS on Win (as opposed to IIS anywhere else. :-) Basically, .com is an executable extension in Win/DOS. The system therefore looks for the .com file, instead of a directory. I'd suggest using _com instead. Not a perfect solution, but.... --Ben Doom Adrian

Re: "Dynamic" CSS

2007-09-10 Thread Ben Doom
I can think of several different ways to handle this. 1) Process .css files. Bad plan -- it eats resources processing what should be static files. B) Put the static classes in one file, and the changing ones in css files that are dynamically linked. Three) Put the static classes in one fil

Re: listQualify and multiple spaces

2007-08-30 Thread Ben Doom
You could try using a replace or rereplace to change multiple spaces into something you can use as a list qualifier in a more direct way. I'm a fan of the bell chr(7) because you can't type it. :-) You could use replace() and then trim the results to get what you want. This is probably the b

Re: Reg ex question

2007-08-28 Thread Ben Doom
; ##[a-zA-Z0-9]; ##[[:alnum:]]##; Personally, I prefer the second one -- it seems the most readable to me -- but feel free to choose what seems best. YMMV, untested, etc. --Ben Doom Smith, Daron [PA] wrote: > I want to do a reg ex replace to remove all special text characters from > an XML f

Re: Link Generator Tool

2007-08-24 Thread Ben Doom
IIRC, you can return false in the JS call to fix this problem. But that's a vague memory from years ago. --Ben Doom Robert Harrison wrote: > I'm building a link generator tool that creates links to data driven > glossaries. The theory is the user can cut and paste the

Re: API Lookup table

2007-08-14 Thread Ben Doom
You could add a method that stores a postback URL. --Ben Doom Richard Cooper wrote: > Hi all, > > I've created a webservice that allows people to perform an order function > from within their own site. > > It is essentially an ordering system that requires some human

Re: Data Validation Resources

2007-08-13 Thread Ben Doom
? email exists? address can receive mail?) then it might help us suggest good resources. --Ben Doom Joel Watson wrote: > Does anybody have or know of a good resource for validation routines on data, > specifically form data? What I'm looking for is an outline of the various > c

Re: Eclipse/CFEclispe.. Problems

2007-08-10 Thread Ben Doom
Odd. I've always had problems unzipping eclipse unless I used a 3rd party tool. I guess YMMV. --Ben Doom Eric Roberts wrote: > XP's unzip utility works fine...it's Vista's that has a problem with how > Eclipse is compressed. > > Eric > > -Original

Re: Eclipse/CFEclispe.. Problems

2007-08-09 Thread Ben Doom
That looks familiar. Did you use XP's "compressed folder" "utility" to unzip eclipse? If so, that may be the cause of the errors. For whatever reason (IIRC, the "utility" doesn't support that many files) eclipse won't work if you use that.

Re: Cold Fusion MX Blackberry cache problem

2007-08-06 Thread Ben Doom
You could try adding nocache and expire headers. I forget the exact syntax, but there have been threads about it on this list for dealing with proxy servers and the like. --Ben Doom Chad Nikirk wrote: > Hi, > > We have an ASP website that runs with Cold Fusion MX. We recent

Re: homesite for CF8?

2007-08-06 Thread Ben Doom
Even before the Adobe buyout, MM said they were dropping support for HS+ in favor of DW. --Ben Doom Leitch, Oblio wrote: > Ok, so it sounds like there aren't any plans? Just extending HS 5.5 > until it hurts? > > -Original Message- > From: Rey Bango [mailto:[EMAI

Re: CFC complex data type problem

2007-08-03 Thread Ben Doom
>As far as I know you can't specify a return type as an array of component >instances. If the argument type is simple, I can return the array of components just fine. If the argument is a document or document array, it throws this error.

Re: CFC complex data type problem

2007-08-03 Thread Ben Doom
hrows an error. > > Document is defined, and document.cfc is present in the directory. > Further, another function in the component returns an array of > document successfully. > > --Ben Doom ~| En

Re: CFC complex data type problem

2007-08-03 Thread Ben Doom
e directory. Further, another function in the component returns an array of document successfully. --Ben Doom ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver up

Re: CF 8 Lic and VPS

2007-08-03 Thread Ben Doom
See section 1.10(a) of the pdf linked in the previous message. The synopsis is dead on. --Ben Doom Eric Roberts wrote: > I think you are incorrect on the standard licensing. The licensing is for > the physical CPU's only...not how many VM's you have. That has always been &

CFC complex data type problem

2007-08-03 Thread Ben Doom
the ColdFusion Component services.document.]] I've tried creating a document object as a protytype as a property of the webservice: I still get the error. What am I doing wrong? --Ben Doom ~| ColdFusion 8 -

Re: multiple series in cfchart

2007-08-03 Thread Ben Doom
What I've done for date-based data to fix this is to loop across the date range, doing a QoQ for each day, and adding a separate datapoint, rather than using data ranges. --Ben Doom Brad Wood wrote: > I am using cfchart in CF7. > > I am making a simple line graph of CF and JS

Re: CF error

2007-08-01 Thread Ben Doom
All var'd variables must be declared before any "real" code starts. That is, function declaration, argument declarations, var declarations, then the function code. --Ben Doom Chad Gray wrote: > I am cleaning up my CFC code adding and hit this > error What doe

Re: CFC webservice premature end of file

2007-08-01 Thread Ben Doom
Heh. No, but it has a typo in a property name. Thanks. --Ben Doom Sean Corfield wrote: > On 7/31/07, Ben Doom <[EMAIL PROTECTED]> wrote: >> I've got a webservice I've built that successfully produces WSDL, and >> most of the functions seem to work. One is drivin

CFC webservice premature end of file

2007-07-31 Thread Ben Doom
1.0 Full Name Any ideas? --Ben Doom ~| Get involved in the latest ColdFusion discussions, product development sharing, and

Re: Query of Queries date comparison

2007-07-30 Thread Ben Doom
I think you need quotes around your date in the comparison in the SQL. But I always have trouble with QoQ syntax for some reason. --Ben Doom Mark Lewis wrote: > Hi, > > Wondered if someone could advise on this problem I am having. > > I have created a query

Re: Regex help with search strings

2007-07-26 Thread Ben Doom
You could do this with a regex but it would be easier and more efficient to do it with listfind() using a space as the delimiter. --Ben Doom Mark Henderson wrote: > Hi > > I have a search box that currently contains only one field. I normally > have one input for first name, one

Re: cfcontent

2007-07-25 Thread Ben Doom
Use cfheader and cfcontent to set they data type, reset the output, etc. Then just print the XML. If you really need to FORCE them to download it (something I'd not recommend), you could always misset the MIME type to something like application/octet-stream. --Ben Doom Chad Gray wrote

Re: reformatting data in text field

2007-07-25 Thread Ben Doom
It didn't occur to me but, yes, that would likely be a more readable solution than either of mine. --Ben Doom Raymond Camden wrote: > I'm surprised no one mentioned ListQualify. > > On 7/24/07, John P <[EMAIL PROTECTED]> wrote: >> Th

Re: MySQL Client

2007-07-23 Thread Ben Doom
I use the tools published by MySQL. Administrator and Query Browser, specifically. --Ben Doom Oğuz_Demirkapı wrote: > Hi all, > > I am using Navicat (navicat.com) as MySQL client now but I would like to hear > what you have. > > Do you have any MySQL client suggestion

Re: This is a good one - another Regex question

2007-07-20 Thread Ben Doom
You need an asterisk after [[:space:]]. Try that on for size. --Ben Doom Jide Aliu wrote: > Hi Claude - I tried the implementation you suggested, the second half worked > fine all are replaced by but absolutely nothing happened the > top half the opening blah blah sdfsd remains

Re: reformatting data in text field

2007-07-20 Thread Ben Doom
As always, untested, YMMV, keep your head inside the web page at all times. --Ben Doom John P wrote: > Is there a way to reformat text in a text area to add quotation marks and > different line spacing? > So a comma separated list: > > John, Tom, Frank, Bonnie, Jennifer, Ri

Re: job postings?

2007-07-20 Thread Ben Doom
The CF-Jobs list here at House of Fusion? --Ben Doom Leitch, Oblio wrote: > Where is a good place to look for CF developers? We might have an > opening for a "full-time temp". A freelancer would be a great choice. > But where to people post resumes or go to look for jobs?

Re: Quick sorting hack...

2007-07-19 Thread Ben Doom
A tilde? Basically anything in the ascii set (http://www.asciitable.com) that comes after the alphabets and numbers. --Ben Doom Che Vilnonis wrote: > Looking for a hack that I know is not a best practice. This is a temporay > fix. > > For example, I have a product called, &quo

Re: Manipulating bullet list tag using Regex or something else

2007-07-19 Thread Ben Doom
Heh. I gotta stop looking for zebras. Even if someone shouts "Zebra!" Yeah, your solution is much more efficient than mine. --Ben Doom Jochem van Dieten wrote: > Jide Aliu wrote: >> Is it possible to wrap a tag round bullet list like the examplme below, >> amongs

Re: Looking for a US/UK English Dictionary database to use with CF.

2007-07-19 Thread Ben Doom
s, I might scrape some dictionary or thesaurus sites until I have a couple thousand words, and declare it good enough. --Ben Doom Che Vilnonis wrote: > Looking for a US/UK English Dictionary database to use with CF. Anyone know > where to get one? An downloadable Access database would be perf

Re: Manipulating bullet list tag using Regex or something else

2007-07-19 Thread Ben Doom
As long as you can guarantee that you won't have nested lists, it's pretty easy. rereplacenocase(string, "(.*?)", "#1#<\p>", "all") Not tested, from memory, YMMV, keep head and arms inside the regex at all times. And I've done backreferencing in 3 languages since doing it in CF. I think the

Re: Session Variable Types

2007-07-17 Thread Ben Doom
Charlie Griefer wrote: > J2EE sessions end on browser close. traditional cf sessions do not. Now that's some useful information. All I have to do is figure out how it can be useful in my immediate future.... --

Re: Simple JS math?

2007-07-17 Thread Ben Doom
It seems to me you have two choices. You can do it as a string (by converting the 20 to a string and adding a space and the fraction) or as a number, which will give you a decimal. Which are you trying to accomplish? --Ben Doom Che Vilnonis wrote: > Looking to add an integer and a fract

Re: Developer Edition on Portable Hard Drive

2007-07-11 Thread Ben Doom
e portable drive as the webroot should be possible. That way, you only need to have it plugged in to use it. You would still have to replicate datasources et. al. in the admin, but I think that would be simple enough. --Ben Doom Douglas Waite wrote: > I work at a university on a web dev

Re: cfoutput acting weird ... need another set of eyes

2007-07-10 Thread Ben Doom
Could you be doing something like: What happens if you dump the cookie scope? --Ben Doom [EMAIL PROTECTED] wrote: > I've got this simple table ... > > > > Vote 6-12 > Months > > > Vote 13-24 > Months > > > > > I&

Re: "maxlength" on text area - how to approximate

2007-04-02 Thread Ben Doom
Do an additional check onsubmit. That way, even if they paste more than you want to allow, it will get caught client-side. --Ben Doom http://www.bendoom.com Les Mizzell wrote: > Does anybody have a really good way to create the equal of "maxlength" > on a text area? The ser

Re: regex question in rereplace

2007-03-29 Thread Ben Doom
You can certainly do it with a regex, but it might be more efficient to do it with a pair or replace() calls. Regex is inherently expensive. If you want to do it with regex, Jacob's suggestion should work. --Ben Doom Scott Stewart wrote: > I’ve got a variable which is a document de

Re: Help with List Comparisons, Output Logic

2007-03-27 Thread Ben Doom
If you are returning a POST instead of a GET, I'd name all the checkboxes the same. Make the values the page IDs. You'll get a comma-delimited list which you can parse into a large insert. If you have to name them individually, prefix them with something similar (ie page_(ID) so, page_23, pag

Re: Help with List Comparisons, Output Logic

2007-03-27 Thread Ben Doom
ected. That is, if Sponsor 1 wants pages 3 and 4 and Sponsor 2 wants pages 4 and 5 you might end up with a table like this: LinkID SponsorID PageID 1 1 3 2 1 4 3 2 4 4 2 5 Does this make sense? --Ben Doom

Re: MySQL Syntax (4.1)

2007-03-18 Thread Ben Doom
Subqueries weren't introduced until 4.1. Check the top of the 4.x doc page for confirmation if you like. --Ben Doom Matt Quackenbush wrote: > Oooops. I just found out that this particular database is actually 4.0.27, > and not 4.1. According to a few articles that I've found

Re: OT: Job posting

2007-03-15 Thread Ben Doom
You might have better luck posting on CF-Jobs -- the House of Fusion jobs posting list. -- Ben Doom Andy Matthews wrote: > I've never done this before, but I figured it couldn't hurt. Dealerskins is > hiring and I thought I might post the job here. Feel free to ask me > qu

Re: Build Admin tool once, reuse on other sites

2007-03-13 Thread Ben Doom
Well, depending on your setup, you might create a CF mapping that points to the admin. --Ben [EMAIL PROTECTED] wrote: > All, > > Say I have three sites all on the same clustered server. I've built one > admin tool, let's > say a press release admin tool which will be located on site #1. Now

Re: How to unsubscribe

2007-03-09 Thread Ben Doom
Try the link marked "unsubscribe" at the bottom of every email. :-) --Ben Doom Richard Colman wrote: > I need to unsubscribe for a month while on vacation. > > I went to houseoffusion.com and can't find any way to do this. Very > frustrating. HELP

Re: Data truncation:

2007-03-09 Thread Ben Doom
*facepalm* Syntax gets you every time, doesn't it? --Ben Doom Deepak Gupta wrote: > got it > > instead of AND i have to use comma. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years.

Re: Hash Algorithems

2007-03-09 Thread Ben Doom
Tom Chiverton wrote: > It's not defeatable in any useful sense. ::snip:: > Likewise, if I give you a MD5 hash of my password, you can't tell me what my > password is. I cannot necessarily tell you what your password is. However, I can determine a string with the same hash value, such that it wi

Re: Data truncation: Truncated incorrect DOUBLE

2007-03-08 Thread Ben Doom
Is the datasource empty in the live version, or did you remove it to post here? --Ben Doom Deepak Gupta wrote: > HI > > I am getting this error > > Data truncation: Truncated incorrect DOUBLE value: 'Valu

Re: Data truncation: Truncated incorrect DOUBLE

2007-03-08 Thread Ben Doom
Are you sure that the value in arr1 which lines up with D points to a char, varchar, etc.? Try removing the cfquery from around the query to show what is actually being produced. Also, check your schema to make sure that the columns are correctly defined. --Ben Doom Deepak Gupta wrote: >

Re: Data truncation: Truncated incorrect DOUBLE

2007-03-08 Thread Ben Doom
; DG >> Offhand, if arr2 contains values, you should use single quotes around >> it, not double quotes. >> >> --Ben Doom >> >> Deepak Gupta wrote: >>> HI >>> >>> I am getting this error

Re: Data truncation: Truncated incorrect DOUBLE

2007-03-08 Thread Ben Doom
Offhand, if arr2 contains values, you should use single quotes around it, not double quotes. --Ben Doom Deepak Gupta wrote: > HI > > I am getting this error > > Data truncation: Truncated incorrect DOUBLE value: 'Valu

Re: Please put me out of my misery (was How to expire a page?)

2007-03-08 Thread Ben Doom
I'm stretching a bit, but what about using JavaScript to either clear the history or close the window? --Ben Doom Victor Moore wrote: > Can please somebody give me a hint what am I missing here. > Just to recap: > I have an application protected by a login page. > In the main

Re: String Function

2007-03-08 Thread Ben Doom
Use the standard list functions (like listgetat()) using "_" as the delimiter. So, to get BC, you could use listgetat(list, 2, "_") --Ben Doom Deepak Gupta wrote: > Hi > > I have a string like this > AB_BC_DE > > Now i have to extract AB, BC, DE in

<    1   2   3   4   5   6   7   8   9   10   >