I have in the database two columns, one for picture_id and one for image. Then I want to show the image which the user sent into the database.
I am using sql server 2000, how should I write the code in asp so that it can show the image not the disordered characters on screen.
I have code as following but the output is disordered characters....
My problem is that the back button (IE) still takes me to the contents page after logout. I am a beginner, do not know much about security.
View Replies View RelatedHere is my code. I'm using 2 pages.
(Page 1) blob.asp
<%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_blob_STRING
Recordset1.Source = "SELECT AboutPic FROM Elizabeth.GF_AboutUs"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Response.contentType = "image/jpg" 'Recordset1.Fields("AboutPic") <---Tried
both methods
size = Recordset1.Fields("AboutPic").ActualSize
blob = Recordset1.Fields("AboutPic").GetChunk(size)
Response.binarywrite(blob)
%>
(Page 2 Show the Image)
<%
Dim urlString
urlString = "?" & Request.QueryString
%>
<% Another rs to show other information as text from the same table %>
<body>
<img src="blob.asp<%=urlString%>" width="194" height="256">
</body>
I'm currently working on a asp page that I want an image to show if its checked in my Access Database otherwise show nothing. The code I have doesnt give me any errors it just doesnt work. The image doesnt appear at all even if the value if checked or not
<% If (leaders.Fields.Item("moh").Value) = "Yes" Then
Response.Write("<img src=cpd_files/dintinctions/medalofhonor.gif>")
End If %>
In place of "Yes" ive tried Yes, True, "True", On, "On" and none of them work. This is an access database with the data type set to Yes/No.
I built a dynamic product catalog page and I need to pull from another recordset the header information. It works, except when it's undefined.
I tryed to write and if then statement, but it I couldn't figure out how the finish it..
If ((Recordset1.Fields.Item("HearderURL").Value) <> "") Then
Display the HeaderURL?
I'm trying to make a list of produkts, in this list I want to have an image of the produkt. the url from that img is stored in the database.. I want to make the list with a datalist because its better looking. how can I get the url from the DB in the ImageUrl tag.
I'm working in ASP.net and the DB is in ACCES.
I have a System.Drawing.Bitmap object in memory, now i want to show it as a normal picture in my ASP web page.
View Replies View RelatedI need to show an image in the header of an asp page. If the image's width
is greater then 82 pixels, the header gets mis-formed. If I specify the
height for the image and it is smaller then 82 pixels it gets stretched and
misformed.
How do I solve this? At first I planned to write a vb-dll that checks the
image's height but since the image come's as a BLOD from sql-server tat is
a no-go.
Can I find the original height in the binary data from the blob itself?
just needed help on how to backup files. how to create a ftp site.
View Replies View Relatedhow can i make that the page show only TOP 5 record in the database ?
View Replies View RelatedI have a problem with show all values from my database into my html page! Code:
View Replies View RelatedI have a strange problem. I have to show demo presentation in CD. In
this presentation record will be show from database. But we dont have
to install the database. any body can see the cd and can search the
data. how it is possible because the databse will not be installed in
CD and computer also.
how to show a drop down list with a selected value that is derived from the database? Is this correct? When I do this, it shows "Mastercard" always, even when its "Visa" in the database.
<select name="ccType">
<option value="Visa" selected="<%=rs("cardtype")%>" >Visa
<option value="Mastercard" selected="<%=rs("cardtype")%>">MasterCard
</select>
I have announcements down the left hand column of a site and want to display contact info if it is available - if it is entered into the database. So I only want to display a space plus the data if there is data in the field. Code:
View Replies View RelatedI have a form that submits values to an asp page. If their is an error on the asp page that is called and you go back to the first page with the form. The values are not in the form.
How can I set the value back into form without the user having to retype them in? If I use hidden fields on the first asp page and I go back to that page wouldn't the values for the hidden fields be empty as well?
Currently i have setup a form that takes the users information and drops the info into an access database and displays the info out the way i want it to.
After i take the info, i setup a seperate form to take in the users images of there choice that drops into a directory on my server, which works fine as well. What i am looking for though is a way to take the location of the image and drop that into another database or the same one so i can use it as a link when displaying the information.
I have two tables. ALPHA; fields
id (a text field, that contains a string)
image (a text field, that contains an url path for a file)
and BETA
id (a text field, that contains a string)
image (a field to insert an image)
I need to insert in BETA the information of field 'id' and the file that the field 'image' is pointing to. The url path of that file may me inside or outside my domain. For example, if the 'image' field says "pepe.com/image1.jpg", even if the ASP file is not in www.pepe.com domain.
Is there a way to do that?
I would like to be able to update an image I have stored in a database by uploading it through a form. The current pages I have now will only add a new entry to the database. I would like the customer to be able to change the image on their index page through the form. How can I change the following code to do that?
showPicture.asp ....
I want to upload my images in the database instead of storing them on the server.
View Replies View RelatedI want 2 upload a image and some text to the sql server database. and in anothere page i will retrieve all the fields . so can anybody help me.i am giving u the html source....
View Replies View RelatedI m trying to set up a form so that a user can isert a gif or jpeg image into a table in the database.
1) Can you please show me how to create a table in the database so that it accepts the images
2) I need to know how to actually browse to an image in hard drive and then insert it in the table
I'm building a path making tool, that is i have a network of paths for a park and each section of the path is its own image.
What i need to do is, when a certain piece of the path is clicked, it querys my path database and returns the information for that section of the path to a table.
Im designing in ASP VBscript and database is connected n all but im a beginner, is it feasable?
As well as this i need to be able to add to the table each time a piece of path is clicked, and also take away, like a stack.
AND aswell as this i need a seperate table which adds up the length of all the paths selected (length is in the database).
What is the best method to insert and retrive image to and from the database?
View Replies View Relatedi wanna check one cell value from database and then if cell value is 0 than put this image in the dynamic table, if it's 1 than put other image to dynamic table, and so on Code:
View Replies View RelatedI have created a website where users can place advertisements and upload complementing photos. I have elected to place the advertiser's contact details and advertisement in 1 table in an Access database and the corresponding photo and Account ID in a second linked table.
Once the photo is inserted as a BLOB, the advertiser is forwarded to the payments page. The upload page has a form with a file field and a hidden field with the Account ID which as been passed on the previous page by a session variable. The website is hosted on a remote server by my web host.
My problem is that the image and the Account ID are not inserted into the database even though the processing page successfully redirects to the payments page. I am new to web programming so I am unsure where my problem lies. Code:
I AM NOT ABLE TO DISPLAY IMAGES FROM ACCESS DATABASE JUST 11 BLACK IMAGE BOXES OF SIZE 400 X 250
Code:
sql="SELECT [IMAGES] FROM ITEMS"
rsAuthors.open sql, cnnNorthWind, 3, 3
%>
<%Set rsAuthors = cnnNorthWind.Execute(sql)
IF rsAuthors.EOF then 'No records found
Response.End
ELSE 'Display the contents
DO WHILE NOT rsAuthors.EOF
'Response.BinaryWrite(rsAuthors("IMAGES"))
%>
<img src="image/<%=rsAuthors("IMAGES")%>" height="400" width="250">
<%rsAuthors.MOVENEXT
LOOP
END IF
%>
how to upload image into the database ?
View Replies View Relatedi have a database..(pics.mdb)
1 table
pics(table name)
id,file,display(3 fields)
4 records..
1,pic1.jpg,yes
2,pic2.jpg,no
3,pic3.jpg,yes
4,pic4.jpg,yes
what line of code do i use on my asp page to display the picture where display is yes?
how to create an image gallery using a SQL database. I placed the images in the sql database and I want to display the image and then a caption under the image? Can anyone help me! I can only get it to display the first picture and the first caption? I want it to display all the images with a categoryID of 1.
View Replies View RelatedHow do I take an image from <IMG SRC>? Meaning I can not insert the image with the Upload method, I have to take it directly from the <IMG SRC>. Is there a possible way to do that?
View Replies View RelatedI need to upload image into a database. Can someone suggest where i can get sample codes or tutorial or any sort of assistance ?
View Replies View Relatedi am developing an application using ASP.I have to get product picture from user and store it in to database. i am getting the file path of the picture.
How to read this image and store it in database and retrieve it back for display in another page ?
Anyone there can help suggest to me where i can find out more about Inserting image into a database.
View Replies View Related