EasyCFM.COM ColdFusion Forums / MS SQL Server Related Issues / Binding problem using ColdFusion & MS SQLserver2k

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Binding problem using ColdFusion & MS SQLserver2k

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

campbela
10-26-2004 @ 8:38 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 7
Joined: Oct 2004

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


campbela
10-27-2004 @ 4:59 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 7
Joined: Oct 2004

Silly me! I've just realized that with the CF server, I should have used the (.cfm) extension and not the (.asp) one.


Website Designed and Developed by Pablo Varando.