Re: CF to .Net - recommended training?

2008-11-10 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Ok.  So it sounds like learning C# is a good place to get started.
Thanks all.  Would anyone recommend a good path or order for tackling
it all?  Is learning C# the best idea?  Should I get more familiar with
Visual Dev product first?  

Thanks


 I've played with both. VB is far more bloated than C#, but VB is also used
 for developing Windows applications.

So is C#. Anything you can do with one .NET language, you can do with another.

 If you are going to be developing only for web, then C# is far more compact
 and clean. If you are also going to be developing Windows applications, VB
 is more useful there.

VB is only more useful there if you have experience writing VB desktop
or console applications.

If you have no prior experience with C# or VB, I would strongly
recommend that you learn C#, since it's the .NET reference language
and it's very similar to Java. VB isn't really that similar to
anything commonly used elsewhere.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information! 

~|
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:315045
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFCHART Developer Edition Watermark

2008-10-29 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Here's more info:  On that PC that I did the fresh install of CF8, I was able 
to run my script with standard CFCHARTs in it just fine.  As soon as I ran 
the FIRST script that did calls to the java objects to create undocumented 
Webcharts charts, the watermark began showing up not only on those charts, but 
also on all charts that are generated from the standard CFCHART tags.  
Apparently the Webcharts engine thinks that I have violated the license, and is 
somehow tracking that fact across restarts, reboots, etc.

I've searched through the Registry, cannot find any tracks there.  Cannot find 
any files with new dates on them.  

~|
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:314548
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


CFCHART Developer Edition Watermark

2008-10-28 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
[This might sound similar to the September posting for CFDOCUMENT, but it's not]
I have servers that were originally installed with the trial edition of CF8 and 
then changed to standard edition by entering our valid license numbers within 
the 30 day period.  That all worked fine, and the edition changed from 
Enterprise to Standard.

At the time we hadn't been doing much with CFCHART, although we did have one 
page in production with a CFCHART on it.  We've recently started doing 
development of more charting pages, using both the CFCHART tag directly as well 
as using the calls via Java to the underlying engine so that we can get the 
more advanced charts.  

All of the charts are coming out with the Adobe ColdFusion Developer Edition 
Not for Production Use watermark on them.  Note that this is not from the 
ColdFusion8\lib\watermark.png file because that image's content says Adobe 
ColdFusion Developer/Trial Edition Not for Production Use.  So this is being 
triggered from somewhere else.  The first question is where  why? but the 
more important second question is how do I fix this?  

I did a clean install where I entered the SN on the installation screen 
(instead of letting it start out as a Trial Edition) on a PC that has never had 
CF on it, ran my CFCHART script, and it DID NOT have the watermark.  
Any ideas?  

I know for a hard fact that this watermark was not showing up 2 weeks ago, but 
cannot find any files in the ColdFusion8 folders that have changed recently - 
plus I'm seeing it on multiple servers and have definitely not been rolling out 
new software to all of them recently.

This is getting to be a hassle, because I have pages that clients see on the 
server where I first noticed this problem, and don't want them thinking that 
I'm running bootleg software!

thanks everyone,
Reed 

~|
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:314442
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFCHART Developer Edition Watermark

2008-10-28 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Nope - just a single instance!
-reed 

~|
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:314480
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Integrating SQL Reporting Services with ColdFusion

2008-09-03 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Before I start trying to crack this nut I'll check-in to see if anyone else has 
made progress since the last posting.  From what I see on the MSDN site, there 
may be problems in doing this from a non-ASPdotNET site while retaining all of 
the SSRS functionality, because the reporting controls are written in .NET.  
The article at http://msdn.microsoft.com/en-us/library/ms155131(SQL.90).aspx 
talks about being able to use the SSRS SOAP API with reduced functionality, to 
be able to render the report into any of the SSRS-supported output formats, but 
that's about it.  Of course the .NET sample app they show is too simplistic to 
be of much use.  But my goal is the same as the original posters of this 
thread, to be able to display SSRS reports in my CF app, hopefully without 
exposing the URL path to those reports.

thanks!
Reed 

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


ODBC Connection to Microsoft SQL DB Stored Proc

2008-08-26 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
My Microsoft SQL database contains multiple stored procedures with access to 
these stored procedures secured by SQL Authenticated Login Accounts (i.e. 
Manager, User, Auditor).

I am setting two session variables, session.UserName and session.Password, to 
the 
SQL Authenticated Login account for the level the person is authenticated (i.e. 
Manager) .  I then pass this information through the “cfstoredproc” tag by 
username=Session.UserName and password=Session.Password.

My question is when setting up an ODBC connection to this database, do I have 
to 
setup a separate odbc connection for each one (User, Manager, Auditor) and set 
the username and password in the ODBC connection to each of their user name and 
password (In my case causing me to have 3 ODBC connections)?  Because it seems 
as 
though my current ODBC connection via the CF Administrator overwrites any of 
the 
cfstoredproc settings. In other words, if I were to create my DSN in ColdFusion 
with the sa username and password, then it doesn’t matter what username and 
password the cfstoredproc passes in – it will run because it is using SA – 
the 
DSN account, to run it.

Do you know of any documents available that explains how the ODBC connections 
and 
SQL Security tie together?  Thank you in advance for all of your help.


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


cfhttp and Google Search Appliance

2008-08-12 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Does anybody know how to use CFHTTP to talk to the Google Search Appliance?

I can't find anything on the Web that mentions this.

I am not talking about CSE.

Thanks,
Jo-Anne 

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


CF8 problem detaching Exchange attachments: Requested Resource was not found

2008-08-07 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
This has been bugging me for some time, and I'm back on the hunt of the 
problem.  I have a pretty simple script that runs every hour and looks for 
messages in certain Exchange 2003 email inboxes whose subjects and attachment 
names meet certain criteria, and then detaches those files for processing.  
Everything works fine - almost.

We use a SonicWall spam filter (their email security software that runs on the 
Exchange server, not one of their spam applicance boxes - version 6.0.1.915) 
for our Exchange server, and to let some of those incoming messages get through 
we needed to create a rule.  Whenever those messages come through, I cannot 
detach their attachment - when I run the code below:
cfexchangemail action=getAttachments
connection=exchangeConnection 
uid=#inbox.UID#
name=attachSummaryX
which is wrapped in a CFTRY, the CFCATCH traps the following error:
The requested resource was not found on the server

If I go into that email box in Outlook (or Outlook Web Access for that matter) 
and forward it back to itself, then it gets processed just fine.  I dump a lot 
of the info about the email messages as I process them, and there is nothing 
about this one that looks any different from the ones that work.  It has what 
appears to be a good UID value, which was the first thing I looked for when 
this started happening.  If we remove the filter, then the inbox will start 
getting a ton of spam messages as well as the good ones (they come from a 
domain that spammers and phishers like to use).

Anyone seen anything like this?  Any ideas for deeper debugging?

thanks
Reed 

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


IIS URLRemap ColdFusion 8 Conflict

2008-07-30 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I've been using the IIS Tool Kit URLRemap function with Coldfusion 7 and no 
problems, but when I installed Coldfusion 8 there seems to be a conflict in 
resolving URLs so that I can get ColdFusion to work but not the IIS URLRemap or 
I can get the IIS URLRemap to work then Coldfusion no longer handles URLs 
correctly.

Any suggestions greatly 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:309927
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Barclays ePDQ MPI Integration

2008-07-28 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Just Bumping and hopefully someone will have dealt with this...

Heya Folks,

Has anyone out there had any success in connecting via XML to BarclayCards 
ePDQ MPI?

Having some troubles and would like some help . .. example code would be 
tremendous...

Thank you in advance

Paul 

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


Re: Galleon Forum - Ray Camden's Forum project

2008-07-08 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I found that and made changes to that setting and the error still persists.



DSN setting, and all settings, in settings.ini.cfm file. Read the docs, Ray
spells it all out in detail.

--- Ben


I'm getting Data source Galleon not found.  Has anyone worked with Ray
Camden's
Forum software.  I can't find where the datasource is set and I've searched
through all
the related files.No matter what I make adjustments to, the error persists.

Thanks

D 

~|
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:308775
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 vs .Net or PHP - need arguement help

2008-07-02 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
They're rebranding and reorganizing from scratch. It's driven by the Marketing
folks and they want my feedback on what we should use, but the angencies talk
about that there's more, less expensive developers out there with these other
technologies.  They're just trying to sell what their staff knows so they can 
land the account.  I need a list of reputable agencies that use CF and not just
a CF development house.

Usually companies don't just spend money for the heck of it.  What is it
they are trying to do by re-writing the site from scratch?  Do they
perceive it as slow or outdated, or are they looking for more features
of some kind?

~Brad

Our company, a large nationwide organization is creating an RFP to redo
our entire site
from scratch for agnecies to review.  The marketing folks are asking the
agencies to 
recommend a application platform as a part of the RFP.  I know most
agencies use 
..net or php, but that will be for their advantage and not our existing
CF staff. 

I need some guidance from someone that's been down this road before. I
don't want us
to switch technologies just beacuse it's what the agencies use. Why
aren't there more 
agencies using CF?

D 

~|
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:308462
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 vs .Net or PHP - need arguement help

2008-07-02 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I can understand your comments, but that's not the case at all.

They are looking for an agencies that can work the marketing and branding 
perspective. The development would be a very small peice of the puzzle which 
is an point I plan on making clear.

We don't own our CF servers.  We utilize a hosting company.

A more important question might be why is your company outsourcing the
development of their site when they have an existing development staff?

It could be that they don't respect, or trust, your team enough to allow you
to do the work, or contribute to the discussion? If they're willing to
outsource, then it's unlikely that they're going to listen to your
arguments. I've run into this before and it's extremely frustrating.

Either way, your best argument will probably come if you own your own CF
servers. We've already invested in ColdFusion, so why change?.


andy

Our company, a large nationwide organization is creating an RFP to redo our
entire site from scratch for agnecies to review.  The marketing folks are
asking the agencies to recommend a application platform as a part of the
RFP.  I know most agencies use ..net or php, but that will be for their
advantage and not our existing CF staff. 

I need some guidance from someone that's been down this road before. I don't
want us to switch technologies just beacuse it's what the agencies use. Why
aren't there more agencies using CF?

D 

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


Re: CFLOOP - why are there duplicates?

2008-06-19 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Not a dumb question ... could have been the issue.  But it not in this instance.

dumb question but... gotta ask.  are you inserting the 100 records
into the table that originally had 100 records (thus resulting in
200)?

how do you know that the getmailids query had 100 records?  can you
verify?  are you getting 200 inserts or are you just ending up with
200 records in the table (if the latter, see the original question).
can you set a counter to zero before the cfloop, increment it by 1
inside the loop, then output outside the loop to see exactly how many
times the loop iterates?  output #getmailids.recordcount# to see if
the value you end up with is the same as the resulting counter
variable value.  it *should* be... so the question becomes is that
number what you expected?

On Thu, Jun 19, 2008 at 12:15 PM,  [EMAIL PROTECTED] wrote:
 

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


Re: CFLOOP - why are there duplicates?

2008-06-19 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
CFQUERY name=getmailids datasource=stonyfieldcustom
SELECT DISTINCT mailprofiles.mailprofileID
FROM dbo.mailprofiles 
INNER JOIN subscriptions ON mailprofiles.mailprofileID = 
subscriptions.mailprofileID
WHERE (dateunsubscribed IS NULL OR datesubscribed  dateunsubscribed)
AND newslettertypeID IN (10,11,1,12,16)
/CFQUERY
  cfoutput#getmailids.recordcount#/cfoutput

CFLOOP query=getmailids
CFQUERY name=INS_TASK_DONE_DATE datasource=stonyfieldcustom
INSERT INTO sub
(
mailprofileID,
newslettertypeID,
datesubscribed
)
vALUES
(
#getmailids.mailprofileID#,
681065,
#CreateODBCDateTime(now())#
)
 /CFQUERY 
 /CFLOOP 

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


Re: CFLOOP - why are there duplicates?

2008-06-19 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
That's why I'm showing the following after the first query and
it confirms that it's the 100k
  cfoutput#getmailids.recordcount#/cfoutput

Strange isn't it?

Have you confirmed that the record set labeled 'getMailIds' does not 
contain more records then you expect. 

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


Re: CFLOOP - why are there duplicates?

2008-06-19 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Thanks.  I thought I was going crazy.

[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
 That's why I'm showing the following after the first query and
 it confirms that it's the 100k
   cfoutput#getmailids.recordcount#/cfoutput

 Strange isn't it?

There isn't anything in the code you have shown so far that would 
account for there to be more inserts then the number of records in the 
getMailIds record set.  So the search would have to be expanded to see 
if there is anyway that this code is being run twice or does something 
happen in the database to somehow cause duplication of data. 

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


Re: Accessibility testing

2008-06-18 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I guess the answer is most CF developers do not test!  But then, accessibility 
compliance is just not as sexy a subject as the latest AIR thingie.

I've been using the extensions for FF as well, but you have to be diligent and 
test each page as you create or edit it. 

From my initial research, it looks like most of the automated tools out there 
are designed to work with Visual Studio.  That's a shame.

BTW, just because a web page validates using Firefox tools does not necessarily 
mean it will make sense when a reader interprets it. 

When I finish researching this, I'll blog or post what I've found out.  Not 
that I am expert 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:307673
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Accessibility testing

2008-06-17 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Does anyone have any experience using developer-based accessibility solutions 
such as HiSoft's AccSoft, specifically with ColdFusion sites?

If not, how do you test?  Do you test?

Thanks~ 

~|
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:307631
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 Store Locator - almost there - order results

2008-05-20 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Does anyone have any ideas on this?  Thanks. 

~|
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:305750
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 Store Locator - almost there - order results

2008-05-20 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Thank you.  This is helpful. but I'm still stumped and it's the last thing I 
have to fix for this Store locator with a Google Maps mashup.

But If I'm feeding results from a zipcode query as a subquery into a store 
query, how do I get the results from the store query to sort the store results 
by the zipcode distance when the zipcode query is the subquery?  Make sense?

Here's the two queries.

SEARCH THE STORE DATABASE WITH THE ZIPCODE QUERY RESULTS
cfquery name=get_stores datasource=#datasource#
select *
from dbo.tblStores
where phone  '' AND lat IS NOT NULL AND long IS NOT NULL AND active = 1 AND 
zip IN  (
cfqueryparam value=#zipquery.zipcodes# cfsqltype=cf_sql_char 
list=yes /)
/cfquery   


GET THE ZIPCODES BASED ON THE RADIUS AND ZIPCODE ENTERED BY USER
select  zip, state, city,
SQRT(
SQUARE(#lat_miles# * (latitude - (#z1.latitude#))) 
+
square(#lon_miles# * (longitude - (#z1.longitude#)))
) as dist
fromzip
where
latitude between #lat1# AND #lat2#
AND
longitude between #lon1# AND #lon2#
order by dist asc




~|
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:305767
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 Store Locator - almost there - order results

2008-05-18 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I have two tables.  The first table is the zip code table.  Once I find the
zipcodes that fall within the milage radius input, I take the list of zipcodes
and seatch against my store table.  I'm trying to figure out how to get the
results from my store database to be in the same order by the zipcode's
distance to the orignal zip code entered.  In my sample is was 01860.

Thanks


I can't see any ordering in that query; there's no order by clause.

On Mon, May 19, 2008 at 11:21 AM,  [EMAIL PROTECTED] wrote:


-- 
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/ 

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


How to unGZip very large archives via CF?

2008-03-27 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I'm running into Java out of memory problems when I try to use the java 
unzipping support (gzipExpandToString) for some files that I download via a 
webservice.  CFHTTP saves the file to disk for me, but then when I unzip them, 
the large ones cause memroy problems.  I've configured the max heap size to be 
1380, which is the max that I've usually been able to set it to.  

Anyone have a lead on code that I can use in CF that doesn't try to store the 
entire unGZipped content in memory?  

I'm probably postponing the eventual problem, because I'm going to need to run 
the content through xmlPARSE, but if I can at least get it unGZipped into a 
file, maybe I can get SQL to do the XML heavy lifting for me.

thanks
Reed 

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


Re: subquery help

2008-03-06 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
thank you sonny 

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


Re: Add form fields dynamically

2008-03-05 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Wow!  Happy Birthday to me! 8-)  Thank you very very much Charlie!

 On Tue, Mar 4, 2008 at 2:11 PM, Charlie Griefer
 [EMAIL PROTECTED] wrote:
  On Tue, Mar 4, 2008 at 1:31 PM,  [EMAIL PROTECTED] 
 wrote:
 i'm sure this can be cleaned up quite a bit... but this should do it
 
 http://www.nomorepasting.com/getpaste.php?pasteid=12545


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


subquery help

2008-03-05 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
hi, i have the following query that retrieves the latest quiz date and quiz 
percent

SELECT MAX(QuizDate) as QuizDate, QuizID,
QuizPercent = (SELECT QuizPercent FROM Test_Board_Acupuncture as t1
  WHERE t1.Customer_ID = #COOKIE.TCMTests#
  AND t1.QuizID = Test_Board_Acupuncture.QuizID
  AND t1.QuizDate = 
MAX(Test_Board_Acupuncture.QuizDate))
FROM Test_Board_Acupuncture
WHERE Customer_ID = #COOKIE.TCMTests#
GROUP BY QuizID 

the problem is that if the student takes the same test back to back right away 
somteimes it can throw an error from the sub query

Diagnostics: Error Executing Database Query. [Macromedia][SQLServer JDBC 
Driver][SQLServer]Subquery returned more than 1 value. This is not 
permitted when the subquery follows =, !=, , = , , = or when the 
subquery is used as an expression.

is there a way of restructuring the query so that i can select the info without 
it triggering the error?

thank you.





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


Re: subquery help

2008-03-05 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
When you store the date, are you also storing the time?  I would think if
you put the time in there that you could not have the problem because even
if doing the test back to back there would be a seconds difference.

On Wed, Mar 5, 2008 at 10:21 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL 
PROTECTED] wrote:



yes i am storing the time in the quiz date. i think it tends to throw the error 
if the quiz percent is the same. 

i checked the table and each entry has a unique id. would using that in the 
query solve it? 

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


CFEXCHANGEMAIL overwriting message on ACTION=MOVE

2008-02-11 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Here's an odd one:  I have a small app that runs every 15 minutes and unloads 
messages from MSX inboxes, detaches and saves their attachments, and then when 
done with each message moves it to a subfolder under the INBOX called 
PROCESSED.  These messages arrive every day, always from the same senders, and 
always with the same subject lines.  Usually, but not always, when it does the 
ACTION=MOVE at the end of the processing, the new message replaces the 
existing message that arrived the previous day, even though they have differing 
UID values.  I've ended up putting code both before and after the ACTION=MOVE 
that does an ACTION=GET of the PROCESSED folder, and dumps the contents, and 
those dumps verify this behavior, including the unique UID values.

Here's the code that's doing the ACTION=MOVE
cfexchangemail action=move
connection=exchangeConnection 
folder=inbox
destinationFolder=#thisProcessedFolder#
cfexchangefilter name = uid value = #inbox.UID#
/cfexchangemail

The var thisProcessedFolder value is typically INBOX/Processed

Anyone see anything wrong with this code, or witnessed a similar behavior?  On 
a related note, since the details on this tag are a little sparce in the 
LiveDocs, can I manipulate the READ flag of a message?  That would let me work 
around this problem so that I don't reprocess previously processed messages.

thanks everyone,
Reed 

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


Re: Submitting a form inside of cfdiv

2008-02-01 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Does anyone know if there is an issue where you place a cfdiv in a cfform with 
with another cfform in the cfdiv that would not allow the form to submit in the 
cfdiv.  For Example:

cfform
name cfinput type=text 
yada cfinput type=text 
yada cfinput type=text 

cfdiv
cfform
add another address: cfinput type=text 
cfinput type=submit name=submit value=submit!-- submit for cfdiv form 
--
/cfform
/cfdiv

cfinput type=submit name=submit value=submit !-- submit for master 
form --
/cfform

When I try to submit the form in the cfdiv it reloads the entire page not cfdiv.



Thank you,

Michael


~|
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:297916
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 App throwing Access access error

2008-01-25 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Thanks. I don't think that's it. It's worked for weeks and today I rebooted
the machine CF is on and still I ge the error.

It is probably locked by the Datasource connection from CF Admin



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


Re: Owned by Rootdamages by FasT

2008-01-23 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Is there a way to address all URL scopes or do I have to be specific and list 
all URL scopes used on the site?

I'm thinking ...

CFIF ISDEFINED (URL.pr_id)
CFIF URL.pr_id contains select
/CFIF
/CFIF


Or at the very least write some generic code in Application.cfm/Application.cfc
that inspects the form, url and cookie scopes and strips out anything
suspicious like SQL statements. That would only be a half measure though.
The queries need to be changed to use cfqueryparam.

On Jan 23, 2008 11:38 AM, Tom Chiverton [EMAIL PROTECTED]
wrote:

 

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


Re: Owned by Rootdamages by FasT

2008-01-23 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
SQL Server 2000

What kind of DB were you using?  I still haven't seen a good example of a
sql query injection in CF since CF auto escapes single quotes.  

Russ

 

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


Re: Owned by Rootdamages by FasT

2008-01-23 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I don't get where you're getting the variables on line ...
cfloop collection=#url# item=variables.itm
Are you cfsetting URL variable and I've never seen the 
variables.itm ... what's this?

You just loop over a collection:

!--- Make sure that all attributes scoped variables are decoded and
trimmed ---
cfloop collection=#url# item=variables.itm
   CFIF variables.itm contains select
   Please don't do that... tisk tisk!
cfabort
   /cfif

/cfloop

On 1/23/08, [EMAIL PROTECTED] [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
 

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


Re: Cybersource Gateway Solution Found For ColdFusion

2008-01-23 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
If anybody is interested I did find information on how to use  
ColdFusion to access the CyberSource Credit Card Gateway.  I'll be  
happy to send you my sample code if you need it.  Works like a charm.

Philip,

If you are willing to share your code, please email me at [EMAIL PROTECTED]  
That would be a GREAT help!

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


Keeping Anon access off turning on Scheduled Tasks

2007-12-31 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Hi Folks - 

I am looking for someone who may have done something like this before and 
remembers what needs to be done! ;-)

I have an intranet web site already built and running fine. It currently has 
Anonymous access turned off.  This allows the web site to pull the user's 
cgi.auth_user info to be passed and processed (display name, set up security, 
etc).

Now I am trying to get Scheduled Tasks to run properly.
But everytime I do it, I get the following message:  (I stripped out the HTML 
code)


___
You are not authorized to view this page
You do not have permission to view this directory or page using the credentials 
that you supplied because your Web browser is sending a WWW-Authenticate header 
field that the Web server is not configured to accept.

Please try the following:

Contact the Web site administrator if you believe you should be able to view 
this directory or page.
Click the refresh button to try again with different credentials.

HTTP Error 401.2 - Unauthorized: Access is denied due to server 
configuration.brInternet Information Services (IIS)

Technical Information (for support personnel)

Go to Microsoft Product Support Services and perform a title search for the 
words HTTP and 401
Open IIS Help, which is accessible in IIS Manager (inetmgr),
 and search for topics titled About Security, Authentication, and About Custom 
Error Messages.

__


If anybody has any ideas of how to keep Anon access off and Scheduled Tasks or 
the CF server proper access to do this, I would appreciate any info.


Thanks,

Doug 

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


Re: Keeping Anon access off amp; turning on Scheduled Tasks

2007-12-31 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Hello again -

Thanks for the good ideas.  I need to keep Anonymous Access off on the primary 
web site, but having a secondary site that does allow it, is a good idea.

Thank you very much!

Doug

Right... Excellent I forgot you could set permissions at a very granular
level like that.
 

Since you are using IIS... You could also go into the IIS Administrator
drill down to the file, then choose properties.  From there go to security
and set it to allow Anon.

IIS allows these settings at the file level.  Helps if you are just having
tasks run that don't need to be secured. You could also add code in the page
to ensure that the remote_addr was the ip of your server.
That way you only run the page if it is the server requesting it. That means
you'd have to use the run command from the CFA Scheduled Tasks and couldn't
hit it from your local machine.

At least this way it prevents passwords from being passed cleartext.

Steve
 

There is a username and password attribute for scheduled tasks. It requires
that you allow the plain text option I believe. 

Barring that you can set up a site that mirrors your web site but does allow
anon access and have it respond only to 127.0.0.1. That would allow your
tasks to run but not expose the content to the outside world.

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


Re: Cffile Write Problem

2007-12-11 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
When you say that you open up the rights what are you referring to?  What you 
need to do is to make sure that the ColdFusion service is running under a 
defined login account, which has been granted rights to the location you are 
writing to, and not under the default local account.  The local account does 
not have, and cannot be given, permissions to access network drives.

Thanks we open up the rights and it is still occurring. 
The Network guys think it is a CFfile timeout issue which 
apparently cannot be controlled.


On Thu, 6 Dec 2007 17:42:44 -0500 (GMT-05:00)
  James Blaha [EMAIL PROTECTED] wrote:
 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

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


Re: CFXML - strange, dropping the beggining tag upon processing

2007-12-11 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I have to upload my XML files to a Magazine fulfillment company
and they are requiring that both tags are present even if there's
an empty element.  Is there a way to force both tags to appear
even when there's an emtpy element?

Thanks

D

 When I output a query's results to an XML file, my code which 

You don't need to add anything. That syntax denotes an empty element. It's
identical to address2/address2 as far as an XML parser is concerned.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information! 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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


Re: CFXML - strange, dropping the beggining tag upon processing

2007-12-11 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Is there a way to force the openning and closing tags even if the element is 
empty?

Thanks

D


 When I output a query's results to an XML file, my code which 

You don't need to add anything. That syntax denotes an empty element. It's
identical to address2/address2 as far as an XML parser is concerned.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information! 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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


MS SQL problem

2007-12-04 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
i have the following sql:

SELECT MAX(QuizDate) as QuizDate, QuizID,
QuizPercent = (SELECT QuizPercent FROM test_module as t1
  WHERE t1.Customer_ID = 21
  AND t1.QuizID = test_module.QuizID
  AND t1.QuizDate = MAX(test_module.QuizDate)
  
FROM test_module
WHERE Customer_ID = 21
GROUP BY QuizID 

it works fine until the QuizPercent subquery returns more than one record when 
the user has, for example, multiple 100% scores. so i thought of isolating and 
looking for max date and max time since the same scores would be done at a 
different time by doing the following:

SELECT MAX(QuizDate) as QuizDate, QuizID,
QuizPercent = (SELECT QuizPercent FROM test_module as t1
  WHERE t1.Customer_ID = 21
  AND t1.QuizID = test_module.QuizID
  AND t1.QuizDate = MAX(Day(test_module.QuizDate))
AND t1.QuizDate = MAX(Time(test_module.QuizDate))
  
FROM test_module
WHERE Customer_ID = 21
GROUP BY QuizID

but in SQL there is no 

MAX(Day(test_module.QuizDate))
AND t1.QuizDate = MAX(Time(test_module.QuizDate)) 

and it generates an error. 

suggestions?

sebastian



~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


looping through each row

2007-11-24 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
hi, i've got a csv file with a comma delimiter. i use cfhttp to retrieve it and 
upload the data into a database. before uploading i want to check each row to 
make sure it has the right number of commas. i know about ListLen to tell me 
how big the list is but how do i loop through each individual row?

this website is on ColdFusion 5.

thanks. 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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


Re: looping through each row

2007-11-24 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
thanks for the suggestion.

hmm...i did not know about ListLen treating consecutive delimiters as one. 

what can be used instead to determine how many commas , are in each row?

sebastian



cf treats consecutive delimiters as one, and here is a caveat with your 
proposed ListLen use:

if your list = a,b,c,,,f then listlen(yourlist) will return 4, not 6.


---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com 

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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


Re: looping through each row

2007-11-24 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
i found this solution on the web 

cfset list = 1,2,3,,59,10
cfset counter = 0

cfoutput
cfloop index=thisElement list=#replace( list, ',', ', ', 'All' )# 
delimiters=,
cfset counter = counter + 1
Element #counter#: #trim( thisElement )#br
/cfloop
brbr
#counter#
/cfoutput 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

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


Re: Strange XML error with CFXML - XML declaration may only begin entities ?

2007-11-15 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Dominic, Dave,

Thanks Dominic, your tip got rid of an error.  

Dave, to answer your previous question, the code ran without a
web page based error.  The value within output variable from 
CFXML tag contained the value of [EMAIL PROTECTED]
instead of the XML i was looking for. If I refresh the self posting
page and try and generate the error again, I get a different number
at the end of [EMAIL PROTECTED]

 CFXML variable=gallery cfoutput'ing the gallery variable.

What does this [EMAIL PROTECTED] mean?  How are
we suppose to debug this?

Thank you very much.

Dan

 



Could it be that there is space before the ?xml version=1.0?
declaration? I believe that will throw that particular error. So do:

cfxml?xml version=1.0?
!--- rest of your xml ---
/cfxml

Dominic



 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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


Re: Strange XML error with CFXML - XML declaration may only begin entities ?

2007-11-15 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Ok. I solved it.  Well thanks to Dave Watts.  Once Dave shared what
this actually was, I had something to go on.  Thanks Dave. I just 
needed to review the CF xml tags and functions
page.  Which can be found at ...

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=XML_07.html

CFXML variable=gallery ...

I just added the tostring function to the gallery variable. And it changed the
object back to a string and there was my XML.

cfoutput#tostring(gallery)#/cfoutput

Thanks All.

Dan

Dominic, Dave,

Thanks Dominic, your tip got rid of an error.  

Dave, to answer your previous question, the code ran without a
web page based error.  The value within output variable from 
CFXML tag contained the value of [EMAIL PROTECTED]
instead of the XML i was looking for. If I refresh the self posting
page and try and generate the error again, I get a different number
at the end of [EMAIL PROTECTED]

 CFXML variable=gallery cfoutput'ing the gallery variable.

What does this [EMAIL PROTECTED] mean?  How are
we suppose to debug this?

Thank you very much.

Dan

 



 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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


Re: What I need to Develop a standalone application on my LAPTOP usiong COLDFUSION?

2007-11-14 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Also, check out the ACME Guide 
(http://www.acidlabs.org/approach/goodies/#acme).  It provides detailed 
instructions on how to prepare a PC or Mac workstation for development using 
ColdFusion and several Open Source tools including the Apache HTTP Server, 
MySQL and Eclipse.

-
MJS


 Hi All,
 
 I need to know that what sofywares do i need to create satandalone CF 
 applications on my blaptop.


~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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


Re: Strange XML error with CFXML - XML declaration may only begin entities ?

2007-11-14 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Thanks Dave,

When I remove the declaration, I get ... [EMAIL PROTECTED]

 XML declaration may only begin entities. 
 ...
 ?xml version=1.0?

Remove that declaration.

Dave Watts, CTO, Fig Leaf Software 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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


Re: Strange XML error with CFXML - XML declaration may only begin entities ?

2007-11-14 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Thanks Dave,

When I remove the declaration, I get ... [EMAIL PROTECTED]

 XML declaration may only begin entities. 
 ...
 ?xml version=1.0?

Remove that declaration.

Dave Watts, CTO, Fig Leaf Software 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293330
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 Dev Edition store local file on Network drive - help

2007-11-12 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Neither.  This is the built in Web server that comes with the CF developer's 
edition.  We have a dev server, but we won't have access to the Web server's
config.  Any ideas on what we can do?  I really want to start using this shared
drive and offload the files from the site off my laptop.

Thanks

Are you doing this in IIS, Apache or what?  Our webroots are sometimes on
other PCs and it works just fine in Apache. 

Russ



 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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


Re: PDF Support with CF8 - Can this be done?

2007-11-02 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Hi everyone,

I've been out of the CF game for a very long time and now I have a little
project to do and wondering
if CF8 has the answer for me. I'll keep search the docs, but in case you
have a quick answer I appreciate it.

What I need to do is take information posted from a web form and merge it
into an existing PDF with place holders
and then save the file and email it as an attachement.

Can CF 8 do the PDF portion natively?

Thank you,

Frank Mamone 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


Re: PDF Support with CF8 - Can this be done?

2007-11-02 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Yes, CF8 can do what you need to do very easily.

Damon


What I need to do is take information posted from a web form and merge it
into an existing PDF with place holders
and then save the file and email it as an attachement.

Can CF 8 do the PDF portion natively?


~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292554
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 this be done

2007-10-31 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Does a user have to have interaction on the homepage?  If the classes are
defined by time, you could do something simple like have the homepage check
the date and time and show the classes that fall within the current date and
time range.  That would be simple.

 I am developing an application for a gym. 
 
 On the home page of the application I am currently displaying details 
 of personal training sessions which are in progress, and also thos 
 sessions which are waiting to be started. 
 
 Sessions in progress 
 
 P/TrainerRoom # Start Time Finish Time  Remaing Time
 
 Rob   17:00   8:00 25 mins
 Mick  27308:30 55 mins
 
 
 Sessions waiting to start
 
 P/TrainerRoom # Start Time Finish Time  Remaing Time
 
 Rob   1
 Mick  2
 
 
 I have also set this page up to referesh every 60 seconds  - this part 
 works well and as intended. 
 
 I could I guess add a button for each record which would allow a user 
 to edit each record individually, but am wondering if there is another 
 simpler way that this could be done - e.g. maybe a checkbox which the 
 user checks and then when the screen refeshes any records with 
 checkboxes marked have their status changed.
 
 Basically I want to enable a user to be able to effortlessly indicate 
 that a session has been completed so that record does not continue to 
 be displayed).  Also I want the user to indicate that a session has 
 moved from the waiting state to the active state. 
 
 I was thinking of including a check box which can be clicked - to 
 indicate that a record can move from the wating state to current. 
 
 Any thoughts on this will be greatly appreciated. 
 
 Thanks 


~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292404
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 WEB HOSTING: Best solution ? For 50,000-100,00 outgoing emails a month?

2007-10-18 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Huh, so this software will act as an SMTP server but it actually just send
the email directly to the recipients incoming mail server.  So does this
skip over and restrictions that an ISP or cable comapny like Comcast might
have setup to block port 25 or other measures?

Thanks Guys.

Ims-lite is also free... Limited to 5 threads though.. 

Russ

 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


Re: 2007 Web Design Survey

2007-10-18 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I have only one but very strong response/opinion based on this survey. It just 
proves that this line of work has increased in the amount of knowledge required 
to do the job but the pay has been significantly descreased as the overall cost 
of living has increased dramtically. 

It no longer possible to contribute to 401k plans or save any of your salary 
unless you have a inexpensive mortgage and don't live near NYC, New England or 
California.

It's abundantly clear to me that unless you want to live pay check to paycheck, 
you need to come up with a business idea that utlizes your skill sets and grow 
a business of your own.  You could do Web consulting, but the survey doesn't 
show great results in that area.  I'm talking about creating a unique product 
or service that people want and charge a small price and work on volume or if 
you idea is extremely hard to compete against, charge a premium for your 
product/service.

There's more tax agvantages being in your own business.  As an employee you 
spend your money after it's already been taxed.  When you're in your own 
business, you spend your money related to your business, take the deductions 
and then pay taxes.
You can write off your car payment, make it a company car, and expense meals, 
travel etc.

This survey just solidifies the truth that no one get's rich enough to have an 
easy life while working for someone else unless you're an executive or are 
lucky and likeable to survive a pre-ipo and post ipo company and all the 
politics that goes along with a company's maturing process.

I recently thought that there should be a union created for all Web related 
professionals or someone needs to unite the web workers of the world in the 
form of a franchise that utilizes a large cummunity of developers to complete 
projects in half the time a small shop would or an individual employee. It 
would become so cost effective for the customers, the international volume 
would seep back into this country and would benefit US based Web professionals.

So go ahead, disagree, call me a bonehead, it's just one opinion. I think 
developers work very hard for their earnings and have high expectations.  We're 
the gate keepers to the Web site world and I see us moving towards becoming a 
commoditity and it makes me sad.

I hope you share some similar views and that I'm not just on my own osolated 
little planet. 8-)

Discuss amongst yourselves.
 
http://alistapart.com/articles/2007surveyresults/
 

 
Andy Matthews
Senior ColdFusion Developer

Office:  877.707.5467 x747
Direct:  615.627.9747
Fax:  615.467.6249
[EMAIL PROTECTED]
www.dealerskins.com 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

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


Re: 2007 Web Design Survey

2007-10-18 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Hey Bruce,  Great response. I'm doing the same thing you're doing.
I guess I just want to make that jump to a higher level beyond 9-5 
and side jobs which is a great living. But I want to join those guys
you see on their huge boat during the day wihc great tans after their
month long vacation.  I watched my Dad kill himself all his life working
for other people and had nothing to show for it in the end.

While I agree with most of what you say, being self employed is not all 
that. I know, I have done it. It is fast or famine. I seem to recall 
several folks on this list who are self employed have gone through some 
great times and some bad times. Sure you get a shit load of tax breaks, 
but to me the smartest way to do it is how I do it now. I work full time 
for shit pay (I am in the public sector after all) but also do a lot of 
side work form home. I get the home office deduction, cell phone is a 
write-off, most of my utilities are as well as any software and computer 
upgrades I buy. It helps me out a lot for my annual tax goal to not pay 
the government ANYTHING other than the taxes I get taken out each month. 
I have successfully ran my business in the negative for over 5 years now 
and it is working out great. I always get a great return. I love my 
accountant.

Bruce

[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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


Re: 2007 Web Design Survey

2007-10-18 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Dave, Crow,

So true, so true.  I hope to have my business.  I own microfuelcell.com
which is an emerging technology for powering portable devices which is
predicted to replace the latest battery technologies.  There's just the
age old issue of time and money to get the thing off the ground.

http://www.tech.co.uk/gadgets/future-tech/news/water-powered-phones-coming-in-three-years?articleid=1524298136

Sorry for being off CF topic.

Anyone want to come for a ride on my boat? lol

Web Development, no, but move your way up a corporate chain into management,
and you're getting closer...


 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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


SOT: Automatically sync an access db to SQL 2005

2007-10-16 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Hi all,

I hope this is not too off topic.  Does any one know of a methodology to 
automatically move Access data to SQL Server 2005?

Here is the scenario.  The Client is syncing their AS400 to Access.  They want 
to upload the Access db to the server and then run a routine to basically purge 
the tables and repopulate them with the Access data.

My first suggestion was to just do this manually, Second to write a CF routine, 
but then they asked about something at the SQL level.

Any thoughts are welcome. 

Thank you,
Michael 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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


Re: CPU spiking, possible bad loop or conditional statement

2007-10-15 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
It was a poorly written sql statement.  Shame on me.

All,  Can anyone recommend a server monitoring tools for a CF MX install
that all of a sudden is creating the CPU to spike and the CF server is maxing 
out?

Thanks for any direction.

D 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


SQL Concat Issue

2007-10-12 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I am probably being dense or showing my ignorance here, but I have a legacy 
database that I need to run a query on like the following. Can anyone tell me 
how I can achieve the following.  Right now I am getting an error that PubYear 
is not a valid column.  Thank you!

SELECT AdINFO_Publication,  
ADINFO_PUBLICATIONDATE_YEAR+ '-' + ADINFO_PUBLICATIONDATE_MONTH 
+  '-01' AS PubYear
FROMcrAdInfo
AND PubYear  BETWEEN  #dateformat(startdate,-mm-dd)# AND 
#dateformat(enddate,-mm-dd)#

Any Help is appreciated.  Thanks! 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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


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

2007-10-08 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I'm trying to capture and pass the elex,y variables that are being passed in
the span tag that looks like ... I never knew you could the id of a span tag
as a variables.  Hmm.
(without the greater and less than)

span id=span_elex nbsp; /span, span id=span_eley nbsp; /span

Are you just wanting to capture the x,y whenever a user clicks? Are you
trying to create a heat map overlay? 

All,  Sorry for the repeat post. I've searched all day for a solution and
can't find anything.
I want to capture the coordinates from this sample and pass them for use in
a cf scope.

I'm stumped!

http://dunnbypaul.net/js_mouse/

If I could only get the x and y coordinates in a form in the action param
and pass them URL scope then use ...

cfset RIGHT = #ListFirst(CGI.QUERY_STRING)# cfset DOWN =
#ListLast(CGI.QUERY_STRING)# 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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


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

2007-10-08 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Thanks Dave, What I'm using is an absolute div with a thick black border
that sits on top of an uploaded image.  I trying to capture the x and y 
coordinates (elex,y) after the user positions this draggable div, I'm using 
that coordinate information to crop the image that appears beneath this 
movable div.  I want to use this as a framing functionality.  Then the 
backend takes the images height and width and the position of
the frame and crops the image to the correct size and then moves
onto the next stage in the process which is importing the perfectly
sized image into a Flash movie.  It's a consolation prize for
contestants that entered a photo related contest. We had over 50,000
entries so it was pretty successful.

Thanks

D


 All,  Sorry for the repeat post. I've searched all day for a 

Presumably, they're clicking on something, right? Otherwise, you'd only be
able to capture the mouse coordinates at the moment they click on your
submit button (or whatever).

If you want the user to click on an image, and you want to capture the
coordinates of where they clicked on the image, you can just use INPUT
TYPE=IMAGE as your submit button - it will automatically return
coordinates within the form data.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information! 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290594
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 Coding Standards

2007-10-08 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I agree with William except on point ...

William, I'm sure you're idea is in the spirit of improvement and sharing, but
putting Jr. developers on the hot seat and allow senior developers to
show off a little is one of the reasons I don't like working in large
development teams with this kind of environment.  

There's nothing worse than a knowledgable developer that wields his knowledge
for the benefit of their own ego at the expense of others.  It should be more 
of a mentoring environment. It's true, that a developers knowledge is their
greatest stregnth, but the use of that knowledge is the greater test the 
person's character. 

My 2 cents.

You are the lead, you see a problem with not only the current code but
future code put together.  You are introducing standards to the group.  This
is not at all a bad thing. You will probably be heralded in the future for
your attempts now, however despised you might be for it now.

I would suggest doing 'spot checks' on other people's code, or 'peer
reviews' on their code so that you can verify that the standards are being
kept to.

You might even do this as a 'group' event.  Where the group of developers
gets together and puts 1 programmer on the 'hot' seat.  The programmer will
'run through' his/her code and explain what it is doing and why it is there.
You could critique the code based on ample commenting and standards
adherence, and you can have the group come up with plausible solutions for
'heavy' code or code that is 'muddled'.  This would be a great exercise to
help the 'junior' coders get better as well as the 'senior' coders to hone
their skills and 'show off' a little.  To get everyone off on the right foot
you might even make the first few 'sessions' regarding a custom tag or UDF
that you can download from the exchange.  Send it out to everyone and have
everyone 'change it' based on their programming skills but to your new
standards.  Then you can run through the original example and open it up for
discussion.

Just an idea...

Can you tell I am 'dying' to get out of my '1 guy' shop and join a bigger
team?

William

-- 
William E. Seiter
 
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
I recently started a position as a technical lead at a new company. Most of
the development is done on a few intranet/extranet sites, so the code (much
of it spaghetti) is touched by a lot of different developers.

I've recently set up a wiki that contains coding standards, and used a lot
of the LiveDocs recommendations (with a References section indicating
sources). I've gone the route of placing these standards under some general
categories, such as Security, Performance, and Stylistic.

The Stylistic category defines things such as capitalization and
indentation. It may have been a bad idea, but with this category, we came to
a lot of these standards based on the consensus of the group - most of whom
maintain the coding style of the CFWACK, e.g., title casing function names,
uppercasing CF operators, etc.

Wondering if any of you would think it is beneficial (or too draconian) to
have these stylistic standards in place, even if it isn't an individual's
preference, to promote readability, consistency and prevent constant
reformatting (annoying when doing diffs), especially in an environment where
different developers are touching a lot of the same code?




http://webapper.net/index.cfm?fuseaction=Fuseblog.ShowCommentsArticleID=200 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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


AXIS problems, where do I put the config file?

2007-10-05 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Am having major problems with calling Google adWords webservices, and need to 
log the AXIS traffic.  I need to know where to find the working directory of 
your Axis client for CF8 so that I can drop in the config file that Google 
gives me to turn on logging.

HELP!
Thanks,
Reed


~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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


Re: MS SQL Triggers and Coldfusion 8

2007-10-04 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Thanks, Ben!  

For some reason the hotfix isn't resolving the issue for me, which is weird.  
But the AlwaysReportTriggerResults=true trick works fine, so I'll just use that.

Thanks for your help!
Jim Sullivan


 Hey Jim,
 
 that issue was fixed with the latest hotfix.

 http://kb.adobe.com/selfservice/viewContent.
 do?externalId=kb402466sliceId=1

 It's not listed in the notes, but I was the one who reported the bug 
 and received an email back stating it was an official bug and that it 
 would be fixed in the first hotfix.

 There is also a workaround to add the argument: 
 AlwaysReportTriggerResults=true to your neo-datasource.xml file for 
 that particular datasource. Or you can select Other as the driver 
 type and enter in the jdbc driver manually as below:

jdbc:macromedia:sqlse 
rver://dbdev01:1433;databaseName=awayx;AlwaysReportTriggerResults=true

 Ben


 - Original Message 
 From: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED]
 To: CF-Talk cf-talk@houseoffusion.com
 Sent: Wednesday, October 3, 2007 3:48:18 PM
 Subject: MS SQL Triggers and Coldfusion 8

 Hi all.  We're in the process of switching over from CF7 to CF8.  We 
 have a query that updates a row in a MS SQL database, which then 
 causes a trigger to return a date value to Coldfusion.  It worked in 7 
 but it doesn't seem to be working in 8.  Coldfusion 8 is telling me 
 that the query is undefined while that is not the case with the same 
 query in Coldfusion 7.

 I searched the docs and release notes and the web, and the only clue I 
 can find are the last few comments under this Ben Forta blog post:
 http://www.forta.com/blog/index.
 cfm/2007/7/6/ColdFusion-8-Can-Return-Identity-Values
 It seems that other people are having the same problem.  

 So does anyone know if MS SQL triggers that return values officially 
 don't work with Coldfusion 8?

 Thanks,
 Jim Sullivan 



~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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


Re: Voting System: Not allowing multiple votes

2007-10-04 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
What I ended up doing is using cookies and storing the email in a table.
We decided to use email verification and allow multiple votes but only one vote 
each day. So we can control the amount of votes by a single user each day
and fake, made up emails still have to verified via email. If an email isn't 
verified, then the vote won't be counted.

Thanks everyone for your feedback.  What a great group!

D

 The trouble with that is you can no longer be sure the person placing 
 the vote 
 isn't being coerced.
 
 -- 
 Tom Chiverton
 Helping to augmentatively engage efficient models
 on: http://thefalken.livejournal.com
 


~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


Re: Design/Web Development Agencies that has a strong CF core

2007-10-03 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Four Eyes Productions
http://www.foureyes.com
1.888.LAUNCH.9



 All, Does anyone know of or had expereince workign with a reputatble 
 Web Design/Development agencies where CF is a strong core of their 
 development focus?  This is for a publically trade company not a small 
 Mom and Pop business.  Thanks.
 
D 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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


MS SQL Triggers and Coldfusion 8

2007-10-03 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Hi all.  We're in the process of switching over from CF7 to CF8.  We have a 
query that updates a row in a MS SQL database, which then causes a trigger to 
return a date value to Coldfusion.  It worked in 7 but it doesn't seem to be 
working in 8.  Coldfusion 8 is telling me that the query is undefined while 
that is not the case with the same query in Coldfusion 7.

I searched the docs and release notes and the web, and the only clue I can find 
are the last few comments under this Ben Forta blog post:
http://www.forta.com/blog/index.cfm/2007/7/6/ColdFusion-8-Can-Return-Identity-Values
It seems that other people are having the same problem.  

So does anyone know if MS SQL triggers that return values officially don't work 
with Coldfusion 8?

Thanks,
Jim Sullivan 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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


Re: Trying to understand the CF8 - .Net integration

2007-10-02 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Dave, I loved your reply.  Made me crack up and almost fall off
my chair.  The comment about the crack pipe and being in a Dilbert
comic strip was hilarious.  

Thanks everyone for your input and feedback.

 All, I'm just starting to learn .Net.  I'm trying to grasp 
 the concept of what .Net assemblies are.  Would it be fair to 
 say that they are like CFCs?  I'm trying to get a comparible 
 CF analogy. I'm assuming you can't access to lines of logic 
 within an .Net Web page, but that these .Net assemblies are 
 compiled dlls or something.  I'm trying to understand exactly 
 what I can grab from a .Net application.

There's a great, simple example right here that should make things clear:
http://tutorial11.learncf.com/

 A layman's explanation would be so appreciated.  My boss, who 
 is a director of Marketing has talked about switching to .Net 
 because it what some Web agencies are saying we should be using. 

Are these web agencies going to do your development for you? I suppose they
would probably like to.

Your director of marketing makes technical decisions about infrastructure?
Based on what some web agencies tell him? It sounds like you live in a
Dilbert strip, or, alternatively, hell. As a partner at a web agency
myself (whatever that is exactly) I would be happy to tell your boss that he
should put down the crack pipe if he thinks it's a good idea to switch from
CF to .NET.

For what it's worth, it's almost never a good idea to switch from CF to
.NET, or vice-versa, if you have any significant investment in application
code. Anyone who tells you otherwise is just angling for your money.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information! 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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


Neo-query.xml in ColdFusion 8?

2007-10-02 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Hi.  We just installed CF8 on a brand new Win2003 server.  This server will be 
replacing another Win2003 server which was running CF7.  

I just copied the neo-query.xml file from the old server to the new server and 
restarted the CF services, but the CF admininstrator on the new server still 
isn't showing me the old data sources.  I remember last time we moved from one 
server to another that was all I needed to do, though I don't remember what 
version we were running back then

Does it work differently in CF8?  Is there something else I need to do to 
import the data source list? 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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


Re: Any experienced FarCry users out there?

2007-10-02 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Scott,


We have been working with FC since its first release and have many dozens of 
site's from small sites to portal's running it.  We also do heavy 
customizations with it.  Feel free to contact me mjs AT foureyes DOT com 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

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


Re: Neo-query.xml in ColdFusion 8?

2007-10-02 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Thanks for the info, everyone.  I have succesfully imported the data source 
list.

Yes, That's correct.

Copying neo-query.xml from CF7 to CF8 will not do now. That file has
been split into two files now as mentioned by Andy. This information is
also provided in the Documentation and Release Notes. In What's new and
different section .

You can consider making a CAR file for all your Datasources and other
Admin settings too for migrating.

Thanks  Regards,
Jayesh Viradiya
Adobe CF Team


I think CF8 now uses neo-datasource.xml and neo-drivers.xml

Andy

On 02/10/2007, [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED]
wrote:
 Hi.  We just installed CF8 on a brand new Win2003 server.  This server
will be replacing another Win2003 server which was running CF7.

 I just copied the neo-query.xml file from the old server to the new
server and restarted the CF services, but the CF admininstrator on the
new server still isn't showing me the old data sources.  I remember last
time we moved from one server to another that was all I needed to do,
though I don't remember what version we were running back then

 Does it work differently in CF8?  Is there something else I need to do
to import the data source list?

 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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


Infinite Structure Looping

2007-09-25 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Hello, 

I'm trying to set up a structure based on unique values in a flat SQL database 
with unique id's.  And then output values in the structure in a hierarchy kind 
of like:

1
|
 2  3  9
|
4  5  6
   |
   7  8


I believe can loop through and exhaust all the values based on a lookup list of 
what structure has been outputted.  But I'm having a problem thinking about the 
natural flow of the output and joining up the parent with children in the 
hierarchy.  

Is this possible or very easy?  I'm basically wanting a cfdump type output that 
I can manipulate the HTML/javascript.  The below code is how I want to set up 
the structure.  Any thoughts would be great.

cffunction name=maketextform access=public
cfargument name=id required=Yes type=numeric
cfargument name=value required=no default=
cfargument name=js required=no default=
cfset this.id = arguments.id
cfset this.value = arguments.value
cfset this.js = arguments.js
cfset  starttag = 'input type=text id = #this.id# 
value=#this.value# onclick=#this.js#'
cfreturn starttag
/cffunction

cfparam name=datacontainer default=#arraynew(1)#
   
cfset container = structnew()
cfset tmp = arrayappend(datacontainer,container)
cfset aid = arraylen(datacontainer)
cfset datacontainer[aid].container.name = IP
cfset scontainer1 = structnew() 
cfset datacontainer[aid].container.1 = scontainer1
cfset datacontainer[aid].container.1.id = 1
cfset datacontainer[aid].container.1.value = I could grab this from a 
structure from query2structure ripper 1
cfset datacontainer[aid].container.1.name = 'Matter'
cfset datacontainer[aid].container.1.js= alert('dog')
cfset datacontainer[aid].container.1.field = 
#maketextform(datacontainer[aid].container.1.id,datacontainer[aid].container.1.value,datacontainer[aid].container.1.js)#

cfset scontainer2 = structnew() 
cfset datacontainer[aid].container.1.2 = scontainer2
cfset datacontainer[aid].container.1.2.id = 2
cfset datacontainer[aid].container.1.2.value = I could grab this from a 
structure from query2structure ripper 2
cfset datacontainer[aid].container.1.2.name = 'Matter'
cfset datacontainer[aid].container.1.2.js= alert('dog')
cfset datacontainer[aid].container.1.2.field = 
#maketextform(datacontainer[aid].container.1.2.id,datacontainer[aid].container.1.2.value,datacontainer[aid].container.1.2.js)#


cfset scontainer3 = structnew() 
cfset datacontainer[aid].container.1.2.3 = scontainer3
cfset datacontainer[aid].container.1.2.3.id = 3
cfset datacontainer[aid].container.1.2.3.value = I could grab this from a 
structure from query2structure ripper 3
cfset datacontainer[aid].container.1.2.3.name = 'Matter'
cfset datacontainer[aid].container.1.2.3.js= alert('dog')
cfset datacontainer[aid].container.1.2.3.field = 
#maketextform(datacontainer[aid].container.1.2.3.id,datacontainer[aid].container.1.2.3.value,datacontainer[aid].container.1.2.3.js)#

cfset scontainer5 = structnew() 
cfset datacontainer[aid].container.1.2.5 = scontainer5
cfset datacontainer[aid].container.1.2.5.id = 5
cfset datacontainer[aid].container.1.2.5.value = I could grab this from a 
structure from query2structure ripper 5
cfset datacontainer[aid].container.1.2.5.name = 'Matter'
cfset datacontainer[aid].container.1.2.5.js= alert('dog')
cfset datacontainer[aid].container.1.2.5.field = 
#maketextform(datacontainer[aid].container.1.2.5.id,datacontainer[aid].container.1.2.5.value,datacontainer[aid].container.1.2.5.js)#

cfset scontainer4 = structnew() 
cfset datacontainer[aid].container.1.4 = scontainer4
cfset datacontainer[aid].container.1.4.id = 4
cfset datacontainer[aid].container.1.4.value = I could grab this from a 
structure from query2structure ripper 4
cfset datacontainer[aid].container.1.4.name = 'Matter'
cfset datacontainer[aid].container.1.4.js= alert('dog')
cfset datacontainer[aid].container.1.4.field = 
#maketextform(datacontainer[aid].container.1.4.id,datacontainer[aid].container.1.4.value,datacontainer[aid].container.1.4.js)#
  
 
cfdump var=#datacontainer#

Thanks! 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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


Re: Scope Question

2007-09-19 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Maybe..

cfset x = listfirst(cgi.query_string, ,)
cfset y = listlast(cgi.query_string, ,)

Hope this helps,

William


Wow!  Thanks everyone for the great responses.  I ended up using ...
RIGHT:cfoutput#ListFirst(CGI.QUERY_STRING)#/cfoutputbr /
DOWN:cfoutput#ListLast(CGI.QUERY_STRING)#/cfoutputbr /

In case this may help anyone, I'm using this to fit uploaded images
into a frame that will be imported into a Flash movie via XML.  The
Flash movie is a product package that allows the user to add their
child's photo to the package. 

My question and everyone's answers help me to create the process and
then the algorythm to center the uploaded image, zoom in or out and then
perform the final cropping to have it fit within a pre-determined frame.
(height and width)  

Thanks.

D 

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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


Re: Spry: Two Forms on one page, validation tiggers on both

2007-09-13 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Sorry, I didn't review my enough, I was missing a top form tag, don't know how 
that happened. 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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


Re: CF8 HTML CFGRID with checkbox possible with binding? +Error Message

2007-09-06 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I am working on the same thing right now.  I have success getting the checkbox 
to show up. That much is no problem.  The way I am doing it is by using 
QueryNew/QuerySetCell to create a query that I send back to the CFGRID via 
binding to a CFC.  Here is how I am creating my checkbox:

CFSET QuerySetCell(searchResults, test,Complete: input type=checkbox 
name=install_complete_date value=#dateformat(now(),mm/dd/)#  
onClick=form.submit();)

I want to set it up so that when the checkbox is checked, the form is submitted 
automatically.  Unfortunately, when the checkbox is checked, the form does 
submit, but I am getting a mysterious Error: The submitted cfgrid form field is 
corrupt (name: __CFGRID__CFFORM_1__FIRSTGRID value: __CFGRID__COLUMN__=ROW; 
__CFGRID__DATA__=5; ... I have no idea what this is about or why its happening. 
 Anyone have any guesses? 

I think I have alot to learn about CFGRID.

Thank you.

I did get the checkbox to showup, however, it initally shows a true or 
false in the column rather than a checkbox.  Upon clicking the cell 
three times, a checkbox finally appears, and can then be changed using 
ajax/cfc.

I ended up doing a flash grid...i think this may be a bug with HTML 
bound grids. 

Chris Martin



Shy Boy wrote:
 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


CFGrid Ajax Results

2007-09-04 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Hello,

I am wondering if someone could clear something up for me.  I am working on a 
datagrid using CFGRID in HTML format.  I would like to be able to manipulate 
the data a little bit before throwing it into the grid.  Two examples are that 
I want CITY AND STATE to be in one column, and I want to be able to have one of 
the columns link to a URL that has two dynamic variables in it, rather than 
just one like you could do with using HREFKEY. (The linked URL would be 
something like: 
http://www.mydomain.com/results.cfm?customer_id=#x#order_id=#y#).  

So the question I have is what is the best way to handle these two things?  I 
started out working with just a CFQUERY on the same template page as the 
CFGRID, but now I've realized that I would probably want to do a CFC instead.  
The question is, what format do I send back the data with?  So far the only 
thing I could come up with that works, but is slow, is to do the initial query, 
then CFLOOP through the data.  While looping, format the data and put it into a 
new query using QuerySetCell/QueryAddRow.  It seems clunky and again, it is 
slow.  Is their any other way, like could I just return a structure or 
something like that?

Any help is appreciated. 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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


Re: Strange Redirect Behavior - running out of things to try

2007-08-29 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Great advice Dave.  Like you idea. I just trying to do one other thing if 
anyone can check my syntax.  I'm trying to open a window once the user clicks, 
plus redirect the page that the user clicks on to open the window. (parent).

I've got ..

a href=JavaScript:; 
onClick=MM_openBrWindow('http://www.domainname.com/Coupon/install2.cfm?ID=CFOUTPUT#ID#/CFOUTPUT;
 ','print','width=1,height=1')Install Now/a

Could I add a MouseDown to this a href like ... (syntax?)

a href=JavaScript:; 
onMouseDown=document.location.href=http://www.domainname.com;; 
onClick=MM_openBrWindow('http://www.domainname.com/Coupon/install2.cfm?ID=CFOUTPUT#ID#/CFOUTPUT;
 ','print','width=1,height=1')Install Now/a



 So this install page performs a task that I don't want people 
 + CFOUTPUT#ID#/CFOUTPUT);

I think that, if your goal is to prevent people from printing out a coupon
multiple times, don't put it on a web server. This would be very easy to
circumvent no matter what you do, with CF or JavaScript. For example, a user
could simply set his default printer to PDF, like mine already is.

That said, I can think of a couple of measures you could use. First, you
could include a barcode in your coupon, and provide information within the
barcode to prevent reuse of multiple printings. This is how online tickets
are handled; Ticketmaster is one example. Second, you could present the
ticket in a separate window, opened through JavaScript; this window could
present no browser controls, and could close when complete. This would make
it more difficult (though not impossible) to reprint the coupon. Within the
opening page, you could determine whether the child window has been opened
once already, to prevent it from being reopened. Of course, this approach
requires the use of a popup window, so it may be defeated by aggressive
popup blockers.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information! 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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


CFGrid on CF 7

2007-08-27 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I am using ColdFusion 7 version 7,0,2,142559.  I am trying to work with CFGrid. 
 My first issue is that I wanted to use the HREF= feature, but it doesn't seem 
to work at all.  I started looking around at sites like ASFusion.com and there 
I learned about some nifty tricks that I am supposed to be able to do if I have 
the CF 7.01 updater.  As you can see from above, I am using a later version 
than that, but yet, I can't seem to use certain scripting features.  I'd like 
to be able to link cells and to have a cell take up multiple lines.

Thanks for any help shedding some light on this. 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287170
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 way to Prevent back button

2007-08-27 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
JJ,  How do you do it at the IIS level?  I asked my Web hosting provider to 
help and they have no idea how to do it.  Thanks.

We do it at the webserver level. IIS and Apache has the ability to
expire pages so that when they hit the back button they get an error
from the browser saying that page has expired.

J.J.

On 8/27/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287188
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 way to Prevent back button

2007-08-27 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I think I found it.  Thought I would post it for anyone else that may need it.

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/0fc16fe7-be45-4033-a5aa-d7fda3c993ff.mspx?mfr=true

Thaks JJ.

We do it at the webserver level. IIS and Apache has the ability to
expire pages so that when they hit the back button they get an error
from the browser saying that page has expired.

J.J.

On 8/27/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


Re: amp;lt;CFExchangeMail action=amp;quot;getattachmentsamp;quot;amp;gt; - MSX error code 501

2007-08-22 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Actually, we are using Exchange 2000.  Working on upgrading to Exchange 2005 at 
some point soon.

thanks
Reed

 I checked with Ram, and we suspect that you are using Exchange 2007. 
 getAttachments with 'attachmentPath' attribute would not work on 
 Exchange 2007.
 
 Hemant 


~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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


CFExchangeMail action=getattachments - MSX error code 501

2007-08-21 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Am having problems getting attachments from Exchange inbox emails.  I can get 
the list of items in teh inbox with no problems, but when I then loop over that 
query to do an ACTION=GetAttachments CF throws an error:
   ERROR PERFORMING THE ACTION.  EXCHANGE ERROR CODE : 501
I've googled the error code and cannot come up with anything other than 
ActiveSync errors for that code.

Has anyone seen anything like this?  Here is my code (pretty simple):

cfexchangeconnection action = open connection = exchangeConnection 
protocol = https server = #msxserver# 
username = #msxuser# password = #msxpassword# / 

cfexchangemail action = get name = google connection = 
exchangeConnection /
cfdump var=#google#

cfloop query=google
HR
HAS ATTACHMENT=#google.hasattachment#  UID=#google.uid#
cfif google.HasAttachment IS yes
cfexchangemail action=getattachments
connection=exchangeConnection 
uid=#google.UID#
name=attachInfo
attachmentPath=C:\temp\Googleattachments
generateUniqueFilenames=true
BR
cfdump var=#attachinfo#
/cfif
/cfloop

cfexchangeconnection action = close connection = exchangeConnection / 



I'm baffled!
Thanks,
Reed


~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

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


Re: lt;CFExchangeMail action=quot;getattachmentsquot;gt; - MSX error code 501

2007-08-21 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
For grins and giggles I changed the HTTPS to be HTTP.  I still get the list of 
email messages back, but now the error when I try to get the first message's 
attachments has changed to:

Requested Exchange resource was not found on the server 

The LiveDocs for this tag have errors and inconsistencies in syntax, making 
this just a bit more fun to figure out. 

Do the Exchange UIDs actually include the  at the beginning and end, or am I 
supposed to strip them off (just grasping here...)?

thx,
Reed 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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


Re: New 2 CFFEED - simple example - throwing error

2007-08-15 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Thank Ray,

All,  I'm not exactly how to read my cfdump and how to extract the data from 
each
element in the struct.  Can anyone give me a few more exmaples based on this 
example?

http://h129823.cf8beta.com/cf8/cffeed.cfm

There are multiple stores in the feed, how do I display each of these?

THanks

D

CFDUMP is your friend. If you dump myProps, you will see myprops.title
is a struct. You want myprops.title.value.

On 8/14/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
-- 
===
Raymond Camden, Camden Media

Email: [EMAIL PROTECTED]
Blog  : www.coldfusionjedi.com
AOL IM : cfjedimaster

Keep up to date with the community: http://www.coldfusionbloggers.org 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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


Re: Scrape pages from RSS Feed

2007-08-15 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Ok Found it. It was one of Ray Camden's creations.  Does this guy ever sleep? 
8-)

Now that I've got this XML feed written to a file on my filesystem, I want to
go through this XML file and parse out some of the details and maybe insert 
some of the data into a db table. What are some of the cf tags that would help 
me do this?

Thanks

D

I know there is an rss.cfc out there somewhere that you could probably use
to get this data.  Unfortunately, I don't know where it is.

_ 

Jake Churchill 
CF Webtools 
11204 Davenport, Ste. 200b 
Omaha, NE  68154 
http://www.cfwebtools.com 
402-408-3733 x103 


Anyone every come across an article that describes how to scrape links from
an
RSS Feed and then scrape just the text of a story from that link?

Thanks 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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


Re: Trouble Downloading CF8 Dev Ed

2007-08-07 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Awesome!  That did the trick! Strange.

Try to create a new Adobe login to download.

http://demirkapi.net/avblog/permalinks/2007/07/30/ColdFusion%2D8%2DDownload%2DProblem/


[EMAIL PROTECTED] wrote: 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


Re: Railo and CF8 speed contest

2007-08-03 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I just posted this back on David's Blog, but I'll post here as well, for ayone 
interested

==
Hi David, 

Thanks for the information. Here's what we found in testing here at Adobe.

OVERVIEW: In all load tests here, we see ColdFusion 8 outperform Railo 
everytime.

Testing Scenarios:
All tests were run with 100 Virtual users on Windows 2003 Sp2 Server with dual 
3.60GHz CPU's and 2GB RAM.

Because we do not support TomCat running on Beta virtualization software ( 
Apple Bootcamp ) the following tests were run on a fully supported server 
platform. 

The following tests mirror some of the tests that were posted on your blog.

Test 1. Simple CFM page outputting a string.

CF 8: Requests per Second: 800.94
Railo: Requests per Second: 721.22

Test 2: Simple MySQL query returning 241 records.

CF 8: Requests per Second: 279.15
Railo: Requests per Second: 187.22

Test 3: Simple page with 5 cfincludes:

CF 8: Requests per Second: 633.33
Railo: Requests per Second: 631.43

I'm not sure why in your testing you are seeing CF 8 take one second longer for 
queries to MySQL. Railo ships with an older MySQL driver ( MySQL Connector/J 
3.0.1 ). CF 8 ships with MySQL Connector 5.0.5. In our testing, CF 8 and the 
newer driver were substantially faster when running queries.


Regards,

Damon Cooper
Adobe Systems.



~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

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


Re: AW: Email Blasts - detecting bouncebacks

2007-08-02 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
You can just set the reply-too email to a pop mailbox that CF checks for bounce 
messages.  Put a unique key into each message so you can track it. =) 



Chris Peterson
Gainey IT
Adobe Certified Advanced Coldfusion Developer

i'm creating a bounce-manager too...


 If anyone wants a copy of the fail/ignore string lists, let 
 me know and I'll send it off-list.
 
 
 -Justin Scott

that would be helpful to me, can you send me the list? 
if needed, i will be able to provide you a similar list in other languages
(probably F-D-I) in a few weeks



 We use boogietools and have found it to be relatively easy to 
 work with (for .net anyway)... much more robust than the code 
 we original created to parse bounced emails.
  Mark


 Here is one pretty intriguing tool to manage this stuff:
 http://www.boogietools.com/products/
 
 I haven't used it myself, but have heard good things, and it 
 looks like it's pretty comprehensive. Looking through the 
 feature list should also give you a clearer picture about 
 what you can do with e-mail bounces, the various types, etc.

i also tried to use the boogie-tool (for CF) but encountred some problems to
initialize the com obj on my multiCF win2k3 server, even recompiled as
javaobj, so i'm developing a tool using an opensource cfc to access the
mailbox via imap

the rest is similar to the other solutions... parse mailbody to get
emailaddress, 'error codes' and 'forbidden words'... delete... forward...
etc...


Tak 

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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


DWMX 2004 - Whats new for us?

2003-08-27 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
At this point I am really getting ticked with MACR. I paided for Studio MX when it 
came out, I even paid for the DevNet Essentials at their cut rate price of $199. But 
now after going through what they posted as new features to DWMX 2004, I think MACR 
is just out to screw the independent developer.

- Right Click Coder Tools --- DRK 4

- CFML Function reference --- DRK 3 or free from http://mythic.com/code/coldfusion/

- Better SQL Query Builder --- DRK 4

- ASP.NET Reference -- DRK 3

- PHP Reference --- DRK 3

- SQL Reference --- DRK 2

- ASP.NET Form Controls --- DRK 3

MACR finally put better CSS support and SFTP, but really can ANYONE tell me why I 
should pay for the extentions again?

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm