Solved

how to bind cfgrid to cfc in virtual directory

Posted on 2010-08-23
14
870 Views
Last Modified: 2013-12-24
I can not find the answer to this. I'm trying to bind a grid to a cfc that is in a virtual directory. It is a windows server using CF8. I keep getting this error on the application log --
"File not found: /orders.cfc The specific sequence of files included or processed is: C:\inetpub\wwwroot\orders.cfc'' --
How do you bind the cfc when it is in a virtual directory that is at the same level that the wwwroot folder is?

The cfc is located here..
C:\\intpub\www-acct1021

The cfc bind keeps looking here
C:\\intpub\wwwroot

On my local server it works fine because everything is in the wwwroot folder.

Here is the code for the grid page
<cfform name="orderForm">
 <cfgrid format="html" name="orderGrid" pagesize=20  stripeRows=true
   bind="cfc:orders.getorders({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})"
 delete="yes" selectmode="edit" deletebutton="Delete Order"
onchange="cfc:orders.editOrder({cfgridaction},{cfgridrow},{cfgridchanged})">

<cfgridcolumn name="orderID" display=false/>
<cfgridcolumn name="customer" display=true header="Customer" width="100"/>
<cfgridcolumn name="model" display=true header="Model" width="50" />
<cfgridcolumn name="color" display=true header="Color" width="50" />
<cfgridcolumn name="placed" display=true header="Placed" width="50" />
<cfgridcolumn name="ordernum" display=true header="Order ##" width="60" />
<cfgridcolumn name="Chasis" display=true header="Chasis ##" width="70" />
<cfgridcolumn name="Production" display=true header="Production" width="80" />
<cfgridcolumn name="EC_ETA" display=true header="EC/ETA" width="60" />
<cfgridcolumn name="Status" display=true header="Status" width="50" />
<cfgridcolumn name="Salesman" display=true header="Salesman" width="80" />
<cfgridcolumn name="EC" display=true header="EC" width="50" />
<cfgridcolumn name="EC_Submitted_FNA" display=true header="EC Submitted FNA" width="120" />
<cfgridcolumn name="EC_Approved_FNA" display=true header="EC Approved FNA" width="120" />
<cfgridcolumn name="EC_Cust_Approved" display=true header="EC Cust. Approved" width="120" />
<cfgridcolumn name="Trade" display=true header="Trade" width="50" />
<cfgridcolumn name="Note" display=true header="Note" width="100" />

</cfgrid>
</cfform>
0
Comment
Question by:carsalsgal
14 Comments
 
LVL 63

Expert Comment

by:Zvonko
Comment Utility
Look in the ColdFusion Administrator in the Server Settings section for the Mappings.
You cannot overlay the wwwroot but you can define some subfolder of server root to be refereing to the network share.
Keep in mind that ColdFusion local service needs to be allowed to use that network share.

0
 

Author Comment

by:carsalsgal
Comment Utility
Hi, I tried using cf mapping earlier and that did not work either.
0
 

Author Comment

by:carsalsgal
Comment Utility
Just tried cf mapping again and got this error.

File not found: /orders.cfc The specific sequence of files included or processed is: C:\inetpub\wwwroot\orders.cfc''

see image for mapping setup and bind code here
bind="cfc:florders.orders.getorders({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})"
screen5.JPG
0
 
LVL 63

Expert Comment

by:Zvonko
Comment Utility
Put a trivial cfm file in the mapped path and try to open that cfm page.
When that works then search the CFC syntax problems.
0
 

Author Comment

by:carsalsgal
Comment Utility
Can you be a bit more specific here. The whole site is in that folder and every other page and component work fine. This is the first time I have tried to use a cfgrid and binding.
0
 
LVL 63

Expert Comment

by:Zvonko
Comment Utility
OK, more specifc.

1.) Crate this file:
C:\\intpub\www-acct1021\hello.cfm

2.) Open that file in browser:
http://yourserver.com/florders/hello.cfm

Tell us when that works.
0
 
LVL 3

Expert Comment

by:dagaz_de
Comment Utility
I t semms to me that you forget to Point to the folder itself:

File not found: /orders.cfc The specific sequence of files included or processed is: C:\inetpub\wwwroot\orders.cfc''

I think it has to be:
/florders/orders.cfc when you call the file
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 63

Expert Comment

by:Zvonko
Comment Utility
By the way, is the C:\\ a typo? Isn't it C:\
0
 

Author Comment

by:carsalsgal
Comment Utility
I put a file in the directory and it did not access it by doing http://www.mysite.com/florders/file.cfm
I got a http 404 error

HTTP Error 404 - File or directory not found.

It did access it after I mapped the florders to the same directory using IIS manager. Then I tried http://www.mysite.com/florders/orders.cfm and got the same error

File not found: /orders.cfc The specific sequence of files included or processed is: C:\inetpub\wwwroot\orders.cfc''

with the same cfc bind line
bind="cfc:florders.orders.getorders({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})"
0
 

Author Comment

by:carsalsgal
Comment Utility
FYI - I did find thhis on the Adobe CF8 Release notes on page 2. It describes the same issue. You would think there was a fix for it by now. The thing about this is I can not find an answer anywhere for the correct syntax to create a hard linked path inside the cfgrid for the bind option.

http://www.adobe.com/support/documentation/en/coldfusion/8/releasenotes.pdf

"69915 The cfajaxproxy tag is not able to correctly locate CFCs that are in symbolically
linked paths on the file system. Ensure that your CFCs are always available
under hard linked paths."
0
 
LVL 6

Expert Comment

by:reiters
Comment Utility
If you cant browse the CFC like this then neither can your grid.

http://mysite/cfc_location/orders.cfc?method=getorders&cfgridpage=1&cfgridpagesize=10&cfgridsortcolumn=orderID&cfgridsortdirection=0

I'm not sure what the right value is for cfgridsortdirection.  I switched my grids to jQuery so I can't look.
0
 

Author Comment

by:carsalsgal
Comment Utility
I can browse to the grid. I tried that also.
0
 

Author Comment

by:carsalsgal
Comment Utility
I guess no one knows the answer to this
0
 

Accepted Solution

by:
carsalsgal earned 0 total points
Comment Utility
If there is anyone else that has had this error, I finally found out the the cf 8.0.1 updater fixes it. Here is the  link to download it
http://www.adobe.com/support/coldfusion/downloads_updates.html
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Hi, Even though I have created this Tutorial on My personal Blog, Some people might not able to find my website, So here i am posting it again Today, from the topic it is very clear that i will be showing you here the very basic usage of how we …
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now