The path to Cold Fusion depends on your setup. If you
installed Cold Fusion
to run atop IIS, then it would be
C:\Inetpub\wwwroot\nameofsite. If you
installed Cold Fusion as a standalone, then it would be
C:\CFusionMX7\wwwroot\nameofsite
The query itself would not contain the path to the database
.. that should
be SELECT whatever FROM tablename ..finish query.
In Cold Fusion, you have to have the data source set up in
the Cold Fusion
Administrator .. did you do that?
--
Nancy Gill
Adobe Community Expert
BLOG:
http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August,
2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004:
A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP
Web Development
"tjones" <webforumsuser@macromedia.com> wrote in
message
news:eajdse$bqc$1@forums.macromedia.com...
>I tried to follow the tutorial at
>
http://www.adobe.com/devnet/coldfusion/articles/connecting_database.html.
> I'm
> used to asp and asp.net but I'm tring to get into cold
fusion. When I
> specify
> the database file as described in the tutorial, the
tables come up as
>
C:\Inetpub\wwwroot\MyColdFusion\data\MySource.Distributor. And, the
final
> select query is SELECT Distributor_ID, Distributor_Name
> FROM
C:\Inetpub\wwwroot\MyColdFusion\data\MySource.Distributor
> ORDER BY Distributor_ID ASC
> Why is it putting in the full path to the database? I
tried to go to
> advanced
> settings and giving it an actual connection string, but
it still asked for
> a
> database file path.
>
1
Reply
AdChoices