Skip to main content
N
noa2
Participant
November 4, 2008
Question

connecting database in dreamweaver to coldfusion

  • November 4, 2008
  • 2 replies
  • 735 views
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 ?
This topic has been closed for replies.

2 replies

D
Daverms
Inspiring
November 10, 2008
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...
A
Abinidi
Inspiring
November 5, 2008
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
N
noa2Author
Participant
November 5, 2008
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
A
Abinidi
Inspiring
November 5, 2008
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?
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices