Coldfusion connection with xampp2

Servers are not my strong point - and I might be trying to do the impossible. To know that would be very helpful !

Set up :

Windows 7 PC, 64 bit
Dreamweaver CC
Coldfusion Development server. (localhost:8500 url address)
XAMPP/Apache Server. (localhost url address )

Both  Apache and Coldfusion are set up within Dreamweaver and I have applications running on each, independently.

My objective is to create a link/handshake  from an application running on Coldfusion to a module (written in Python) which is running as a XX.cgi page on the Apache Server. The XX.cgi module would deliver the output to the application user in those occasions when it is called - no reverse link/handshake from Apache to Coldfusion required.

Backing up for a moment -  The application is 80% coldfusion - but I would like to 'subcontract' some parts to Python - which I think coldfusion finds hard to handle .  That's the concept - and I'm not sure of the feasibility .

I have tried the following example to test:

1..  Created a page XXX.html on the coldfusion server (localhost:8500/)
2..  Created a page YYY.html on the apache server.(localhost)
3... XXX.html has a link to YYY.html on the apache server. The link is href="../../../localhost/htdocs/PizzaKitchen/YYY.html"
4..  On clicking the link I arrive at localhost:8500/localhost/htdocs/PizzaKitchen/YYY.html  ----- with an error message as per attached image

Must have missed something or am trying to do the impossible.

Thanks for any input
ERROR404.jpg
jameskaneAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LajuanTaylorCommented:
Based on the error message it appears that you have a missing file. java.io.FileNotFoundException - "QtyOrderForm.html"

Make sure the file "QtyOrderForm.html" does exist.

Can you elaborate on the parts you find hard for ColdFusion to handle?

I was just pondering if the handshake portion could be accomplished using ColdFusion webservice or if you could call some executable using the <cfexecute tag...
0
jameskaneAuthor Commented:
Many thanks for input LajuanTaylor !

QtyOrderForm.html does exist, but it is on the Apache server. The page with the pointer to QtyOrderForm.html is on the Coldfusion server.  Noticed that the pointer link finally resolves to localhost:8500/localhost/htdocs/PizzaKitchen/YYY.html  - which would indicate that control has not been relinquished to the apache server.... I would have expected the resolved address to be localhost/htdocs/PizzaKitchen/YYY.html ???

I found the order processing hard with Coldfusion although I eventually got a system running and it has been running for past 3 years without problems. However, it is complex and difficult to maintain. We have 40 different courses and each order is a selection of these courses - by quarter, Q1,Q2,Q3.  Now we need to add more courses and that means diving into the code again.  I used MS ACCESS as the database (just as a repository, not using any of the access specific functionality.  I intend to move everything over to mysql.

I have been experimenting with Phyton and find it has the potential  for treating the above via 2D Lists AND it automatically handles additional courses as they are defined - in addition to printing out receipts, updating databases...

I want to retain those parts of the current system which deal with check processing, membership registration, course definition - while at the same time being able to handshake with the Python modules which will do the order entry and processing - including receipt and report generation.  

I imagine a cfm page with a link to a cgi page - which basically hands over to Python running on Apache. The order processing and mysql database update would be done and then control returned to coldfusion via a link on the ending Python/cgi page.  For data, the common touch stone for both the coldfusion and apache code is mysql.  

Thanks again for taking an interest in this !

James
0
jameskaneAuthor Commented:
PS.... for clarity - the file YYY.html is same as QtyOrderForm.html. I used YYY.html in the text for simplicity in typing !
0
LajuanTaylorCommented:
If you populate the course selections for Q1, Q2, Q3 using a dynamic drop down list (i.e. db query), I was thinking that you could just make a CRUD page for the database table that contains your course information... Updating the menu items would then just be a matter of using a web interface to update a db table.

As for the handshake, you might have to create some type of session table that shared between the CGI and ColdFusion. You could pass the handshake in the URL via named value pairs. For security purposes after it's working you could also encrypt or create some sort of hash for name value pairs when passing as a URL string.

Example of creating a dropdown using a db table
http://www.cf-toolbox.com/DynamicDropDowns.cfm

Example if you need the dropdowns to be dependent
http://tutorial166.easycfm.com/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jameskaneAuthor Commented:
thanks LajuanTaylor  - following your suggestions and have managed to set up what I need.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Apache Web Server

From novice to tech pro — start learning today.