Forums
This topic is locked
Binding problem using ColdFusion & MSSQLserver2000
Posted 27 Oct 2004 04:10:14
1
has voted
27 Oct 2004 04:10:14 alex campbell posted:
Using Dreamweaver MX2004, I have a simple (.asp) page containing a form populated with fields from a SQLServer2000 recordset. When I test the recordset by clicking the test button within the “bindings” window, the data displays fine, yet when I run <F12> the page, I get the fields populated with things like: <%=(rsCategories_total)%>
Environment used:
-------------------------
I setup the site using :
1) Remote Info & Testing Server access = LOCAL/Network, with server model = Coldfusion
and with the appropriate directory paths and :8500 based URL.
2) Everything including the SQLserver database sits locally on a single laptop.
3) I’m using the Coldfusion 6.1 developer edition.
A further clue, is that another page within the same site, uses a flash movie embedded within the HTML page, which can successfully access & display the same SQLserver data via the Flash remoting and the same Coldfusion.
Can anyone please explain why I can access the data to bind when testing, but not when running in the browser (IE6)? I have “PUT” the whole site before running – but still no sign of proper data binding
Any help, much appreciated
Replies
Replied 27 Oct 2004 12:03:20
27 Oct 2004 12:03:20 alex campbell replied:
Silly me! I've just realized that with the CF server, I should have used the (.cfm) extension and not the (.asp) one.