Re: Can you use a CFTHREAD inside an Ajax routine?

2015-03-16 Thread John Pullam

The original answer that this does work was enough to get me headed in the 
right direction. I eventually found a bug in my code; the CFTHREAD was starting 
up the task correctly. 

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


Can you use a CFTHREAD inside an Ajax routine?

2015-03-05 Thread John Pullam

It seems to me that the CFTHREAD I attempt to start from inside an Ajax routine 
(triggered by a CFWINDOW) never runs and doesn't generate any error message. 
Can anyone advise if this is a legitimate thing to do? 

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


Re: Cannot access session variables in a cfc

2015-01-29 Thread John Pullam

For what it's worth, the approach of storing a global data item in the 
application scope seems to be legit according to the documentation. Here's what 
it said in the CF10 doc:

Application variables are a convenient place to store information that all 
pages of your application might need, no matter which client is running that 
application. Using application variables, an application could, for example, 
initialize itself when the first user accesses any page of that application. 
This information can then remain available indefinitely, thereby avoiding the 
overhead of repeated initialization.

Because the data stored in application variables is available to all pages of 
an application, and remains available until a specific period of inactivity 
passes or the ColdFusion server shuts down, application variables are 
convenient for application-global, persistent data.

However, because all clients running an application see the same set of 
application variables, these variables are not appropriate for client-specific 
or session-specific information. To target variables for specific clients, use 
client or session variables. 

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


Re: Cannot access session variables in a cfc

2015-01-28 Thread John Pullam

You will need to pass your session variables as a parameter in order to use
them in the CFC, this is best practices anyways.

The difficulty is that there a lot of cfc calls and some of them are in bind 
expressions so the chance of making errors is high. That's why I am so anxious 
to find one that doesn't make me change a lot of programming. Long term I will 
opt for a better solution.

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


Cannot access session variables in a cfc

2015-01-28 Thread John Pullam

My app is running in a CF10 system and since I moved my cfc's out of the 
document root, they are losing access to the session variables. It seems that 
they work for around a day and then can no longer be found. I initialize them 
in my application.cfm to a value and I can still cfdump them in a regular web 
page, but the cfc fails with the error Element XXX is undefined in SESSION.

Is this normal behaviour? If it is, then what is the alternative method of 
passing a variable into the cfc (other than making it a parameter when 
calling)? 

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


Re: Cannot access session variables in a cfc

2015-01-28 Thread John Pullam

If you moved your cfc's above the application.cfc (or application.cfm) file,
the session variables will not be accessible. Session and application vars
are accessible from the application file down. 

That's what we did.

What other method than session variables can I use to pass a common variable 
that won't require me to include it as a parameter of every calling routine? 

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


Re: Cannot access session variables in a cfc

2015-01-28 Thread John Pullam

Thanx. That's what I think I will do for the time being.

It is hard for me to come up with all the symptoms that we started seeing on 
the cfc's now and I don't think I could do justice to any explanation of those 
issues. It seemed to me that it was all quite normal stuff. All pages and cfc's 
were in the same doc root. And I have had issues with cfc locations on my test 
system because it gets confused with localhost and virtual directories, so 
getting the cfc's into a separate folder had a certain appeal.

I'm planning to do a big refresh on the app over the summer and this is going 
to be addressed then. In the meantime, I have my fingers crossed than an 
application scoped variable will get us through.

Thanx again. 

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


Re: Cannot access session variables in a cfc

2015-01-28 Thread John Pullam

I know this isn't ideal, but it is a live application and the decision to move 
the cfc's outside of the doc root was taken because CF was having trouble 
finding them (for no obvious reason). Code that has worked since CF7 started 
breaking.

So we moved them and this problem began. 

I am looking for a quick solution for now, knowing that I need to develop a 
better one.

I'm wondering about putting the variable in the Application scope? Do the cfc's 
have access to that? 

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


Re: CF10 creating extra CFID/CFTOKEN cookies at the domain level

2014-10-20 Thread John Pullam

For anyone who stumbles across this post, I thought I should add the closure as 
I now understand it.

First of all, the duplicate CFID and CFTOKEN was not the problem I thought it 
was. It confused matters, but it seems that most browsers can tolerate it, even 
though it makes no sense to me.

I eventually found that browsers were losing the CFID/CFTOKEN values and as a 
result could not locate the session variables and that is what caused the 
problem. And for the most part it happened in IE, but was not consistent. Some 
IE11 systems failed all the time while others were sporadic and some ran fine. 

I found a couple of postings that said for security reasons you should now use 
J2EE Session Variables on the ColdFusion Administrator Memory Variables page 
and that would improve security and mean that CFID/CFTOKEN were no longer used 
so I tried it. And it worked. My ISP had not set that value but as soon as they 
did, everything worked perfectly again. 

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


Re: CF10 creating extra CFID/CFTOKEN cookies at the domain level

2014-10-02 Thread John Pullam

Some more info:

- I have not issued a setclientcookies=yes so assuming that is the default it 
should be there.

- the redirect is via an htaccess file which says 

RewriteEngine On
RewriteCond %{HTTP_HOST} !^www\.
RewriteRule ^(.*)$ http://www.%{HTTP_HOST}/$1 [R=301,L]

- I think the redirect is not relevant because I am doing the testing and I am 
only using www.

- Multiple browsers have shown up with the duplicate cookies and the 
duplication seems to occur after a logon (using my own app code). I don't use 
any specific URLs ... all are relative based on the domain.

Any other thoughts on what is causing it? 

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


Re: CF10 creating extra CFID/CFTOKEN cookies at the domain level

2014-10-01 Thread John Pullam

I did what you suggested and thought that the problem had gone away. I was 
successful in getting any traffic to move to the www prefixed name but that 
didn't solve the cookie problem. I am having trouble creating the failure but I 
am still seeing duplicate cookies with the same CFID and CFTOKEN values. I 
would really like to eliminate these as I believe they are part of the problem 
I am trying to solve.

What can cause CF10 to store duplicate cookies, one under the www subdomain and 
one at the higher level?


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


CF10 creating extra CFID/CFTOKEN cookies at the domain level

2014-09-11 Thread John Pullam

I am having a problem that from time to time CF10 creates a new pair of cookies 
at the domain level, specifically whitevalegolfcub.com

The application runs under www.whitevalegolfclub.com and the CFID and CFTOKEN 
cookies are created there, along with several of my own, at logon. But this 
spontaneous creation of the additional pair at the domain level overrides the 
sub-domain cookies and hides them from my application.

I have seen some postings that sound like others have had a similar problem but 
I have not heard of a fix for CF or a programming technique to stop it from 
happening and becoming a problem.

I'd sure appreciate some input on why they are being created or on how to stop 
the problem from occurring. 

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


Re: Unable to add text to HTML HEAD tag

2014-05-09 Thread John Pullam

I appreciate the feedback received on this and some of the ensuing discussion. 

On the technical side, it was a cfajaximport tag on which it failed. But as I 
mentioned earlier, it still failed when that tag was removed. Thanx to one 
suggestion I got it to work by moving the entire cfwindow up (but still inside 
the body tag). I had already looked at all those articles that have been 
mentioned and none of them did a thing or applied to my case. But I appreciate 
the suggestions because if I hadn't done my research before posting, that would 
have given me more useful things to do.

FWIW, I have been there and done that too (been a programmer for nearly 50 
years) so I believe I'm qualified to participate in the discussion about giving 
help. My concern is that on any number of posts I read, I have found some 
responders who prefer to give technique advice rather than deal with the issue 
at hand. Yes, I know that some folks need that, but often the tone of the 
response comes across like I'm smarter than you. If the responder had the 
sensitivity to phrase their words like you may already know this, but what you 
are doing is no longer considered best practice in the industry it would be a 
lot easier to handle. But derailing a thread into a discussion of what is a 
better practice rarely helps get the issue solved in short term.

On the specific issue of the CF UI stuff, I agree that most of it is poor. I 
have wasted numerous hours myself and thrown away things like cfgrid. 
Fortunately, apart from the differences from CF8 to CF9, the cwindow code has 
been excellent in my apps so I am in no hurry to rewrite all that code. 

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


Unable to add text to HTML HEAD tag

2014-05-07 Thread John Pullam

I'm doing some testing on my new CF10 desktop system and have run into an odd 
one that I can't figure out.

This program has been running OK for several years but when I ran it in CF10 it 
generated the error message Unable to add text to HTML HEAD tag. It did this 
at the end of the page after everything else looked fine. The error line it 
contained was a cfjaxaproxy inside a CFWINDOW tag.

The detailed explanation says This is probably because you have already used a 
CFFLUSH tag in your template or buffered output is turned off. I haven't used 
a CFFLUSH and my administrator is set for 1024 buffering (the default). When I 
comment out the CFWINDOW tag it runs fine.

The CFWINDOW is this:

cfwindow name=Invoice modal=true resizable=false title=Invoice Details 
width=320 height=300 x=500 y=170
bodyStyle=font-size:12px; font-family: verdana; color: black; 
text-align: left;
headerStyle=font-size:13px; font-weight:bold; font-family:Verdana; 
background-color: ##003399; color: white; text-align:left;
cfajaximport tags=cfform, cfwindow scriptsrc=/CFIDE/scripts
/cfwindow 

I took out the cfajaximport but the error just moved to another line number.

Any suggestions? 

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


Re: Unable to add text to HTML HEAD tag

2014-05-07 Thread John Pullam

So you suggest going back and rewriting a 50,000 line application in order to 
resolve the problem? Not a very practical solution, I'm afraid.

Does anyone have a more realistic suggestion? 

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


Re: Unable to add text to HTML HEAD tag

2014-05-07 Thread John Pullam

I don't dispute that rewriting it might be the best long term solution. And 
perhaps doing it in pieces is smart too (although I'd hate to be the person who 
had to maintain the application when it is in the middle.)

But I wasn't asking for advice on CF programming strategy, rather I was looking 
for help on one particular problem, after having spent a few hours with no 
results from searches and tests.

It annoys me (and I'm sure others) when people feel compelled to advise/lecture 
on programming techniques rather than discuss the issue. It also detracts from 
the quality of discussion because who wants to put themselves up for that 
criticism? Clearly anyone who advises me on my problem must be as dumb and 
inexperienced as I am!

I will probably get very little additional feedback on this question because of 
that response. 

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


Re: ColdFusion 10 does not allow Access datasource

2014-04-29 Thread John Pullam

At the moment I have the Access datasources working. Here is what solved it for 
me:

The underlying issue was that message that said The ColdFusion ODBC Server 
service is not running or has not been installed. I observed the behaviour of 
the ODBC server and realized that it was running fine after an install (I redid 
the CF10 instrall) but it was the next reboot that caused things to stop 
working.

I located an error message in the log that said ColdFusion 10 ODBC 
Server@LOCALHOST,ErrorCode=430,ErrorMessage=Failed to open event trace file 
because the file version is not recognised. And when I googled that one I ran 
into a similar problem on CF9 where the person reporting it said I have solved 
this problem by deleting all of the .trc files in folder 
C:\ColdFusion9\db\slserver54\tracing.  Once that was done, I was able to 
successfully start the ODBC Server  ODBC Agent services.

After deleting the .trc files from 
C:\ColdFusion10\cfusion\db\slserver54\tracing I was able to start the services 
manually. I then rebooted and it worked. I am not sure that this is a long term 
fix but it is working. I notice that the 2 .trc files are back  in that folder 
and hope thay are correct now.

And of course I had to also use that workaround mentioned here; 
http://blogs.coldfusion.com/post.cfm/coldfusion-10-64bit-and-msaccess 

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


Re: ColdFusion 10 does not allow Access datasource

2014-04-29 Thread John Pullam

Have you rebooted again just to make sure that it doesn't happen again, I
only mention this because that was what you said caused it. Just looking at
making sure this is a 100% fix.

Yes, I have rebooted once so far. And tomorrow I'll probably get my courage up 
to apply those updates that were not in the download. And each time I do 
something I will check carefully in case that is what caused the failure.

Thanx for all your help and feedback.

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


ColdFusion 10 does not allow Access datasource

2014-04-28 Thread John Pullam

I have a newly installed CF10 system working on my desktop (developer) machine, 
including several working SQL Server datasources. But when I try to get the 
Access ones to work I keep running into issues.

I installed the 32 bit version of ColdFusion in order to bypass the issues with 
64 bit drivers, but the results I get sound similar to what others have said 
already. Unfortunately the suggestions and fixes in those postings don't seem 
to help in my case. Initially I thought I had this working but after a reboot, 
its behaviour changed and the Access datasources failed, so I deleted them in 
order to try again.

Now, when I attempt to add a new datasource, I get the message The ColdFusion 
ODBC Server service is not running or has not been installed. You may also use 
the MS Access with Unicode driver to connect to MS Access datasources. 

I did the obvious things such as going into services and manually starting the 
service. Also there is no Unicode driver option in the administrator.

Any ideas? 

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


Re: ColdFusion 10 does not allow Access datasource

2014-04-28 Thread John Pullam

The only option is to use the workarounds to get a 32bit ODBC DSN setup.
This also means you will have hosting problems, as Windows is 64bit only
since Server 2008, so you wont be able to setup a CF DSN unless the host is
willing to also do this workaround for you or unless they are still running
Windows 2003.

Actually I have read and tried this very workaround. And being on my desktop, I 
don't have a hoster to worry about at the moment.

But when I click on Add (step 3 in that article), I get the above message. So I 
can't even get into the workaround any more. (It seemed to work at first but 
stopped after some updates and a reboot.)


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


Re: ColdFusion 10 does not allow Access datasource

2014-04-28 Thread John Pullam

Are you able to manually create a 32-bit ODBC connection to your Access 
database?  If you weren't aware already, you need to run the 32-bit 
Windows ODBC data sources applet from inside \Windows\SysWOW64 to access 
the 32-bit stuff.  If you can do that successfully, then try connecting 
to that 32-bit ODBC data source from within CF Administrator.

If you mean can I run C:\Windows\SYSWOW64\odbcad32.exe, the answer is yes. It 
allows me to select an Access datasource and to specify the mdb file. But when 
I go back into the CF administrator I again get that error message when I try 
an add of a Microsoft Access 
file.

You said that I should try connecting it with the administrator. Does that mean 
something other than trying to add it as I have done?

I'm still unable to get past that error The ColdFusion ODBC Server service is 
not running or has not been installed. You may also use the MS Access with 
Unicode driver to connect to MS Access datasources.

Any ideas would be appreciated... 

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


Re: ColdFusion 10 does not allow Access datasource

2014-04-28 Thread John Pullam

 Is the service running?

I went into Services and the ODBC service is defined and it set up as 
automatic. When I started it, it said it started and then stopped. It indicated 
that some services only start when they are needed. I then made it manual and 
started it again and received the same message. 

So I think that it believes it is there and is able to run.

 
 You may also use the MS Access with Unicode driver to connect to 
 MS Access datasources.
 
 Have you tried this?

There is no entry for that driver in the drop-down for CF10. It seems to have 
disappeared after CF9.

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


Re: ColdFusion 10 does not allow Access datasource

2014-04-28 Thread John Pullam

This is going to sound a bit basic, but did you actually install the ODBC
drivers when you installed ColdFusion?

I have no problem with suggesting basic stuff ... I make errors like everyone 
else. But the fact that the ColdFusion 10 ODBC Server is in Services should 
suggest that it is actually there.


Just out of curiosity, I know you mentioned the reason behind this in
another thread, but is there any chance that this maybe the time to just
bite the bullet and export the data into a SQL DB?

My application receives its Access databases from an external 3rd party 
application which I cannot change. I can't think of any practical way to avoid 
using them. 

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


Re: ColdFusion 10 does not allow Access datasource

2014-04-28 Thread John Pullam

As with anything it is a process of elimination, what about the other
suggestion it says. I don't recall if you tried that or not.

The other suggestion was the Microsoft Access driver with Unicode. There is no 
such driver being offered in the driver list (there was in CF9 but it is no 
longer there in CF10). 

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


Re: ColdFusion 10 install fails with code 0x800700c1

2014-04-25 Thread John Pullam

I started the CF10 Web Server Configuration Tool and it showed one connector 
which seemed to be for IIS and all websites. As suggested, I deleted it.

Then I added a connector, specifying localhost, IIS and all websites. The 
resulting connector looked very much like the one that was there before (to my 
untrained eye).

I then tried to start the CF10 administrator and got the same result as 
before... Server 500 with a code of 0x800700c1

I really don't know what to do next. Please do not suggest dropping IIS as 
everything worked great in CF9 and I don't want to make that change right now.

Your help is appreciated. 

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


Re: ColdFusion 10 install fails with code 0x800700c1

2014-04-25 Thread John Pullam

I'm happy to update the IIS config but I couldn't find the parameter to change. 
I googled for IIS and connector but that didn't help.

I looked into the handler mappings and .cfm shows as being mapped to 
C:\ColdFusion10\config\wsconfig\1\isapi_redirect.dll which I think is right.

BTW, this is IIS 7.5 

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


Re: ColdFusion 10 install fails with code 0x800700c1

2014-04-25 Thread John Pullam

For what it's worth (and for anyone in the future who reads this), I concluded 
that those IIS config files were fairly large and beyond my capability to 
understand/edit them.

So I decided to uninstall CF10 64 bit and try the 32 bit version, seeing as 
that shouldn't have any impact on my development system (and it might be a 64 
bit issue).

And surprise, it installed and worked. So I am now going through the next level 
of issues and hope to be back on the air before too long.

Thanx for the ideas and advice. 

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


ColdFusion 10 configuration wizard doesn't start

2014-04-24 Thread John Pullam

I have just installed CF10 on my development machine. I have been happily 
running CF9 for several years and decided it was time to move on. The actual 
install seemed to go smoothly but at the end when it tells you it is going to 
the configuration wizard nothing happens. It simply serves up a blank page from 
the URL http://127.0.0.1/CFIDE/administrator/index.cfm 

The CF9 pages continue to run fine but any attempt to pull up the administrator 
fails (being the same URL).

I tried this twice. The first time it failed with the URL bringing up the CF9 
administrator, the second time it brings up the blank page.

I looked in the event log and at my started tasks to see if I could find a clue 
but nothing appeared. Could sure use some ideas of what to do! 

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


Re: ColdFusion 10 configuration wizard doesn't start

2014-04-24 Thread John Pullam

I'm not trying to run CF9 at all. I never ran across an option to set the port 
for CF10. Did I miss something? 

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


Re: ColdFusion 10 configuration wizard doesn't start

2014-04-24 Thread John Pullam

CF9 refuses to stop. Even after a reboot and the first thing I did was go into 
services and clicked on stop. I noticed that each version has a tool in the 
program folder called web server configuration tool and when I ran it for each 
version (thinking I might use it to alter what port it was listening on), each 
tool suggested that IIS was set for all requests. So I guess I have a conflict.

Perhaps I need to uninstall both and then reinstall CF10. I had hoped that by 
installing CF10 when CF9 was already there, it would be able to migrate some 
useful things and might give me the option of taking over all CF requests by 
CF10. But no luck.

Any other ideas? 

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


Re: ColdFusion 10 configuration wizard doesn't start

2014-04-24 Thread John Pullam

I appreciate the help. I am primarily a CF application guy but I usually have 
enough Windows skills to keep things working OK on my development desktop 
machine. (I've done CF6 onwards and kept it going on my desktop.) I am unclear 
on connectors and don't believe that I saw or answered any questions about 
them. I was looking for options/questions that would allow me to distinguish 
between the 2 versions but saw very little.

I am sorry but it looks like I am over my head. I'll just uninstall both and 
try again.

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


ColdFusion 10 install fails with code 0x800700c1

2014-04-24 Thread John Pullam

Sorry to post a second install problem ... I'm feeling like a real dummy today.

I just cleaned out my CF9 development install that had run well for several 
years and did a clean CF10 install. I'm running windows 64 bit and did a 64 bit 
CF install. It looked good and asked all the expected questions.

But when it attempted to call up the configuration wizard at URL 
http://127.0.0.1/CFIDE/administrator/index.cfm it failed with server error 500 
and code 0x800700c1

I've googled around to see if others have seen this but the cases I've run 
across aren't that close yet. 

Suggestions would be appreciated ... 

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


Re: ColdFusion 10 install fails with code 0x800700c1

2014-04-24 Thread John Pullam

Yes, I was able to get CF to issue an error message after enabling that server 
and inserting the port in the URL. So I guess that means it is an IIS issue.

Can you suggest a next step... 

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


Re: ColdFusion 10 install fails with code 0x800700c1

2014-04-24 Thread John Pullam

No I didn't. How do I uninstall a connector? (Given that I don't really 
understand what a connector is.)

I read a post of yours elsewhere also suggesting using the bultin web server. 
My rationale for staying with IIS is that I want to test on a system very 
similar to what it will be deployed on. I also have a Microsoft Access app to 
test eventually and I need to confirm that the app works in this environment 
before the ISP cuts it over.

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


Re: ColdFusion 10 install fails with code 0x800700c1

2014-04-24 Thread John Pullam

Dave, you indicated that I should have uninstalled the CF9 connectors before 
starting the install. Given that I didn't and that I no longer have a CF9 
system, how would I go about removing them? Do I now need to re-install CF9, 
remove the connector and then uninstall it? I hope not. I can't see any 
evidence of CF9 files kicking around but it may be that IIS is trying to send 
the cfm page request to the wrong place.

Please let's not get into a discussion about Microsoft Access. I am very aware 
that it is obsolete and should not be used, but I have a legacy app that 
produces Access databases that I am stuck with for now. All my new development 
is SQL Server. 

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


Re: Need to wait on Bind to complete before submitting a CFFORM

2013-01-21 Thread John Pullam

I played around with several alternatives and eventually concluded that the 
cleanest solution was to use a single hidden variable with JavaScript 
validation which went to a small JavaScript function. The function calls a cfc 
which does the database look-up and returns true or false. 

This should work on future releases and is not dependent on the js framework 
(which has been known to change). 

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


Need to wait on Bind to complete before submitting a CFFORM

2013-01-20 Thread John Pullam

I have a situation where a CFDIV bind expression needs to complete before the 
cfform click takes effect. My assumption was that the Bind could set a hidden 
variable that would trigger a CFINPUT error routine when the cfform's button 
was pressed. But it turns out that the variable doe not update in time for this 
to work.

Is there any way to tell the submit button to wait for the CFDIV bind to 
complete?

Here's a code fragment to show what I was trying to do.

cfinput name=Password type=password tabindex=12 value=#DefPassword# 
size=20 required=yes message=Please enter your Password

cfdiv style=float:right; width: 100px; ID=Userdiv 

bind=url:CheckLogon2.cfm?Email={Email}Userid={Userid}Password={Password} 
bindonload=Nonbsp;/cfdiv

cfinput type=hidden value=1 range=1,1 message=This Password is not 
valid for the Email Address or Userid you entered name=LogonError1 
id=LogonError1

cfinput name=Logon type=submit tabindex=13 value=Logon class=Button

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


Re: Need to wait on Bind to complete before submitting a CFFORM

2013-01-20 Thread John Pullam

Have the form call a custom function onsubmit and check the values in your
form fields before it allows form submission.

I'm probably missing something here but I need to lookup data in a database 
after the email address and password are provided. I was using a cfc behind the 
scenes to do that when the bind was triggered and then updating the on-page 
variable. 

How might I do that from the submit button? I'm really hoping to be able to 
post any bad email/password error message in a javascript window alert and not 
do it on a new page. 

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


Re: Need to wait on Bind to complete before submitting a CFFORM

2013-01-20 Thread John Pullam

Why don't you use a javascript submit interception, then the Javascript
could check the results returned in the div  and allow the submit or not?


I think that solution has the same problem. Because the bind is asynchronous, 
it doesn't necessarily finish execution when you are in the submit logic. I 
found from testing it out and issuing javascript alert messages that usually 
the submit fires before the bind runs. 

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


How do I code French accents in a CFMail (HTML format) ?

2012-10-30 Thread John Pullam

I have a bilingual website and on the French side I need to send out a standard 
email that includes some accented characters. I have tried several techniques, 
including using the HTML notation (e.g., eacute;) and just letting the 
characters be imbedded in the body, but it doesn't look right when received. 

I have tried it with charset=ISO-8859-1 and with utf-8. No difference.

How should I be doing this?


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


Re: How do I code French accents in a CFMail (HTML format) ?

2012-10-30 Thread John Pullam

I discovered that I had not properly coded the type=HTML on the cfmail. When 
I corrected that and used the b; notation it seems to work. Thanks for the 
tip but it turned out that I didn't need it.

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


Struggling to code accents into a cfinput regex pattern

2012-10-01 Thread John Pullam

I am still trying to code a regex pattern for my cfinput that accepts the usual 
accented characters you find in languages such as French. I need something that 
allows people to enter their names when they contain accented characters. I 
realize that names can be even broader than this but I am quite happy to 
include all of the traditional alphabet, blanks, quotes, hyphens and accented 
characters. What I would like to code is this: pattern=^[a-zA-ZÀ-ÿ'\-\ 
]{1,50}$

But it seems that when I insert the little piece À-ÿ it fails inside the 
ColdFusion javascript.

Is there some way I can code this in my cfinput pattern so that the regex does 
accept that range of accented characters?

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


Re: Struggling to code accents into a cfinput regex pattern

2012-10-01 Thread John Pullam

I think I just answered my own question from another post I read. I am now 
using this

pattern=^[a-zA-Z\u00E0-\u00FC'\-\ ]{1,50}$

and it seems to do the job. 

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


Re: How do you allow accented characters in a cfinput regex?

2012-09-18 Thread John Pullam

OK, I think I tried what you suggested--here is exactly what I did:

Added this to the page: cfprocessingdirective pageencoding=utf-8

Made the cfinput: cfinput type=text name=FName required=yes  size=30   
  validate=regex pattern=[:alpha:]  message=Please enter a valid First 
Name

This now allows nearly anything in the field, including characters that are not 
valid in names, such as $ or slash. It also leaves out the {2,50} length spec. 

So it doesn't seem to do what I need. 

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


Re: How do you allow accented characters in a cfinput regex?

2012-09-17 Thread John Pullam

Did you try setlocale on the string as per previous example?


Sorry but I'm not clear on how I would use that, so please help me understand. 
For background information, this is a form field coming in to a CFFORM that I 
am checking with CFINPUT regex validation.  I don't want to force someone to 
use a character set for a different country, I just want my string to be 
checked for accented characters. 

Do I need a setlocale to do that? If yes, what would I do with it? What locale 
would I use to accept all types of accented characters? 

This is obviously over my head. Sorry ... 

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


Re: How do you allow accented characters in a cfinput regex?

2012-09-17 Thread John Pullam

did swapping [:alpha:] for \w in the regex expression work or not? if not, 
what 
version of cf?

No, it started rejecting all names when I did that. I am running CF9. 

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


How do you allow accented characters in a cfinput regex?

2012-09-16 Thread John Pullam

I've read a whole bunch and tried many things but I can't seem to get my regex 
pattern to allow accented characters, which will occur in people's names. My 
cfinput currently looks like this:

cfinput type=text name=FName required=yes  size=30 validate=regex 
pattern=^[\w'\-\ ]{2,50}$ message=Please enter a valid First Name

It is fine on non-accented names like John or hyphenated names but as soon as I 
enter a name with accents, it posts an error. For example, Agnès. 

I've played with other versions including :alpha: and [A-Za-zÀ-ÿ'\-\ ] but 
nothing seems to work correctly.

Sure would appreciate some help on this ... what am I missing?

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


Re: How do you allow accented characters in a cfinput regex?

2012-09-16 Thread John Pullam

Sorry I don't know how to do that. How do you put a string in unicode format?

http://www.regular-expressions.info/unicode.html
It is possible that cf regex doesn't support unicode, so you should perform
some basic tests to confirm that, plus make sure the string your testing is
in unicode format

Regards
Russ Michaels
On Sep 16, 2012 3:45 PM, John Pullam jpul...@mcleansystems.com wrote:

 

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


Re: How do you allow accented characters in a cfinput regex?

2012-09-16 Thread John Pullam

Most if the stuff in that post refer to more general regex processing, not the 
ColdFusion implementation. When I tried his syntax, CF failed with errors 
because it doesn't appear to be recognized. 

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


Re: How do you allow accented characters in a cfinput regex?

2012-09-16 Thread John Pullam

When I use this pattern=^[[:alpha:]'\-\ ]{2,50}$ nothing validates. Is that 
what you meant? 

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


Disable submit button after CFFORM validation?

2011-11-07 Thread John Pullam

I can disable a submit button using javascript 
(onclick=this.disabled=true;return true) but this occurs before the 
ColdFusion input field validation.

The problem is that if the form does not pass validation, you cannot resubmit 
it after the errors are corrected because the submit button is disabled.

Can anyone suggest a technique for disabling the button after the form has 
passed validation? (The server code that runs after gets into trouble when 
impatient users do multiple clicks.) 

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


Re: Disable submit button after CFFORM validation?

2011-11-07 Thread John Pullam

Looks like using CFINPUT with validate=submitonce solves the problem. I 
didn't know that existed! 

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


onclick to open cfwindow fails in IE8

2011-09-17 Thread John Pullam

I have a strange bug where this code works on IE9, FF, Opera, etc. but fails on 
IE8. It appears to be trying to execute the href and ignores the function that 
creates and opens the window. I realize that this may be a JavaScript issue in 
IE8 but due toe the CF involved I doubt that it will be understood on that list.

The function is defined like this:

script
function makeWin(x,y,z,num,title) {

ColdFusion.Window.create('ImageWindow'+num,title,'Image.cfm?ID='+z,{x:150,y:y+80,height:640,width:840});
}
/script

I call it from several places like this:

a href=## 
onClick=makeWin(event.pageX,event.pageY,'SeatonL.jpg',0,'Whitevale GC in 
relation to the Seaton Master Plan');return false;
img src=SeatonS.jpg style=position: absolute; left: 700px;/a

I have tried several variations such deleting the href or taking out the # 
signs but nothing changes. I even went from strict.dtd to transitional.dtd.

Any ideas on how to make this work on IE8 

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


Re: onclick to open cfwindow fails in IE8

2011-09-17 Thread John Pullam

I tried changing the function to this:

function makeWin(x,y,z,num,title) {

ColdFusion.Window.create('ImageWindow'+num,title,'Image.cfm?ID='+z,{x:150,y:y+80,height:640,width:840});
return false;
}

unfortunately it still fails to execute. 

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


Re: onclick to open cfwindow fails in IE8

2011-09-17 Thread John Pullam

I've done some further isolation and deleted a lot of extraneous code. By 
adding a hello world alert I found it it is actually executing the function. 
I ran the  debugger on IE8 and it gave me an invalid argument from ext-all.js, 
line 7 character 54203.

This seems to me to suggest an IE8 bug itself, because no other browser has 
reported a problem. 

Or is it perhaps indicating a problem that I have somewhere that can be 
rectified in my code? 

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


Re: CF9 generates Error Code 430 in event log

2011-03-21 Thread John Pullam

Actually, I'm not really looking for advice on what to do on a Win 7 freeze, 
I'm trying to determine why CF9 is generating these errors messages in the 
windows log when I reboot.

 ColdFusion 9 ODBC Agent@LOCALHOST,ErrorCode=430,ErrorMessage=Failed to 
 open event trace file because the file version is not recognised.

 ColdFusion 9 ODBC Server@LOCALHOST,ErrorCode=430,ErrorMessage=Failed 
 to open event trace file because the file version is not recognised.

Has anyone else seen these errors? Any hint about what might be happening? 

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


CF9 generates Error Code 430 in event log

2011-03-19 Thread John Pullam

I'm struggling with a problem in my Win7 system that just started today. It 
freezes on me and requires a reboot so I'm trying to get to the bottom of what 
might be causing it.

When I open the windows event log, the first error message after a boot is this:

The description for Event ID 0 from source ColdFusion 9 ODBC Agent cannot be 
found. Either the component that raises this event is not installed on your 
local computer or the installation is corrupted. You can install or repair the 
component on the local computer.

If the event originated on another computer, the display information had to be 
saved with the event.

The following information was included with the event: 

ColdFusion 9 ODBC Agent@LOCALHOST,ErrorCode=430,ErrorMessage=Failed to open 
event trace file because the file version is not recognised.

The second message is similar:

The description for Event ID 0 from source ColdFusion 9 ODBC Server cannot be 
found. Either the component that raises this event is not installed on your 
local computer or the installation is corrupted. You can install or repair the 
component on the local computer.

If the event originated on another computer, the display information had to be 
saved with the event.

The following information was included with the event: 

ColdFusion 9 ODBC Server@LOCALHOST,ErrorCode=430,ErrorMessage=Failed to open 
event trace file because the file version is not recognised.

Can anyone tell me what this mean and what I can do to eliminate it?


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


IE8 Form Submit button not being passed

2011-02-23 Thread John Pullam

I am testing my application on an IE8 system running Win 7 and CF 9. I do not 
know if any of these are relevant but the problem does not occur on Firefox or 
Chrome.

Essentially, IE is not passing the FORM.Submit to my post-back form processor. 
It passes everything else, including Submit.X and Y!!

My form is as follows:

cfform
table
trtd width=100bFirst Name/b/td
td width=500cfinput name=FirstName type=text required=No Size=20 
//td/tr
trtdbLast Name/b/td
tdcfinput name=LastName type=text required=No Size=20 //td/tr
/table
input type=hidden name=Submit2 value=any
pcfinput name=Submit type=image value=Submit 
src=../Buttons/MSearch.png //p
/cfform

When I get the postback on IE8, I use a cfdump to see what I got, and the 
FIELDNAMES for the form are: FIRSTNAME,LASTNAME,SUBMIT2,SUBMIT.X,SUBMIT.Y but 
not SUBMIT!!!

As I use this technique in other applications to capture a post-back, I'm 
rather concerned. Am I doing something wrong?


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


Image button in a cfwindow doesn't pass coordinates

2010-10-05 Thread John Pullam

Normally when you click on an image button inside a CFFORM, the coordinates are 
passed to the form processor. This is a simple way to support multiple buttons 
from a single form because you can use the presence of a coordinate to tell you 
which button was pressed.

I couldn't figure out why this wasn't working inside a CFWINDOW and eventually 
I stripped out all the extraneous code until I discovered that when the CFFORM 
is inside a CFWINDOW, it no longer passes the coordinates. Is that documented? 
Can anyone comment on that situation?

If anyone wants to play around with it, my test program is in 2 pieces below, 
the page that opens the CFWINDOW followed by the CFWINDOW code which dumps the 
FORM fields.

TestImageButton.cfm:

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01//EN 
http://www.w3.org/TR/html4/strict.dtd;
html
head
meta http-equiv=Content-Type content=text/html; charset=utf-8
titleUntitled Document/title
/head
body
pa 
href=javascript:ColdFusion.Window.show('EventUpdate');ColdFusion.navigate('TestImageButton2.cfm','EventUpdate');
 
Click here to open the window/a/p

cfwindow name=EventUpdate modal=true resizable=false title=Test 
width=550 height=550 x=500 y=150
bodyStyle=font-size:12px; font-family: verdana; background-color: 
##dcefd2; color: black; text-align: left; 
headerStyle=font-size:13px; font-weight:bold; font-family:Verdana; color: 
white; text-align:left; 
cfajaximport tags=cfform, cfwindow scriptsrc=/CFIDE/scripts
/cfwindow 

/body
/html


TestImageButton2.cfm:

cfdump var=#FORM#
cfform
cfinput name=Comment size=75 required=no /
INPUT TYPE=IMAGE NAME=Save SRC=Buttons/MSave.png
INPUT TYPE=IMAGE NAME=Delete SRC=Buttons/MDelete.png
/cfform



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


Re: Trying to set cfform focus in an Ajax window

2010-10-01 Thread John Pullam

Great, thanx for the explanation. I use firebug for CSS and errors but hadn't 
understood how the other tabs worked.

When I click on the call and then open the response tab, here is what it shows 
(I can deduce what parts of it are there for but this is a bit beyond what I 
have done before):

script type=text/javascript/* ![CDATA[ */
ColdFusion.Ajax.checkImportedTag('CFFORM');
/* ]] *//script

script type=text/javascript/* ![CDATA[ */
if (window.ColdFusion) ColdFusion.required['AccessID']=true;
/* ]] *//script

script type=text/javascript/* ![CDATA[ */
if (window.ColdFusion) ColdFusion.required['Password']=true;
/* ]] *//script

script type=text/javascript/* ![CDATA[ */
ColdFusion.Ajax.checkImportedTag('CFFORM');
/* ]] *//script
script type=text/javascript
!--
_CF_checkLoginForm = function(_CF_this)
{
//reset on submit
_CF_error_exists = false;
_CF_error_messages = new Array();
_CF_error_fields = new Object();
_CF_FirstErrorField = null;

//form element AccessID required check
if( _CF_hasValue(_CF_this['AccessID'], TEXT, false ) )
{
//form element AccessID 'RANGE' validation checks
if  (!_CF_checkrange(_CF_this['AccessID'].value, 1000.0,4999.0, 
true))
{
_CF_onError(_CF_this, AccessID, _CF_this['AccessID'].value, 
A valid Access ID is required);
_CF_error_exists = true;
}

}else {
_CF_onError(_CF_this, AccessID, _CF_this['AccessID'].value, A 
valid Access ID is required);
_CF_error_exists = true;
}

//form element Password required check
if( !_CF_hasValue(_CF_this['Password'], PASSWORD, false ) )
{
_CF_onError(_CF_this, Password, _CF_this['Password'].value, A 
password is required);
_CF_error_exists = true;
}


//display error messages and return success
if( _CF_error_exists )
{
if( _CF_error_messages.length  0 )
{
// show alert() message
_CF_onErrorAlert(_CF_error_messages);
// set focus to first form error, if the field supports js 
focus().
if( _CF_this[_CF_FirstErrorField].type == text )
{ _CF_this[_CF_FirstErrorField].focus(); }

}
return false;
}else {
return true;
}
}
//--
/script

script type=text/javascript/* ![CDATA[ */

ColdFusion.Event.registerOnLoad(LoginInit,{_cf_containerId:'Login_body'},false,true);
/* ]] *//script













div id=LoginDiv

pPlease identify yourself, then press quot;Submitquot;/p


form name=LoginForm id=LoginForm 
action=/WGC-CF/MemberLogin.cfm?_cf_containerId=Login_body_cf_nodebug=true_cf_nocache=true_cf_clientid=843C53D8689D544653CE2DD24EE6081A_cf_rc=1
 method=post onsubmit=return ColdFusion.Ajax.checkForm(this, 
_CF_checkLoginForm,'Login_body')
table id=LoginBox
tr height=21
td width=100bAccess ID/b/td
td width=100input name=AccessID type=text id=AccessID  
size=8  //td
/tr
tr height=21
tdbPassword/b/td
tdinput name=Password id=Password  type=password size=8  
//td
/tr
tr height=21
td colspan=2span class=fineprintRemember me on this 
computer/span

input type=checkbox name=Remember value=Yes /td
/tr
/table
input name=Submit id=Submit  type=image value=Submit 
src=../Buttons/MSubmit.png  /
 /form

 /div
 
 


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


Re: Trying to set cfform focus in an Ajax window

2010-10-01 Thread John Pullam

That's not the code I wrote ... I set focus in the source.

So does this look like another CF9 bug, that it doesn't call my function? My 
source code is above in this thread so I won't repeat it. 

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


Re: Trying to set cfform focus in an Ajax window

2010-10-01 Thread John Pullam

I too am trying not to get frustrated. I appreciate that you are trying to help 
and I suspect we are caught in semantics based on different technology 
experiences.
 
In any event, I have learned more about what Firebug can do and the statement 
that should trigger the focus is in the code being sent to the browser. At 
present it's inside the AjaxOnLoad function and the JavaScript statement just 
before the HTML (calling LoginInit)should be triggering it:

script type=text/javascript/* ![CDATA[ */   
ColdFusion.Event.registerOnLoad(LoginInit,{_cf_containerId:'Login_body'},false,true);
 /* ]] *//script

I know this works because I also have put an alert in there and the alert fires 
(and have removed it as well).

When I go to the original (which I believe is what you would like to see there, 
I replace the AjaxOnLoad with:

script
document.LoginForm.AccessID.focus(); 
/script 

It also shows up in the code sent to the browser but generates the run time 
error:

document.LoginForm is undefined 


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


Re: Trying to set cfform focus in an Ajax window

2010-09-30 Thread John Pullam

You may have to lead me into what exactly you'd like to see, but here is what I 
have coded and I'll be happy to view source and get you something else ...

There are any number of pages that could force a login, and the do it from this 
sequence:

a 
href=javascript:ColdFusion.Window.show('Login');ColdFusion.navigate('../MemberLogin.cfm','Login');
bMembers Only/b/a

The login processor does some server stuff and then shows the form:

div id=LoginDiv
cfif LoginMsg
pPlease identify yourself, then press quot;Submitquot;/p
cfelse
p class=errormsgIncorrect Access ID or Password. Please try 
again./p/cfif
cfoutput
cfform name=LoginForm
table id=LoginBox
tr height=21
td width=100bAccess ID/b/td
td width=100cfinput name=AccessID validate=range 
range=1000,4999 value=#DefAccessID# size=8 ID=AccessID
required=yes message=A valid Access ID is required //td
/tr
tr height=21
tdbPassword/b/td
tdcfinput name=Password type=password value=#DefPassword# 
size=8 required=Yes
message=A password is required //td
/tr
tr height=21
td colspan=2span class=fineprintRemember me on this 
computer/span
cfset checked=IIf(DefRemember EQ Yes,'checked','')
input type=checkbox name=Remember value=Yes 
#checked#/td
/tr
/table
cfinput name=Submit type=image value=Submit 
src=../Buttons/MSubmit.png  /
 /cfform
 /cfoutput/div
 cfset AjaxOnLoad('LoginInit')
 /cfif

The LoginInit function is:

function LoginInit() {
document.LoginForm.AccessID.focus(); 
//  document.getElementById(AccessID).focus();
}

What else can I show you? 

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


Re: Trying to set cfform focus in an Ajax window

2010-09-30 Thread John Pullam

Here is the view source from when the window has opened ... 

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01//EN 
http://www.w3.org/TR/html4/strict.dtd;
html
headscript type=text/javascript/* ![CDATA[ */_cf_loadingtexthtml=img 
alt=' ' src='/CFIDE/scripts/ajax/resources/cf/images/loading.gif'/;
_cf_contextpath=;
_cf_ajaxscriptsrc=/CFIDE/scripts/ajax;
_cf_jsonprefix='//';
_cf_clientid='843C53D8689D544653CE2DD24EE6081A';/* ]] *//scriptscript 
type=text/javascript 
src=/CFIDE/scripts/ajax/yui/yahoo-dom-event/yahoo-dom-event.js/script
script type=text/javascript 
src=/CFIDE/scripts/ajax/messages/cfmessage.js/script
script type=text/javascript 
src=/CFIDE/scripts/ajax/package/cfajax.js/script
script type=text/javascript 
src=/CFIDE/scripts/ajax/yui/animation/animation-min.js/script
script type=text/javascript 
src=/CFIDE/scripts/ajax/ext/adapter/yui/ext-yui-adapter.js/script

script type=text/javascript 
src=/CFIDE/scripts/ajax/ext/ext-all.js/script
script type=text/javascript 
src=/CFIDE/scripts/ajax/package/cfwindow.js/script
script type=text/javascript src=/CFIDE/scripts/cfform.js/script
script type=text/javascript src=/CFIDE/scripts/masks.js/script
script type=text/javascript src=/CFIDE/scripts/cfformhistory.js/script
link rel=stylesheet type=text/css 
href=/CFIDE/scripts/ajax/resources/ext/css/ext-all.css /
link rel=stylesheet type=text/css 
href=/CFIDE/scripts/ajax/resources/cf/cf.css /

meta http-equiv=Content-Type content=text/html; charset=utf-8
titleWhitevale Golf Club/title
link rel=stylesheet media=all type=text/css href=../WGCStyle10.css /

script language=JavaScript src=../WGCCF.js/script
script type=text/javascript
function ChangeWidth()
{
var winW = 630;
if (parseInt(navigator.appVersion)3) {
 if (navigator.appName==Netscape || navigator.appName==Opera) {
  winW = window.innerWidth;
 }
 if (navigator.appName.indexOf(Microsoft)!=-1) {
  winW = document.body.offsetWidth;
 }
}
document.images[image0].width = winW;
}
/script

script type=text/javascript/* ![CDATA[ */
ColdFusion.Ajax.importTag('CFWINDOW');
/* ]] *//script

script type=text/javascript/* ![CDATA[ */
ColdFusion.Ajax.importTag('CFAJAXPROXY');
/* ]] *//script

script type=text/javascript/* ![CDATA[ */
ColdFusion.Ajax.importTag('CFFORM');
/* ]] *//script

script type=text/javascript/* ![CDATA[ */
var _cf_window_init_1285851829390=function()
{
var _cf_window=ColdFusion.Window.create('Login','Please 
login','',{ modal:true, closable:true, divid:'cf_window1285851829389', 
draggable:true, resizable:false, fixedcenter:false, width:380, height:200, 
shadow:true, bodystyle:'font-size:12px; font-family: verdana; background-color: 
#dcefd2; color: black; text-align: left;', headerstyle:'font-size:13px; 
font-weight:bold; font-family:Verdana; background-color: #2e5327; color: white; 
text-align:left;', callfromtag:true, initshow:false, destroyonclose:false, 
x:80, y:80});
};ColdFusion.Event.registerOnLoad(_cf_window_init_1285851829390);
/* ]] *//script

/head

body OnLoad=ChangeWidth() id=SplashBody
img id=image0 src=SplashHole4.jpg
div id=SplashLogoa href=PublicHome.cfmimg SRC=SplashLogo.png 
border=0/a/div
div id=SplashButtons
a href=PublicHome.cfmimg SRC=../Buttons/LGuests.png hspace=25 
border=0/a
a 
href=javascript:ColdFusion.Window.show('Login');ColdFusion.navigate('../MemberLogin.cfm','Login');
img SRC=../Buttons/LMembers.png hspace=25 border=0/a/div

div  id=cf_window1285851829389 class=x-hidden

div  id=Login_title class=x-window-header style=font-size:13px; 
font-weight:bold; font-family:Verdana; background-color: #2e5327; color: white; 
text-align:left;
Please login
 /div

div  id=Login_body class=x-window-body style=font-size:12px; 
font-family: verdana; background-color: #dcefd2; color: black; text-align: 
left;


 /div
 /div 

/body
/html

If you'd like to see something else, how do I get it? 

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


Re: Trying to set cfform focus in an Ajax window

2010-09-30 Thread John Pullam

Well I certainly understand that CF has to compile it before it runs it, but I 
have never concerned myself with that step. How would I see the compiled 
source? (Sorry to be so simple but it has never been an issue for me before.) 

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


Re: Trying to set cfform focus in an Ajax window

2010-09-30 Thread John Pullam

Sorry but I certainly didn't understand what was involved to do that (hope my 
posts made that clear, but maybe not) and I don't have sufficient firebug 
skills to do what is suggested.

Thanx for trying, but let's leave this problem as it lies. I'm obviously over 
my head and getting a cursor in a field just isn't worth the hassle. 

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


Re: SOT: Canadian CF Hosting

2010-09-29 Thread John Pullam

I use LooseFoot in Regina ... lfchosting.com, and am very pleased with their 
service. They have both CF7 and CF9 hosts right now. 

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


Re: Trying to set cfform focus in an Ajax window

2010-09-29 Thread John Pullam

It might be that the form hasn't been added to the dom, though that's
usually not the case since the js comes after the form code.
However if you'll remember a few days ago I suggested:

 1. Wrap your JS code at the bottom of the page in a function and execute
the function when the ajax call completes.
 2. Add your focus setting code into a callback function on the ajax call.

That advice is still sound.



On Mon, Sep 27, 2010 at 4:56 PM, John Pullam jpul...@mcleansystems.comwrote:



Must admit that I'm not really sure what you are suggesting. e.g., what do you 
mean a callback function on the ajax call?

In any event, it all seems fairly consistent at the moment. I have converted to 
using AjaxOnLoad and the function contains either:

document.LoginForm.AccessID.focus(); or 
document.getElementById(AccessID).focus();

Regardless of which I use, it works fine in Opera, Chrome and Safari. Neither 
work in IE, and in Firefox, the cursor is set but it moves away again in about 
a second.

Very strange but it is not worth the amount of time being spent so I will 
probably give up on ever fixing it and assume it is some kind of CF9 issue that 
will get resolved over time. 

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


Re: Trying to set cfform focus in an Ajax window

2010-09-27 Thread John Pullam

I don't understand what you are trying to tell me. I don't currently use jquery 
so I can't really follow if you are doing something different.

My case seems simple. I have inserted an alert (which fires) in the script so I 
am confident that the JavaScript code is being executed, but it simply isn't 
resolving the focus() ... is it perhaps trying to do that at the wrong time? My 
JavaScript/firebug skills are not far enough along to be able to understand the 
DOM when I look at it. But it seems to me that I've tried every combo of id and 
name and of trying to access the field in my JavaScript and still nothing. Can 
anyone suggest something I should look for in the DOM? 

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


Re: Trying to set cfform focus in an Ajax window

2010-09-27 Thread John Pullam

No problem posting my code and providing a URL of it in action. The following 
is one of the many that I've tried which I believe to be syntactically correct. 
I left the JavaScript alert in so that you can see that it fires.

First one of the calling pages:

cfinclude template=../AutoLogin.cfm!--- Goes to member home page if it 
logged someone in ---

!--- Either no cookie, or no valid auto-login so just show the splash page ---
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01//EN 
http://www.w3.org/TR/html4/strict.dtd;
html
head
meta http-equiv=Content-Type content=text/html; charset=utf-8
titleWhitevale Golf Club/title
link rel=stylesheet media=all type=text/css href=../WGCStyle10.css /
script type=text/javascript
function ChangeWidth()
{
var winW = 630;
if (parseInt(navigator.appVersion)3) {
 if (navigator.appName==Netscape || navigator.appName==Opera) {
  winW = window.innerWidth;
 }
 if (navigator.appName.indexOf(Microsoft)!=-1) {
  winW = document.body.offsetWidth;
 }
}
document.images[image0].width = winW;
}
/script
/head

body OnLoad=ChangeWidth() id=SplashBody
img id=image0 src=SplashHole4.jpg
div id=SplashLogoa href=PublicHome.cfmimg SRC=SplashLogo.png 
border=0/a/div
div id=SplashButtons
a href=PublicHome.cfmimg SRC=../Buttons/LGuests.png hspace=25 
border=0/a
a 
href=javascript:ColdFusion.Window.show('Login');ColdFusion.navigate('../MemberLogin.cfm','Login');
img SRC=../Buttons/LMembers.png hspace=25 border=0/a/div
cfinclude template=../LoginWindow.cfm
/body
/html

Next the template LoginWindow which it calls:

!--- The window used to display/process the member login ---
cfwindow name=Login modal=true resizable=false title=Please login 
width=380 height=200 x=80 y=80
bodyStyle=font-size:12px; font-family: verdana; background-color: 
##dcefd2; color: black; text-align: left; 
headerStyle=font-size:13px; font-weight:bold; font-family:Verdana; 
background-color: ##2e5327; color: white; text-align:left; 
cfajaximport tags=cfform, cfwindow scriptsrc=/CFIDE/scripts
/cfwindow 


Next the entire template MemberLogin.cfm which it calls to process:

cfset LoginMsg = True
cfif IsDefined(FORM.AccessID)

!--- Processing for the form postback (user clicked on submit) ---
cfparam name=FORM.Remember default=No
cfquery name=GetUser datasource=WGCClubUser
SELECT  UserName, FirstName, LastName, Password, 
GolfClassification, Sex, MemberID 
FROM Users 
WHERE Status = 'Active' AND UserName = '#FORM.AccessID#'
/cfquery
cfif (GetUser.RecordCount EQ 1) AND (FORM.Password EQ GetUser.Password)
!--- Success: We have a member who has logged on successfully 
---
!--- Create a user's extension record if one doesn't exist ---
cfquery name=GetExtCount datasource=#datasource#
SELECT UserName
FROM UserNameExt 
WHERE UserName = '#FORM.AccessID#'
/cfquery
cfif GetExtCount.RecordCount EQ 0
!--- Write a new blank one ---
cfquery name=GetExtCount datasource=#datasource#
INSERT INTO UserNameExt(
UserName, 
LastLogin, 
AuthAdminEvents, 
AuthAdminContent, 
AuthAdminMarketing, 
AuthAdminUsers) 
VALUES (#FORM.AccessID#, 
#01/01/2001#, 
0,0,0,0)
/cfquery/cfif
!--- We have a UserNameExt record, now update it with this login date 
---
cfquery datasource=#datasource#
UPDATE UserNameExt
SET LastLogin=#CreateODBCDateTime(Now())#
WHERE UserName = '#FORM.AccessID#'
/cfquery
!--- Get the user's authorities ---
cfquery name=GetExt datasource=#datasource#
SELECT *
FROM UserNameExt 
WHERE UserName = '#FORM.AccessID#'
/cfquery

!--- Remember stuff in the session variables ---
cflock timeout=5 throwontimeout=no type=exclusive 
scope=session 
cfset Session.IsLoggedIn=True
cfset Session.FirstName=GetUser.FirstName 
cfset Session.LastName=GetUser.LastName 
cfset Session.AccessID=GetUser.UserName 
cfset Session.LoggedInAccessID=GetUser.UserName 
cfset Session.Password=GetUser.Password 
cfset Session.Class=GetUser.GolfClassification 
cfset Session.Gender=GetUser.Sex 
cfset Session.Account=GetUser.MemberID
cfset Session.AuthAdminUsers=False 
cfif GetExt.AuthAdminUsers EQ 1cfset 
Session.AuthAdminUsers=True/cfif
cfset Session.AuthAdminEvents=False 
cfif GetExt.AuthAdminEvents EQ 1cfset 

Re: Trying to set cfform focus in an Ajax window

2010-09-27 Thread John Pullam

Yes. That's what occurs when it tries to execute the line 

document.LoginForm.AccessID.focus();

That's what I'm trying to solve. 

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


Re: Trying to set cfform focus in an Ajax window

2010-09-27 Thread John Pullam

alert(document.LoginForm); gives the message undefined.

I assume that means that at the time the JavaScript is executing there is no 
such object in the DOM.

Could the JavaScript be executing at the wrong time? I'm wondering about using 
some sort of onAjaxLoad thing (but I have no experience doing that).


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


Re: Trying to set cfform focus in an Ajax window

2010-09-25 Thread John Pullam

Well, it still doesn't work. I've been doing CF for several years myself and 
this one doesn't make a lot of sense. I have tried the various combos you are 
alluding to and the code now is:

cfform name=LoginForm
table id=LoginBox
tr height=21
td width=100bAccess ID/b/td
td width=100cfinput name=AccessID validate=range 
range=1000,4999 value=#DefAccessID# size=8
required=yes message=A valid Access ID is required 
//td
/tr
tr height=21
tdbPassword/b/td
tdcfinput name=Password type=password 
value=#DefPassword# size=8 required=Yes
message=A password is required //td
/tr
tr height=21
td colspan=2span class=fineprintRemember me on this 
computer/span
cfset checked=IIf(DefRemember EQ 
Yes,'checked','')
input type=checkbox name=Remember value=Yes 
#checked#/td
/tr
/table
cfinput name=Submit type=image value=Submit 
src=../Buttons/MSubmit.png  /
 /cfform
 script
document.LoginForm.AccessID.focus();
/script

It feels to me as though the JS can't find document.LoginForm.AccessID. Firebug 
freezes on that line but I'm not getting a clean error message.

Is it possible that there is some new trick needed in CF 9? 

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


Trying to set cfform focus in an Ajax window

2010-09-24 Thread John Pullam

I have a cfform inside an Ajax window and I am trying get the cursor to appear 
in the first input field when the window opens. I've tried the usual javascript 
solution but nothing seems to work for me. Any ideas? 

Extracted code from the module follows:

div id=LoginDiv
cfif LoginMsg
pPlease identify yourself, then press quot;Submitquot;/p
cfelse
p class=errormsgIncorrect Access ID or Password. Please try 
again./p/cfif
cfoutput
cfform id=LoginForm onload=document.LoginForm.AccessID.focus();
table id=LoginBox
tr height=21
td width=100bAccess ID/b/td
td width=100cfinput name=AccessID validate=range 
range=1000,4999 value=#DefAccessID# size=8
required=yes message=A valid Access ID is required 
//td
/tr
tr height=21
tdbPassword/b/td
tdcfinput name=Password type=password 
value=#DefPassword# size=8 required=Yes
message=A password is required //td
/tr
tr height=21
td colspan=2span class=fineprintRemember me on this 
computer/span
cfset checked=IIf(DefRemember EQ 
Yes,'checked','')
input type=checkbox name=Remember value=Yes 
#checked#/td
/tr
/table
cfinput name=Submit type=image value=Submit 
src=../Buttons/MSubmit.png  /
 /cfform/cfoutput/div 

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


Re: Connecting to CFC's in the same directory in CF9.

2010-07-29 Thread John Pullam

For the benefit of anyone who encounters this posting while scanning the list, 
I was just informed that Adobe have verified the behaviour I reported and are 
targeting a hotfix for it.

Nice to know that I wasn't misunderstanding something. 

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


Re: Access Data Source Problem with ColdFusion 9 on 64 bit Windows 7

2010-07-20 Thread John Pullam

I am successfully using the HXTT driver on a 64 bit platform for that purpose. 
The only glitch I have run into is that the queries were all case sensitive. 
They do have a parameter you can set to turn that off.


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


Re: Connecting to CFC's in the same directory in CF9.

2010-07-19 Thread John Pullam

I have only one special mapping for a directory that has some externally 
provided cfc's called /cfc but to reference those ones, the code prefaces the 
calls with cfc. 

In the case I am describing above, I'm just doing the simple thing of looking 
for a  cfc in the same directory as the invoking web page, so I don't believe 
that any mapping is needed. 

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


Re: Connecting to CFC's in the same directory in CF9.

2010-07-18 Thread John Pullam

I think that I have isolated it pretty well now ...

It can find the CFC if both the invoking web page and the CFC are in the 
document root (c:\inetpub\wwwroot\) and it can find it if I create a 
subdirectory from there, e.g., c:\inetpub\wwwroot\real\ and move them both to 
it.

But if I create a virtual directory that points into my website pages and place 
both modules there then it fails.

I went back to my old CF8 system and tested it the same way and satisfied 
myself that there is no such problem in CF8.

So my conclusion is that CF9 is not able to find the CFC when it is in a 
virtual directory, even though the calling page is in the same virtual 
directory. I am using a new Windows 7 Professional system which means I am 
running IIS 7. So I figure that the issue is either a CF9 bug or something that 
needs to be changed in the IIS 7 setup. (But if I can access the web page, 
could anything else need to be done to access the CFC?)

Any ideas? If I get nothing back I will post this to Adobe and see if they can 
provide help. 

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


Re: Connecting to CFC's in the same directory in CF9.

2010-07-18 Thread John Pullam

That surprises me. Virtual directories work fine in CF8 and I have been using 
them like that on my development desktop for several years without a problem. 
Can you please provide me more information about your statement?

Specifically:
- what is the limitation?
- is it an IIS issue or CF?
- did it just happen on CF9?
- is there any documentation that explains this limitation?

If I can't use virtual directories, what is the approach that others use for 
testing on a desktop with multiple CF websites? Put all the data on the c: 
drive in wwwroot? (It seems more logical to me to use virtual directories and 
keep them with the rest of my files.)

Thanx.



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


Connecting to CFC's in the same directory in CF9.

2010-07-16 Thread John Pullam

This is a variation of a question I posted a few days ago that didn't get 
resolved, so please bear with me. It seems simple but I am not getting anywhere 
with it.

I have a test page (TestCFC.cfm) that binds to a CFC (TestCFC2.cfm) that is in 
the same directory. This used to work on CF8 but it doesn't on CF9. I keep 
being told that The specified CFC TestCFC2 could not be found.

I don't understand why it can't be found because the manual says that for bind 
expressions, The componentPath value must be a dot-delimited path from the web 
root or the directory that contains the current page.

My calling page contains:
cfform
  cfselect name=oSLevel bind=cfc:TestCFC2.GetRoles() bindonload=true 
value=m /
  /cfform

The CFC it calls is:

cfcomponent
!--- Function to populate the Roles drop-down ---
cffunction name=GetRoles access=remote returnType=array
cfset var result=ArrayNew(2)
cfset var i=2
cfset var item=

cfset result[1][1]=
cfset result[1][2]=-- Select --
cfset result[2][1]=m
cfset result[2][2]=person

cfreturn result
/cffunction
/cfcomponent

Can anyone tell me what I am doing wrong? Or is this a CF9 bug?


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


Re: Connecting to CFC's in the same directory in CF9.

2010-07-16 Thread John Pullam

OK, several replies ...

1 - Yes, I made that stupid error. After I renamed it to CFC, it worked 
correctly on the live CF9 system.

2 - Even with that fixed, it fails on my desktop (that was the original problem 
and I was trying to narrow it down). So when I have the calling page on 
localhost and the CFC in the same directory, it can't find it.

3 - I just applied the 9.0.1 update (after much grief) and that didn't fix it.

So I may have a CF9 bug here ... it can't find the CFC even though it is in the 
same directory. Any other ideas? 

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


Re: Coldfusion 8 vs 9 - cfc mapping differences?

2010-07-12 Thread John Pullam

John,

I am not sure what your problem is here, when doing any work like this
ColdFusion will try to look into the root of the website. Unless you specify
a mapping or have set something up in IIS or apache.

The code that you have shown to us will be trying to execute a cfc in the
root of the website called BSelects, are you 100% certain that you have no
other configuration difference between the 2 installations of ColdFusion?



I'm struggling a bit with running some previously operational applications
under CF9. It seems that most of my challenge comes from cfc invocation.
I've been browsing around trying to understand what has changed but haven't
come up with anything much.

Ok, that's useful information.

Just to expand on the situation a little, I'm moving from CF8 on Win XP to CF9 
on Win 7 so there is clearly an environmental difference. In both cases I am 
doing this on my desktop which is where I always test, so all of my customer 
sites are under localhost with separate directories. I assume that means that 
the document root is actually up one level from where it is in production and 
it is trying to pull BSelects from the wrong one.

But when I examine the older Win XP config everything appears to me to be the 
same as now. So assuming that the problem is that the cfc is trying to come 
from the higher directory, why didn't it do that in CF8? I checked lots of 
settings and don't see anywhere that I could have even overridden that.

Have the new application.cfc and the expanded settings introduced something new 
into the mix? Sorry but I'm still struggling ...


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


Re: Coldfusion 8 vs 9 - cfc mapping differences?

2010-07-12 Thread John Pullam

The ColdFusion 9 Developer's Guide says on page 650 under Using Bind 
Expressions:

 cfc:componentPath.functionName(parameters)

 Note: The component path cannot use a mapping. The componentPath value must 
 be a dot-delimited path from the web root or the directory that contains the 
 current page.

That seems to confirm that it can be the path from the directory that contains 
the current page, which is what has worked previously in my CF8 system. Seeing 
as it is the same directory, I have used the notation cfc:BSelects()


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


Re: Coldfusion 8 vs 9 - cfc mapping differences?

2010-07-12 Thread John Pullam

Sorry, correction: It should read cfc:BSelects.getSessions() and BSelects is 
the component with getSessions the method. 

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


Re: Coldfusion 8 vs 9 - cfc mapping differences?

2010-07-11 Thread John Pullam

Yeah, but .

Why did it work fine in CF8? (I'm not talking about the second example which 
was added, but my original posting.) 

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


Coldfusion 8 vs 9 - cfc mapping differences?

2010-07-10 Thread John Pullam

I'm struggling a bit with running some previously operational applications 
under CF9. It seems that most of my challenge comes from cfc invocation. I've 
been browsing around trying to understand what has changed but haven't come up 
with anything much.

I have my cfc's in the same folder as my normal templates. So I would expect 
that the following code would be valid because BSelects is in the same folder 
and getSessions is in the cfc. This worked in CF8. Is there something new I'm 
missing? 

cfselect name=Session bind=cfc:BSelects.getSessions() bindonload=yes /

CF says that the cfc BSelects could not be found. This should be simple but I 
don't get it! 

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


Re: How can you GetFileInfo for a datasource?

2010-06-24 Thread John Pullam

You are correct. I made an assumption that was incorrect and now realize that 
it was the same issue in .Net.

For what its worth, I have decided to base the file location on the relative 
location from my website root. That is not likely to change while the ISP could 
always reqyuire me to move the entire website. My final code is:

cfset LastUpdated=GetFileInfo(ExpandPath(/)  
App_Data\MyDatabase.mdb).LastModified


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


Re: How can you GetFileInfo for a datasource?

2010-06-24 Thread John Pullam

You are correct. I made an assumption that was incorrect and now realize that 
it was the same issue in .Net.

For what it's worth, I have decided to base the file location on the relative 
location from my website root. That is not likely to change, but the ISP could 
always require me to move the entire website. My final code is:

cfset LastUpdated=GetFileInfo(ExpandPath(/)  
App_Data\MyDatabase.mdb).LastModified



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


How can you GetFileInfo for a datasource?

2010-06-23 Thread John Pullam

I have a datasource that points to an Access database (no editorializing 
please, I didn't create it). I need to do a GetFileInfo on it to obtain the 
last modified date. This was pretty easy in .Net (I'm converting it from .Net 
to CF) but I can't figure out how to do it in CF. GetFileInfo requires an 
absolute path ... is there a simple way to get the absolute path for a 
datasource? 

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


Re: How can you GetFileInfo for a datasource?

2010-06-23 Thread John Pullam

I do know the absolute path but the whole idea was to make it work correctly 
even if something might change. I was looking for a more elegant solution! 

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


Re: How can you GetFileInfo for a datasource?

2010-06-23 Thread John Pullam

This info is not made readily available unless you unlock it.

You need access to the database...

 Open the database
Go to tools--Options
Check the box under *show* that says *system Objects*. You will notice that
several new tables appear in table view with the prefix MSys -
MSysAccessObjects, MSysAces, MSysObjects, MSysQueries, MSysRelationships,
and there may be a few others depending on your version of Access.
Now Go to Tools--Security--User and Group Permissions
Select the MSysObjects table and check the box that says Read Data

Then...


The database is created in a 3rd party application and a copy is sent to my 
website every 15 minutes, so it isn't practical to change the database itself.

I dislike .Net but it certainly was simple there. It took 3 lines:

db = Session(DBpath)  myDB.mdb
Dim myFile as FileInfo = New FileInfo(db)
Dim ModDate as Date = myFile.LastWriteTime

   SELECT UpdateDate FROM MSysObjects
/CFQUERY

   cfdump var=#getSysData#




Jim Eisenhauer 

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


Re: How to show a work-in-progress icon while waiting for a web service

2010-05-13 Thread John Pullam

Good feedback.  

I am using the ColdFusion error checking of cfinput and cfselect to validate 
the input in the form before processing. If I simply JavaScript the button to 
either pop an image or inhibit the button, would it trigger that even though 
the validation failed?

I'd not want to have the situation where the validation failed but the 
working icon or inactive button were left on the page. 

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


Re: How to show a work-in-progress icon while waiting for a web service

2010-05-13 Thread John Pullam

Good feedback.  

I am using the ColdFusion error checking of cfinput and cfselect to validate 
the input in the form before processing. If I simply JavaScript the button to 
either pop an image or inhibit the button, would it trigger that even though 
the validation failed?

I'd not want to have the situation where the validation failed but the 
working icon or inactive button were left on the page. 

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


Re: How to show a work-in-progress icon while waiting for a web service

2010-05-13 Thread John Pullam

Good feedback.  

I am using the ColdFusion error checking of cfinput and cfselect to validate 
the input in the form before processing. If I simply JavaScript the button to 
either pop an image or inhibit the button, would it trigger that even though 
the validation failed?

I'd not want to have the situation where the validation failed but the 
working icon or inactive button were left on the page.


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


How to show a work-in-progress icon while waiting for a web service

2010-05-12 Thread John Pullam

I have an app which calls a web service on a different computer to do work on 
its behalf and sometimes my users are impatient and hit the invocation button a 
second time, which causes problems. I'd like to pop some kind of 
work-in-progress or busy icon on the web page while this service is executing 
but am drawing a blank on how to do that. I can envision a hidden div with some 
kind of animated gif but am not sure of exactly how to activate it and then 
deactivate it when the service returns.

Would appreciate any ideas on how to do this. 

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


Re: Using two submit buttons to control form action

2010-04-29 Thread John Pullam

Thanx for all the feedback. I'm about 95% sure that I've done all this before 
and made it work. And the examples given have been tried too. There must be 
something different in my case. This simple use of 2 buttons on a page worked 
for me. But when I put it back into the live case it fails, so I think I am 
missing something there. 

I have trimmed out irrelevant code in an attempt to get this down to a basic 
test but still it fails showing me a string that has both button names (it 
didn't do this when I started with a single page). My case includes a cfwindow, 
so there are 2 bits of code below ... the page and the window.

The calling page:

!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN 
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
head
meta http-equiv=Content-Type content=text/html; charset=utf-8 /
titleUntitled Document/title
script language=javascript
function WinGo(WindowName,WindowCode) {
ColdFusion.Window.show(WindowName);
ColdFusion.navigate(WindowCode,WindowName);
}
/script/head

body
input name=Duration type=Button value=Change Duration   

onclick=WinGo('DurationWindowEdit','UpdateBookingChangeDuration.cfm?Guest=0')/
cfwindow closable=true draggable=true modal=true 
name=DurationWindowEdit resizable=false 
title=Change Duration width=500 height=200 x=100 y=100
headerStyle=font-size:13px; font-weight:bold; font-family:Verdana; 
background-color: ##003399; color: white; text-align:left; 
cfajaximport tags=cfform, cfwindow, cfdiv scriptsrc=/CFIDE/scripts
/cfwindow

!-- InstanceEndEditable --

/body
/html

and the window template:

cfoutput

!--- Postback processing if the form specified a change in partial stay 
duration ---
cfif IsDefined(FORM.Choose) AND (FORM.Choose NEQ Full)
cfdump var=#FORM#
cfabort showerror=stop

!--- Postback processing if the form specified a change to a full stay ---
cfelseif IsDefined(FORM.choose) AND (FORM.choose EQ Full)
cfabort showerror=made it

cfelse!--- Initial call, just show the input form ---

cfdump var=#FORM#
cfform
input name=Choose value=Change type=submit  /
input name=Choose value=Full type=submit  /
/cfform
/cfif
 
/cfoutput

No matter what I do, it keeps setting FORM.Choose to Change,Full

Any ideas? 

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


Re: Using two submit buttons to control form action

2010-04-29 Thread John Pullam

When I change the cfform to form, it works properly, but that will stop my 
cfinput and cfselect tags from working.

Is it possible that there is something about the use of cfform that is causing 
this? 

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


Re: Using two submit buttons to control form action

2010-04-29 Thread John Pullam

Then what I am reading is that ColdFusion simply doesn't do a correct job of 
processing cfform submit buttons when used in a cfwindow. As much as I would 
like to get it to run correctly I have opted for making this 2 separate small 
forms and then testing the existence of a button that is unique to each form in 
the postback processing. That was the cleanest thing to do in my case. 

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


Using two submit buttons to control form action

2010-04-28 Thread John Pullam

I have seen several examples of using multiple form buttons on a single form. 
The idea is that you can get the value of the respective form variable when you 
are posted and then take the appropriate action.

But I'm getting odd results. Instead of getting a single value, I get both 
values every time, and the examples I've seen suggest that you should only get 
the one that was pressed.

Can anyone tell me what I'm doing wrong or what I need to do to get a single 
value? My code for the buttons is as follows:

input name=Choose value=Change type=submit class=EditButton /
input name=Choose value=Full type=submit class=EditButton /

When I CFDump it, FORM.Choose is Change,Full 


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


Re: What happens to session variables after redirecting to https?

2010-04-01 Thread John Pullam

Good feedback. Glad to see I'm not the only one who has had some struggles here.

I'm not the CF admin for the production sites I use, so I'm a bit unsure of 
exactly what is configured. But on my test site, when I look at my session 
variables, sessionid is always correctly set, whether http or https. And I have 
done nothing specific to pass the CFid or CFtoken. 

The doc on CFLOCATION doesn't say whether the default is ADDTOKEN yes or no. 
Perhaps I need to go in and make sure that I keep saying it, just in case.





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


  1   2   >