Re: secure cross-domain login

2008-01-09 Thread William Seiter
Just a thought, but you could have the sending site create a unique url string variable (encrypted of course) when the user clicks on the link that goes to your page: 1. The code would look for the encrypted url string in lieu of the login credentials. 2. If it exists, then your

Re: Adobe ColdFusion IDE survey

2008-01-09 Thread Tom Chiverton
On Tuesday 08 Jan 2008, Andy Allan wrote: If you want to see the follow up to 2007's fuzzy oranges, you will be there ;) Well, now I have to go :-) -- Tom Chiverton Helping to enthusiastically negotiate integrated interfaces on: http://thefalken.livejournal.com

How can you check that CFHTTP is Caching as it should

2008-01-09 Thread Ian Vaughan
Hi I have the following CFHTTP tag script, how do I check that it is caching this data correctly into the Application scope of the server, so the CFHTTP tag does not need to go out to the Internet within the 500 minute timeframe set? This is my Application.cfm page CFAPPLICATION

Re: Adobe ColdFusion IDE survey

2008-01-09 Thread Tom Chiverton
On Tuesday 08 Jan 2008, Claude Schneegans wrote: Eclipse's 'view module' uses the same rendering engine as FireFox Then why not using Firefox directly? The 'I' in IDE :-) I do use a separate FireFox, to be honest, I was just mentioning that IDEs don't always roll their own renderers these

A Very Sophisticated Query

2008-01-09 Thread Gonzo Rock
I know there are a few SQL savants on this list so I wanted to see if I might learn something from one of you. I believe this is a very sophisticated query... at least for me it is ;-)It's a real head scratcher and I really need to figure this out. So here goes... There is some Lot of parts

Re: Shopping Cart Recommendation?

2008-01-09 Thread Tana Adams
The main issue people have with it these days (and typically the reason I get from people that switch to my product) is that it no longer is really a ColdFusion application, it merely uses ColdFusion as the front-end to the underlying Java code. Ok, I wondered about that after reading

Re: How can you check that CFHTTP is Caching as it should

2008-01-09 Thread Tom Chiverton
On Wednesday 09 Jan 2008, Ian Vaughan wrote: I have the following CFHTTP tag script, how do I check that it is caching this data correctly into the Application scope of the server, so ThrowOnError. The LiveDocs are fairly clear, I thought. -- Tom Chiverton Helping to professionally

RE: Multiple Conditions

2008-01-09 Thread Steve LaBadie
Thanks for the tip Dominic that did the trick. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January

Re: ColdFusion 8 Enterprise and FLEX Setup Question

2008-01-09 Thread Rick Root
On 1/9/08, James Blaha [EMAIL PROTECTED] wrote: With a fresh clean install of CF8 Enterprise on Vista WIndows 2003 Server is it out of the box ready for FLEX? Do I need to download anything elese as a addin for FLEX Remoting? Yes, it is out of the box ready for Flex. If you're running a

Re: Adobe ColdFusion IDE survey

2008-01-09 Thread Claude Schneegans
You don't check in FireFox (20%+ of Europe uses it) ? I was speaking about my own customers. In average and roughly, their sites are visited at 80% by MSIE, 10% Firefox, 10% others. But 100% of the administrators are using MSIE, and none is in Europe. So I FIRST check for MSIE compatibility.

Re: Forms within CFWINDOW

2008-01-09 Thread Sam Farmer
Yeah, your right, I see what Pete is after now. The easiest way is to use cfform otherwise you need to use the ColdFusion JavaScript functions. I misread and thought you wanted a form on the main page to submit to a cfwindow. On Jan 8, 2008 8:01 PM, Azadi Saryev [EMAIL PROTECTED] wrote: iirc,

Re: ColdFusion 8 Enterprise and FLEX Setup Question

2008-01-09 Thread James Blaha
Hi Rick, Thanks for the post. Where do I being if I want to use a IIS webroot? I'm the person that would need to set this up in production so I need to learn what needs to be setup and tweaked. -Jim ~| Adobe® ColdFusion® 8

ColdFusion 8 Enterprise and FLEX Setup Question

2008-01-09 Thread James Blaha
All, I just started testing the FLEX Builder software IDE and created the demo samples in their documention. I'm stummped at the CF integration point, Getting Started with Flex 2 Lessons Use ColdFusion Event Gateway Adapter documention area. With a fresh clean install of CF8 Enterprise on

Re: ColdFusion 8 Enterprise and FLEX Setup Question

2008-01-09 Thread James Blaha
Rick, Would this URL apply to CF8 and IIS setup? http://labs.adobe.com/wiki/index.php/Flex_Module_for_Apache_and_IIS -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free

Re: ColdFusion 8 Enterprise and FLEX Setup Question

2008-01-09 Thread Tom Chiverton
On Wednesday 09 Jan 2008, James Blaha wrote: Would this URL apply to CF8 and IIS setup? Not normally. Most people compile 'off line' and but the compiled .swf file in the web servers webroot. The CF installer should configure IIS for you. -- Tom Chiverton Helping to challengingly supply

Re: ColdFusion 8 Enterprise and FLEX Setup Question

2008-01-09 Thread James Blaha
Tom, Thanks I think I'll try doing a fresh CF8 download and reinstall on my Vista OS and see if this fixes my issues. My original WEB-INF direcroty was sitting in the D:\ColdFusion8\wwwroot\WEB-INF then I did a mapping to my local IIS install. So baically I could hit my CF Admin via 8500 or

Re: ColdFusion 8 Enterprise and FLEX Setup Question

2008-01-09 Thread Rick Root
On 1/9/08, James Blaha [EMAIL PROTECTED] wrote: Would this URL apply to CF8 and IIS setup? http://labs.adobe.com/wiki/index.php/Flex_Module_for_Apache_and_IIS What tom said.. you'd only need the flex module for IIS if you wanted to compile on the fly and most people don't do that. I'm just

Re: ColdFusion 8 Enterprise and FLEX Setup Question

2008-01-09 Thread Jo�o_Fernandes
James, if you install CF8 with integrated LCDS you don't need the IIS module compiler since LCDS will that job for you. -- João Fernandes http://www.onflexwithcf.org http://www.riapt.org ~| Adobe® ColdFusion® 8 software 8 is

Some help on defining passing a parameter in text HTML?

2008-01-09 Thread ismail cassiem
Hi, I need help please i usually code in coldfusion but now i want to create 2 text html files where i pass a parameter on href? This normally works in coldfusion! Page1 a href=test.htm?test=100','','height=300,width=300 Page2 html head param name=test value=/ /head body cfoutput #test#

RE: Adobe ColdFusion IDE survey

2008-01-09 Thread Dawson, Michael
And who can argue with the looks alien in Windows...that's a show stopper. (rolls eyes) I'm not a fan of the visual interface of Eclipse. It looks as if the authors either didn't take the time, didn't care or purposely avoided making Eclipse look like a native Windows application. There is

Re: ColdFusion 8 Enterprise and FLEX Setup Question

2008-01-09 Thread Jo�o_Fernandes
Tom, it's easier to have the compiler setup by installing the integrated LCDS during install process than installing CF and then manually install BlazeDS and manually install the web-tier compiler. regarding the original question, people shouldn't forget to set use-mappings property = true in

Re: Some help on defining passing a parameter in text HTML?

2008-01-09 Thread Tom Chiverton
On Wednesday 09 Jan 2008, ismail cassiem wrote: This normally works in coldfusion! So what goes wrong this time ? -- Tom Chiverton, hint: url. This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability

Problems comsuming complex type web sevices.

2008-01-09 Thread Stewart Turnbull
I am trying to invoke a web service with coldfusion that takes and returns complex types. I have been successful with all but 1 of the web service methods. The problem is that I'm unsure how a create a CF structure that can hold a value and attribute and outlined below: ?xml version=1.0

Re: Outputting a hash character in an IIF() function.

2008-01-09 Thread Tom Chiverton
On Wednesday 09 Jan 2008, Ian Skinner wrote: I'm having trouble with this and the usual tricks don't seem to be working. #iif(bgFlag,DE(' style=background-color: #DDFFDD'),DE(''))# Why not just rewrite it so as not to use iif or de ? -- Tom Chiverton Helping to administratively architect

Re: ColdFusion 8 Enterprise and FLEX Setup Question

2008-01-09 Thread Tom Chiverton
On Wednesday 09 Jan 2008, João_Fernandes wrote: James, if you install CF8 with integrated LCDS I wouldn't suggest people start using the intergrated LCDS given it's now a separate open source project (blaze DS). -- Tom Chiverton Helping to dynamically develop sticky metrics on:

Re: Forms within CFWINDOW

2008-01-09 Thread Pete Ruckelshaus
OK, followup to my own question. The form that I am displaying with cfwindow has date fields. I always like to give my users a date picker, and I generally use Mishoo's excellent DHTML calendar -- http://www.dynarch.com/projects/calendar/ However, I was unable to get this to work properly when

Re: Forms within CFWINDOW

2008-01-09 Thread Don L
I'd like to add some quick comments. a) my approach is done when this particular form action usually also have some impact on the Main/Parent window hence justification of reloading this window, otherwise, the cost of reloading the Main window does not seem to be necessary unless not much

Re: Adobe ColdFusion IDE survey

2008-01-09 Thread Brian Kotek
That's because it's a Java application. While it does mean that the GUI will look different than a traditional, native W32 application, it also means that it looks the same on all platforms (Win, Mac, Linux, etc.). Is it the greatest GUI ever? Hell no. But is it OK? Yes. To me (and most people, I

RE: Adobe ColdFusion IDE survey

2008-01-09 Thread Andy Matthews
You have a very valid point M!ke. If you hopped into a car that had a control stick instead of a steering wheel, would THAT make a difference? -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 8:39 AM To: CF-Talk Subject: RE: Adobe

Outputting a hash character in an IIF() function.

2008-01-09 Thread Ian Skinner
I'm having trouble with this and the usual tricks don't seem to be working. #iif(bgFlag,DE(' style=background-color: #DDFFDD'),DE(''))# This fails. I have tried escaping the internal hash character by doubling. I have tried to concatenate chr(35). Everything I do throws exceptions involving

Re: Adobe ColdFusion IDE survey

2008-01-09 Thread Tom Chiverton
On Wednesday 09 Jan 2008, Andy Matthews wrote: You have a very valid point M!ke. If you hopped into a car that had a control stick instead of a steering wheel, would THAT make a difference? If the car had enough features to justify the investment, I'd spend some time getting used to it. It's

Re: Some help on defining passing a parameter in text HTML?

2008-01-09 Thread Ben Doom
Without some kind of server-side processing (PHP, ColdFusion, etc.) or some fancy JavaScript, you aren't going to be able to display a URL variable. Raw HTML can't do that. --Ben Doom ismail cassiem wrote: Hi, I need help please i usually code in coldfusion but now i want to create 2 text

RE: Adobe ColdFusion IDE survey

2008-01-09 Thread Jerry Guido
There is little, or no, use of common Windows icons for Open, Save, Print, Search, etc. That is like looking at a Lunar module and complaining about the color. Never mind that it can land on the moon It looks funny. Seriously, I cannot remember the last time I clicked on any of those icons.

RE: Array Read / Output Help

2008-01-09 Thread Dave
1. cfset IDFound=false cfloop from=1 to=#ArrayLen(DiscArray)# index=i cfif DiscArray[i]=SearchID cfset IDFound=true cfbreak /cfif /cfloop 2. cfloop from=1 to=#ArrayLen(DiscArray)# index=i cfquery name=queryname datasource=ds

RE: Outputting a hash character in an IIF() function.

2008-01-09 Thread Dave
Have you tried assigning it to a variable in a cfset and then displaying the variable. Alternately, convert to RGB: style=background-color:rgb(221 255 221)' -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 9:34 AM To: CF-Talk

RE: Adobe ColdFusion IDE survey

2008-01-09 Thread Mark Kruger
CF-Talkers, Rather than bore the list with a long email I have written a blog post with some of my thoughts on this topic. Remember that I am old and set in my ways so take it for what it's worth :) http://www.coldfusionmuse.com/index.cfm/2008/1/9/Coldfusion.IDE.Debate -Mark Mark A. Kruger,

Re: Outputting a hash character in an IIF() function.

2008-01-09 Thread Ian Skinner
Tom Chiverton wrote: On Wednesday 09 Jan 2008, Ian Skinner wrote: I'm having trouble with this and the usual tricks don't seem to be working. #iif(bgFlag,DE(' style=background-color: #DDFFDD'),DE(''))# Why not just rewrite it so as not to use iif or de ? Generally because I prefer to

Re: Outputting a hash character in an IIF() function.

2008-01-09 Thread Ian Skinner
Dave wrote: Have you tried assigning it to a variable in a cfset and then displaying the variable. Alternately, convert to RGB: style=background-color:rgb(221 255 221)' Yes I can set and use a variable, but I was curious why I would have to do this. Why do I need to create five lines to set

Re: Outputting a hash character in an IIF() function.

2008-01-09 Thread Tom Chiverton
On Wednesday 09 Jan 2008, Ian Skinner wrote: Generally because I prefer to KNOW why I have to replace one clear line of code with 5 lines of slightly less clear code that requires the using a few bits more memory to store a variable I will not use any place else. if (foo){ bar=a }else{

RE: Outputting a hash character in an IIF() function.

2008-01-09 Thread Brad Wood
The hash simply needs to be escaped as #iif(bgFlag,DE(' style=background-color: DDFFDD'),DE(''))# The hash needs to be escaped twice since you are delaying evaluation. The text: style=background-color: DDFFDD Is passed out of the de function as (including the quotes):

RE: Outputting a hash character in an IIF() function.

2008-01-09 Thread Brad Wood
Actually, if I am going to use braces, I like them to align vertically for better readability: if (foo) { bar = a; } else { bar = b; } But enough of this. He didn't ask for our opinions in code readability, he asked how to escape a

cfimage - read, resize, write to browser resize options

2008-01-09 Thread Nathan C. Smith
I ran into a cfimage behavior that was not quite what I expected, perhaps it will be more obvious to others. I wanted to resize an image. I wanted to use cfimage to read the image, resize it, and write it to the browser without saving it back to disk. The resize action is what had me stumped for

Re: Outputting a hash character in an IIF() function.

2008-01-09 Thread Ian Skinner
Brad Wood wrote: The hash simply needs to be escaped as #iif(bgFlag,DE(' style=background-color: DDFFDD'),DE(''))# The hash needs to be escaped twice since you are delaying evaluation. The text: style=background-color: DDFFDD Is passed out of the de function as (including the

Re: Outputting a hash character in an IIF() function.

2008-01-09 Thread Ian Skinner
Tom Chiverton wrote: if (foo){ bar=a }else{ bar=b } b seems clearer to me than nested iif and de. This is completely personal preference and a very very small matter. But I generally find less to be clearer then more. -- cfscript if (foo) { bar='a'; } else {

CFAjaxproxy weird issue.

2008-01-09 Thread Todd
I have a weird issue. I just wanted to create a small test and play around with cfajaxproxy. When I was first developing this test, I had index.cfmand test.cfc in a directory without an Application.cfc and everything worked fine. As soon as I drop this Application.cfc in the same directory as

SOT sql question

2008-01-09 Thread Mark Fuqua
I think I need to be using 'IN' within my WHERE clause but I can't seem to get it to work. I have a column with a comma delimited list. This is the latest attempt and it craps out too. SELECT.. ...WHERE JobFileJob = #session.jobId# AND '#session.UserRole#' IN (JobFileAccessLevel)

CFC, Custom tag, or something for tedious SQL Queries?

2008-01-09 Thread George Linderman
Hey guys, We all do them all the time, just good old basic SQL queries. INSERT, UPDATE etc. However, many times the forms I develop are insanely long...so writing down all of the field names, and then their values every time I want to INSERT or UPDATE is a large source of pain for me. Do you

Re: cfimage - read, resize, write to browser amp; resize options

2008-01-09 Thread Janet MacKay
I wanted to resize an image. I wanted to use cfimage to read the image, resize it, and write it to the browser without saving it back to disk. Did you try using the ImageResize() function instead? Janet ~| Adobe® ColdFusion®

Re: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-09 Thread Todd
Break up the form into forms? On Jan 9, 2008 11:56 AM, George Linderman wrote: Hey guys, We all do them all the time, just good old basic SQL queries. INSERT, UPDATE etc. However, many times the forms I develop are insanely long...so writing down all of the field names, and then their

RE: SOT sql question

2008-01-09 Thread Will Swain
IN works the other way round I think - say you have a list of values and you want to pull all records with any of those values: WHERE name IN (will,john,ray) -Original Message- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: 09 January 2008 16:57 To: CF-Talk Subject: SOT sql question

Re: SOT sql question

2008-01-09 Thread Charlie Griefer
On Jan 9, 2008 8:56 AM, Mark Fuqua [EMAIL PROTECTED] wrote: I think I need to be using 'IN' within my WHERE clause but I can't seem to get it to work. I have a column with a comma delimited list. This is the latest attempt and it craps out too. SELECT.. ...WHERE JobFileJob =

Ajax cfchart

2008-01-09 Thread Dustin Snell [Network Automation]
Is there a way via Ajax to automatically update CFCHART with new data without refreshing the page? If not with CFCHART are there any other technologies out there that can do this? ~| Adobe® ColdFusion® 8 software 8 is the most

Re: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-09 Thread Brian Kotek
Use an ORM. On Jan 9, 2008 11:56 AM, George Linderman [EMAIL PROTECTED] wrote: Hey guys, We all do them all the time, just good old basic SQL queries. INSERT, UPDATE etc. However, many times the forms I develop are insanely long...so writing down all of the field names, and then their

Re: SOT sql question

2008-01-09 Thread Marco Antonio C. Santos
Mark, I'll like to suggest you to use DataMgr. DataMgr is a great time saver tool and could be the answer to your needs. http://datamgr.riaforge.org/ Cheers Marco Antonio C. Santos On Jan 9, 2008 2:56 PM, Mark Fuqua [EMAIL PROTECTED] wrote: I think I need to be using 'IN' within my WHERE

RE: cfimage - read, resize, write to browser amp; resize options

2008-01-09 Thread Nathan C. Smith
I wanted to resize an image. I wanted to use cfimage to read the image, resize it, and write it to the browser without saving it back to disk. Did you try using the ImageResize() function instead? Janet Wow! No, didn't know there was one, this is great. Thanks for the

RE: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-09 Thread Jerry Guido
I use SQL.cfc. http://sqlcfc.riaforge.org/ It is MSSQL Server only. I ported it to MySQL... well sorta. It is CF8 only (CFDbinfo) at the moment, I haven't had the time to make it a pure SQL version nor has it been tested in a production environment. Let me know if you are interested and I can

Re: Ajax cfchart

2008-01-09 Thread Ian Skinner
Dustin Snell [Network Automation] wrote: Is there a way via Ajax to automatically update CFCHART with new data without refreshing the page? If not with CFCHART are there any other technologies out there that can do this? I do not believe so, not with CFCHART. CFCHART does not run on the

RE: Outputting a hash character in an IIF() function.

2008-01-09 Thread Bobby Hartsfield
cfscriptif (foo) {bar='a';} else {bar='b';}/cfscriptuse_number #bar# Now it's one line... who didn't see that coming? :-P ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Adobe® ColdFusion® 8 software 8

RE: SOT sql question

2008-01-09 Thread Mark Fuqua
My mechanic likes to tell me that I should inform him what my car is/is not doing and let him do the diagnosing. Maybe I should try that with this problem also. Using a form, 'JobFileUpload.cfm', files are uploaded to the server to a folder based on JobId and a then a record of jobId, file name,

Re: Ajax cfchart

2008-01-09 Thread Rey Bango
Dustin, I'm not sure about CFChart but you have a couple of options including: http://ajaxian.com/archives/plotting-in-jquery Also, Google now has their chart api. Finally, you can go to AjaxRain and get a nice list of chart components: http://www.ajaxrain.com/search.php (keyword: chart)

RE: A Very Sophisticated Query

2008-01-09 Thread Brad Wood
Gonzo, I've got to say I've had a time trying to wrap my head around your data structure without really knowing how it is populated. I have generated some SQL here, but I don't really know if I have interpreted the data correctly. For starters are there only 4 bins total, or does EACH serial have

Re: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-09 Thread Marco Antonio C. Santos
George, I'll like to suggest you to use DataMgr. DataMgr is a great time saver tool and could be the answer to your needs. In your case just name your form fields with the same name in database and DataMgr will do the heavy work for you. http://datamgr.riaforge.org/ Cheers Marco Antonio C.

Re: Ajax cfchart

2008-01-09 Thread Sonny Savage
The YUI library has a DataTable library, but I can't vouch for it as I've never used it. http://developer.yahoo.com/yui/datatable/ On Jan 9, 2008 12:45 PM, Ian Skinner [EMAIL PROTECTED] wrote: Dustin Snell [Network Automation] wrote: Is there a way via Ajax to automatically update CFCHART

Re: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-09 Thread Dominic Watson
Use an ORM ORM = Object-Relational Modeler/Modeling Examples: * Reactor: http://www.alagad.com/go/products-and-projects/reactor-for-coldfusion/reactor-for-coldfusion * Transfer: http://compoundtheory.com/?action=transfer.index In a nutshell, these work by automatically generating components

Re: SOT sql question

2008-01-09 Thread Ian Skinner
Mark Fuqua wrote: I know I could do a another table with JobFileId's and Access levels, instead of a list of access levels, but it seems cleaner this way. It is not. You have denormalized your data in such away that doing the type of select you want to do is very difficult. If you had

Re: Ajax cfchart

2008-01-09 Thread Cutter (CFRelated)
Live Cycle Data Services in conjunction with Flex? Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Dustin Snell [Network Automation] wrote: Is there a way via Ajax to automatically

Re: Ajax cfchart

2008-01-09 Thread Barney Boisvert
CFCHART is static at create time; it can't change it's backing data. My FlexChart utility (http://www.barneyb.com/flexchart/) can change not just the data, but also the entire structure (5-series line chart, to a pie chart, to a 3 series column chart). It's all XML driven, which makes it a snap

Re: A Very Sophisticated Query

2008-01-09 Thread Dominic Watson
Ok, task 1: SELECT bd.Serial_ID, s.Lot_ID, Sum(bd.Bin_Quantity) as qty FROM BinD bd INNER JOIN Serial s ON s.Serial_ID = bd.Serial_ID INNER JOIN Transaction t ON t.Transaction_Id = bd.TransactionID WHERE t.date BETWEEN date1 AND date2 -- This is made up, I assume it is where the date is stored

Re: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-09 Thread Brian Kotek
Object-Relational Mapping, actually. Transfer seems to have the most traction nowadays. On Jan 9, 2008 1:17 PM, Dominic Watson [EMAIL PROTECTED] wrote: Use an ORM ORM = Object-Relational Modeler/Modeling Examples: * Reactor:

Loading plain text into Flash

2008-01-09 Thread Andy Matthews
I have a URL that I'm hitting: http://socket.carfax.com:8080/?REQUEST=INV http://socket.carfax.com:8080/?REQUEST=INVONE_OWNER=YUID=C410881VIN=1G6D M57N030113765 ONE_OWNER=YUID=C410881VIN=1G6DM57N030113765 It tells me if a vehicle has a report created on the CarFax website, and if that vehicle

Re: A Very Sophisticated Query

2008-01-09 Thread Dominic Watson
Task 2: Assuming @SerialID holds the serial id in question, SELECT Bin_ID, Serial_ID, Bin_Quantity FROM BinD WHERE EXISTS (SELECT BinD_ID FROM BinD bd2 WHERE bd2.transactionID BinD.transactionID) Does this do what you want? Dominic Woops, forgot the serialID bit! SELECT Bin_ID,

Re: Ajax cfchart

2008-01-09 Thread Andrew Powell
This is what you're trying to do: http://www.infoaccelerator.net/index.cfm?event=showEntryentryId=2BE38F46-1372-FA49-99088CD1819F9BA3 CFCHART is static at create time; it can't change it's backing data. My FlexChart utility (http://www.barneyb.com/flexchart/) can change not just the data, but

RE: SOT sql question

2008-01-09 Thread Mark Fuqua
Nuf said. I'll do it the right way. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 1:12 PM To: CF-Talk Subject: Re: SOT sql question Mark Fuqua wrote: I know I could do a another table with JobFileId's and Access levels, instead of a

Re: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-09 Thread Dominic Watson
Object-Relational Mapping, actually. Transfer seems to have the most traction nowadays. Lol ok, that makes more sense - I got the term 'modelling' from here: http://trac.reactorframework.com/ and I have heard modeler, mapping, mapper and modeling all used. I s 'modeling/modeler' just plain

Re: A Very Sophisticated Query

2008-01-09 Thread Dominic Watson
Task 2: Assuming @SerialID holds the serial id in question, SELECT Bin_ID, Serial_ID, Bin_Quantity FROM BinD WHERE EXISTS (SELECT BinD_ID FROM BinD bd2 WHERE bd2.transactionID BinD.transactionID) Does this do what you want? Dominic

Submitting a form inside of cfdiv

2008-01-09 Thread Steve Sequenzia
I am trying to be submit a form from within a cfdiv on a parent page. What I mean is I have a page that has the entire layout and everything in it but the for itself is actually on another page that is showing by using a cfdiv with a bind to the URL. All of the form variables are on one page

Re: A Very Sophisticated Query

2008-01-09 Thread Jochem van Dieten
Gonzo Rock wrote: 1st task - Given a Lot_ID, query the most recent BinD_Quantities recorded for each of the Serial_ID's in the Lot. The MySQL manual has a section named Groupwise Maximum. It presents 2 solutions, one of which will also work on other databases. Jochem

Re: Loading plain text into Flash

2008-01-09 Thread Josh Nathanson
how can I hit this URL and get back JUST the plain text? I'll format it in Flash once I get it back in. Can you do listGetAt using the carriage return character as a delimiter, something like var1 = listgetat(returnedstring,1,chr(13)chr(10)) var2 = listgetat(returnedstring,2,chr(13)chr(10))

Re: ColdFusion 8 Enterprise and FLEX Setup Question

2008-01-09 Thread James Blaha
All, Thank you very much for all your posts today. I'll be picking back up on this tomorrow. Flex seems to be a very powerful GUI. -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date

Re: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-09 Thread Brian Kotek
It's Mapping. Not sure where Doug got modeling from, that's not correct. On Jan 9, 2008 2:04 PM, Dominic Watson [EMAIL PROTECTED] wrote: Object-Relational Mapping, actually. Transfer seems to have the most traction nowadays. Lol ok, that makes more sense - I got the term 'modelling'

OT: Loading plain text into Flash

2008-01-09 Thread Andy Matthews
I'm sorry...I should have posted OT. I'd like to do all of this from within Flash/Actionscript. -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 1:48 PM To: CF-Talk Subject: Re: Loading plain text into Flash how can I hit this URL and

Re: Model-Glue CrystalTech

2008-01-09 Thread Tom McNeer
Well, I did talk to CrystalTech. And it's almost certain that they will not downgrade to JVM 1.6. Which is probably understandable, given the fact that it would be of direct benefit to a small percentage of their CF customers. For my part, I've already removed a couple of clients from them, so I

listGetAT problem...

2008-01-09 Thread Les Mizzell
I've got an http response that's being return like: 2|1|2|Approved||P|1688659283|12912008010910019012|.. I need to pull a couple of things out of that to display on a page, so... cfset request.responseCODE = #trim(listGetAt(AuthList, 1, |))# cfset request.response =

Re: listGetAT problem...

2008-01-09 Thread Todd
Use ListToArray(*list* [, *delimiters*, *includeEmptyFields*]) instead. On Jan 9, 2008 4:45 PM, Les Mizzell [EMAIL PROTECTED] wrote: I've got an http response that's being return like: 2|1|2|Approved||P|1688659283|12912008010910019012|.. I need to pull a couple of things out of

Re: listGetAT problem...

2008-01-09 Thread Charlie Griefer
that assumes he's on CF8, no? (which he may be... i'm not sure) :) On Jan 9, 2008 2:00 PM, Todd [EMAIL PROTECTED] wrote: Use ListToArray(*list* [, *delimiters*, *includeEmptyFields*]) instead. On Jan 9, 2008 4:45 PM, Les Mizzell [EMAIL PROTECTED] wrote: I've got an http response that's

Re: listGetAT problem...

2008-01-09 Thread Todd
Yeah, sorry... If you're on CF8, which you should be, if you're not... sorry. On Jan 9, 2008 5:07 PM, Charlie Griefer [EMAIL PROTECTED] wrote: that assumes he's on CF8, no? (which he may be... i'm not sure) :) On Jan 9, 2008 2:00 PM, Todd [EMAIL PROTECTED] wrote: Use ListToArray(*list* [,

Re: listGetAT problem...

2008-01-09 Thread Bryan Stevenson
and in case you want to know why and just not a fix ;-) the problem is CF doesn't recognize empty list elements...so you can replace all instances of || with | | in the list and then parse things out Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems

Re: listGetAT problem...

2008-01-09 Thread Charlie Griefer
On Jan 9, 2008 2:17 PM, Bryan Stevenson [EMAIL PROTECTED] wrote: and in case you want to know why and just not a fix ;-) the problem is CF doesn't recognize empty list elements...so you can replace all instances of || with | | in the list and then parse things out that won't resolve two

Re: listGetAT problem...

2008-01-09 Thread Les Mizzell
Todd wrote: Yeah, sorry... If you're on CF8, which you should be, if you're not... sorry. CF7 still - waiting on the host to upgrade ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date

Re: listGetAT problem...

2008-01-09 Thread Brian Kotek
There is also a function at CFLib.org that will do this. http://www.cflib.org/udf.cfm?ID=962 On Jan 9, 2008 5:27 PM, Les Mizzell [EMAIL PROTECTED] wrote: Todd wrote: Yeah, sorry... If you're on CF8, which you should be, if you're not... sorry. CF7 still - waiting on the host to

Re: listGetAT problem...

2008-01-09 Thread Chris Jordan
Yeah, that's a known issue... if you want a buddy of mine wrote a little UDF called listFix http://www.cflib.org/udf.cfm?id=507. It's available on cflib.org. Just pass your list to this function before running the rest of your code. Chris On Jan 9, 2008 4:17 PM, Bryan Stevenson [EMAIL PROTECTED]

Re: listGetAT problem...

2008-01-09 Thread Sonny Savage
Since you are already Trim()ming all the values, you could do something like this: cfset AuthList =replace(AuthList,||,| |,all) All of your existing code after that should work. On Jan 9, 2008 5:24 PM, Charlie Griefer [EMAIL PROTECTED] wrote: On Jan 9, 2008 2:17 PM, Bryan Stevenson

Re: Loading plain text into Flash

2008-01-09 Thread Eric Haskins
Played with the url a bit not sure you meant to put your UID in there but it looks like the response for your query is Yes N Meaning Yes they have a history report and No the vehicle is not a One Owner vehicle. So you would need to use SPACE as your delimiter not carriage return. If I change

cfsavecontent fails to save output of cfinput datefield in HTML

2008-01-09 Thread henry ho
I tried ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive:

CF_forward and ColdFusion 8

2008-01-09 Thread Richard Colman
I just did an upgrade to CF8 and my venerable CF_forward tag is now causing a problem. Does anyone know if this tag still works with CF8? Richard Colman ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic

Re: cfsavecontent fails to save output of cfinput datefield in HTML

2008-01-09 Thread henry ho
wow, cfsavecontent does not fully work with cfform. Besides the datefile doesn't work, all the javascript validations are not saved. So cfform just cannot be saved using cfsavecontent? Any workaround? btw, I'm using CF8. Thanks I tried

Re: A Very Sophisticated Query

2008-01-09 Thread Gonzo Rock
Yes! http://dev.mysql.com/doc/refman/6.0/en/example-maximum-column-group-row.html That is the sql that Matt Williams suggested to me offline earlier this morning and I have been trying to wrap my head around it... as Brad described earlier in this thread ;-) And studying what Dominic has

Re: cfsavecontent fails to save output of cfinput datefield in HTML

2008-01-09 Thread henry ho
after more testing, validations only works with cfsavecontent when validateAt is set to onBlur and/or onServer. wow, cfsavecontent does not fully work with cfform. Besides the datefile doesn't work, all the javascript validations are not saved. So cfform just cannot be saved using

Re: ColdFusion 8 Enterprise and FLEX Setup Question

2008-01-09 Thread James Blaha
Folks, When you peform a developer install of CF8 is there a way to test LCDS? I dont see any extra Windows services for it runnning. -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date

Re: ColdFusion 8 Enterprise and FLEX Setup Question

2008-01-09 Thread Jo�o_Fernandes
Jim, LCDS runs under the same service as your ColdFusion install. -- João Fernandes http://www.onflexwithcf.org http://www.riapt.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get

  1   2   >