Solved

how to bind cfgrid to cfc in virtual directory

Posted on 2010-08-23
14
871 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
ID: 33505733
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
ID: 33505853
Hi, I tried using cf mapping earlier and that did not work either.
0
 

Author Comment

by:carsalsgal
ID: 33505922
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
ID: 33507014
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
ID: 33507105
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
ID: 33508168
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
ID: 33508913
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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 63

Expert Comment

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

Author Comment

by:carsalsgal
ID: 33512254
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
ID: 33512320
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
ID: 33522898
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
ID: 33523012
I can browse to the grid. I tried that also.
0
 

Author Comment

by:carsalsgal
ID: 33537869
I guess no one knows the answer to this
0
 

Accepted Solution

by:
carsalsgal earned 0 total points
ID: 33668293
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

New My Cloud Pro Series - organize everything!

With space to keep virtually everything, the My Cloud Pro Series offers your team the network storage to edit, save and share production files from anywhere with an internet connection. Compatible with both Mac and PC, you're able to protect your content regardless of OS.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi. There are several upload tutorials using jquery and coldfusion. I found a very interesting one here Upload Your Files using Jquery & ColdFusion and Preview them (http://www.randhawaworld.com/) . I did keep the main js functions but made sever…
I spent nearly three days trying to figure out how incorporate OAuth in Coldfusion for the Eventful API. Hopefully, this article will allow Coldfusion Programmers to buzz through the API when they need to. Basically, what this script does is authori…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

911 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

23 Experts available now in Live!

Get 1:1 Help Now