Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

how to bind cfgrid to cfc in virtual directory

Posted on 2010-08-23
14
Medium Priority
?
880 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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

Plesk WordPress Toolkit

Plesk's WordPress Toolkit allows server administrators, resellers and customers to manage their WordPress instances, enabling a variety of development workflows for WordPress admins of all skill levels, from beginners to pros.

See why 2/3 of Plesk servers use it.

Question has a verified solution.

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

Hi, I will be creating today a basic tutorial on how we can create a Mail Custom Function and use it where ever we want. The main advantage about creating a custom function is that we can accommodate a range of arguments to pass to the Function and …
What You Need to Know when Searching for a Webhost Provider
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

715 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