Solved

how to bind cfgrid to cfc in virtual directory

Posted on 2010-08-23
14
879 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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 
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

 Database Backup and Recovery Best Practices

Join Percona’s, Architect, Manjot Singh as he presents Database Backup and Recovery Best Practices (with a Focus on MySQL) on Thursday, July 27, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7). In the case of a failure, do you know how long it will take to restore your database?

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…
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

626 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