Re: CF Shopping carts

2010-06-30 Thread Kevin Pepperman
(a one CFC convention-based DI 'framework' in the spirit of FW/1). Yes, I like that idea a lot. FW/1 has inspired me in many ways, the most important thing it has taught me is that conventions, when they are fully understood in a framework-- is the best ways to build things. It is all too

RE: CF Shopping carts

2010-06-30 Thread Eric Roberts
You said you wanted to make it framework agnostic, why not do something that uses the concepts of a framework, but not the actual framework. Back when I was working at ATT, due to their insanely paranoid server restrictions, we couldn't use the actual fusebox tags, so instead, we simulated

Re: SQL - Selecting a row based off linking table row matches

2010-06-30 Thread Will Tomlinson
Use an inner join on the id's that you wish to link across the tables. I don't get what you mean Andrew. Sorry. ~| Order the Adobe Coldfusion Anthology now!

Re: DB2 EBCDIC translation issue [spamtrap bayes][spamtrap heur]

2010-06-30 Thread Rick Root
On Tue, Jun 29, 2010 at 10:04 PM, Paul Hastings p...@sustainablegis.com wrote: On 6/30/2010 12:47 AM, Rick Root wrote: However, setting the codepage to 500 (or 500,0,0) in the connection string using the typdefovr  doesn't seem to help either. dumb question, are you sure there's actually an

Re: DB2 EBCDIC translation issue [spamtrap bayes][spamtrap heur]

2010-06-30 Thread Paul Hastings
On 6/30/2010 7:13 PM, Rick Root wrote: No, I'm not sure it's an encoding error. You suggested that =) it's beyond odd that only the 1 char is getting changed. is the page w/this query still using utf-8 encoding? I don't really know what that means. The extent of the page I'm testing this

JSON response need a little help

2010-06-30 Thread Glyn Jackson
Hi I am trying to create a JSON response it needs to be like the one below. I have created a CFC that returns a validate JSON response but not in the format needed I think I am not understanding something can anyone help? Thanks Response needs to look like this {hotspots: [ {distance:

Re: JSON response need a little help

2010-06-30 Thread Brian Kotek
To get the case to match, use the bracket structure syntax: i.e. response['hotspots'] = . will preserve the case of the key. When you do response.hotspots, CF automatically uppercases the key. On Wed, Jun 30, 2010 at 10:49 AM, Glyn Jackson glyn.jack...@newebia.co.ukwrote: Hi I am trying

Re: JSON response need a little help

2010-06-30 Thread Glyn Jackson
simply things! thanks that is something I missed yes. one last thing looking at what they want back it seems that 'hotspots' needs to be an array can you do implicit Arrays in CF like this would this not give me an error? ~|

RE: JSON response need a little help

2010-06-30 Thread Andy Matthews
You can do implicit array and structure creation in ColdFusion since v8. cfset myArr = [] cfset myStruct = {} Only on CF 9 however can you do this cfset myArr = [] cfset ArrayAppend( myArr, {} ) -Original Message- From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk] Sent:

Re: JSON response need a little help

2010-06-30 Thread Glyn Jackson
cool so something like this would work?... response['hotspots'] = [{ distance ='100', attribution=This is a test layer POI provider, title= My layer - snowy4, lon= 53.472696,

slurping data from an asp.net site

2010-06-30 Thread Jeff Gladnick
There is an asp.net site that I access in order to download a CSV file report. The report is generated on the fly, and I don't want to have to manually click around to get it. I am trying to submit the form via coldfusion, but the site is setup in a strange way. Instead of submitting some

array help how do I do this?

2010-06-30 Thread Glyn Jackson
can anyone tell me what I am doing wrong here as as the hotspots does not seem to like this array i.e. the web service responses back Required field 'title' etc for all fields cfscript var response = StructNew();

ByteArray objects

2010-06-30 Thread Sisk, Kris
Is there a way to convert a java bytearray into something human readable? Everything I've tried has thrown a ByteArray objects cannot be converted to strings error. Kris Sisk USD-457 Technology 1205 Fleming St. Garden City, KS 67846 (620) 805-7107 There are 10 types of people in this

Re: array help how do I do this?

2010-06-30 Thread Glyn Jackson
not an array issues must be to do with the upper-case conversion again, how do i get around that with... response['hotspots'] = [ { distance =100,

Re: slurping data from an asp.net site

2010-06-30 Thread Dave Watts
There is an asp.net site that I access in order to download a CSV file report.  The report is generated on the fly, and I don't want to have to manually click around to get it. I am trying to submit the form via coldfusion, but the site is setup in a strange way.  Instead of submitting

Turning off client variables

2010-06-30 Thread Robert Harrison
can't be either/or.  It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 5241 (20100630) __ The message was checked by ESET Smart Security. http://www.eset.com

RE: Has anyone experienced a blank screen created by ColdFusion.Window.Create?

2010-06-30 Thread Nathan Chen
I forgot to mention an important thing. This doesn't happen in FireFox, just in IE 8.0. Most my users use IE. Is this just an IE thing? Nathan From: Nathan Chen Sent: Wednesday, June 30, 2010 12:11 PM To: cf-talk@houseoffusion.com Subject: Has anyone experienced a blank screen created by

Re: Turning off client variables

2010-06-30 Thread Alan Rother
of virus signature database 5241 (20100630) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology

Has anyone experienced a blank screen created by ColdFusion.Window.Create?

2010-06-30 Thread Nathan Chen
All: I have a page that has a href like this: a href= onClick=ColdFusion.Window.create('MyTest', 'Test Title', 'MyTestPage.cfm?s=2006c=A', {x:100,y:100,height:500,width:900,modal:true,closable:true, draggable:true,resizable:true,center:true,initshow:true, minheight:200,minwidth:200

Re: Turning off client variables

2010-06-30 Thread Dave Watts
AFAIK I am not using any client variables on a site (i.e., any variables in scope client.myvar). I am using session variables (scope session.myvar). I'd like to turn off client variables (to satisfy a host with no CF experience). Are there any unforeseen problems I should be looking for if I

Order By question

2010-06-30 Thread Les Mizzell
, version of virus signature database 5241 (20100630) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology

Re: Order By question

2010-06-30 Thread Michael Grant
, version of virus signature database 5241 (20100630) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion

Re: Order By question

2010-06-30 Thread John M Bliss
), EXCEPT for 2 of them. They need to be LAST regardless of their last names (problem)... Perhaps something with their 2 ID numbers? Ideas? __ Information from ESET NOD32 Antivirus, version of virus signature database 5241 (20100630) __ The message was checked by ESET

RE: Windows SQL 200X Full Text search query quandry [spamtrap heur]

2010-06-30 Thread UXB Internet
Paul, SUBSTRING(URLdescription,PATINDEX('#Searchstring#',URLdescription),256) That worked perfectly. I had never used the PATINDEX command before so I overlooked it completely. A little massaging of the search string to make it a wildcard matching pattern and all is well. Thank you. Dennis

Weird Time Thing

2010-06-30 Thread Robert Harrison
/unplugged __ Information from ESET Smart Security, version of virus signature database 5241 (20100630) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Order the Adobe Coldfusion

RE: Order By question

2010-06-30 Thread Jon Sala
of folks ordered by last_name (no problem), EXCEPT for 2 of them. They need to be LAST regardless of their last names (problem)... Perhaps something with their 2 ID numbers? Ideas? __ Information from ESET NOD32 Antivirus, version of virus signature database 5241 (20100630

Re: Weird Time Thing

2010-06-30 Thread John M Bliss
http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 5241 (20100630) __ The message

Re: Order By question

2010-06-30 Thread Michael Grant
(problem)... Perhaps something with their 2 ID numbers? Ideas? __ Information from ESET NOD32 Antivirus, version of virus signature database 5241 (20100630) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com

RE: JSON response need a little help

2010-06-30 Thread Andy Matthews
Well, remember that JSON is a string representation of a complex object, not the object itself. So if you plan on passing the variable below through SerializeJSON, or ColdFusion's built in JSON returnformat then you'd be okay. andy -Original Message- From: Glyn Jackson

RE: Order By question

2010-06-30 Thread Jon Sala
)... Perhaps something with their 2 ID numbers? Ideas? __ Information from ESET NOD32 Antivirus, version of virus signature database 5241 (20100630) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com

RE: Order By question

2010-06-30 Thread Paul Alkema
? __ Information from ESET NOD32 Antivirus, version of virus signature database 5241 (20100630) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http

RE: Order By question

2010-06-30 Thread brad
And by much faster he means by 100 milliseconds. Realistically, I would not consider the appending of two rows to a query to be a time consuming operation in CF. I would disagree with that approach too, but only on the grounds that is more work, more code, and more convoluted than a simple case

Re: DB2 EBCDIC translation issue [spamtrap bayes][spamtrap heur]

2010-06-30 Thread Rick Root
On Wed, Jun 30, 2010 at 9:12 AM, Paul Hastings p...@sustainablegis.com wrote: On 6/30/2010 7:13 PM, Rick Root wrote: No, I'm not sure it's an encoding error.  You suggested that =) it's beyond odd that only the 1 char is getting changed. It is, isn't it? Isn't it also a bit odd that the

RE: Order By question

2010-06-30 Thread brad
Let's hope no one has a last name starting with any of the following characters: space ! # $ % ' ( ) * + , - . / All of those fall alphabetically before 0. :) ~Brad Original Message Subject: RE: Order By question From: Paul Alkema paulalkemadesi...@gmail.com Date: Wed,

Re: Order By question

2010-06-30 Thread John M Bliss
Yeah *that's* why I didn't suggest your more terse ELSE last_name Yeah. That's the ticket.;-) On Wed, Jun 30, 2010 at 3:13 PM, b...@bradwood.com wrote: Let's hope no one has a last name starting with any of the following characters: space ! # $ % ' ( ) * + , - . / All of those

Converting a trial version to standard

2010-06-30 Thread Rick Colman
I want to buy a license for CF9 to convert an installed trial version to a standard edition. I need a third-party to do it, who does not want me to get their credit-card info (bye-bye Las Vegas). What is the easiest way to buy and install the license? Rick.

Re: Converting a trial version to standard

2010-06-30 Thread Dorioo
I think you just enter the license key in the administrator. And voila, trial becomes standard. - Gabriel On Wed, Jun 30, 2010 at 4:16 PM, Rick Colman rcol...@cox.net wrote: I want to buy a license for CF9 to convert an installed trial version to a standard edition. I need a third-party to

Re: Converting a trial version to standard

2010-06-30 Thread Rick Colman
easiest way to buy the license key ...??? On 6/30/2010 1:18 PM, Dorioo wrote: I think you just enter the license key in the administrator. And voila, trial becomes standard. - Gabriel On Wed, Jun 30, 2010 at 4:16 PM, Rick Colmanrcol...@cox.net wrote: I want to buy a license for CF9

Re: Converting a trial version to standard

2010-06-30 Thread Rick Colman
This seems to be another example of brain-dead design. Why doesn't the trial version have a BIG button that says buy a license right up front on the administrator page. No one ever got rich making it difficult for a customer to make a purchase... On 6/30/2010 1:18 PM, Dorioo wrote: I think

RE: Converting a trial version to standard

2010-06-30 Thread Eric Roberts
Either you buy it and charge them or they buy it and send you the license key...I don't think there is any other option. Eric -Original Message- From: Rick Colman [mailto:rcol...@cox.net] Sent: Wednesday, June 30, 2010 3:20 PM To: cf-talk Subject: Re: Converting a trial version to

RE: Order By question

2010-06-30 Thread brad
lol. My list-of-names-that-will-screw-up-DBAs just got a little longer. ~Brad Original Message Subject: Re: Order By question From: John M Bliss bliss.j...@gmail.com Date: Wed, June 30, 2010 3:16 pm To: cf-talk cf-talk@houseoffusion.com Yeah *that's* why I didn't suggest

RE: Converting a trial version to standard

2010-06-30 Thread Eric Roberts
I don't think going to the adobe website and purchasing it the license is that difficult...I believe there is (or at least was) a link that pointed to the ordering system on the site. But even so, typing adobe.com in your browser isn't that difficult ;-) -Original Message- From: Rick

Re: Order By question

2010-06-30 Thread Andrew Clarke
Check out the article linked in http://developers.slashdot.org/story/10/06/17/2347257/Falsehoods-Programmers-Believe-About-Names for a good read on that. - Andrew. On 2010-06-30, at 16:34, b...@bradwood.com wrote: lol. My list-of-names-that-will-screw-up-DBAs just got a little longer.

Re: Converting a trial version to standard

2010-06-30 Thread Ian Skinner
On 6/30/2010 1:20 PM, Rick Colman wrote: easiest way to buy the license key ...??? www.adobe.com/coldfusion Once they have purchased a license they will have access to a page that allows the downloading of the software and lists the license keys. They provide you the license key, you

Re: Order By question

2010-06-30 Thread Claude Schnéegans
I respectfully disagree with this approach. Doing it in the db will be much faster. Not so sure: If the query has to be ordered by the name, it could use an internal index. If it has to be sorted by some artificial column, there is no index and the query could be much longer. So IMO this

RE: Order By question

2010-06-30 Thread Paul Alkema
I love how almost every question asked on this list will eventually turn into some kind of debate. It's great. :) -Original Message- From: =?ISO-8859-1?Q?Claude_Schn=E9egans [mailto:schneeg...@interneti=71?= =?ISO-8859-1?Q?ue.com=3E?=] Sent: Wednesday, June 30, 2010 5:03 PM To: cf-talk

Re: Order By question

2010-06-30 Thread Les Mizzell
Works the charm: SELECT * FROM judges ORDER BY CASE WHEN judge_id IN (2589,7555) THEN 1 ELSE 0 END, judge_lname Thanks folks... __ Information from ESET NOD32 Antivirus, version of virus signature database 5241 (20100630) __ The message was checked by ESET NOD32 Antivirus

RE: Order By question

2010-06-30 Thread brad
Paul, now's a good time to start a select * rant. :) Glad it works for you Les. ~Brad Original Message Subject: Re: Order By question From: Les Mizzell lesm...@bellsouth.net Date: Wed, June 30, 2010 4:18 pm To: cf-talk cf-talk@houseoffusion.com Works the charm: SELECT *

Re: Order By question

2010-06-30 Thread Les Mizzell
IN (2589,7555) THEN 1 ELSE 0 END, judge_lname __ Information from ESET NOD32 Antivirus, version of virus signature database 5241 (20100630) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com

RE: Order By question

2010-06-30 Thread Eric Roberts
It's what happens when you get a bunch of uber intelligent people who have a lot of knowledge in the same room. Eric -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Wednesday, June 30, 2010 4:12 PM To: cf-talk Subject: RE: Order By question I love

RE: Order By question

2010-06-30 Thread Mark A. Kruger
Paul, I hate to disagree with you but Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Wednesday, June 30, 2010 4:12 PM To:

Re: DB2 EBCDIC translation issue [spamtrap bayes][spamtrap heur]

2010-06-30 Thread Paul Hastings
On 7/1/2010 3:09 AM, Rick Root wrote: It is, isn't it? Isn't it also a bit odd that the IBM web site you originally pointed me to mentioned that exact character translation issue?! and yet didn't tell you how to fix it, i guess that comes of the mentality of charging by the kblock ;-) let

Re: Windows SQL 200X Full Text search query quandry [spamtrap heur]

2010-06-30 Thread Paul Hastings
On 7/1/2010 2:21 AM, UXB Internet wrote: That worked perfectly. I had never used the PATINDEX command before so I overlooked it completely. books-on-line is your best friend when it comes to sql server. ~| Order the Adobe

RE: Order By question

2010-06-30 Thread andy matthews
NOD32 Antivirus, version of virus signature database 5241 (20100630) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe

Re: ByteArray objects

2010-06-30 Thread denstar
On Wed, Jun 30, 2010 at 11:07 AM, Sisk, Kris wrote: Is there a way to convert a java bytearray into something human readable? Everything I've tried has thrown a ByteArray objects cannot be converted to strings error. yourByteArray.toString() maybe? Depends if it's binary data or not, I