connecting database in dreamweaver to coldfusion

[noa2]

i did access database. i created site with all the files and images. i did the connection from coldfusion to the database in dreamweaver through the "datasources " in the coldfusion administrator, but when i try to make the page appear by clicking view - live data i get this message: "dreamweaver couldn't convert properly the live page from the server". can someone help me ?

[Abinidi]

Without seeing your actual code that you are doing your query, it's kinda hard to tell.

Post up your code to how you are doing your database query and we can take a look

[noa2]

here are the codes:
<cfquery name="artwork" datasource="cftutorial">
SELECT FIRSTNAME, LASTNAME, ARTNAME, DESCRIPTION, PRICE, LARGEIMAGE, ISSOLD, MEDIATYPE
FROM ARTISTS, ART, MEDIA
WHERE ARTISTS.ARTISTID = ART.ARTISTID
AND ART.MEDIAID = MEDIA.MEDIAID
</cfquery>
<cfdump var="#artwork#">
and then:
<table border="0" cellpadding="15" cellspacing="0" bgcolor="#FFFFFF">
<cfoutput query="artwork">
<cfif artwork.currentrow mod 3 eq 1>
<tr>
</cfif>
<td valign="top" align="center" width="200">
<img src="images/#artwork.largeImage#" width="200" height="200"><br>
<strong>#artwork.artName#</strong><br>
Artist: #artwork.firstName# #artwork.lastName#<br>
Price: #artwork.price#<br>
#artwork.mediaType# - #artwork.description#<br>
<font color="##FF0000">#artwork.isSold#</font>
</td>
<cfif artwork.currentrow mod 3 eq 0>
</tr>
</cfif>
</cfoutput>
</table>

thank you in advance

[Abinidi]

What happens when you actually run the page in the browser?

Code looks fine. Is RDS setup on the coldfusion server and DW is able to do queries from it?

[noa2]

i did activate the rds. i don't understand what it means dreamweaver is able to do queries from it. but when i run the page in the browser i see the table and then the pictures and last a list of debugging in information which i think should not appear at all.
please help me.

[Newsgroup_User]

which DW version are you using?

to not show debug output at the end of your pages, disable it in CF
Administrator.

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

[noa2]

thank you Azadi. DW is 8. and i did what you told me and debugging information dissappeared.

but the problem with the instructions: view - live data as i mentioned above still remains. what did i do wrong ?.

also is there a guide book for dreamweaver and coldfusion ? what i need to do is that database table images will be link to: 1. another table fields. 2. another images.
thank you in advance.

[Daverms]

May be you can clear the cached files by,

Choosing Edit > Preferences > Preview in Browser and then unchecking the "Preview using temporary file option."

But I am not sure whether it will solve your issue or not...