SOT: file sharing recommendations

2013-12-06 Thread Matt Williams

I have been tasked with recommending some sort of file sharing solution for
our office. Basic requirements:
1) File sharing between less than 10 employees.
B) Access to these files in and out of office.
3) Off-site backup
D) Possibly allow clients to upload files to specific, segregated locations

We had been using a box with Windows Server Essentials with FileZilla FTP
server, but that died. We currently just have a workstation with sharing
set up.

What are you using for these types of needs?
Would something like DropBox or Google Drive make sense?
Or is it safer in the long run to stick with a box we manage in house?

Thanks for the input.

-Matt


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357310
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


CF 10 and webservice call

2013-11-21 Thread Matt Williams

I've been having some issues with a new server running CF 10 on Windows
Server 2008 R2. At first we couldn't get the web service to register at
all. After upgrading to 10.0.12.286680, that now works along with most
method calls.

However, one method, getSearchResults, will not work. It runs fine on my
local workstation which is running CF 9 and even on an older server running
CF 8.

The error received:
org.apache.axis2.AxisFault: javax.xml.stream.XMLStreamException: element
text content may not contain START_ELEMENT at
org.apache.axis2.AxisFault.makeFault(AxisFault.java:430)

I did some googling and am not finding much help there.

The wsdl is done in .Net I believe and is here:
https://secure.instantsoftwareonline.com/StayUSA/ChannelPartners/wsWeblinkPlusAPI.asmx?wsdl

Has anyone run across this in CF 10? I've tried this with both createObject
and cfinvoke but get the same results. Any ideas on what else to try?

Thanks,

-Matt


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357125
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: viewport tag question

2012-07-02 Thread Matt Williams

Sorry, to get to the non-mobile site, you should use this url:
http://amaproracing.com/?mo=1

It's the full site that is the problem, not the mobile site.
-Matt


On Mon, Jul 2, 2012 at 10:19 AM, Matt Williams  wrote:
> My apologies for the non-CF related question (though the site is
> running on CF), but I know folks here are so well-rounded I'll throw
> it out.
>
> I'm struggling with getting a site to scale correctly on mobile
> devices. I have tried the viewport tag with various settings, but
> don't really understand the tag that well. The current code has this:
> 
> I have tried setting the width=device-width and it didn't seem to help.
>
> Site in question: http://amaproracing.com/
> In portrait mode on whatever device (seems consistent across various
> phones and tablets), it loads with only a portion (30%?) of the width
> showing. You can pinch the screen to zoom out and get the entire site.
> Landscape mode seems to be ok for most devices.
>
> Does anyone have a solid understanding of how to set the viewport tag
> up so it is good in both portrait and landscape orientations?
>
> Banging my head,
>
> -Matt

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351791
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


viewport tag question

2012-07-02 Thread Matt Williams

My apologies for the non-CF related question (though the site is
running on CF), but I know folks here are so well-rounded I'll throw
it out.

I'm struggling with getting a site to scale correctly on mobile
devices. I have tried the viewport tag with various settings, but
don't really understand the tag that well. The current code has this:

I have tried setting the width=device-width and it didn't seem to help.

Site in question: http://amaproracing.com/
In portrait mode on whatever device (seems consistent across various
phones and tablets), it loads with only a portion (30%?) of the width
showing. You can pinch the screen to zoom out and get the entire site.
Landscape mode seems to be ok for most devices.

Does anyone have a solid understanding of how to set the viewport tag
up so it is good in both portrait and landscape orientations?

Banging my head,

-Matt

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351790
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Wysiwyg editor

2011-10-24 Thread Matt Williams

I recommend that people only copy and paste from notepad. Extra html
that gets in there from any other source can wreak havoc on the final
output.

-Matt

On Mon, Oct 24, 2011 at 6:43 PM, Greg Morphis  wrote:
>
> That's exactly what I thought. In fact I found a solution how to get rid of
> the error message. I appreciate the reply!
> On Oct 24, 2011 5:41 PM, "Russ Michaels"  wrote:
>
>>
>> the copy and paste is a firefox security setting, they are going to
>> get it with any WYSIWYG editor.The message actually tells you how to
>> get rid of it if I recall.
>> it is however very easy to bypass, you can drag and drop text or right
>> click paste and you wont get the message,
>>
>>
>> >
>> >
>> >
>>
>>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348322
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Caching ajax / dhtml

2011-09-14 Thread Matt Williams

I switched to cffeed. I'm afraid we'll hit Twitter's limit too easily.
I've already seen it in on the staging site.

Thanks, I knew that about the client side javascript, I was just
thinking that somehow the CF could pre-render that.

Working too late, too many hours

-Matt

On Tue, Sep 13, 2011 at 8:24 PM, Michael Grant  wrote:
>
> Not on the client side. Either way you have to hit a server. Better
> Twitter's than yours I'd say.
>
>
>
> On Tue, Sep 13, 2011 at 7:12 PM, Matt Williams  wrote:
>
>>
>> I have some divs that are populated with tweet.js (jquery plugin for
>> twitter). So on document.ready(), the divs are populated by the
>> plugin.
>>
>> I don't want to hit twitter on every page load and want to cache the
>> populated divs somehow.
>>
>> Is there a way to take those populated divs and cache them? Simply
>> saving the content to html is still saving the javascript too and not
>> the actual output.
>>
>> I guess I may have to switch to grabbing the feed using cffeed or
>> something, but this code is already done and styled, so I was hoping
>> for something else.
>>
>> Thanks,
>>
>> -Matt
>>
>>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347457
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Caching ajax / dhtml

2011-09-13 Thread Matt Williams

I have some divs that are populated with tweet.js (jquery plugin for
twitter). So on document.ready(), the divs are populated by the
plugin.

I don't want to hit twitter on every page load and want to cache the
populated divs somehow.

Is there a way to take those populated divs and cache them? Simply
saving the content to html is still saving the javascript too and not
the actual output.

I guess I may have to switch to grabbing the feed using cffeed or
something, but this code is already done and styled, so I was hoping
for something else.

Thanks,

-Matt

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347449
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


SOT: Workstation recommendations

2011-09-07 Thread Matt Williams

My HP desktop at work died last night. This morning we took the hard
drive out and put it into another box whose drive had died a couple
months ago. It worked at first, but after about 20 minutes it croaked
too.

Anyway, I'll be shopping for a new desktop and just wondered what
brands people recommend these days. I'll probably stay away from HP
and plan to stay with a Windows machine. I run CF Developer, SQL
Server Mgt Studio, CF Builder, Adobe Creative Suite (primarily DW and
PS), MS Office, and various browsers and other tools.

Dell?
Lenovo?
Asus (seems to be mostly gaming oriented)?
Acer?
Gateway?
Others?

Thanks,

-Matt

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347273
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion 9 64-bit Image Manipulation

2011-07-29 Thread Matt Williams

Yes, try the built-in functions in CF.

Our 32-bit apps use imagecr3, which I believe has a 64-bit version in beta.
Our 64-bit apps use imagemagick.

-Matt


On Thu, Jul 28, 2011 at 3:03 PM, Pete Freitag  wrote:
>
> Lots of image functions were built into ColdFusion starting with version 8:
> http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec1a60c-7ffc.html#WSc3ff6d0ea77859461172e0811cbec22c24-66e4
>
>
> --
> Pete Freitag - Adobe Community Professional
> http://foundeo.com/ - ColdFusion Consulting & Products
> http://petefreitag.com/ - My Blog
> http://hackmycf.com - Is your ColdFusion Server Secure?
>
>
>
>
> On Thu, Jul 28, 2011 at 2:43 PM, Donnie Carvajal <
> donnie.carva...@transformyx.com> wrote:
>
>>
>> We are upgrading our system to CF9 64-bit and our CFX tags we use for image
>> resizing and info gathering are not working.  We get an "unable to load
>> library" error.  Since these tags have been in this application for over 10
>> years, I will assume that they were compiled for 16-bit and 64-bit CF on
>> Windows 2008 can not process them.  Does anyone know of any CFX tags that
>> will run on 64-bit for image manipulation?  Is there anything native to CF 9
>> that I can use?
>>
>> Thanks,
>>
>> Donnie
>>
>>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346398
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Its ColdFusion's Fault

2011-07-27 Thread Matt Williams

> Specifically: "One of the explicit design goals leading into HipHop
> was the ability to continue writing complex logic directly within
> PHP." - so they do 'work' in PHP, they do not write C++.

Interesting concept. Seems like somebody could do the same for Java -
maybe a tag based deal with some cool tie-ins to a database, email,
searching, web services, dhtml, reports ...

So full of good ideas I could pop,

- Matt

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346353
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cffileupload and makeUnique

2011-04-26 Thread Matt Williams

I thought about that, but is that still and Enterprise only deal? I'm
on CF Standard for this.

-Matt

On Tue, Apr 26, 2011 at 10:10 PM, Bobby Hartsfield
 wrote:
>
> You might check into an event gateway. Ray Camden had an example online for
> a directory watcher that basically just monitored a directory for new files
> to do stuff with.
>
> It shouldn't be too hard to find but if he sees this, I'm sure he will share
> it again.
>
> .:.:.:.:.:.:.:.:.:.:.:.:.:.
> Bobby Hartsfield
> http://acoderslife.com
> http://cf4em.com
>
>
> -Original Message-
> From: Matt Williams [mailto:mgw...@gmail.com]
> Sent: Tuesday, April 26, 2011 7:58 PM
> To: cf-talk
> Subject: cffileupload and makeUnique
>
>
> I'm using cffileupload to allow users to upload multiple photos into a
> gallery. For each photo, there is additional processing including
> resizing, cropping, writing to DB, etc. At the end four new photo
> files are written. At first I tried doing all of that when the image
> was uploaded, but that seemed too slow and the user does not need to
> wait for this processing to happen before continuing.
>
> I tried cfthread but for some reason it did not work, plus I'm dealing
> with CF Standard and the limitations there probably wouldn't help
> enough.
>
> Round three, I created a javascript function to make an ajax call
> after each photo is uploaded, using the oncomplete attribute of
> cffileupload. This works. The photo is uploaded quickly, the ajax call
> happens and users are happy.
>
> My problem happens when a file is renamed via the
> overwrite="makeUnique" setting of cffile. The function called
> oncomplete includes the FILENAME as part of the js object, but only
> the original filename and not the new/unique one. I need the unique
> filename in order to perform the additional processing.
>
> Any ideas on how to make this happen better?
>
> Thanks,
>
> -Matt W
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344013
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cffileupload and makeUnique

2011-04-26 Thread Matt Williams

Thanks Russ,

Lucky me!  >>"sounds like you may have found a bug in cffileupload"
I'm looking to replace an existing page that simply puts 5  tags on one page.

I just downloaded and was checking out Dan Vega's CFMU on riaforge.
The demo didn't work perfectly for me right away so I'm not sure if it
returns the unique name or not.

I'll take a look at the upload on asfusion too.

-Matt

On Tue, Apr 26, 2011 at 8:12 PM, Russ Michaels  wrote:
>
> sounds like you may have found a bug in cffileupload then, as you don't have
> any control over which filename is passed with oncomplete as far as I can
> see.
> You may have to resort to the old fashioned cffile upload instead, then you
> can use the following attribute.
>
> serverFile
>
> Filename of the file saved on the server
>
> for details on all the cffile attributes returned after AN UPLOAD SEE HERE
> http://cfquickdocs.com/cf9/#cffile.upload
>
> If you want to allow multiple file uploads, you could use the flash uploader
> at www.asfusion.com
>
> On Wed, Apr 27, 2011 at 12:58 AM, Matt Williams  wrote:
>
>>
>> I'm using cffileupload to allow users to upload multiple photos into a
>> gallery. For each photo, there is additional processing including
>> resizing, cropping, writing to DB, etc. At the end four new photo
>> files are written. At first I tried doing all of that when the image
>> was uploaded, but that seemed too slow and the user does not need to
>> wait for this processing to happen before continuing.
>>
>> I tried cfthread but for some reason it did not work, plus I'm dealing
>> with CF Standard and the limitations there probably wouldn't help
>> enough.
>>
>> Round three, I created a javascript function to make an ajax call
>> after each photo is uploaded, using the oncomplete attribute of
>> cffileupload. This works. The photo is uploaded quickly, the ajax call
>> happens and users are happy.
>>
>> My problem happens when a file is renamed via the
>> overwrite="makeUnique" setting of cffile. The function called
>> oncomplete includes the FILENAME as part of the js object, but only
>> the original filename and not the new/unique one. I need the unique
>> filename in order to perform the additional processing.
>>
>> Any ideas on how to make this happen better?
>>
>> Thanks,
>>
>> -Matt W
>>
>>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344010
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


cffileupload and makeUnique

2011-04-26 Thread Matt Williams

I'm using cffileupload to allow users to upload multiple photos into a
gallery. For each photo, there is additional processing including
resizing, cropping, writing to DB, etc. At the end four new photo
files are written. At first I tried doing all of that when the image
was uploaded, but that seemed too slow and the user does not need to
wait for this processing to happen before continuing.

I tried cfthread but for some reason it did not work, plus I'm dealing
with CF Standard and the limitations there probably wouldn't help
enough.

Round three, I created a javascript function to make an ajax call
after each photo is uploaded, using the oncomplete attribute of
cffileupload. This works. The photo is uploaded quickly, the ajax call
happens and users are happy.

My problem happens when a file is renamed via the
overwrite="makeUnique" setting of cffile. The function called
oncomplete includes the FILENAME as part of the js object, but only
the original filename and not the new/unique one. I need the unique
filename in order to perform the additional processing.

Any ideas on how to make this happen better?

Thanks,

-Matt W

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344008
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Database connection cross over

2011-02-14 Thread Matt Williams

It turns out there was a couple of new reports written that had "USE Banana" in 
the query. With that and "Maintain connections across client requests" enabled 
in the CF Admin, we were magically swapping what the DSN pointed to.

Thanks again for the help.

-Matt


>>
>> >Is the problem random or reproducible?
>> Random, but when it happens, it seems to stay that way for a while. A CF
>> service restart will correct it for a while.
>
>
>This behavior is consistent with a connection in the database connection
>pool switching active databases. There might be one seldom-used query in the
>site that does it. If the dev server is used by multiple people, the switch
>could be caused by another developer using SQL that is not present in the
>Web site. Instead of restarting the entire CF service, you could kill the
>database connection pool in cf admin, which should be a quicker temporary
>fix, assuming this is the problem.
>
>The way I would approach this problem is to do some site-wide searches for
>suspect code, including any stored procedures that might be used. Following
>that, send an E-mail to all developers who might be using those databases to
>be on the lookout for "use [database]" SQL. Following that, run a SQL trace
>to try to capture the event occurring, which should reveal enough details
>about the user account, application name, and the exact SQL that is run, to
>identify where the source of the problem is.
>
>-Mike Chabot 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342194
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Database connection cross over

2011-02-10 Thread Matt Williams

>Is the problem random or reproducible? 
Random, but when it happens, it seems to stay that way for a while. A CF 
service restart will correct it for a while.

>Is dbBanana used anywhere by the Web
>site, or should that database not be used at all? 
It is used. Both are used by the site with the error.

>If it should not be used
>at all, do a site-wide search for dbBanana to make sure it does not show up
>anywhere in the code. Are the two databases allowed to talk to each other?
There ares some instances where one query actually talks to both databases, 
(e.g., FROM Apple.dbo.tablename JOIN Banana.dbo.tablename

>Is one user account given permission to both databases?
Yes. Actually using the sa account, which I know is wrong.


>Watch our for SQL like "Use dbBanana" or "SELECT FROM dbBanana.dbo.table."
>Maybe do a site-wide search for "use "
I'm thinking that if the code/SQL was the problem, this wouldn't be 
intermittent. And I have looked at the query it fails on and this is not the 
case.

>If you think it is a DNS issue, put in the IP address of the db server in
>cfadmin to eliminate that possibility.
Definitely worth a try.

>Every time I have seen the issue with the symptoms that you describe it
>turns out to be a developer-caused error, not a server error, network error,
>or a random bug.
You are probably right, I just have yet to track down that developer-caused 
error.


>-Mike Chabot
Thanks for the input.

>
>On Thu, Feb 10, 2011 at 1:03 PM, Matt Williams  wrote: 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342127
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Database connection cross over

2011-02-10 Thread Matt Williams

Basics: Windows 2003 server, CF 7.0.2, SQL Server 8

Multiple datasources, but lets specifically look at the ones named Apple and 
Banana. They point to separate databases on the same SQL server, connecting to 
db Apple and db Banana respectively, as expected. However, occasionally, 
datasource Apple gets mixed up and attempts to use db Banana.

At first my error reported the following:
Datasource: Apple
Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 
'dbo.company'. 

After verifying the table did indeed exist, I did a simple cfquery to return 
the tables that do exist in datasource Apple. This query returned the tables 
from database Banana! I double and triple checked the datasource in the CF 
Administrator. It is correctly set to Apple. 

This is happening on our dev server. My solution thus far has been to create a 
new datasource called Apple_tmp. It seems to work. I did try to then delete 
Apple and rename Apple_tmp back to Apple, but it soon had the same issue. A!

My suspicions are some DNS or IP funkiness but have yet to track that down. 
This is all on one physical box, so I don't know if that would be it or not. 
I'm mainly curious if anyone else has seen this. 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342116
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Web Service and SSL

2010-09-10 Thread Matt Williams

I'm invoking a web service that when browsed gives a security certificate 
warning. This is a temporary issue and will be fixed. But to use it now, does 
anyone know if there is a way to make the web service call ignore or accept the 
certificate warning?





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336930
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Git, CF and best practices

2010-08-30 Thread Matt Williams

I'm not a git user myself, but here is a recent blog article I remember seeing:
http://www.bytestopshere.com/post.cfm/git-is-scary-but-it-doesn-t-need-to-be

-Matt

On Mon, Aug 30, 2010 at 9:16 PM, Mallory Woods  wrote:
>
> Hello all,
>
> I just started looking a git to use for source control for our CF projects.
> I wanted to ask those who are using it a few questions.
>
> First a few facts:
>
> Our servers are running Linux (dev, staging, production) but we are writing
> our code on Windows boxes.
> We are using CF builder and I have the git plugin installed.
>
> I wanted to ask about setting up the git repository on the server to be in
> our web server directory?
> For example: the web directory is http://www.thissite.com  and the local
> directory is : /var/www/html/projectname
> Would it be best to put the repo there in the project directory and create
> two branches for the two developers and merge them when we want to release
> the code?
>
> I would also like to ask, if anyone has any good suggestions on a tool or
> tools to push a specific version of the code to the server(s).
> From what I can see I would do an export then manually unarchive the files
> to the proper directory
>
> Thanks in advance.
>
> Mallory
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336658
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


CF 9 local scope gotcha

2010-05-20 Thread Matt Williams

I believe this behavior is as expected, however it breaks our code that worked 
in CF 8. Similar issues have been discussed here and maybe even raised on the 
bug tracker, but I didn't see an example quite like this, so I wanted to share.

Basically, when in a function (where local scope is automatically created) and 
looping over a query or a list, you may reference a column name or the list 
index without adding a scope. For example, myQuery has a column named "key."


  


On the first iteration through the loop, the variable local.key does not exist. 
The column "key" is found in the query, and now local.key equals that value; 
say it is 1. On the next loop iteration, CF sees that local.key indeed does 
exist and never looks to the query for the column "key". The scope hierarchy 
looks in LOCAL before it looks to the query we are looping over. So each 
subsequent assignment of local.key will equal 1.

There are several fairly simple workarounds: don't use the same variable name 
for the local scope; scope the right side of the assignment; etc. The point is 
you will need to watch out for this on legacy code if you're upgrading to 
ColdFusion 9.

I don't think this should be filed as a bug, although the current scope 
hierarchy could be debated. That is why I'm posting here and on my blog which 
also has sample code for download:
http://www.mattjanell.com/index.cfm?event=showEntry&entryId=B5EBBF4F-0C02-AEAF-607ECCAD91A37089

Just FYI. Sorry if this has already been discussed, but I couldn't find a 
similar post.

-Matt W 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333829
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Does cflocation pass through request type and variables?

2010-04-16 Thread Matt Williams

You may be able to do something with cfheader.
http://www.bennadel.com/blog/1550-Performing-ColdFusion-Processing-After-A-CFLocation-Tag.htm

-Matt W


>Well, in almost every case, if not all cases, with a 3rd party URL, we don't
>care about passing the variables. We wouldn't even have a problem with this
>one if it wasn't for the fact that the third party URL is blocking POST
>requests.
>
>
>andy
>
>Loop through the form scope and append to the redirect URL's querystring?


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332957
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cffunction and webservice call question

2010-04-15 Thread Matt Williams

Hey Ken, I work with HR-XML some too. I see a lot of companies that do HTTP 
Post instead of web services. If they are posting straight XML, there is 
probably not a form field name, so instead you will use 
getHttpRequestData().content to pull whatever was posted into a variable.

-Matt

> I am trying to hook up with an ATS vendor for one of my clients that 
> is going to use the ATS (Applicant Tracking System).  Here is what the 
> prerequisits say for the ATS vendor regarding the webservice 
> functionality.  
> 
> "The vendor must support the post of HR-XML data via HTTPS both to and 
> from their service. We are currently unable to provide other data 
> transfer means, such as FTP or SOAP."
> 
> How does this change things regarding your SOAP comment?  Are they 
> just sending a string of data through url parameters?  I think I need 
> to get a better spec sheet from them.  Any Feedback?
> 
> Ken Willis


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332923
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Best Way to use AJAX in MachII

2010-04-05 Thread Matt Williams

> Thank you Matt for your reply. Can you provide some links to start 
> with? I am a novice in Jquery.
> 

I don't know of any links specifically demonstrating jQuery AJAX with M2. I 
would start with the jQuery docs: http://api.jquery.com/category/ajax/. The 
info there and the examples near the bottom of that link will get you pretty 
far.

Also, googling "coldfusion jquery ajax" will you get you some things to read up 
on.

-Matt 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332579
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Best Way to use AJAX in MachII

2010-04-05 Thread Matt Williams

>What is best way to use Ajax in MachII?

I won't claim it is the "best," but I like using jQuery to simply call 
index.cfm?event=myAjaxEvent.

You can do it as a POST or a GET. The event is then just like any other Mach-II 
event with a call to a listener and ending in a view. 

The view page can then either output JSON or even HTML. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332574
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Set session variable via AJAX

2010-02-22 Thread Matt Williams

I have seen cases where I had to add the CFID and CFTOKEN to get the session to 
be remembered on an ajax call.

-Matt W

> I have a dropdown with an onchange that calls a CFC via cfajaxproxy 
> and I'm trying to set a session variable in that CFC. For some reason 
> this session variable isn't taking. Here's the code I'm working with 
> 
> This whole thing is intended to facilitate machine translation of our 
> site. The session variable in question is supposed to specify what 
> language the user wants so that they don't have to call the 
> translation manually on each page. The problem is that session.
> language isn't defined when I call another page. Is there another way 
> to do this? 


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331041
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: XML POST with Coldfusion

2009-10-26 Thread Matt Williams


  
   
 


http://www.myserver.com/AddOn/myService/XML/XMLInput.aspx"; 
method="post" result="servicePostBack">
  


-Matt

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327697
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: coldfusion to setup iis websites

2009-10-21 Thread Matt Williams

This isn't for directly setting up web sites, but may point you in that 
direction.

http://www.bryantwebconsulting.com/blog/index.cfm/2009/10/20/My-First-ColdFusion-Builder-Extension-Set-IIS-Root

>hi, is there a way to setup iis websites directly with cf code?
>


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327446
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: XML Issues with webservices

2009-06-04 Thread Matt Williams

And what are the errors? Are you sure the xml is still valid? I have recently 
worked with a couple of webservices talking in XML. I have generally returned 
things as a string as opposed to type="xml". Just something else to try.

-Matt

> Hello all. Was hoping someone could help me solve this irritating 
> issue. 
> 
> Curently I have a cfc called gateway.cfc setup to recieve incoming xml, 
> perform some operations and then pass back some xml. 
> 
> Here is the component
> 
>output="false">
>   
>   
>   
>   
>   
>   SUCCESS
>   100
>   User 
> #xmlRequest.request.username.xmltext# Logged 
> In
>   
>   
>   
>   
>   
> 
> I'm calling this function using the following code to create some xml 
> and then call the component as a webservice
> 
> 

> xmlRequest = XmlNew();

> xmlRequest.xmlRoot = XmlElemNew(xmlRequest,"Request");

> xmlRequest.Request.xmlChildren[1] = XmlElemNew(xmlRequest,
> "Username");

> xmlRequest.Request.Username.XmlText = "Jim";

> xmlRequest.Request.xmlChildren[2] = XmlElemNew(xmlRequest,
> "Password");

> xmlRequest.Request.Password.XmlText = "password";
> 
> 
> 
> 
> 
 
> ws = CreateObject("webservice", "#variables.wsURL#");
 
> ret = ws.sfrequest(xmlRequest); 
> 
> 
> 
> 
> Now this works fine if I call the cfc locally, but I get an error when 
> I access it as a webservice. The webservice works fine if I just 
> return the xmlRequest variable and it also works fine I I just return 
> the generated xmlOutput without doing anything to the inputted xml. 
> However as soon as I try to do anything with the xmlRequest such as 
> pulling some text from it as above, it errors.
> 
> Any ideas??
> 
> Cheers
> 
> Jim
> 
> 
> 


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323182
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFHTTP Problem - is file type extension required?

2009-06-04 Thread Matt Williams

I usually just do a cfdump of the cfhttp variable. If you aren't getting what 
you expect then you've either got the wrong url or are not passing something 
correctly. You may need to be grabbing a cookie from an earlier landing page 
and passing that back as part of the cfhttp request. And depending on what type 
of web server the site is on that cookie may need to be appended to the url 
(;jsessionid=xyz).

I've been going rounds with various cfhttp calls too and am about to post my 
own question regarding getting pdfs... Stay tuned. :)

-Matt


> I'll include the whole get-go here and see if anyone sees anything 
> else.  The server was disconnected accidentally for the last 2 hours 
> so I got behind on my posts.
> 
> 
> Here is the URL and the result from a browser:
> 
> http://server.somewhere.
> com/websvc/util?a=doHTMLRequest&event=workgroupstat
> 
> Result from the request:
> 
> Agents 
Availableworkgroup:Chat 
>agents_available:1agents_logged_in:1
> 
> here is the CF code:
> 
> 
> 
> 
>method="get" 
>   url="http://server.somewhere.
> com/websvc/util?a=doHTMLRequest&event=workgroupstat" />
> 
> 
> #agentCount#
> 
> 
> cfhttp.errorDetail:  #cfhttp.errorDetail#
> cfhttp.text:  #cfhttp.text#
> cfhttp.statusCode  #cfhttp.statusCode#
> cfhttp.MIMEType  #cfhttp.MIMEType#
> cfhttp.header  #cfhttp.header#
> 
> 
> here is the source code from the resultant page when I use the code 
> above:
> 
...
> about 10 blank lines.
> 
> cfhttp.errorDetail:  
> cfhttp.text:  YES
> cfhttp.statusCode  200 OK
> cfhttp.MIMEType  Unable to determine MIME type of file.
> 
> cfhttp.header  HTTP/1.1 200 OK
> Set-Cookie: JSESSIONID=CDE7D7C516BA85674B6859522ADC9CB4; Path=/websvc
> Date: Thu, 04 Jun 2009 16:25:12 GMT
> Content-Length: 0
> Server: Microsoft-IIS/6.0
> X-Powered-By: ASP.NET
> 
> 
> I expect to see the ... etc. code above the cfhttp.
> variables listed at the bottom.
> 
> Thanks in advance.
> Jerry 


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323181
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Query of Queries Functions

2009-02-26 Thread Matt Williams

On Thu, Feb 26, 2009 at 6:35 AM, Ron Gruner  wrote:
>
> Thanks Matt.  Is there some other way to build a small and temporary database 
> that resides in RAM and can be manipulated with all, or most, SQL functions?  
> I suppose Structures is the best approach but they're new for me.
>

Yes, you could do structures or an array of structures. If temporary
is all you need and not actual database persistence, you can work with
the query result set also. You can manipulate data in that with
QuerySetCell. You can also add rows and columsn with QueryAddRow and
QueryAddColumn. Check the docs for actual usage and examples.


-- 
Matt Williams
"It's the question that drives us

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319859
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Query of Queries Functions

2009-02-26 Thread Matt Williams

On Thu, Feb 26, 2009 at 5:56 AM, Ron Gruner  wrote:
>
> Is there a way to do SQL Updates and Deletes on record sets organized as 
> Query of Queries?  It seems that only SELECT works.  I'm using CF8.
>

A query of queries does not make a connection to the actual database.
It is only a way to further filter previously retrieved record sets.
So no, you cannot do updates or deletes.


-- 
Matt Williams
"It's the question that drives us

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319857
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Can I do this in a single SQL query?

2009-02-24 Thread Matt Williams

On Tue, Feb 24, 2009 at 9:25 PM, Jim McAtee  wrote:
>>
> The new system requires user registration and new comments are now tied
> directly to a user account.  What I'd like to do is link any newly
> registered users to their old comments by using the email address.  It's
> imperfect, but better than nothing.  In the comments table below old
> comments have the name and email columns populated, while new comments
> have the userid populated instead.
>
> users
> 
> userid     int
> username   varchar
> email      varchar
> ...
>
> comments
> 
> commentid  int
> userid     int
> name       varchar
> email      varchar
> comment    varchar
> ...


UPDATE comments
SET userID = (
SELECT userID
    FROM users
WHERE users.email = comments.email
)



-- 
Matt Williams
"It's the quest

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319781
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Inserting an array of structs into a database table

2009-02-14 Thread Matt Williams

On Sat, Feb 14, 2009 at 8:28 PM, Mike Soultanian  wrote:
>
> Hey everyone,
> I am pulling a song listing from another website that's in JSON format.
>  I already figured out how to bring it into CF with deserializeJSON(),
> but now I need to put all that data into my database.  There are over
> 60,000 songs in their database so that means I have to insert over
> 60,000 structs (song title, artist, id, etc) into my database.  What is
> the most efficient way to do this?
>
> I am able to pull down chunks of song data  (i.e. pull first 1000 songs,
> then pull then next 1000, etc), and then would I loop through the array
> and individually insert each struct into the database?  It seems like
> that would be like a slow process but I don't know how else I'd do it.
> Any suggestions would be much appreciated!
>
> thanks!
> Mike
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319327
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Coldfusion AJAX Demos

2009-02-08 Thread Matt Williams

Also search on Ben Nadel's and Ray Camden's blogs.
http://www.bennadel.com
http://www.coldfusionjedi.com

On Sun, Feb 8, 2009 at 1:19 PM, John M Bliss  wrote:
>
> 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
> http://www.webmonkey.com/tutorial/Add_Ajax_to_Your_Site_Using_Adobe_ColdFusion
> http://tutorial401.easycfm.com
>
> On Sun, Feb 8, 2009 at 12:02 PM, Terry Troxel  wrote:
>
>>
>> Anyone wish to share any links to examples and maybe some code on cf8 Ajax
>> uses and magic?
>>
>> Terry Troxel
>>
>>
>>
>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319047
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Arrays

2009-02-08 Thread Matt Williams

On Sun, Feb 8, 2009 at 8:04 AM, Will Tomlinson  wrote:
>
> I find a structure of structures to be better-understood, and easily updated.

Interesting Will. So does your outer-most structure have some sort of
incremental key? Personally an array of structs seems easier to me
because the array implies a series of something. As far as updating
and the code to deal with them it is pretty much 6 or 1/2 dozen I
would think.

-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319041
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Arrays

2009-02-08 Thread Matt Williams

Hey Jason, if you don't already know which position in the array the
item id is located, then you'll need to loop through the array and
find it. Once found, you are actually dealing with a structure, so
updating is just a simple cfset. Something like this (assuming item id
is in session and new zoneCost coming from a form variable):


  

  


Does that make sense? I'm hoping I understand your question correctly.
Your post seemed to have a lot of extraneous info that I wasn't sure
if it was relevant.

-Matt

On Sun, Feb 8, 2009 at 5:36 AM, Jason Congerton
 wrote:
>
> Hi
>
> I am currently getting trying to get my head arounds arrays. The shopping 
> cart system i use, stores the cart details into an array. I need to be able 
> to update the array with a figure at a certain point. Please see array 
> structure below;
>
> The place i need to enter is ITEMS, zone cost, drilled down by the item id.
>
> i.e add zone cost to item array where ID EQ 12
>
> I have had a look around, and i am thinking along the lines of array insert 
> at?
>
> Any help would be appreciated.
>
> DecimalPlacesC 2
> DecimalPlacesW 2
> DiscountsDisplayIndex 1
> DisplayIndex 1
> ForceDecimalsC true
> ForceDecimalsW true
>
>
> Items array
> 1 struct
> DeliveryCost 100.
> Description [empty string]
> FullDetails 1 The Cedar Ridge Playset (12)
> ID 12
> Name The Cedar Ridge Playset
> Price 651.304347826
> Quantity 1
> Ref SELWOOD-CEDARRIDGE-09
> TotalPrice 651.304347826
> TotalWeight 42
> Weight 42.00
> zoneCost 0.00
>
> 2 struct
> DeliveryCost 50.
> Description [empty string]
> FullDetails 1 Cabin Package (18)
> ID 18
> Name Cabin Package
> Price 868.695652174
> Quantity 1
> Ref SELWOOD-CABIN-PCKG-09
> TotalPrice 868.695652174
> TotalWeight 130
> Weight 130.00
> zoneCost 0.00
>

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319037
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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

2009-02-04 Thread Matt Williams

Hey Rick,

What you have coming back is a JSON object. The part of your ajax call
- success:   function(response) { - is the beginning point for
displaying that data returned. You'll be adding quite a bit more
javascript to handle the display. You can either put this additional
js into that success function or separate it out to a new function. So
either

success:   function(response) {
 --- lots of js code to parse JSON and populate display --
}

OR

success:   function(response) {
 populatePage(response);
}

and then outside that ajax call write:
function populatePage(response) {
 --- lots of js code to parse JSON and populate display --
}

Doing the display part is where you have to learn to translate your
abilities to output CF structures and queries to javascript. As James
said, there is some looping involved. The JSON object is somewhat like
a CF structure. The variables preceded by a curly bracket are keys in
that structure. The queries are basically arrays inside the structure.

I assume you have an empty div or some place in your html to put the
response data. I'll call it 'myDiv' for now. To display one of the
simple structure variables, you can do this.
$('myDiv').append(response.MONTH + '/' + response.YEAR); //variables
are case sensitive

For the queries, you can use jQuery's each to loop over the query
rows. I don't have time to complete this, but here is a start of how
you can get to that query data.
function populatePage(response) {
$.each(response.QGETSCHEDULE.DATA, function(i, row) {
$.each(response.QGETSCHEDULE.COLUMNS, function(j, colName) {
console.log(colName + ': ' + row[j]);
});
});
}

On Wed, Feb 4, 2009 at 12:57 AM, James Holmes  wrote:
>
> Try $.getJSON instead of $.ajax for a little more efficiency.
>
> cfajaxproxy is the JS way of getting to the same point, essentially.
> With either method, you need to be able to write the JS you need to
> use the result set. You're getting back an object with two properties:
> COLUMNS and DATA. COLUMNS is an array; DATA is an array of arrays. So
> yes, there's going to be some looping involved.

-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318860
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Charlotte North Carolina

2008-12-15 Thread Matt Williams
If anyone in the Charlotte, North Carolina area is interested in
starting up a ColdFusion user group, please contact me off-list:
mgw4jc (the at thingy) gmail

-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316755
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Anyone willing to help me build an AJAX/jQuery/CF8 modal login for pay or gifts?

2008-12-12 Thread Matt Williams
Hey Rick. I've done some modal stuff with jQuery and thickbox. Had it
working on IE 6 & 7 and FF 2 & 3 at some point. Ping me off list if
you don't already have a taker.

Matt Williams

On Fri, Dec 12, 2008 at 7:18 PM, Rick Faircloth
 wrote:
> I've been struggling with developing a modal login system
> for the past 4 days...just can't tie it all together.
>
> I just don't know enough about javascript in general, for one thing.
> I prefer to use jQuery for the js part...it's more intuitive.
>
> I pretty much have a solution worked out in Firefox, using Shadowbox,
> but tried it in IE7, and the modal window didn't even show up...sigh.
>
> I've decided to try Thickbox, but can't find a tutorial that walks
> me through everything.  I get some of the jQuery side in some tutorials,
> but not the CF8.  I get CF8 in some tutorials, but not the jQuery.
>
> So now I'm looking for someone who would spend an hour or two working
> with me through IM or via some other method to show me how to put
> all this together.  I want to expand from this to use AJAX in other
> ways in my apps, but if I can't get this simple thing working, well...
>
> I'd be willing to pay for someone's time or buy gifts from a wishlist
> or whatever to get this working.  I've got to move ahead on a project
> and I really wanted to using the AJAX approach.
>
> Anyone have the jQuery, Thickbox (or other jQuery modal window), and
> CF8 experience and willing to help?
>
> Thanks,
>
> Rick
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316725
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF, JQuery and IE

2008-09-17 Thread Matt Williams
On Tue, Sep 16, 2008 at 9:55 AM, Scott Stewart <[EMAIL PROTECTED]> wrote:
> As far as it happening in all plugins, the answer is yes. It'll work
> like a champ in FF3 and fail completely in IE7
>

Probably not the issue, but note that IE barfs if you try


instead of


-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312710
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Flummoxed bya simple query

2008-08-21 Thread Matt Williams
On Thu, Aug 21, 2008 at 11:07 AM, Tim Claremont
<[EMAIL PROTECTED]> wrote:
> THIS Fails:
>
>
> 
>SELECT BasicInfo.mcaidrecda, Identity.*, Enrollment.*
>FROM BasicInfo
>INNER JOIN Identity ON BasicInfo.IDID = Identity.ID
>INNER JOIN Enrollment ON BasicInfo.IDID = Enrollment.IDID
>ORDER BY LastName ASC, FirstName ASC
> 

What about running the query directly in some sort of FoxPro Query
tool (if there is one) as opposed to using CF?


-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311379
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFC Best Practices

2008-08-19 Thread Matt Williams
On Tue, Aug 19, 2008 at 10:44 AM, Craig Dudley <[EMAIL PROTECTED]> wrote:
> Rob, if you are using MSSQL why don't you use @@IDENTITY?

Just to be clear, @@identity returns the most recent inserted id of
all tables. So if you had a trigger that when a table gets an insert,
another table also gets an insert, @@identity would return the
triggered table ID.

For SQL 2000 +, look at SELECT SCOPE_IDENTITY() or SELECT
IDENT_CURRENT('tablename').

http://www.sqlteam.com/article/alternatives-to-identity-in-sql-server-2000

I've seen other good blog entries / articles about this, but couldn't
locate them at the moment.

-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311267
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Outputting columned UL tags

2008-08-14 Thread Matt Williams
On Thu, Aug 14, 2008 at 12:57 PM, Claude Schneegans
<[EMAIL PROTECTED]> wrote:
>  >>Tables were intended to display tabular data.
>
> Correct, then if you want a list to be displayed as a tabular data, use
> a TABLE.

I hate to drag this out further, but there what if there was more to
it than display? What if the 3 columns were wider than a physical
piece of paper? With 3 column divs and  elements, you would be
able to use a print CSS style that simply stacks them, keeping them in
order.

Or, what if the list maybe something the user would want to highlight
and copy/paste to something else? If they want it in the 1,2,3,n
order, the tabular table would not work.

By doing a table to simply do a 3 column display of lists, you are
creating a table-based layout. And last time I checked that is code
smell.

Just some things to think about.

-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311020
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: SOT: Using jQuery to access the JSON that CF8 returns?

2008-08-14 Thread Matt Williams
On Thu, Aug 14, 2008 at 11:39 AM, Andy Matthews
<[EMAIL PROTECTED]> wrote:
> I'm using jQuery to make a direct CFC call, with the optional returnFormat 
> parameter.
> d['DATA'][0][1];
>
> But when I do so in Firefox, using Firebug I get the error:
>
> d.DATA has no properties
> coupons.js
> Line 68
>
> What am I doing wrong?
>

For queries returned in JSON, I I use a jsonencode function by Jehiah Czebotar.
It adds a RECORDCOUNT variable and then I reference returned data like so:

for (var i=0; ihttp://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310999
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Outputting columned UL tags

2008-08-14 Thread Matt Williams
On Thu, Aug 14, 2008 at 11:26 AM, Claude Schneegans
<[EMAIL PROTECTED]> wrote:
>  >>Besides...TABLEs are for tabular data. Sure you CAN put other stuff into
> them, but that wasn't their original intended purpose.
>
> IMO you are making a confusion between database tables and HTML tables.

Just to agree with Andy here...
Yes, Claude, HTML tables can be used for many purposes. I've even
heard of them used for doing actual layout (gasp!). But, if you want
to be more accessible and CSS compliant, then HTML tables are best
used for database type information. Query output as it were.



-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310996
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Outputting columned UL tags

2008-08-14 Thread Matt Williams
I looks like Andy wants a list displayed in three columns. A table
implies that that the first row contains a record of data with fields.
I could have missed something, but the item at the top of column 1 is
not related to the item at the top of column 2 or column 3. So it is
just a 3 column list.

Andy, were you able to get the output to work?

Matt

On Thu, Aug 14, 2008 at 9:36 AM, Claude Schneegans
<[EMAIL PROTECTED]> wrote:
>  >>So it's a little lighter, codewise, plus ULs and LIs are MEANT to display
> lists of things while tables are not.
>
> Frankly, I don't see your point.
> ULs and LIs are meant to display lists, right, but what you want to do
> is not a list,
> it is a TABLE, so why not use a table ?
>
-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310961
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Outputting columned UL tags

2008-08-13 Thread Matt Williams
On Wed, Aug 13, 2008 at 3:03 PM, Dave Phillips
<[EMAIL PROTECTED]> wrote:
> Andy,
>
> Check out Ben Nadel's blog entry from March last year:
>
> http://tinyurl.com/5tjcmf
>
It looks like what I just sent you is the same idea as Ben Nadel's
blog. Mine is just a lot less pretty with less line breaks and
comments. :)

Matt

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310932
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Outputting columned UL tags

2008-08-13 Thread Matt Williams
Try this out. myVar would be your quey record count or whatever.





link#i# -



link#nextOut# --









-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310931
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: SQL injection attack on House of Fusion

2008-08-09 Thread Matt Williams
On Fri, Aug 8, 2008 at 11:12 PM, Raymond Camden <[EMAIL PROTECTED]> wrote:
> Hmm. I'm having no luck with this. I'm trying it on a blogcfc site, so
> it's being added after /, so I also added path_info
>
> RewriteEngine on
> RewriteCond %{QUERY_STRING} .*DECLARE.* [NC]
> RewriteRule ^(.*)$  /violation.htm
> RewriteCond %{PATH_INFO} .*DECLARE.* [NC]
> RewriteRule ^(.*)$  /violation.htm
>
> And it's not picking up when it sees declare in the url.


Here's what I have within my  block:

RewriteEngine On
RewriteOptions Inherit
RewriteCond %{QUERY_STRING} .*DECLARE.* [NC]
RewriteRule ^(.*)$  /violation.htm [nc,L]

Also, uncomment the
LoadModule rewrite_module modules/mod_rewrite.so

And make sure you restarted Apache for changes to take effect. With
that I can do this and get redirected:
http://myDomain/?foo=declare
http://myDomain/?declare


-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310605
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: SQL injection attack on House of Fusion

2008-08-08 Thread Matt Williams
Scratch that. declare is case sensitive. Seems to work now.
Matt

On Fri, Aug 8, 2008 at 6:00 PM, Matt Williams <[EMAIL PROTECTED]> wrote:
> On Fri, Aug 8, 2008 at 2:45 PM, Terry Ford <[EMAIL PROTECTED]> wrote:
>> Here's the rewrite I'm using (linux apache) to keep traffic off the app 
>> server.
>>
>> RewriteCond %{QUERY_STRING} .*DECLARE.*
>> RewriteRule ^(.*)$  violation.htm [nc,L]
>
> Okay, I'm a rewrite and apache newbie. I'm trying to replicate locally
> before doing this on my server. I'm running Win XP with Apache 2.2.
>
> In my httpd.conf file I removed the # sign from this line:
> LoadModule rewrite_module modules/mod_rewrite.so
>
> Then I added the above rewrite rules within one of my  sites.
>
> Should that be all I have to do? Doesn't seem to work if I do
> myLocalSite/index.cfm?test=DECLARE
>
> Do the rewrite rules go somewhere else? Do I need something more than
> just he LoadModule line?
>
> Thanks,
>
> --
> Matt Williams
> "It's the question that drives us."
>

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310582
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: SQL injection attack on House of Fusion

2008-08-08 Thread Matt Williams
On Fri, Aug 8, 2008 at 2:45 PM, Terry Ford <[EMAIL PROTECTED]> wrote:
> Here's the rewrite I'm using (linux apache) to keep traffic off the app 
> server.
>
> RewriteCond %{QUERY_STRING} .*DECLARE.*
> RewriteRule ^(.*)$  violation.htm [nc,L]

Okay, I'm a rewrite and apache newbie. I'm trying to replicate locally
before doing this on my server. I'm running Win XP with Apache 2.2.

In my httpd.conf file I removed the # sign from this line:
LoadModule rewrite_module modules/mod_rewrite.so

Then I added the above rewrite rules within one of my  sites.

Should that be all I have to do? Doesn't seem to work if I do
myLocalSite/index.cfm?test=DECLARE

Do the rewrite rules go somewhere else? Do I need something more than
just he LoadModule line?

Thanks,

-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310580
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: variables.whatever isn't defined in CFC

2008-06-25 Thread Matt Williams
Create a temp scribble page and call that cfc, passing in only the
bare essentials to make it run. And do some cfdumps or cflog entries
to see where it is failing.

If you're on CF8, the step debugger is a useful tool to see what all
pages have been called, variables created (including cookies), etc.

On Wed, Jun 25, 2008 at 11:23 AM, Ian Rutherford
<[EMAIL PROTECTED]> wrote:
> Hi Brian,
>
> I did a full project search in Eclipse and it isn't anywhere in the project. 
> I'm not including any files in either the wrapper or the other cfc.
>
> I'm using FB3 which I have heard can do some strange things to layout tags 
> like cfpod and cflayout but there aren't any cookies there either.
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308132
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFC confusion. please help!

2008-06-23 Thread Matt Williams
On Mon, Jun 23, 2008 at 8:36 AM, Lori Stone <[EMAIL PROTECTED]> wrote:
> I have always returned query objects but apparently that is not the "best 
> practice".  I don't understand the problem with returning query
> objects.  I would love to understand the reasoning and what the return type 
> should be.

There is nothing wrong with returning queries. It really depends on
your use case. Typically, if I'm needing one record, I return a simple
object with getters/setters for each field. If I'm returning more than
one record, I return a query.

One issue with returning an array of objects instead of a query is
that if you're talking about lots of records, creating all those
objects can become processing and memory intensive.

However, one potential way around this is to use Peter Bell's
Iterating Business Object: http://ibo.riaforge.org/

-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307962
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: query help

2008-06-20 Thread Matt Williams
Hard to say what is going on. The following works fine for me:
SELECT node.userCity,count(node.userCity)
FROM core.users AS node, core.users AS parent
WHERE parent.userName = node.userFirstName
  AND node.userCity = 'Pasadena'
GROUP BY node.userCity

I seem to get the correct number based on the node.userCity where clause.

On Fri, Jun 20, 2008 at 4:23 PM, Jessica Kennedy
<[EMAIL PROTECTED]> wrote:
> no luck...
>
> I do need the group by clause, my actual query is much larger than  the one 
> posted.  the problem, for example is this:
>
> for five people, paid="no", for five others, paid="yes" under one parent 
> sponsor.
> I am now getting a result of "10", but I need the result to be "5", only 
> counting those people under sponsor who have paid.
>
> what am I doing wrong?? =(
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307865
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfquery function to do this?

2008-06-20 Thread Matt Williams
I had something like this once upon a time. I think I had to
manipulate the data so that I had leading and trailing commas in the
list in table. This was so I wouldn't get false matches, such as 6
being found in this list: 1,16,8. If you can do that, this might work.


select col1, col2
from mytable
where 1=0

OR col2 Like '%,#i#,%'



If you can't make sure of the leading and trailing commas (which is
somewhat an ugly solution), you will have to do some looping over
queries. I'll defer to someone else for how this would work because
the only thing I can think of is to get all records and then loop over
those results and do a ListFind for each record. And for each record
you'd have to loop over the list of criteria too.


On Fri, Jun 20, 2008 at 12:25 PM, Richard White <[EMAIL PROTECTED]> wrote:
> Hi
>
> i have a query in coldfusion and one of the columns has a list of data: for 
> example
>
> col1  col2
> -
> 1 0,1,2,3
> 2 1,6,7
>
> i want to run a query where i pass it a list and it returns any row that has 
> any item in that list
>
> for example i want to run a query that says select all rows where col2 has 
> any of the values 2,6
>
> this would return both of the rows as the first column has the number 2 and 
> the second column has the number 6
>
> or another example is i want to run a query that says select all rows where 
> col2 has any of the values 6,8,9
>
> this would return only the second row as col2 has 6 in it
>
> i hope i am making myself clear
>
> i was wondering whether there was a way i could do this in query of queries, 
> and if not then can anyone suggest an alternative as I cannot seem to get my 
> head around the best and most efficient way to this
>
> thanks
>
> richard
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307853
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: WSDL2Java DuplicateFileException error

2008-06-20 Thread Matt Williams
I can't remember the error I was getting, but I do remember having
some web service weirdness and ended up running this to fix it:


I'm not sure exactly what it does and can't remember where i got it,
but it may be worth a try. I'm also not sure if I was running it
before or after the web service creation. Just a shot in the dark.

On Fri, Jun 20, 2008 at 11:07 AM, Brad Wood <[EMAIL PROTECTED]> wrote:
> Ok, here's a nice one.  One of my coworkers is running into this problem when 
> he tries to invoke a ColdFusion web service he wrote.  He didn't have any 
> problems on our dev environment, but the test environment is puking out.  
> Unfortunately, Dev is CF7 Ent and test is CF7 standard.  Not that it SHOULD 
> make any difference...
>
> Before I start pasting in miles of indecipherable code, I wanted to see if 
> anyone has gotten this dreaded 
> org.apache.axis.wsdl.toJava.DuplicateFileException error before and can help. 
>  I have Googled, and there seem to be NO results related to ColdFusion out 
> there, and the results I did find were instances where people were creating 
> their own WSDL which is obviously not the case here.
>
> Let me know what additional information might help figure this out-- like the 
> names of the methods in the web service, etc.
>
> Also, I have manually deleted those stub files, cleared the template cache 
> and restarted the server to no avail.
>
> Thanks.
>
> ~Brad
>
> Could not generate stub objects for web service invocation.
>
> Name: 
> http://testtempest.nationsts.com/webservices/integrations/FNC/AppraisalPort/appraisalPort.cfc?wsdl.
>  WSDL: 
> http://testtempest.nationsts.com/webservices/integrations/FNC/AppraisalPort/appraisalPort.cfc?wsdl.
>  org.apache.axis.wsdl.toJava.DuplicateFileException: Duplicate file name: 
> /opt/coldfusionmx7/stubs/WS-1435972790/webservices/integrations/FNC/AppraisalPort/AppraisalPort.java.
>  Hint: you may have mapped two namespaces with elements of the same name to 
> the same package name. It is recommended that you use a web browser to 
> retrieve and examine the requested WSDL document for correctness. If the 
> requested WSDL document can't be retrieved or it is dynamically generated, it 
> is likely that the target web service has programming errors.
>

-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307841
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Waaahhhh! Why won't my CFC work!

2008-06-20 Thread Matt Williams
On Fri, Jun 20, 2008 at 10:10 AM, Rick Faircloth
<[EMAIL PROTECTED]> wrote:
> Can you explain how that work and show me an example
> of the code I need to put in a cfc.
>
> I tried this that someone gave me:
>
> 
>
>
>
> 
>
> But that doesn't make sense to me.  My dsn is set
> in application.cfm like so:  cfset application.dsn = "myDB".
> So why, "variables.dsn" above?
>
> I just don't understand what the code is doing.
> Why is variables.dsn being set to be the value of
> arguments.dsn?  And what exactly does "cfreturn this" do?
>

The idea here is to keep you cfc separate from the application so it
is more re-usable. It is good practice to not reference application
scope (or form or session, etc.) directly in your cfc (there are
always exceptions to this, as Tom mentioned a facade earlier). But in
keeping it simple, this init function is receiving the dsn as an
argument and putting it in the variables scope so that the cfc does
not have any knowledge of the application scope.

When you do  that is
telling the server to create a new instance. This instance will be put
in the server memory. By using , the instance is
returned to whatever calls it. In other words, the variable
"myNewInstance" holds a reference to that object.

If you have the basic setup working, try a cfdump on myObj.



You'll see what looks like a structure output of all the methods
defined for that object. Some folks like to also add a "dump" method
to their cfcs.




With that, you can do this:

That will show you the values that are held within the variables scope
(doing this you will also see each function definition).

I just got Ian's post. He explains the different scopes.

I think one of the main things you'll need to grasp first is that when
you create this object, it exists in memory and holds data and
functions with which you can interact. Because of this, you'll want to
think about what scope an object should exist within. An object that
holds information specific to one user makes sense to be in session
scope. But an object that can be used by many users should probably be
in application scope. This is one of the advantages Object Oriented
programming. Otherwise you are just creating and destroying objects
for every request and may as well do it inline or with cfincluded
files.

Hope that helps. Keep the questions coming though. There are also many
blog entries on some of these basics. Adrian Moreno's blog comes to
mind first. He did a whole series.
http://www.iknowkungfoo.com/blog/index.cfm/2007/8/22/Object-Oriented-Coldfusion--1--Intro-to-Objectcfc
-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307834
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Waaahhhh! Why won't my CFC work!

2008-06-20 Thread Matt Williams
>> On Friday 20 Jun 2008, Rick Faircloth wrote:
>> > What would be the best way to pass variables to a CFC
>> > for processing?

To go back to this question, there are several methods for passing in
variables. There is no really best way, it is more a matter of
personal preference. Besides the use of cfinvoke, here are some ways
to do it with .

1) Named arguments. Here you actually specify the argument names when
you call a method


2) Unnamed arguments. Here you just put in the variables in the same
order in which you specify the arguments in the function.


3) Argument collection. Here you first build up a structure that holds
the arguments. Structure keys match the argument names.






-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307828
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: KInda OT - FF3 and flash forms

2008-06-19 Thread Matt Williams
On Thu, Jun 19, 2008 at 4:40 PM, Will Swain <[EMAIL PROTECTED]> wrote:
> Final release. I get the same thing with flash player 9 and the 10 beta.
>
> Darn it.

Any funky FF add-ons/extensions possibly causing the issue?
Firebug and Web developer are the only ones I'm running.

Does it work on another computer within the network? If not, maybe
some funky trusted domain setting or someting??

-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307798
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Waaahhhh! Why won't my CFC work!

2008-06-19 Thread Matt Williams
On Thu, Jun 19, 2008 at 4:27 PM, Rick Faircloth
<[EMAIL PROTECTED]> wrote:
> That was it!  Thanks Josh and Mark.
>
> Ok... concerning createObject, etc.
>
> I tried again with this line:
>
>  "c21-ar-sm-homesite.components.manager_authorization").init(application.dsn) 
> />
>
> but I got this error:
>
> The method init was not found in component
> E:\Inetpub\webroot\c21-ar-sm-homesite\components\manager_authorization.cfc.
>
> How do I write the "init" method for the db in the component?






> (And by the way, where should the line I wrote above, " but put?  In the cfc?  In my application.cfm? In the calling page?

If you want to use your managers component throughout the application,
then put it in app.cfm, probably with


Then any page in your app can do

-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307792
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: KInda OT - FF3 and flash forms

2008-06-19 Thread Matt Williams
On Thu, Jun 19, 2008 at 4:21 PM, Will Swain <[EMAIL PROTECTED]> wrote:
> Hmmm...must be something else going on for me then.
>
> Are you guys on XP Pro?

XP Pro
FF 3
Flash 10
Holding my tongue to the left.


-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307790
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: How can I restate this without using EVALUATE?

2008-06-19 Thread Matt Williams
Can't be done in a regular cfset



On Thu, Jun 19, 2008 at 4:14 PM, Brad Haas <[EMAIL PROTECTED]> wrote:
> I know using evaluate is a no-no, but I'm stumped on how to restate this line 
> of code:
>
> 
>
> Any help would be appreciated.
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307784
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: KInda OT - FF3 and flash forms

2008-06-19 Thread Matt Williams
I see it the calendar with flash 10 plugin.

On Thu, Jun 19, 2008 at 3:35 PM, Will Swain <[EMAIL PROTECTED]> wrote:
> If anyone has a moment, can they look at this page in FF3 and let me know if
> they see the cfcalendar flash widget?
>
> http://www.hothorse.com/flash/test.cfm
>
> I don't see anything. It's there in IE, and in FF2
>
> Thanks for your time guys.
>
> Will
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307782
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: KInda OT - FF3 and flash forms

2008-06-19 Thread Matt Williams
Quick test on a couple of forms on an intranet seem okay here.

On Thu, Jun 19, 2008 at 11:43 AM, Will Swain <[EMAIL PROTECTED]> wrote:
> No one else seeing this problem?
>
> I'm on XP pro.
>
> -Original Message-
> From: Will Swain [mailto:[EMAIL PROTECTED]
> Sent: 18 June 2008 16:22
> To: CF-Talk
> Subject: KInda OT - FF3 and flash forms
>
> Hi,
>
> Apologies for the slightly OT post, but has anyone else experienced issues
> with Flash forms not loading in Firefox 3.
>
> I get view other flash content, but a couple of places where we use flash
> cfforms in our intranet just aren't working. They do work in IE.
>
> I've seen that there were some issues with betas of FF3 and flash content in
> general, but that doesn't seem to be my problem.
>
> Cheers
>
> Will
>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307734
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Here's what I wish I had...

2008-06-18 Thread Matt Williams
On Wed, Jun 18, 2008 at 9:56 AM, Ian Skinner <[EMAIL PROTECTED]> wrote:
> The is a ColdFusion debugger that theoretically does the type of
> functionality you are dreaming of.

Yes, just look at the debugger. I use Fusion Debug and love it, but
you should be able to get the same thing from the CF8 debugger.
Basically you set a 'breakpoint' in your code so that the debugger
will know when to trigger. You call the page that will run that code
with the breakpoint.

Then, in the Eclipse's Debug perspective you get to see all variables
that have been defined. You can also see what is just about every
scope: application, request, session, server, cgi, url, form, cookie,
client, etc.

Other parts I really like about it is the ability to work with
expressions. You can watch an expression such as
IsNumeric(myVariable). More recently I've found myself finding what a
variable's or an expression's value is by highlighting it, right
clicking and selecting Inspect Expression (Fusion Debug, not sure if
that is available in CF debug).

Lately I've been working with some threading. The debugger also picks
up those as separate threads and shows me what is going on there.
-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307672
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Adobe ColdFusion to be free for Acadmeic use

2008-06-18 Thread Matt Williams
On Wed, Jun 18, 2008 at 9:37 AM, Tom Chiverton
<[EMAIL PROTECTED]> wrote:
>On Wednesday 18 Jun 2008, Matt Williams wrote:
>> shop owner. They were primarily a CF shop but have decided to do all
>> new development with Ruby on Rails. I'm only vaguely familiar with
>> Rails. What is so attractive about Rails that they would do this?
>
> I have no idea, now CF is free (Railo/OpenBD), esp. given the time it'll take
> to retrain and retool.

I don't think the Rails draw is only price driven. It's the
auto-generation piece. We have some ways to do this, but there is not
something that just stands out.

What is the learning curve on Rails? Maybe that coupled with price is
what is attracting people. Yes CF is easy to learn, but to jump into
auto-generated DB components takes some digging and learning.

Maybe the move toward Hibernate will be the thing that makes CF an
easy choice, especially for java developers.
-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307670
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Adobe ColdFusion to be free for Acadmeic use

2008-06-18 Thread Matt Williams
On Wed, Jun 18, 2008 at 8:48 AM, Tom Chiverton
<[EMAIL PROTECTED]> wrote:
> http://www.pbell.com/index.cfm/2008/6/18/The-Future-of-ColdFusion-Adobes-CF-United-Keynote
>

I think the free for academic use is a great idea. According to Ray's
blog it is to solve this: "Biggest problem is lack of available
developers."

Also on Ray's blog he said Adam Lehman announced integration of
Hibernate into the next version of CF. This is probably good too.

But I have a different concern. I was recently talking to a Web Design
shop owner. They were primarily a CF shop but have decided to do all
new development with Ruby on Rails. I'm only vaguely familiar with
Rails. What is so attractive about Rails that they would do this?

And what does Adobe / the CF community need to do to step it up?
-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307658
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: One thing I've always wanted to build... breadcrumb trail...

2008-06-10 Thread Matt Williams
On Tue, Jun 10, 2008 at 10:51 AM, Rick Faircloth
<[EMAIL PROTECTED]> wrote:
> Thanks, Matt... sounds similar to what I was thinking about doing.
>
> Question:  What do you mean by "window numbers"?

Some of our links open a new browser window or tab. If this happens
and they started using links in both windows/tabs, then the breadcrumb
trail would get wacked out. Because it is only one session per
browser, the session crumbs would be shared between 2 windows/tabs and
have links from one show up in the other. Window numbers were my way
to prevent this. Basically if I knew a link opened a new window/tab,
it was assigned a new window number. So then window #1 and window #2
have their own bread crumb trail.

Again, this may not be an issue for you and I'm not sure I had it working 100%.

-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307176
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: One thing I've always wanted to build... breadcrumb trail...

2008-06-10 Thread Matt Williams
I have a breadcrumb solution that I created for a Mach-II app. You
could probably pull out relevant parts of the code and use it in
Application.cfm.

At one point I attempted to make it "window aware" so that if a link
spawned a new window or tab, it would keep track of that. I don't
think this part works 100%. However, it looks a bit like this:

session.struct_crumbTrails - structure for window numbers (e.g.,
session.struct_crumbTrails.1, session.struct_crumbTrails.2)
session.struct_crumbTrails.1 - an array of events (Mach-II speak for
pages or requests)
session.struct_crumbTrails.1[1] - a structure to hold the event name
(such as home), args (query string variables stored as a struct), and
the page name (what the crumb trail will display).

It is probably a bit overly complicated due to the window number part,
so unless that is really something you want, it should probably be
stripped out. I also have some hooks in there so that if you want a
the crumb trail to be reset you can do that. It also does some
checking to make sure the same request doesn't show up twice, like on
a refresh or from a bookmark or something.

I probably need to double check with my employer before sharing the
code, but I don't think it will be a problem (they are on Pacific
time, so not in yet). The code is Mach-II specific and refers to an
event object and such, but I think the code could be modified pretty
easily. I'll post back here and possibly on my blog if/when I can
share the code.


On Tue, Jun 10, 2008 at 8:17 AM, Rick Faircloth
<[EMAIL PROTECTED]> wrote:
> Thanks for the ideas and feedback, everyone...I'll
> check it all out!
>
> Rick
-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307162
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: List question... (having a brain [EMAIL PROTECTED])

2008-06-06 Thread Matt Williams
On Fri, Jun 6, 2008 at 4:59 PM, Brad Wood <[EMAIL PROTECTED]> wrote:
> Technically, couldn't you create some regex that would check for it in
> one swipe?  Something like if find matches of (string1 or string2 or
> string3 or etc...)

I had the same thought, but I had a feeling his list of bad keywords
were just a sample. That could be a long list, possibly even dynamic.
And while it still could be done, it is probably cleaner to do the
loop.
-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307012
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Adobe ColdFusion Survey

2008-06-03 Thread Matt Williams
On Tue, Jun 3, 2008 at 7:44 PM, Gerald Guido <[EMAIL PROTECTED]> wrote:
>>> That's not shoe size. Aww yeahh.
>
> Nice.
>
> I haven't been following this thread. Did anyone post the answers yet?
> Just askin'... ;)
>

>From Andy M.
So as to make it simple, the answers to the last 3 questions are:

1) 2005
2) 1:30
3) Ray Camden


-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306781
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Adobe ColdFusion Survey

2008-06-03 Thread Matt Williams
On Tue, Jun 3, 2008 at 3:30 PM, Charlie Griefer
<[EMAIL PROTECTED]> wrote:
> d'oh!  i got #2 wrong.  i thought it asked what time it ends :(
>
> On Tue, Jun 3, 2008 at 1:26 PM, Andy Matthews <[EMAIL PROTECTED]> wrote:
>> So as to make it simple, the answers to the last 3 questions are:
>>
>> 1) 2005
>> 2) 1:30
>> 3) Ray Camden
>>

Thanks Andy. Of course your entry will somehow get misplaced now that
you gave the answers. And mine too for admitting I used them. Oh well,
iTouch - SchmiTouch.  :P

-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306755
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Adobe ColdFusion Survey

2008-06-03 Thread Matt Williams
It is an interesting marketing technique, make us think Adobe cares
and give away an iTouch. In return, we have to learn more about the
conference and give them our email address so they can send us
"announcements". Where can I send the 3x5 postcard with my entry
printed on the back (no purchase/research necessary)?

Matt

On Tue, Jun 3, 2008 at 2:55 PM, Phillip Vector
<[EMAIL PROTECTED]> wrote:
> I did as well.. But it was just annoying seeing questions that I would
> have to research for a conference that I won't be able to attend
> anyway.
>
> On Tue, Jun 3, 2008 at 12:53 PM, Jerry Johnson <[EMAIL PROTECTED]> wrote:
>> I submitted without answering those.
>>
>> So I don't qualify for the drawing, but answered the poll questions.
>>
>>
>> On Tue, Jun 3, 2008 at 3:47 PM, Phillip Vector <[EMAIL PROTECTED]>
>> wrote:
>>
>>> This is pretty bad...
>>>
>>> I filled out the first 5 questions... Then I have to do research to
>>> answer the last 3? C'mon.. Stop with the marketing. It's annoying.
>>>
>>

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306740
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Left Join on 4 Tables

2008-06-03 Thread Matt Williams
Not sure what is up. It's kinda difficult without having the actual
tables set up. Can you post the entire query you have again?

One way to troubleshoot would be to build one join at a time. Start
with the Customer table, join Orders and test; Then join OrderItems
and test, etc.

Matt

On Tue, Jun 3, 2008 at 10:18 AM, Jason Congerton
<[EMAIL PROTECTED]> wrote:
> Hi
>
> Thanks for your replys have tried the code and am getting the following error,
>
> Syntax error (missing operator) in query expression 
> 'retailCustomer.retailCustID = retailOrders.ocustID LEFT JOIN retOrderItems 
> ON retailOrders.orderNo = retOrderItems.piOrderNo LEFT JOIN products ON 
> retOrderItems.piProductID = products.productID'.
>
> Tried troubleshooting but to no avail.
>
> Jason
>
>
>>Try this. Note that if you use a where on one of the left joined
>>tables it kind of negates the "left" part of that. One way around this
>>is to add "or x is null"
>>
>>FROM retailCustomer
>>LEFT JOIN retailOrders ON retailCustomer.retailCustID = retailOrders.ocustID
>>LEFT JOIN retOrderItems ON retailOrders.orderNo = retOrderItems.piOrderNo
>>LEFT JOIN products ON retOrderItems.piProductID = products.productID
>>WHERE 0=0
>>
>>AND (retCustCounty) LIKE '%#scCounty#%'
>>
>>AND (products.productID) = #scPdname# OR products.productID IS NULL
>>
>>
>>
>>On Tue, Jun 3, 2008 at 4:15 AM, Jas
>>>

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306701
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Left Join on 4 Tables

2008-06-03 Thread Matt Williams
Try this. Note that if you use a where on one of the left joined
tables it kind of negates the "left" part of that. One way around this
is to add "or x is null"

FROM retailCustomer
LEFT JOIN retailOrders ON retailCustomer.retailCustID = retailOrders.ocustID
LEFT JOIN retOrderItems ON retailOrders.orderNo = retOrderItems.piOrderNo
LEFT JOIN products ON retOrderItems.piProductID = products.productID
WHERE 0=0

AND (retCustCounty) LIKE '%#scCounty#%'

AND (products.productID) = #scPdname# OR products.productID IS NULL



On Tue, Jun 3, 2008 at 4:15 AM, Jason Congerton
<[EMAIL PROTECTED]> wrote:
> Hi
>
> I need to query four tables and return all the results from the 
> retailCustomer table regardless of matching records in retailOrders, 
> retOrderItems and products. The innner join query i use is below (please note 
> i will individually reference items in select stat. once i get this right, as 
> well as using query params) I get errors when trying to create the left 
> joins, any ideas?
>
> Thanks
>
> 
> SELECT retailCustomer.*, retailOrders.*, retOrderItems.*, products.*
> FROM products INNER JOIN ((retailCustomer INNER JOIN retailOrders ON 
> retailCustomer.retailCustID = retailOrders.ocustID) INNER JOIN retOrderItems 
> ON retailOrders.orderNo = retOrderItems.piOrderNo) ON products.productID = 
> retOrderItems.piProductID
> WHERE 0=0
> 
> AND (retCustCounty) LIKE '%#scCounty#%'
> 
> AND (products.productID) = #scPdname#
> 
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306687
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Coldspring docs?

2008-05-30 Thread Matt Williams
Try this page:
http://coldspringframework.org/docs/

Also, there is a ColdSpring specific mailing list:
http://groups.google.com/group/coldspring-users



On Fri, May 30, 2008 at 9:32 AM, Jason Durham <[EMAIL PROTECTED]> wrote:
> I'm hoping the person(s) who handle the Coldspring docs can be found on
> this list.  I'm getting a CF error when trying to access the documents.
>
>
>
> http://www.coldspringframework.org/index.cfm?objectid=389CE41C-F61D-DDF6
> -61D577E5A370B2F5
>
>
>
>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306357
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: ajax submit form

2008-04-17 Thread Matt Williams
On Thu, Apr 17, 2008 at 9:18 AM, Chad Gray <[EMAIL PROTECTED]> wrote:
> There are so many options it seems to use Ajax now in CF8.
>
>  Here is what I want to do, what is the best way to achieve it?
>
>  I have a search form that submits to an action page and displays results out 
> of a database.
>
>  I don't want to re-write my pages, I just want the submit to not refresh the 
> page and return the results on the same page as the search form.

Hold a magic AJAX wand over your code and say the magic spell:
"Bawitdaba da bang a dang diggy diggy diggy said the boogy said up
jump the boogy"

Sorry. You will have some rewrite to do and unfortunately there is not
a "best" way. You need to look at cfajaxproxy. There are many other
ways to do this without using CF8's ajax abilities too but using a
javascript library such as scriptaculous, prototype or jQuery.

-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303670
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Some JS help please

2008-04-16 Thread Matt Williams
>  On Wed, Apr 16, 2008 at 2:47 PM, Bruce Sorge <[EMAIL PROTECTED]> wrote:
>  > I changed everything to regular select and regular form. Still the same
>  >  issue. Just downloaded Firebug and I will work with that to see if I can
>  >  spot the problem.
>  >
>  >  Bruce

It may be as simple as the fact that the  element does not
exist before the JS runs. It is recommended that any JS depending on
the DOM being written to be deferred somehow. Something like the
window.onLoad() event. I can't remember the best practice here because
I'm spoiled by jQuery and $(document).ready()

-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303640
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Can you guys give me your thoughts on this?

2008-04-07 Thread Matt Williams
On Mon, Apr 7, 2008 at 11:05 AM, Phill B <[EMAIL PROTECTED]> wrote:
> The customer would like to have versions of the product that he could print
>  out. I'm not sure I see an easy way of  doing this with the data stored like
>  this. Then again its Monday morning and I'm not firing on all cylinders yet.

If you require more extensive data tracking, then consider a duplicate
table named something like product_archive. It would have all the same
fields, plus its own primary key (product_id would be FK back to
original product table), and maybe a time stamp.

-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302866
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfform flash required field...

2008-04-07 Thread Matt Williams
It won't work like you're trying because "required" is something CF
uses to know whether to write the necessary javascript to enforce a
value in that field. After you load the form you can view source and
see that "required" isn't even included in the html created.

You'll probably have to do some custom javascript or use qForms to
create this type of dependency.

On Mon, Apr 7, 2008 at 10:54 AM, Paul Ihrig <[EMAIL PROTECTED]> wrote:
> ok.. i am trying to make a field required if a check box has been clicked.
>  i can seem to be able to do this like required="{(imp_O.selected ==
>  true)?false:true}"
>  i can only seem to be able to do it by using the disabled thingy...
>  but that leaves the * on the form even when the item is hidden!
>
>  
>  required="yes" disabled="{(imp_O.selected == true)?false:true}"
> visible="{imp_O.selected}"
> width="200"
> label="{(imp_O.selected == true)?'Please Specify':'
> '}"  />
>
>  If i do required like disabled then i get the error below.
>
>  Attribute validation error for the CFINPUT tag.
>  The value of the REQUIRED attribute is invalid. The value cannot be
>  converted to a boolean because it is not a simple value.Simple values
>  are booleans, numbers, strings, and date-time values.
>
>  thanks guys
>  -paul
>
>  

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302858
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Can you guys give me your thoughts on this?

2008-04-07 Thread Matt Williams
This type of data logging is quite common. One way to do it is before
doing the update, get the record again from the db. Compare it to the
form data. Another way is to have the form send a duplicate set of
form fields named something like "orig_productName". Or you could even
be fancy with some javascript to make a list of the fields changed
when they are changed.

For tracking what was changed, you don't really need the XML, you can
do it with an additional table. You could have a table with something
like
changed_ID | changed_table | changed_field | orig_value | new_value.
A sample record would be
1234 | 'tbl_product' | 'product_name' | 'my widget' | 'my cool widget'

Matt

On Mon, Apr 7, 2008 at 10:40 AM, Phill B <[EMAIL PROTECTED]> wrote:
> I need some input on this. I need to keep track of changes made to products
>  in our database. The best thing I have come up with that meets the customers
>  needs is using CF to track the product using XML. The product will be stored
>  in the database but all the versions of it would be stored on the server in
>  XML with the transactions being recorded in it.
>
>  Here is how I think it should work but it just doesn't feel right yet.
>
>  A new product is created so an XML file is written to the server with the
>  date and user name attached.
>
>  When a potential change is made, the current product will be compared to the
>  most current XML to see if anything really was changed. If a change is
>  detected, a new XML file is written to the server with the date and user
>  name attached to the change.
>
>  Does this sound solid enough to use or is there a better way? All input is
>  appreciated.
>
>  It would be great if I could find an easy way to integrate Subversion, CF
>  and SQL2K for this but that's just crazy talk. :-)
>
>  Thanks
>
>  --
>  Phil
>
>

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302855
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Coldspring Question

2008-04-04 Thread Matt Williams
ColdSpring is best suited for managing the CFCs that need to be in
application scope and their inter-related dependencies. Anything
session related would still have to be done manually as ColdSpring is
not really session aware.

Matt

On Fri, Apr 4, 2008 at 10:59 AM, Ryan J. Heldt <[EMAIL PROTECTED]> wrote:
> Hey Guys-
>
>  I'm fairly new to this whole Coldspring business, so I apologize if this
>  is a glaringly obvious question. I have an intranet application that has
>  a AuthenticatedUser CFC that is given to every user that signs in,
>  persisted in the session scope. Is it possible to have Coldspring inject
>  that session-persisted object into another object/bean. Say, for
>  example, I have an object that needs to return information based on the
>  current user.
>
>  Thanks for your help!
>  Ryan

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302737
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Eclipse vs MyEclipse

2008-03-31 Thread Matt Williams
Adam,

I'm just now checking out Pulse. It looks pretty slick. Do you have a
shared profile I can check out?

On Mon, Mar 31, 2008 at 1:01 PM, Adam Haskell <[EMAIL PROTECTED]> wrote:
> Most of the plugins in MyEclipse are proprietary, developed by Genuitec,
>  though it does base some of the plugins on OS projects.  A couple of years
>  ago I would have agreed hands down with Barney. These days i am tending to
>  lean the other way. I have found more and more that I can setup a more
>  productive environment on my own. MyEclipse has become heavier and slow and
>  in all honesty I find myself more productive with other plugins. With 100
>  developers and quite a few contractors coming in and out It is well worth
>  our time as a company to evaluate the plugins on the market find the best of
>  breed and distribute them, tools like pulse and yoxos make it tremendously
>  easy. Aside from Apanta, which is abit of hog, all the plugins I listed
>  previously are quick and nimble. To each his/her own though if you evaluate
>  myEclipse and like it, go for it like Barney said to him it is worth it and
>  I think many would agree.
>
>  Adam Haskell
>
>

-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302352
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: turn integer list into list of characters

2008-03-27 Thread Matt Williams


On Wed, Mar 26, 2008 at 11:24 AM, erik tom <[EMAIL PROTECTED]> wrote:
> I have a query that returns the EmployeeiD, on the other table i have column 
> employeeId which is varchar datatype. so my question is how can I convert 
> integer list into char list so it looks like this
>
>  
>  

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302151
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Checkboxes not passing variables correctly

2008-03-25 Thread Matt Williams
What is your desired output?

If you just want a straight list with commas between the chosen names,
then do as Claude said:
Faculty Supervisor: #form.fac#

If you need line breaks between the names, then do a loop as Claude
said (with a  added):

#f#



On Tue, Mar 25, 2008 at 9:12 AM, Steve LaBadie <[EMAIL PROTECTED]> wrote:
> Is there a list of all possible delimiters value?
>
>  If I use your suggestion there are no spaces or commas between full
>  names when the information is sent. If I use delimiters="| " there is a
>  comma but no space after comma.
>
>  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: Claude Schneegans [mailto:[EMAIL PROTECTED]
>  Sent: Tuesday, March 25, 2008 9:59 AM
>  To: CF-Talk
>  Subject: Re: Checkboxes not passing variables correctly
>
>   >>delimiters="crlf">
>
>  You're using "crlf" as delimitior?
>  No wonder c, r, l & f are lost.
>  You probably meant CR LF, but these are not the delimiters used to
>  separate field values, the simple comma is used.
>  So just use
>  Faculty Supervisor: #f#
>
>  or more simply:
>  Faculty Supervisor: #form.fac#
>
>  --
>  ___
>  REUSE CODE! Use custom tags;
>  See http://www.contentbox.com/claude/customtags/tagstore.cfm
>  (Please send any spam to this address: [EMAIL PROTECTED])
>  Thanks.
>
>
>
>
>  

~|
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: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302015
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Brain not working... how do I get these values?

2008-03-21 Thread Matt Williams
On Fri, Mar 21, 2008 at 11:34 AM, Rick Faircloth
<[EMAIL PROTECTED]> wrote:
>   Add New Image Field
>
>  

Bad HTML. Put in closing  after "Add New Image Field"

should work after that.

-- 
Matt Williams
"It's the question that drives us."

~|
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: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301757
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Brain not working... how do I get these values?

2008-03-21 Thread Matt Williams
On Thu, Mar 20, 2008 at 11:13 PM, Rick Faircloth
<[EMAIL PROTECTED]> wrote:
>  I'll get on the jQuery list, which is the library I'm using
>  to perform the form field additions and find out how to implement
>  the counter.

Rick,

You don't really need a counter. Just do something like (not checking
syntax here...):

  

  


-- 
Matt Williams
"It's the question that drives us."

~|
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: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301733
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Multiple File Inputs of Same Name Create Comma Delimited List?

2008-03-20 Thread Matt Williams
OR
http://www.fyneworks.com/jquery/multiple-file-upload/

On Thu, Mar 20, 2008 at 1:22 PM, Adrian Moreno <[EMAIL PROTECTED]> wrote:
> Rick,
>
>  it works the same way as other form inputs: you'll get a comma-delimited 
> list of files. There's no need to have different field names for each file 
> input. Just do a CFLOOP using that field name as a list and you're good to go.
>
>  -- Adrian
>
>
>  >Hi, all.
>  >
>  >I've been working with jQuery to create a cloning system
>  >where I can click a link and add multiple file upload fields.
>  >
>  >But I'm a little confused about how to proceed on the CF side, too.
>  >
>  >Should all file upload fields have the same name and generate
>  >a comma delimited list of files that I can loop over with CF
>  >and create a record in the db for each?
>  >
>  >Or should I change the DOM to clone new file fields with unique
>  >names?  This approach seems problematic, because it seems that
>  >it would be more difficult to create distinctly named file fields and
>  >than to have to figure out how many fields there are to loop
>  >over.
>  >
>  >One question is whether or not file fields with the same name
>  >will create a comma-delimited list of file names as with radio or check 
> boxes.
>  >I was having trouble making that happen.
>  >
>  >Thoughts, anyone?
>  >
>  >Thanks,
>  >
>  >Rick
>
>  

~|
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: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301703
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: AJAX based mutiple file upload

2008-03-20 Thread Matt Williams
On Thu, Mar 20, 2008 at 5:09 PM, HCI <[EMAIL PROTECTED]> wrote:
>  Is there anyplace online that I can visit to help me get the SWFupload piece 
> to play nicely with a CF site?  I can get the Flash to run and apparently to 
> get the form to send the file(s) over...but capturing and processing them 
> server-side is defeating me.
>
>  I've spent the better part of the day beating on this and I'm just not 
> making any progress.  I'd love to speak with any CF dev who has gotten this 
> to work as I'm sure I'm just missing/forgetting something.

I haven't used this specific one, but do have a similar flash deal
working. http://www.element-it.com/MultiPowUpload.aspx
In it I was able to define the part of the field name that stayed the
same for the multiple files (fileData_1, fileData_2). Then I just loop
over the form fields and look for field names starting with
"fileData".

Have you tried just dumping the form scope on the page the upload calls?

-- 
Matt Williams
"It's the question that drives us."

~|
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: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301702
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Baffling Error

2008-03-20 Thread Matt Williams
Somebody has a bad link to your site?

On Thu, Mar 20, 2008 at 10:38 AM, Mark Leder <[EMAIL PROTECTED]> wrote:
> Hi,
>
>
>
>  I've been going through my error logs on CF8/IIS6, and repeatedly come up
>  with this message (note the URL will be for any site that's on my server,
>  this is an example):
>
>
>
>  http://rosemariespeaks.com/'http:/rosemariespeaks.com/index.cfm
>
>
>
>  The filename, directory name, or volume label syntax is incorrect null
>
>  The error occurred on line -1.
>
>
>
>  I've been searching all over Google for issues related to IIS6, but haven't
>  found anything.  I use an application.cfc in the front end of all my sites.
>  Is there something I could be doing in the application.cfc or in IIS to
>  prevent these malformed urls?
>
>
>
>  Thanks,
>
>  Mark
>
>
>
>
>
>
>  

~|
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: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301650
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Flash Remoting and CF

2008-03-19 Thread Matt Williams
I don't think Flash does queries. It does as your Flash guy says, send
a request and receives responses - that is Flash remoting. So yes, you
should write CFCs that Flash will send requests to.

On Wed, Mar 19, 2008 at 1:40 PM, Robert Harrison
<[EMAIL PROTECTED]> wrote:
> We're developing a data driven site where the front end will run in Flash.
>  I've written all the admin programs in CF. These handle all the DB updates
>  and ancillary file management.
>
>  Now we've looking at how to run the queries on the display side (flash). I
>  was expecting the Flash programmer to connect directly to the DB, run
>  queries from inside flash, and use the data to fill the flash page. I
>  thought that was Flash Remoting.
>
>  The flash programmer, however, wants me to write all the queries in CF
>  pages. He'll pass data to my CF pages, CF will do the queries, and I'll pass
>  back these big chunks of XML data (or strings). To me this seems a bit
>  questionable. If the DB can be queried directly from Flash wouldn't that be
>  more efficient?
>
>  Anyone have an ideas?
>
> Run queries in CF and pass large data chunks into flash OR
> connect flash to the SQL server (through a web service or something)
>  and run the queries from there?
>
>  Which is right/best?
>
>  Thanks,
>  Robert
>
>
>  Robert B. Harrison
>  Director of Interactive services
>  Austin & Williams
>  125 Kennedy Drive, Suite 100 Hauppauge NY 11788
>  T : 631.231.6600 Ext. 119
>  F : 631.434.7022
>  www.austin-williams.com
>
>  Great advertising can't be either/or... It must be &.
>
>
>
>
>  

~|
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: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301600
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFC Best practices question

2008-03-05 Thread Matt Williams
On Wed, Mar 5, 2008 at 3:43 PM, Gerald Guido <[EMAIL PROTECTED]> wrote:
> If I have an object loaded in the Application scope and want to use it in
>  another object/component ,should I pass it in as a variable or should I call
>  it directly from the Application scope. Assume that the object will always
>  be loaded in memory.

I vote for passing it in. It makes the component that will use it less
couple to application scope and therefore more reusable.

If several methods within the component are going to need access to
various methods in the application.myCFC object, then it would make
more sense to do what Rich says in step 2. Basically when the
component that is dependent on app.myCFC is instantiated, it should
get that instance in variables scope


  
 
  
  

    
  





-- 
Matt Williams
"It's the question that drives us."

~|
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: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300582
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: reinit application variables

2008-02-17 Thread Matt Williams
On Feb 17, 2008 5:38 PM, Ricardo Russon <[EMAIL PROTECTED]> wrote:
> Matt,
>
> Is there any performance gain using structKeyExists(url, 'init') over
> isdefined("url.init") ?
> Is it a best pactice thing or your own preference?
> Ric.

structKeyExists is my preference. As whether or not there is a
performance gain, I'm sure others will be glad to debate. And it won't
be the first time.
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:33841#170108
http://www.google.com/search?q=structkeyexists+vs+isdefined

-- 
Matt Williams
"It's the question that drives us."

~|
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: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299241
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cf to pdf

2008-02-16 Thread Matt Williams
 ?

On Feb 16, 2008 1:32 PM, Steve Kahn <[EMAIL PROTECTED]> wrote:
> For output of cf to pdf what would you recommend?
> I need to pass form input to 50 different letters and then save them as one
> pdf file.
>
> TIA
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.20.7/1283 - Release Date: 2/16/2008
> 2:16 PM
>
>

~|
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: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299212
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: reinit application variables

2008-02-16 Thread Matt Williams
On Feb 16, 2008 3:40 PM, Chad Gray <[EMAIL PROTECTED]> wrote:
> How do you reset application variables?
>
> I am using application.cfc to set some application variables and cant figure 
> out how to reset them so they reload with different data.

One way is to add this in onRequestStart:

  


Then you can reset them by adding init=myInitPass into the url.


-- 
Matt Williams
"It's the question that drives us."

~|
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: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299211
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: OT: ThickBox (JQuery)

2008-02-14 Thread Matt Williams
Steve, as for modal,
add modal=true and clicking the parent is disabled. Though you will
need to add a button or link that calls tb_remove() or you can't exit
it all.

I haven't tried any dragging. The sources the others have mentioned
will be best for that and future questions.

Matt

On Thu, Feb 14, 2008 at 9:37 PM, Rey Bango <[EMAIL PROTECTED]> wrote:
> No prob. Just so you know, I'm part of the jQuery team and I troll here
>  often. If you need something, feel free to email me directly.
>
>  Rey
>
>
>
>  Steve Good wrote:
>  > Thanks Rey.  That might be exactly what I need.
>  >
>  > ~Steve
>  >
>  >
>  >
>  > Rey Bango wrote:
>  >> Steve,
>  >>
>  >> Check out http://dev.iceburg.net/jquery/jqModal/
>  >>
>  >> Rey...
>  >>
>  >> Steve Good wrote:
>  >>
>  >>> I gave up on the CF8 bundled AJAX libraries and moved on to JQuery.  I
>  >>> decided to use ThickBox for my modal window needs, but I've noticed some
>  >>> differences between thickbox and cfwindow.
>  >>>
>  >>> 1.  ThickBox is not modal in the same way that cfwindow is.  It fades
>  >>> out the parent layer, but unlike cfwindow, I can exit the thickbox by
>  >>> clicking in the faded area.  With cfwindow my interaction is limited to
>  >>> just the modal window.  Is there a way to accomplish the same thing in
>  >>> ThickBox?
>  >>>
>  >>> 2.  I can't figure out how to make the thickbox window draggable like
>  >>> cfwindow.  Is this something that is possible with thickbox?
>  >>>
>  >>> I know this isn't directly related to CF, but I am at a loss for places
>  >>> to ask.  If anyone knows of a list or forums where these kinds of
>  >>> questions would be more appropriate to ask please let me know :)
>  >>>
>  >>> Thanks!
>  >>>
>  >>

~|
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: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299050
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Beyond Captcha

2008-02-07 Thread Matt Williams
If you're dealing with an actual person, then there is probably no
stopping them. Is that what you mean by crackers / hackers?
Do you mean trying to get in admin parts of sites, or legitimate
customer account screens?
I'm not sure I understand the use case...

On Feb 7, 2008 1:37 PM, William Seiter <[EMAIL PROTECTED]> wrote:
> This tag seems nice for a blogging environment or a web entry system
> (similar to the web page where you can add comments to this list at
> houseoffustion.com), but what about not just the 'spammers', what about the
> crackers and hackers who want to gain entry to the website via a login page?
>
> William
>
> --
> William E. Seiter
>
> Have you ever read a book that changed your life?
> Go to: www.winninginthemargins.com
> Enter passkey: goldengrove
>
> Web Developer / ColdFusion Programmer
> http://William.Seiter.com
>
> -Original Message-
> From: Mike Francisco [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 07, 2008 11:25 AM
> To: CF-Talk
> Subject: RE: Beyond Captcha
>
> I don't want to speculate, but I do know what works extremely well for my
> apps... Jake Munson's CFFormProtect
>
>
>
> > -Original Message-
> > From: Billy Cox [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, February 07, 2008 11:19 AM
> > To: CF-Talk
> > Subject: Beyond Captcha
> >
> > It might just be wishful thinking on my part, but I believe that Captcha
> > will soon be as rare (and just as appreciated) as those little icons
> > saying
> > 'this site optimized for IE 4.0'.
>
>
> 

~|
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: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298462
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Beyond Captcha

2008-02-07 Thread Matt Williams
+1 on cfformprotect. Just did an install last week.
Quick.
Easy.
Transparent to user. And so far no spam.

http://cfformprotect.riaforge.org/


-- 
Matt Williams
"It's the question that drives us."

~|
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: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298458
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Upload progress bar

2008-02-02 Thread Matt Williams
On Feb 2, 2008 4:36 PM, Gerald Guido <[EMAIL PROTECTED]> wrote:
> http://www.webdice.org/uber_uploader/
>

>From the research I did on this a few months ago you need to use
either Perl or Flash to accomplish real upload status. That
uber_uploader uses Perl on the backend to do its thing. Because I'm
more comfortable with Flash that Perl, I used this:
http://www.element-it.com/MultiPowUpload.aspx

The docs even show a way to hide the flash (still embed it, but not
visible) and work with it via html/javascript. There's a free version
and a pay version. The company is in Russia, but I found their support
to be very responsive and even accommodated a feature request for me.

-- 
Matt Williams
"It's the question that drives us."

~|
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: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298017
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Starting up work environment

2008-02-01 Thread Matt Williams
Maybe they will start sequentially. I haven't actually tried it to
tell the truth.
As for not restarting. I used to do that, but starting noticing a
slowness and other intermittent problems if I don't shut down at
night. Basically I would end up having to reboot after a couple of
hours in the morning anyway.

I hadn't thought of Warren's idea of a separate login, but I think I
would still rather have an on-demand way to start all the programs.

Perhaps I'll just try a batch file and see if they run as expected. I
guess even if they aren't sequential, it doesn't matter, they'll just
take longer to boot, but would anyway.

The only thing I'm not sure how to do is start the VPN connection. Is
there an exe associated with this? Or some flags to an exe?

As for the quick launch idea, I abandoned it a long time ago. I use
the "Pin to Start Menu" instead. All my often used programs are just
in the Start menu and I don't have to navigate through All Programs. I
prefer this over the quick launch because I like my task bar real
estate for the open windows. Oh, and I don't have anything on my
desktop. I have desktop icons turned off. That just seems like a very
un-handy place to put things. As soon as one program is maximized,
they are no longer easily accessible. Thus, the pin to start menu
idea.

Matt

On Feb 1, 2008 8:42 AM, Dave Watts <[EMAIL PROTECTED]> wrote:
> > I know a batch file can do this, but is it going to do them
> > all at once? If so, is there a way to make it pause between each?
>
> If you just start each program directly from the batch file, they'll start
> sequentially. You can spawn programs so that the batch file continues
> running while the programs are starting, though, I think.
>
> > Are there other solutions?
>
> Suspend mode? Why bother restarting?
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
>
> Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
> http://training.figleaf.com/

~|
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: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297908
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


SOT: Starting up work environment

2008-02-01 Thread Matt Williams
Does anybody have an automated way to start up your work environment
(Windows)? I don't think I want to use the windows startup folder
because I wouldn't want it everytime I start the computer. I work at
home and my work laptop is also my personal laptop. I'm thinking a
batch file is what I'm looking for, but not sure.

For example, each morning for work I open the following:
FireFox
IE
Trillian
VPN Connection
Outlook
Eclipse
MS SQL Mgt Studio Express
A folder on my C: drive

I know a batch file can do this, but is it going to do them all at
once? If so, is there a way to make it pause between each?

Are there other solutions?

Thanks.

-- 
Matt Williams
"It's the question that drives us."

~|
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: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297901
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


  1   2   3   4   >