Re: Parse text into structure.

2008-11-25 Thread John M Bliss
Fun! cfset thistext = options (direct=true, errors=99) load data into table raw_i append (record_id position(1:1) CHAR, process_mt position(2:3) CHAR, process_yr position(4:5) CHAR, batch_no position(6:9) CHAR, nursery_indposition(14:14) CHAR, county_cd

Re: Parse text into structure.

2008-11-25 Thread John M Bliss
Nice. Why did I think that CFML used: variable[1] but required quotes here: variable[one] Was that *ever* the case? On Tue, Nov 25, 2008 at 1:05 PM, Peter Boughton [EMAIL PROTECTED] wrote: How would some of you take this text file and parse it into a structure? I might do

Re: Parse text into structure.

2008-11-25 Thread John M Bliss
Sweet. Thanks. Like the game Othello, CFML is a moment to learn...a lifetime to master. :-) On Tue, Nov 25, 2008 at 2:07 PM, Peter Boughton [EMAIL PROTECTED] wrote: Well variable[one] is different to variable[#one#] You still need quotes if you are referring to the name of a key directly,

Re: Parse text into structure.

2008-11-25 Thread John M Bliss
I got that. The part I was missing was, variable[x] and variable[#x#] are the same. On Tue, Nov 25, 2008 at 2:53 PM, Jason Fisher [EMAIL PROTECTED] wrote: myVariable[1] may be referring to a numbered element in an array (which have to be integers): cfset myVariable = arrayNew(1) cfset

Re: Wrong results in query

2008-11-26 Thread John M Bliss
You're welcome. As long as you only have one table in your FROM clause, you don't need to use table.column anywhere in your query. You can just use column. Makes for easier-to-read and easier-to-debug SQL. Have a nice day! On Wed, Nov 26, 2008 at 7:38 AM, Jason Congerton [EMAIL PROTECTED]

Re: Wrong results in query

2008-11-26 Thread John M Bliss
I think you can significantly simplify your WHERE clause be losing some vacancies. and some parens. Try: WHERE archive = cfqueryparam cfsqltype=cf_sql_bit value=no cfif Isdefined('divisionID') AND divisionID NEQ 'All'AND vdivisionID = cfqueryparam cfsqltype=cf_sql_integer value=#divisionID#/cfif

Re: problem with sum of resuts of two queries

2008-11-26 Thread John M Bliss
#Evaluate(total1.Expr1 + total2.Expr1)# On Wed, Nov 26, 2008 at 8:34 AM, alex poyaoan [EMAIL PROTECTED] wrote: HI everybody just wondering if there is a way i could sum the results of two queries and display it inside of cfoutput.. the queries are below CFQUERY NAME=total1 datasource=db1

Re: problem with sum of resuts of two queries

2008-11-26 Thread John M Bliss
Second relatively basic thing I learned about CFML syntax in as many days! I've used this language for more than a decade and I didn't know you could omit the Evaluate()! What else don't I know? :-) On Wed, Nov 26, 2008 at 8:40 AM, Andy Matthews [EMAIL PROTECTED]wrote: That's because you need

Re: problem with sum of resuts of two queries

2008-11-26 Thread John M Bliss
[whew] :-) On Wed, Nov 26, 2008 at 9:04 AM, Dave Watts [EMAIL PROTECTED] wrote: I think that's new CF8 syntax. Dave Watts, CTO, Fig Leaf Software -Original Message- From: John M Bliss [EMAIL PROTECTED] Sent: Wednesday, 26 November, 2008 09:46 To: cf-talk cf-talk

Re: problem with sum of resuts of two queries

2008-11-26 Thread John M Bliss
I didn't get the memo. :-) On Wed, Nov 26, 2008 at 9:27 AM, Ian Skinner [EMAIL PROTECTED] wrote: John M Bliss wrote: [whew] :-) On Wed, Nov 26, 2008 at 9:04 AM, Dave Watts [EMAIL PROTECTED] wrote: I think that's new CF8 syntax. Dave Watts, CTO, Fig Leaf Software On Wed, Nov

Re: SQL between dates problem

2008-12-01 Thread John M Bliss
Because GETDATE() will return the current date *and time* and I'll bet that your start/end dates are coming back as 12/1/2008 12:00 AM. On 12/1/08, Will Tomlinson [EMAIL PROTECTED] wrote: SQL server 2000. I have two columns - startdate and enddate, why would this not return a record if the

Re: SQL between dates problem

2008-12-01 Thread John M Bliss
Another CFMLish option: couponstartdate = #CreateODBCDateTime(CreateDateTime(DatePart(, Now()), DatePart(m, Now()), DatePart(d, Now()), 23, 59, 59))# and couponenddate = #CreateODBCDateTime(CreateDateTime(DatePart(, Now()), DatePart(m, Now()), DatePart(d, Now()), 0, 0, 1))# On Mon, Dec

Re: IntelliJ CFML Plugin

2008-12-03 Thread John M Bliss
http://www.urbandictionary.com/define.php?term=wadge 2. wadge - a great mass Had to look it up. :-) On Wed, Dec 3, 2008 at 8:01 AM, Dominic Watson [EMAIL PROTECTED] wrote: hmm... a $250 IDE (personal licence)... Yikes and if you're in the UK, that'd be £187 - £17 above today's exchange

Re: Adobe's CF IDE, Bolt

2008-12-04 Thread John M Bliss
I signed up for the beta. No word from the mothership yet. On Thu, Dec 4, 2008 at 8:36 AM, Rick Faircloth [EMAIL PROTECTED]wrote: So...anyone *not* using the Bolt beta, please raise your hands... I don't see any hands, so it must be out. Is anyone allowed to confirm that it's out and being

Re: Open BlueDragon and Railo - ready?

2008-12-05 Thread John M Bliss
Quoting Dr. Peter Venkman, I'd call that a big yes. :-) (The rest of the line is, Uh, are you habitually using drugs? Stimulants? Alcohol? but that didn't seem to apply here. :-) OpenBD+1 Railo+1 On Fri, Dec 5, 2008 at 2:12 AM, Gert Franz [EMAIL PROTECTED] wrote: David, just yesterday we

Re: What IDEs are folks using?

2008-12-08 Thread John M Bliss
DW CS4. On Mon, Dec 8, 2008 at 5:05 PM, Neil Ross [EMAIL PROTECTED] wrote: I'm curious as to what people are using for IDE of choice these days. I'm sure some folks have moved toward the Eclipse-based IDE but are any of you using the IBM Rational IDE?

Re: Help with consuming .NET complex datatype webservice

2008-12-11 Thread John M Bliss
What do you see when you cfdump YourWebserviceReturnVar.get_any() ? On Thu, Dec 11, 2008 at 12:21 AM, Sebastian Powell [EMAIL PROTECTED] wrote: I am trying to consume a .NET webservice from coldfusion. When I cfinvoke the webservice it returns a complex object which has the get_any() method. I

Re: Source Control Method

2008-12-11 Thread John M Bliss
I like http://www.visualsvn.com/server/ On Thu, Dec 11, 2008 at 10:48 AM, Torrent Girl [EMAIL PROTECTED]wrote: Hello All I need to set up a source control solution and am not familiar with doing this. Doesn't Dreamweaver allow you to manage code? Also can someone suggest a free, easy to

Re: Is Dreamweaver CS4 taking off as an IDE?

2008-12-11 Thread John M Bliss
I like the built-in Spry support in DW. On Thu, Dec 11, 2008 at 1:05 PM, Rick Faircloth r...@whitestonemedia.comwrote: I noticed that the chatter around DW CS4 has increased a lot lately. Isaac, Aaron, Massimo, Michael, et al, are discussing it, and, Isaac, you stated that you want to use

Re: Is Dreamweaver CS4 taking off as an IDE?

2008-12-11 Thread John M Bliss
I've been a CFML dev for 12 years and I still use insight (and/or right-click tag left-click Edit Tag) because I *absolutely do not trust my memory and hate to make mistakes*. I know, I know: slightly anal/OCD. But I swear I'm wicked-fast. :-) On Thu, Dec 11, 2008 at 1:39 PM, s. isaac dealey

Re: Is Dreamweaver CS4 taking off as an IDE?

2008-12-11 Thread John M Bliss
?!?! -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Thursday, December 11, 2008 2:46 PM To: cf-talk Subject: Re: Is Dreamweaver CS4 taking off as an IDE? I've been a CFML dev for 12 years and I still use insight (and/or right-click tag left-click Edit

Re: Is Dreamweaver CS4 taking off as an IDE?

2008-12-11 Thread John M Bliss
I've been asked to do this (notepad coding) in interviews with CFML/SQL/HTML/JS/etc and I can usually pull it out. My methods allow me to spend almost zero time fixing typos/syntax errors/etc where I've helped colleagues track down insidious bugs caused by errant keystrokes. On Thu, Dec 11, 2008

Re: CF-based freelancer time/billing system?

2008-12-18 Thread John M Bliss
Have you checked out riaforge.org? Some possibilities...? http://lighthousepro.riaforge.org http://projecttracker.riaforge.org http://pronto.riaforge.org On Thu, Dec 18, 2008 at 4:47 PM, Jason Durham jdur...@cti-stl.com wrote: I'm looking for an inexpensive tool to keep track of time logs for

Re: Extranet App

2008-12-19 Thread John M Bliss
I've used the following and liked it: http://www.intranetconnections.com It can be used as an extranet and/or intranet and is easy to customize if you know CFML and SQL Server. On Fri, Dec 19, 2008 at 7:39 AM, cfcom cf...@aceligent.com wrote: Looking to purchase a cf extranet application,

Re: SQL2K, CFMX7, Bulk Insert XML

2008-12-20 Thread John M Bliss
This works in 2005. Not sure about 2000. PROCEDURE [dbo].[MySproc] @doc text AS BEGIN DECLARE @idoc int --Create an internal representation of the XML document. EXEC sp_xml_preparedocument @idoc OUTPUT, @doc INSERT INTO MyTable (column1, column2...) SELECT column1, column2... FROM

Re: CF iPhone mutiplayer game host using UDP event gateway whatever?

2009-01-03 Thread John M Bliss
Useful links...? http://tutorial117.easycfm.com http://www.intrafoundation.com/software/UDPClient.htm On Sat, Jan 3, 2009 at 8:21 AM, dicklac...@mac.com dicklac...@mac.com dicklac...@mac.com wrote: Hi I have been away from CF for a few years. My latest activities have been learning Cocoa

Re: market rates

2009-01-04 Thread John M Bliss
FWIW, in my 13-year career in the US (most of it spent doing CFML and SQL Server), I've seen rates of about $40/hr for junior developers up to $200/hr for senior developers. (Granted: $200/hr for senior developers was in the middle of the dot-com-boom in Washington, DC, and it's gone down from

Re: How do you guys deploy databases to shared servers?

2009-01-04 Thread John M Bliss
I can't live without Red-Gate... Which of them do you use to copy/duplicate/synchronise http://www.red-gate.com/products/SQL_Compare/ for DB structure. http://www.red-gate.com/products/SQL_Data_Compare/ for DB contents. On Sun, Jan 4, 2009 at 10:55 PM, Mike Kear afpwebwo...@gmail.com wrote:

Re: How do you guys deploy databases to shared servers?

2009-01-05 Thread John M Bliss
I didn't name them. Just love them. :-) On Sun, Jan 4, 2009 at 11:30 PM, Mike Kear afpwebwo...@gmail.com wrote: huh? the COMPARE product is the one that copies data and structure between two servers??? Really?? Cheers MIke Kear On Mon, Jan 5, 2009 at 4:28 PM, John M Bliss bliss.j

Re: How do you guys deploy databases to shared servers?

2009-01-05 Thread John M Bliss
Red-Gate's answer to this (for SQL Server) is http://www.red-gate.com/products/SQL_Comparison_SDK/ (I think) No, I do not work for Red-Gate. :-) On Mon, Jan 5, 2009 at 4:00 PM, Matt Robertson websitema...@gmail.comwrote: An unhelpful observation: I just migrated a guy off of SQL Server and

Re: Hex Number Formatting

2009-01-08 Thread John M Bliss
Replace(RJustify(yourHex, 3), , 0, all) On Thu, Jan 8, 2009 at 6:11 AM, Kamru Miah k.m...@csl.gov.uk wrote: Hello, I have requirement to use only 3-char to represent value above 999, so I decided to use FormatBaseN() function convert the number to hex (i.e. FFF will give upto 4096), but I

Re: Hex Number Formatting

2009-01-08 Thread John M Bliss
I specialize in simple. ;-) On Thu, Jan 8, 2009 at 9:06 AM, Kamru Miah k.m...@csl.gov.uk wrote: John, that's simpler than I thought! Many thanks. :-) Replace(RJustify(yourHex, 3), , 0, all) ~| Adobe® ColdFusion® 8

Re: Loop and Variable Names

2009-01-08 Thread John M Bliss
That'll only work if guestdetail.guest is an array (i.e. guestdetail.guest[1], guestdetail.guest[2], etc). If it's not and you're really trying to get guestdetail.guest1, I think you need #Evaluate(guestdetail.guest idx)# On Thu, Jan 8, 2009 at 10:04 AM, Les Mizzell lesm...@bellsouth.net wrote:

Re: Loop and Variable Names

2009-01-08 Thread John M Bliss
Right. Brad's syntax is better. :-) On Thu, Jan 8, 2009 at 10:13 AM, b...@bradwood.com wrote: You are trying to treat guest as a struct with a key called 1 through 10. You want to concatenate the word guest with the number, and THAT composite string is the name of the key in the

Re: using tab delimitation

2009-01-15 Thread John M Bliss
Chr(9) On Thu, Jan 15, 2009 at 3:30 PM, Eric Roberts ow...@threeravensconsulting.com wrote: I have to be able to parse a form field that might be tab delimited...it is the default and also what would happen if someone custs and pastes the list from excel... What would I use to represent a

Re: SOT Oracle query OR problem

2009-01-16 Thread John M Bliss
CFQUERY NAME=passport_attendance dbtype=query SELECT passport_attendance_id FROM passport_attendance WHERE student_id = cfqueryparam value=#passport_registration.student_id[pr]# cfsqltype=CF_SQL_INTEGER null=#YesNoFormat(passport_registration.student_id[pr] is '')# OR people_id = cfqueryparam

Re: SOT Oracle query OR problem

2009-01-16 Thread John M Bliss
Oops. Try this: CFQUERY NAME=passport_attendance dbtype=query SELECT passport_attendance_id FROM passport_attendance WHERE cfif passport_registration.student_id[pr] is people_id = cfqueryparam value=#passport_registration.people_id[pr]# cfsqltype=CF_SQL_INTEGER cfelse student_id = cfqueryparam

Re: usps rates

2009-01-17 Thread John M Bliss
http://uspscfc.riaforge.org On Sat, Jan 17, 2009 at 10:09 AM, Matthew Smith chedders...@gmail.comwrote: An e-commerce site I work on wants to transition from UPS to USPS for shipping. Is there a custom tag available for the USPS rates? I found a UPS one way back, I think it was done by

Re: Coldfusion killed my query?

2009-01-19 Thread John M Bliss
Another thing to try: put the query in a sproc and call it with cfstoredproc. Theoretically, modern SQL Server has made it so that cfquery (ad-hoc) is as fast as cfstoredproc...but...maybe... Let us know... On Mon, Jan 19, 2009 at 7:17 AM, Al Musella, DPM muse...@virtualtrials.comwrote: Try

Re: Coldfusion killed my query?

2009-01-19 Thread John M Bliss
What the heck?! Never would have guessed that. You changed cf_sql_type on which queryparam from what to what? On Mon, Jan 19, 2009 at 7:55 AM, Robert Rawlins robert.rawl...@thinkbluemedia.co.uk wrote: Hello Guys, Thank you all for your ideas. After speaking with [Justice] over on the IRC

Re: cfchart in cfdocument.

2009-01-19 Thread John M Bliss
If you do it without the cfdocument so that the chart would appear in the browser, does it still show as a broken image? If so, can you right-click the broken image and pull up the image location? That'll (at least) tell you where that page *thinks* the chart should be... On Mon, Jan 19, 2009

Re: SQL CASE STATEMENTS

2009-01-19 Thread John M Bliss
If you're referring to something like the following, then sure: cfquery dbtype=query select stuff from stuff where cfswitch expression=#var# cfcase value=7 things = 2 /cfcase cfdefaultcase things = 1 /cfdefaultcase /cfswitch /cfquery On Mon, Jan 19, 2009 at 8:19 AM, Torrent Girl

Re: GetTimeZoneInfo() Schedules in local timezone based on UTC

2009-01-23 Thread John M Bliss
And, yes, you should be storing that data as datetime in the database. That'll give you the most flexibility. On Fri, Jan 23, 2009 at 6:00 AM, AJ Mercer ajmer...@gmail.com wrote: Paul Hastings has an excellent CFC that handles timezones and DLT. http://www.sustainablegis.com/blog/cfg11n/

Re: GetTimeZoneInfo() Schedules in local timezone based on UTC

2009-01-23 Thread John M Bliss
, 2009 at 7:41 AM, John M Bliss bliss.j...@gmail.com wrote: And, yes, you should be storing that data as datetime in the database. That'll give you the most flexibility. What should I use as the default date? Just the first date they are added to the schedule for their particular day

Re: GetTimeZoneInfo() Schedules in local timezone based on UTC

2009-01-23 Thread John M Bliss
Concur. datetimes in the DB should all be in the same TZ and then converted to local TZ, as needed, for output. On Fri, Jan 23, 2009 at 7:30 AM, Paul Hastings p...@sustainablegis.comwrote: John M Bliss wrote: Maybe this'll help...? http://recurrence.riaforge.org For a given schedule

Re: GetTimeZoneInfo() Schedules in local timezone based on UTC

2009-01-23 Thread John M Bliss
I see. Good point. On Fri, Jan 23, 2009 at 7:42 AM, Paul Hastings p...@sustainablegis.comwrote: John M Bliss wrote: Concur. datetimes in the DB should all be in the same TZ and then converted to local TZ, as needed, for output. not quite. the problem is that cf sees all datetimes

Re: Adobe Bolt anyone?

2009-01-23 Thread John M Bliss
Nope...but wasn't the rumor, if one is in the beta program, one is not allowed to admit it? On Fri, Jan 23, 2009 at 11:46 AM, Rick Faircloth r...@whitestonemedia.comwrote: Anyone seen the beta of Bolt, yet? Rick ~|

Re: How do I traverse XML using ColdFusion?

2009-01-23 Thread John M Bliss
all I get back are a bunch of stub methods that I don't know how to use What happens when you cfdump those stub methods? Something like cfdump var=#myWebServiceObject.StubMethod()# In my experience, as long as the webservice is developed by a sane person, you'll be able to figure out how to

cfgrid format=html and copy

2009-01-30 Thread John M Bliss
I'm using cfgrid with no onChange wired up (per client). However, client requires copy (Ctrl-C) from cells in grid. So I added cfgrid selectMode=edit ... cfgridcolumn select=yes ... so now end-user can double-click in a cell to get a cursor, highlight text, and Ctrl-C. The problem is that

cfgrid format=html and copy

2009-01-30 Thread John M Bliss
I'm using cfgrid with no onChange wired up (per client). However, client requires copy (Ctrl-C) from cells in grid. So I added cfgrid selectMode=edit ... cfgridcolumn select=yes ... so now end-user can double-click in a cell to get a cursor, highlight text, and Ctrl-C. The problem is that

Re: stock market indexs

2009-01-30 Thread John M Bliss
http://www.webservicelist.com/webservices/c.asp?cid=12web+services On Fri, Jan 30, 2009 at 10:44 AM, Chad Gray cg...@careyweb.com wrote: Anyone know of a CF based app that pulls the current stock market indexes? I can't seem to find anything on cflib or riaforge. Thanks! Chad

Re: Dreamweaver CRASHES!!!

2009-01-30 Thread John M Bliss
My only complaint about DW is that I really don't need the WYSYWIG interface...the rest is pretty awesome. I use DWCS4 and I *never* use the WYSIWYG interface and I love the IDE. It's no longer the case that DW = WYSIWYG = for designers only. On Tue, Jan 27, 2009 at 6:58 PM, Eric Roberts

cfgrid format html and copy

2009-01-30 Thread John M Bliss
I'm using cfgrid with no onChange wired up (per client). However, client requires copy (Ctrl-C) from cells in grid. So I added cfgrid selectMode=edit ... cfgridcolumn select=yes ... so now end-user can double-click in a cell to get a cursor, highlight text, and Ctrl-C. The problem is that

CF8 and Axis

2009-02-03 Thread John M Bliss
Hi! Does anyone know which version of Axis (used by CF to consume webservices) is shipped with CF8? -- John Bliss IT Professional LinkedIn: http://www.linkedin.com/in/jbliss ~| Adobe® ColdFusion® 8 software 8 is the most

Re: Using FileExists function in a CFIF tag

2009-02-03 Thread John M Bliss
Further, most often I used FileExists as follows: FileExists(ExpandPath(../images/myimage.jpg)) On Mon, Feb 2, 2009 at 3:50 PM, C S cfsearch...@yahoo.com wrote: cfset PhotoLocation = http://mls.northernweb.net/images/Photo; .. Any idea of what I am doing wrong? Is there a better way to

Re: CFHTTP error 302 Moved Temporarily

2009-02-03 Thread John M Bliss
Do you know for a fact that #variables.urlAddress# does not relocate you to another page? Can you go to #variables.urlAddress# in your browser? What happens when you do? Do you end up looking at another URL? 302 (or a similar number) is what happens when you use cflocation. On Mon, Feb 2,

Re: CF8 and Axis

2009-02-03 Thread John M Bliss
Thanks! On Mon, Feb 2, 2009 at 9:27 PM, C S cfsearch...@yahoo.com wrote: Hi! Does anyone know which version of Axis (used by CF to consume webservices) is shipped with CF8? Version 1.2.1 cfset axis = createObject(java, org.apache.axis.Version) cfoutput version #axis.getVersion()#br

Re: Acces a record count in javascript

2009-02-03 Thread John M Bliss
Sure: cfoutput script function checkBoxValidate(cb) { for (j = 0; j #query.recordcount#; j++) { if (eval(document.addCust.ckbox[ + j + ].checked) == true) { document.addCust.ckbox[j].checked = false; if (j == cb) { document.addCust.ckbox[j].checked = true; } } } } // End --

Re: Learning Fusebox 5.5 -- Seeking guidance / mentor

2009-02-03 Thread John M Bliss
Assuming you're not opposed to books, www.protonarts.com (when the site's working :-( ) has two books you should purchase: Fusebox 5 FLiP: Master-Class ColdFusion Applications and How to Drive Fusebox 5.5 both by Jeff Peters (www.grokfusebox.com). Other Fusebox resources to bookmark and/or

Re: Fusebox book?

2009-02-03 Thread John M Bliss
SEE thread from earlier today for my 2 cents: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:58671#318786 On Tue, Feb 3, 2009 at 6:23 PM, Joe joe_ts...@hotmail.com wrote: I've been asked to start on a new project from the ground up and I'm interested in using FB55 for this

Re: No SQL Update!

2009-02-03 Thread John M Bliss
Run: SELECT * FROM dbo.Vehicles WHERE (StockNo='#form.carid#') and see if that returns a row. On Tue, Feb 3, 2009 at 6:34 PM, Rick Sanders r...@webenergy.ca wrote: I've been trying to figure this one out. The query gets hit, but the database isn't being updated from the values in the form.

Re: Learning Fusebox 5.5 -- Seeking guidance / mentor

2009-02-04 Thread John M Bliss
Concur. Should have been more clear: How to Drive Fusebox 5.5 *requires*Fusebox 5 FLiP: Master-Class ColdFusion Applications or equivalent FB knowledge. On Tue, Feb 3, 2009 at 10:36 PM, Mary Jo Sminkey mary...@cfwebstore.comwrote: Assuming you're not opposed to books, www.protonarts.com

Re: This CFC function and jQuery Ajax stuff is killing me...

2009-02-04 Thread John M Bliss
Can we have some more background? What are you going to be doing with this data once you get it back to the calling page? A grid or what? On Tue, Feb 3, 2009 at 11:57 PM, James Holmes james.hol...@gmail.comwrote: Try $.getJSON instead of $.ajax for a little more efficiency. cfajaxproxy is

Re: This CFC function and jQuery Ajax stuff is killing me...

2009-02-04 Thread John M Bliss
get this back into a structure where I could use CF code to deal with it...oh, that would be nice... Rick -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Wednesday, February 04, 2009 7:37 AM To: cf-talk Subject: Re: This CFC function and jQuery Ajax

Re: This CFC function and jQuery Ajax stuff is killing me...

2009-02-04 Thread John M Bliss
just try to tackle this so I can keep everything hand-coded. (A glutton for punishment...) Rick -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Wednesday, February 04, 2009 3:20 PM To: cf-talk Subject: Re: This CFC function and jQuery Ajax stuff

Re: Simplest forum

2009-02-05 Thread John M Bliss
Check out http://galleon.riaforge.org On Thu, Feb 5, 2009 at 10:33 AM, Don L do...@yahoo.com wrote: This question has probabaly been raised hundreds of times and yet I feel necessary to do so again. First, Rrequirements, simply three: a) interactive discussion like this forum; b) without

Re: CFFILE - multiple uploads

2009-02-06 Thread John M Bliss
Check out http://uploadformcfc.riaforge.org On Fri, Feb 6, 2009 at 1:56 PM, Fawzi Amadu abd...@gmail.com wrote: Having to alter the functionality of a site, I decided to add multiple upload functionality using CFFILE but I find that I am confused. Looking at my use of CFFILE and CFQUERY

Re: CFMail Failover Capture

2009-02-07 Thread John M Bliss
Why not write CFML that uses cfpop or cfexchangemail to check the messages in the special mailbox for returns and, if they represent bad email addresses, update the DB accordingly... On Sat, Feb 7, 2009 at 9:57 AM, Richard Steele r...@photoeye.com wrote: We send out a weekly newsletter to 22k

Re: CFMail Failover Capture

2009-02-07 Thread John M Bliss
cfpop is the way to go: http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_p-q_08.html#2965096 Should be pretty straightforward: cfpop will return a query result set where each element in the set is a message in the box. Then it's just a matter of either performing a query-of-query on the set

Re: CFMail Failover Capture

2009-02-07 Thread John M Bliss
Look at the content of the special mailbox for returns and look for recurring strings in subject and at the top of the body... On Sat, Feb 7, 2009 at 4:41 PM, Richard Steele r...@photoeye.com wrote: I'm wondering if there is a standard set of reasons for the returned emails that I can use

Re: Coldfusion AJAX Demos

2009-02-08 Thread John M Bliss
http://livedocs.adobe.com/coldfusion/8/htmldocs/ajaxui_1.html http://www.fusionauthority.com/techniques/4593-using-ajax-with-coldfusion-part-i.htm http://www.adobe.com/products/coldfusion/features/ajax_features/ http://www.ajaxcf.com

Re: Html to XML

2009-02-09 Thread John M Bliss
Another possibility...? http://domcfc.riaforge.org On Mon, Feb 9, 2009 at 1:33 PM, Claude Schneegans schneeg...@internetique.com wrote: Does anyone know of a udf or another application that can be used to parse html into xml? Check CF_REextract, especially desined to parse about any

Re: cfc/query/cfoutput question

2009-02-09 Thread John M Bliss
As long as IsQuery(object.getallusers()) returns true. :-) On Mon, Feb 9, 2009 at 7:05 PM, Mike Soultanian msoul...@csulb.edu wrote: So I'm reading this guide and it's really helpful! http://www.iknowkungfoo.com/blog/index.cfm/2007/8/22/Object-Oriented-Coldfusion--1--Intro-to-Objectcfc

Re: CF Vertical Expanding Menu

2009-02-10 Thread John M Bliss
I like Spry: http://labs.adobe.com/technologies/spry/samples/menubar/MenuBarSample.html http://labs.adobe.com/technologies/spry/ On Tue, Feb 10, 2009 at 1:55 PM, Joel Polsky polskystud...@gmail.comwrote: Hi.. Need a easy solution to create a vertical menu system that expands when clicked.

Re: (ot) SQL 2000 + FCKEdit truncation problem

2009-02-11 Thread John M Bliss
Are you using cfstoredproc or cfquery? If cfquery, can you reply with body of query? On Wed, Feb 11, 2009 at 9:48 AM, Les Mizzell lesm...@bellsouth.net wrote: SQL Server 2000 (8.0.x) Database field type ntext Using FCKEditor as a rich text editor for this field There's no restriction on

(ot) WYSIWYG

2009-02-11 Thread John M Bliss
On an *old* project, I'm getting rid of http://www.zrinity.com/activedit/ Which do you prefer...? http://fckeditor.net http://tinymce.moxiecode.com something else -- John Bliss IT Professional LinkedIn: http://www.linkedin.com/in/jbliss

CFML to clean up Word HTML

2009-02-14 Thread John M Bliss
On an old site, I'm moving from http://www.zrinity.com/activedit/ to http://tinymce.moxiecode.com and having issue described here: http://tinymce.moxiecode.com/punbb/viewtopic.php?id=15002 I searched riaforge.org and cflib.org for CFML to clean up Word HTML without affecting the way the HTML

Re: special characters in mysql

2009-02-18 Thread John M Bliss
In MS SQL Server, solution is to use nvarchar instead of varchar and ntext instead of text. Not sure about MySQL... On Wed, Feb 18, 2009 at 6:42 AM, Mike Little m...@nzsolutions.co.nz wrote: aha, i see it has done the same on this site. basically the characters have accents on them. mike

Re: special characters in mysql

2009-02-18 Thread John M Bliss
http://forums.mysql.com/read.php?103,2074,2233#msg-2233 On Wed, Feb 18, 2009 at 6:52 AM, Mike Little m...@nzsolutions.co.nz wrote: from what i can see ntext is not supported in mysql john. i am using mysql 4.1 by the way.

Re: special characters in mysql

2009-02-19 Thread John M Bliss
Might want to post *that* question to the TinyMCE forums...? http://tinymce.moxiecode.com/punbb/ (I looked through http://wiki.moxiecode.com/index.php/TinyMCE:Index and did not see anything obvious.) On Thu, Feb 19, 2009 at 2:21 AM, Mike Little m...@nzsolutions.co.nz wrote: thanks guys,

Re: problem with cfinput tag - when validation on, field requires an entry

2009-02-19 Thread John M Bliss
Why not just use cfinput type=text name=blm_eml1 validate=email ? On Thu, Feb 19, 2009 at 6:42 AM, Jason Fisher ja...@wanax.com wrote: The RegEx pattern is what's insisting on content there. Add a ? at the end of it to allow 0 or 1 of the pattern, and that should then allow the field to be

Re: Googlebot got me good last night...

2009-02-19 Thread John M Bliss
This is where I should post links to Fusebox 5 FLiP and How To Drive Fusebox 5.5 but protonarts.com is down. Anyone have any ideas and/or Jeff Peters on speed dial...? On Thu, Feb 19, 2009 at 6:48 PM, Justin Scott jscott-li...@gravityfree.comwrote: Les Mizzell wrote: You have much to

Re: HTTP_USER_AGENT question

2009-02-20 Thread John M Bliss
It notes the more common bots (google) and assigns them a timeout of 2 seconds. I'm under the impression that bots (or just the Google bot?) don't do sessions at all, no? On Fri, Feb 20, 2009 at 1:44 AM, Michael Dinowitz mdino...@houseoffusion.com wrote: I use this in my

Re: HTTP_USER_AGENT question

2009-02-20 Thread John M Bliss
with state management. Bottom line is that if you have session turned on, every visitor will have a session. On Fri, Feb 20, 2009 at 7:14 AM, John M Bliss bliss.j...@gmail.com wrote: It notes the more common bots (google) and assigns them a timeout of 2 seconds. I'm under

Re: HTTP_USER_AGENT question

2009-02-20 Thread John M Bliss
I learn something every day. Thanks, ya'll. On Fri, Feb 20, 2009 at 6:49 AM, Dave Watts dwa...@figleaf.com wrote: It notes the more common bots (google) and assigns them a timeout of 2 seconds. I'm under the impression that bots (or just the Google bot?) don't do sessions at all,

Re: HTTP_USER_AGENT question

2009-02-20 Thread John M Bliss
Interesting. That seems like a more server-memory-friendly approach. Wonder why Adobe CF does not do it that way... On Fri, Feb 20, 2009 at 7:12 AM, Adrian Lynch cont...@adrianlynch.co.ukwrote: -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: 20 February

Re: HTTP_USER_AGENT question

2009-02-20 Thread John M Bliss
- Original Message - From: John M Bliss bliss.j...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Friday, February 20, 2009 7:20 AM Subject: Re: HTTP_USER_AGENT question Interesting. That seems like a more server-memory-friendly approach. Wonder why Adobe CF does not do

Re: Count the number of times page submitted

2009-02-20 Thread John M Bliss
cfparam name=session.pagecount default=0 cfset session.pagecount = session.pagecount + 1 On Fri, Feb 20, 2009 at 9:47 AM, Priya Koya priya23...@gmail.com wrote: Hi All, I need to count the number of times a page was submitted continuously with a single user. If I set a count in the page

Re: Chrome now higher traffic than IE on some of my sites

2009-03-02 Thread John M Bliss
Seems anomalous to me: http://www.w3schools.com/browsers/browsers_stats.asp 2009 January IE7 25.7% IE6 18.5% IE8 0.6% Fx 45.5% Chrome 3.9% S 3.0% O 2.3% On Mon, Mar 2, 2009 at 6:38 PM, Mike Kear afpwebwo...@gmail.com wrote: For the first time since I

Re: What the heck is happening during CFQUERY?

2009-03-09 Thread John M Bliss
If that's all you need to know, use SELECT TOP 1... On Mon, Mar 9, 2009 at 11:05 AM, Claude Schneegans schneeg...@internetique.com wrote: because that is the only way to get a recordcount. A big price in efficiency to pay for something we use only sometimes. Most of the time, we only

Re: Does String Contain?

2009-03-12 Thread John M Bliss
cfif Find(?, curlink) cfset thisDelim = cfelse cfset thisDelim = ? /cfif cfset newlink = ListAppend(curlink, mynewvars, thisDelim) On Thu, Mar 12, 2009 at 8:52 AM, Robert Harrison rob...@austin-williams.com wrote: I want to know if a string contains a ? or not. Essentially, the

Re: Does String Contain?

2009-03-12 Thread John M Bliss
Great minds... :-) On Thu, Mar 12, 2009 at 10:03 AM, Peter Boughton bought...@gmail.comwrote: Heh, didn't see your answer when I posted. Nice to see we both gave the same solution. :) ~| Adobe® ColdFusion® 8 software 8

Re: How can I make this Replace() work?

2009-03-14 Thread John M Bliss
cfset renamedOriginal = Replace(Replace(cffile.serverFile, , , all), ', , all) cffile action=rename destination=#ExpandPath(renamedOriginal)# source=#ExpandPath(cffile.serverFile)# On Fri, Mar 13, 2009 at 7:26 PM, Rick Faircloth r...@whitestonemedia.comwrote: I have an uploaded file named:

Re: scheduled tasks and performance, whats the impact on the server?

2009-03-18 Thread John M Bliss
If you can call each of them manually and watch them finish quick enough (1-2 seconds?) you probably have nothing to worry about...unless they're set to run once per second or something... On Wed, Mar 18, 2009 at 6:45 AM, Glyn Jackson glyn.jack...@newebia.co.ukwrote: A quick question re

cfgridcolumn dataalign=right

2009-03-18 Thread John M Bliss
Is there a known bug with cfgrid format=html completely ignoring cfgridcolumn's headeralign=right dataalign=right? -- John Bliss IT Professional LinkedIn: http://www.linkedin.com/in/jbliss ~| Adobe® ColdFusion® 8 software 8

Re: cfgridcolumn dataalign=right

2009-03-18 Thread John M Bliss
on the tag, by the way. 2009/3/18 John M Bliss bliss.j...@gmail.com Is there a known bug with cfgrid format=html completely ignoring cfgridcolumn's headeralign=right dataalign=right? -- John Bliss IT Professional LinkedIn: http://www.linkedin.com/in/jbliss

Suppress whitespace in CFC

2009-03-19 Thread John M Bliss
I've written a CFC responsible for returning data to cfgrid format=html bind=cfc:MyCFC.getStuff({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection}) I'm experiencing a strange error and, when I call http://localhost/.../MyCFC.cfc?method=getStuffreturnFormat=json;... the actual

Re: Suppress whitespace in CFC

2009-03-19 Thread John M Bliss
2009 15:30 To: cf-talk Subject: RE: Suppress whitespace in CFC Set output=false in both the cfcomponent and cffunction tags. See if that makes a difference. Adrian -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: 19 March 2009 15:22

Re: Limiting RSS Records

2009-03-20 Thread John M Bliss
cfif arraylen(objRSS.rss.channel.item) LT [insert limit here] cfset Item_Length = arraylen(objRSS.rss.channel.item) / cfelse cfset Item_Length = [insert limit here] / /cfif 2009/3/20 Steve LaBadie slaba...@po-box.esu.edu I am pulling an RSS feed from a 3rd party events calendar and want

Re: cffile name of uploaded file

2009-03-20 Thread John M Bliss
http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_f_10.html#3540091 Parameter - Description attemptedServerFile - Initial name ColdFusion used when attempting to save a file serverFile - Filename of the file saved on the server On Fri, Mar 20, 2009 at 3:11 PM, Nupur Gupta

  1   2   3   4   5   6   7   8   9   >