Solved

how to bind cfgrid to cfc in virtual directory

Posted on 2010-08-23
14
873 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
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

 
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
 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ColdFusion Rereplace 3 81
DNS, website, godaddy 6 89
Ways to assess https/ssl websites 3 102
Using coldfusion <cfexecute> to restore mysql database 7 47
One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

840 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