Query.asp -
<%@ LANGUAGE="VBSCRIPT" %>
-
<!-- #include file="../../includes/dbconn.asp"-->
-
<%
-
dim MyRs, sqlstr, MyConn
-
-
Response.Expires = 0
-
Response.Buffer = TRUE
-
Response.Clear
-
Response.ContentType = "image/gif"
-
-
Set MyConn = Server.CreateObject("ADODB.Connection")
-
MyConn.Open dbConn
-
Set MyRs = Server.CreateObject("ADODB.Recordset")
-
-
sqlstr="select img from img"
-
MyRs.Open sqlstr, MyConn, adOpenKeyset, adLockOptimistic
-
Response.BinaryWrite MyRs("img")
-
Response.End
-
-
MyRs.Close
-
MyConn.Close
-
-
set MyRs=nothing
-
set MyConn= nothing
-
%>
Main.asp -
<HTML>
-
<HEAD><TITLE>Display Image</TITLE></HEAD>
-
<BODY>
-
This page will display the image New Moon Books from a SQL Server
-
image field.<BR>
-
<IMG SRC="Query.ASP">
-
</BODY>
-
</HTML>
why can't display, really dunno what to do
7  4197 
Hi Alex,
Try changing the SQL query as follows: - SELECT [img].[img] FROM [img];
SQL does not like parent and child objects (the child/ren field/s of the parent table) to have identical names as it can confuse things.
The square brackets should act as field name delimiters so the first lot of text in square brackets identifies the table name, followed by the field name.
Failing that, rename the image binary data field to something different, for example ImgData and let us know how you get on.
You also were calling your SQL statement twice - using the Open command with a SQL string as a parameter automatically executes the SQL and returns the results. I removed the line where you used MyRs.Execute.
And finally, simple question - but do you have any image data stored in your database at present?
Best regards,
medicineworker
Hi Alex,
Try changing the SQL query as follows:
- SELECT [img].[img] FROM [img];
SQL does not like parent and child objects (the child/ren field/s of the parent table) to have identical names as it can confuse things.
The square brackets should act as field name delimiters so the first lot of text in square brackets identifies the table name, followed by the field name.
Failing that, rename the image binary data field to something different, for example ImgData and let us know how you get on.
You also were calling your SQL statement twice - using the Open command with a SQL string as a parameter automatically executes the SQL and returns the results. I removed the line where you used MyRs.Execute.
And finally, simple question - but do you have any image data stored in your database at present?
Best regards,
medicineworker
I have fields with named id (int),img (BLOB) in my table called img.It is correct? and I manually insert a picture through the MySQL yog(db administration interface)
Hi Alex
I have fields with named id (int),img (BLOB) in my table called img.It is correct?
As mentioned previously, add the square braces and the full-stop, and rename the "img" field to ensure that MySQL is reading the query correctly, otherwise it will be interpreted as "SELECT myTable FROM myTable" - as we all know you can't select a table from a table, so by definition it's not correct.
medicineworker
Heya, Alex.
The exciting part of computer programming is getting a machine that does exactly what you tell it to do... to do what you want it to do.
You set up your table correctly, and your query looks right... but the server is misinterpreting it. Try adding the proper delimiters to eliminate the possibility of ambiguity in your query.
Hi Alex
As mentioned previously, add the square braces and the full-stop, and rename the "img" field to ensure that MySQL is reading the query correctly, otherwise it will be interpreted as "SELECT myTable FROM myTable" - as we all know you can't select a table from a table, so by definition it's not correct.
medicineworker
Display.asp -
<HTML>
-
<HEAD><TITLE>Display Image</TITLE></HEAD>
-
<BODY>
-
<IMG SRC="Query.asp">
-
</BODY>
-
</HTML>
Query.asp -
<%@ LANGUAGE="VBSCRIPT" %>
-
<!-- #include file="../../includes/dbconn.asp"-->
-
<%
-
dim MyRs, sqlstr, MyConn
-
-
Response.Expires = 0
-
Response.Buffer = TRUE
-
Response.Clear
-
Response.ContentType = "image/gif"
-
-
Set MyConn = Server.CreateObject("ADODB.Connection")
-
MyConn.Open dbConn
-
Set MyRs = Server.CreateObject("ADODB.Recordset")
-
-
sqlstr="select file from img"
-
MyRs.Open sqlstr, MyConn, adOpenKeyset, adLockOptimistic
-
Response.BinaryWrite MyRs("file")
-
Response.End
-
-
MyRs.Close
-
MyConn.Close
-
-
set MyRs=nothing
-
set MyConn= nothing
-
%>
My table is called img with fields id(int) and file (blob) . It's correct? why i still can't display.Thanks
hi, i was wandering....can you match the picture name with table primary key, so for my project i want to display a picture which also mathces with the primary key with a record, and display it on the screen, automatically.
as when users click the menu from pictures menu, the code automatiicaly does this, and beside the picture i want to display the record details.
thanks....
ok i guess nobody knows how to do it
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Alper Adatoz |
last post by:
Hi,
i have a little problem. i hope u guys give me a clear solution (:
db: mssql
i just want to put jpeg file to the image field at the mssql db.
and after that i want to call it back..
|
by: Dan Anderson |
last post by:
I have created a BLOB field to store images. Is there any way to embed
them within HTML with something like:
<image start: jpeg>
</image>
Thanks in advance,
Dan
|
by: david |
last post by:
Hi,
I have asp pages running from a MySQL database.
I have placed a path in the required field (although not quite sure on
the correct format).
My asp page is just displaying the text path...
|
by: John Smith |
last post by:
I know that uploading an image to a database has been covered, oh, about 3
trillion times. However, I haven't found anything covering uploading to a
MySQL database with .net. Please don't...
|
by: Objectifnet |
last post by:
What I really want to do is to be able to link two pages together using an ID, The table involved displays an image stored on the File Server that has the image details stored in the Database called....
|
by: cybervigilante |
last post by:
I can't seem to change the include path on my local winmachine no
matter what I do. It comes up as
includ_path .;C:\php5\pear in phpinfo() but there is no such file. I
installed the WAMP package...
|
by: tanyali |
last post by:
my .png files r stored as a blob in MySql,
I wanna to display them out in php through a web browser.
this is part of code (in php):
---after connect to database ,
$dbQuery=" select name,...
|
by: mirianCalin |
last post by:
i am doing a site for appliance center..
i need to display all the products that the company offers, but my problem is that i cant display ALL the images in my database.. the first entry on the...
|
by: msmjsuarez |
last post by:
how can i display both image and other information in the web page using php?
i'm using mysql database.
I do displaying the image only but i want to display both other information from the database...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
