Ask a Question related to Coldfusion Database Access, Design and Development.
-
Moe #1
Fetching Images from MS Access to Dreamweaver via Coldfusion
I'm trying to make a web application which would fetch data from MS access
and display in website, if need I can upload into the DB at one point.
I have a DB in MS access which has a table in which I have column with
images and others are text colums
Table format:
COLUMN NUMBER COLUMN TXT COLUMN TXT COLUMN OLE COLUMN OLE
Datatype OLE in MS Access and it contains pictures. Using ColdFusion with
ODBC connectivity to connect.
I am using Dreamweaver MX and trying to fetch the whole table. there is no
problem with the TXT columns however the pictures are not coming up.
What do i need to do to fetch the pictures and display in the website.
Below is my example that i'm working on, please assist if can. Thank you.
<cfquery name="Cars" datasource="db1">
SELECT *
FROM Car
</cfquery>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Test Doc</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
..style1 {font-family: Arial, Helvetica, sans-serif}
..style2 {font-family: "Times New Roman", Times, serif}
-->
</style>
</head>
<body>
<table border="1" class="style2">
<tr>
<td>car_id</h3></td>
<td><h3 class="style2">car_make</h3></td>
<td><h3 class="style2">car_model</h3></td>
<td><h3 class="style2">car_ex</h3></td>
<td><h3 class="style2">car_year</h3></td>
<td><h3 class="style2">car_picture</h3></td>
<td><h3 class="style2">car_detail</h3></td>
</tr>
<cfoutput query="Cars">
<tr>
<td>#Cars.car_id#</td>
<td><h5><a href="detail.cfm?car_id=#car_id#"
target="_self">#Cars.car_make#</a></h5></td>
<td><h5>#Cars.car_model#</h5></td>
<td><h5>#Cars.car_ex#</h5></td>
<td><h5>#Cars.car_year#</h5></td>
<td align="left"><h5>#Cars.car_picture#</h5></td> <!--- PICTURES
FAILED TO APPEAR INSTEAD RECEIVED ERROR -->
<td align="left"><h5>#Cars.car_picture01#</h5></td><!--- PICTURES
FAILED TO APPEAR INSTEAD RECEIVED ERROR -->
<td><h5>#Cars.car_detail#</h5></td>
</tr>
</cfoutput>
</table>
</body>
</html>
Moe Guest
-
Dreamweaver 8& Coldfusion MX 7
Can somebody help? When using Dreamweaver 8 without the Coldfusion MX 7 extensions I can use cfform, but can't see the datasources. However, when I... -
coldfusion with dreamweaver
i recently used the coldfusion mx and dreamweaver. I already verify my database to connect into dreamweaver using the sql statement.but's still... -
New to Coldfusion..trying to set up with Dreamweaver
Hi, IMy name is Tim and I started teaching myself Coldfusion 2 days ago, with no prior experience with dynamic pages, webservers or anything of the... -
Dreamweaver Coldfusion DB2
I am working with Dreamweaver MX, Coldfusion MX, and DB2 8.1. Trying to connect dreamweaver via coldfusion to db2, so far I am not able to connect... -
Dreamweaver and Coldfusion
Hi there, I've recently started trying to use coldfusion with Dreamweaver and was wondering about the coldfusion info showing up inside Dreamweaver... -
Moe #2 Fetching Images from MS Access to Dreamweaver via Coldfusion
I'm trying to make a web application which would fetch data from MS access
and display in website, if need I can upload into the DB at one point.
I have a DB in MS access which has a table in which I have column with
images and others are text colums
Table format:
COLUMN NUMBER COLUMN TXT COLUMN TXT COLUMN OLE COLUMN OLE
Datatype OLE in MS Access and it contains pictures. Using ColdFusion with
ODBC connectivity to connect.
I am using Dreamweaver MX and trying to fetch the whole table. there is no
problem with the TXT columns however the pictures are not coming up.
What do i need to do to fetch the pictures and display in the website.
Below is my example that i'm working on, please assist if can. Thank you.
<cfquery name="Cars" datasource="db1">
SELECT *
FROM Car
</cfquery>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Test Doc</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
..style1 {font-family: Arial, Helvetica, sans-serif}
..style2 {font-family: "Times New Roman", Times, serif}
-->
</style>
</head>
<body>
<table border="1" class="style2">
<tr>
<td>car_id</h3></td>
<td><h3 class="style2">car_make</h3></td>
<td><h3 class="style2">car_model</h3></td>
<td><h3 class="style2">car_ex</h3></td>
<td><h3 class="style2">car_year</h3></td>
<td><h3 class="style2">car_picture</h3></td>
<td><h3 class="style2">car_detail</h3></td>
</tr>
<cfoutput query="Cars">
<tr>
<td>#Cars.car_id#</td>
<td><h5><a href="detail.cfm?car_id=#car_id#"
target="_self">#Cars.car_make#</a></h5></td>
<td><h5>#Cars.car_model#</h5></td>
<td><h5>#Cars.car_ex#</h5></td>
<td><h5>#Cars.car_year#</h5></td>
<td align="left"><h5>#Cars.car_picture#</h5></td> <!--- PICTURES
FAILED TO APPEAR INSTEAD RECEIVED ERROR -->
<td align="left"><h5>#Cars.car_picture01#</h5></td><!--- PICTURES
FAILED TO APPEAR INSTEAD RECEIVED ERROR -->
<td><h5>#Cars.car_detail#</h5></td>
</tr>
</cfoutput>
</table>
</body>
</html>
Moe Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
