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.
Here 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 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....
I am trying to create a datalist that pulls from table A. When the user clicks on one of the rows in table A I want it to expand under that row and show the data from table B (one to many relationship).
Im not sure what is the best way to accomplish this. Is there a way to use the selecteditemindex to insert a new datalist ?
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?
I have a client who has had a ASP site with an Access database for several years. It stores information for the used cars on his lot. I have stored text in the database that points to the location of the image for each record. Each record will have a thumb image that is supposed to display in a list of vehicles available then the user can select an item from this list and a new page displays with the information and the regular size image. So far everything has worked fine exept for the display of the images which are stored in a separate directory called veh-photos. All I get are image place holders. I am using Dreamweaver 2004 and and Access 2000 for the database.
Following is the code to list vehicles: ....
1.I want to show a image file of type '.tif' in the browser window; for that I'm writting as ASP code page.
2.This '.tif' type image can be shown better with 'Kodak Image Control'.
3.To have this 'Kodak Image Control' on my code page I just add it's ..ocx to tool box and then drag it from 'Toolbox' to the page.
4.Now after dropping this control to the code it's type is getting changed to 'object' instead of type 'ImgEdit'(and I think this is the
reason I don't get correct result).
5.On one button's 'Onclick' event I'm calling a javascript function with which I'm setting a 'Path'and'Display' property of a control.
6.And want to show a image at location -- '..MFTDRCMF919685173-62.tif' which get shown in new browser window but could not get shown in that particular control. That means the path is correct, then what is the problem?
For better understanding of problem I'm pasting a following code which I've tried up till now......
..................................................
<%@ Language=VBScript %>
<% OPTION EXPLICIT %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<SCRIPT LANGUAGE=javascript>
<!--
function showpic()
{
var path;
path = document.frmtif.path.value;
alert(path);
document.frmtif.ImgEdit1.Image =path;
document.frmtif.ImgEdit1.Display;
window.parent.self.open(path);
}
//-->
</script>
</HEAD>
<BODY bgColor=#ffe4e1>
<form name="frmtif">
The Image
<P>
<OBJECT id=ImgEdit1 style="WIDTH: 409px; HEIGHT: 218px" type="ImgEdit"
align=left
border=1 classid=clsid:6D940280-9F11-11CE-83FD-02608C3EC08A
name=imgtif></OBJECT>
<input type="hidden" name="path"
value="..MFTDRCMF919685173-62.tif">
<input type="button" name="show" value="Show" onclick="showpic();">
</P>
</form>
</BODY>
</HTML>
..................................................
I am creating a dynamic ASP VBScript page, which gets data from an Access database.
In the database, there is a field which holds a URL to an image. I can get the image to display fine, but where there is no file that matches the URL (i.e. a missing image) I want to display an alternative, default image (e.g. one that says "Awaiting Image"). The field is never blank, but the image file may not exist for all records in the database.
I think what I am trying to get to is the following:
If file exists (using URL from database to get location of image file) then
display image using the url from the database as the image source
else
display default image - hardcoded in program
endif
I have had a go and come up with the attached but I get an error with my if statement...
I can convert an image that is retrieved from a FileUpload object into a byte array and insert it into the database..
When the user signs-up i wish tosimply insert into the Picture (DB Type = Image) field to an image i already have saved in my images folder?
Anyone know of a way to do this? Tutorials, articles or advise??!
I'm working on a project where I'm suppose to upload a image to a server. The uploading works fine but when I want to change the image I uploaded to another image I can't get the filepath of the old image to show in my "filefiled"....is it possible to set a "value" where I can retrieve a filepath in a form if the input type is "file"?
View Replies View Relatedis there a tutorial around anywhere that tells you how to change images on the page when a user selects from a select box
View Replies View RelatedI have a database of songs listed as Title, Artist,Description, DiscNo and TrackNo with a seperate record in that format for each song.What I would like to do is search through them for the Description, show only the disc numbers in the results.
This I can do easily. Where I am lost is that I only want each individual disc number to show once. If I moveNext through the recordset, it shows the disc number 15 times per disc. Is there a filter I can add to limit this display?
Is there any way to input .asp code so that a specific element isn't show on a page? example: I don't want a menu on a specific product page, but I want it on all the others. Is there any code to input into a site wide includes file to implement this?
View Replies View RelatedThis worked fine for enlarging my images until i put it onto a secure server, anyone know how i can fix it ??? just comes up with the standard box with a red cross in it .. and the url when i click image properties says: http://url/images/<%=request.querystring( which is only part of the code)
View Replies View RelatedI have a ASP application which let user to download their reports in pdf format. I would like to show a progress bar, or change the mouse cursor to a hourglass while the user is waiting for the file. How to acomplish this? In the asp code, I use response.BinaryWrite to create the pdf file directly to the browser. How to detect when the file is ready?
View Replies View RelatedI create a page which will show me all the Regions from the table "RegionTable" where I have no information (empty fields) in on of the fields RegionDescription or RegionRank.
It is to make my content managing easier. I do not want to see those records which contain all the necessary info (region description and rank).
I tried the following code, but it does not work
qry = "SELECT * FROM RegionTable WHERE RegionDescription="" AND RegionRank="" "
error message is:
([Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1)
I have a query that displays values from a db.
The problem is that the value displays like this:
R 6.5
instead of like this:
R 6.50
How would I get it to show the full value?
ok, well what I have been having some trouble with is to show the person character name like this:
Welcome, 'Username' <-- Here I want it to show the persons username from the database.
I am using a Cdonts e-mail script that e-mails the results of a form to my address. It currently displays the data like:
Amount: 12.00
Percent: 2.00
I need it to say:
Amount: $12.00
Percent: 2.00%
How can I get the $ and % symbols to be included in the e-mail template without getting a 500 error?
Here is what I have:
Body = Body & vbcrlf & "Amount: " & request.form("amount")
Body = Body & vbcrlf & "Percent: " & request.form("percent")
I've tried a few diffrent ways but here is one example:
Body = Body & vbcrlf & "Amount: $" & request.form("amount")
Body = Body & vbcrlf & "Percent: " & request.form("percent")%
I've tried using / before the symbols and "" but everything I've tried keeps coming up with a 500 error. How can I add these symbols to my template so they will show up in the e-mail?
I know we have this thread somewhere, but I can't seem
to find it now
I want to show the first 100 chars of a string, but
I don't want a word to be cut in half at the end, it must
show the whole word then and go a bit beyond 100 chars.
How do you print out all of the contents of an array if all you know is the array name?
FOr example, I am looking at pre existing code that looks like this:Code:
scartItem2 = session("cartItem")
arrCart2 = session("MyCart")
For Z = 0 to scartItem2
cartfields2="&Email=YES" & "&processed" & z & "=" & arrCart2(cProductid,z) & "&quantity=" & arrCart2(cQuantity,z)
What I need to find out is if there are ANY other elements other than cProductid AND cQuantity in this array and what their names would be so I can add them to the code.
I know that I could print out the values of the above by simply doing this:
response.write(cartfields2)
But how do I find out if there's a cFeature or any other element?
i have very strange error.i can not see some of the asp pages on my browser. when i
look from view source, all the source is there but browser does not show anything, just an empty page.
im looking to find out how can i make, when the pointer is over a link or picture without clickin on the link an small textbox(something like that) open and show the content of that link. for example in this forum when you go over a thread you can see the content.
View Replies View RelatedI have a ASP page that when a user clicks a link it uses a DLL to stamp a .pdf with a watermark and then display the .pdf in there web browser using the Adobe Reader. This all works fine.
if a user views a pdf and then modifes it if they click the link again it still shows the old version of the file. They have to hit there refresh button to show the changes. How can I make it so my page always displays the lastest version of the PDF and not what is in the cache?
i have a website that users log on to. On one of the pages is a form. What I want to do is only show a certain part of the form for specific users. The way i want to do this is by using their username as a 'show if' command in dreamweaver. What I currently have is this
<% If Session("MM_Username") = "union" %>
all data to be hidden shown is here
<% End If %>
But this doesnt work for me! Any suggestions on how to show this properly?
I want to show the currency like that xxx.00. In my database, i already set the type of column which i want to show to currency. However, the currency can no be shown as my expect. It only show like that XXX..
View Replies View RelatedIn one of my ASP page, I want to show the visitor's IP. Who can I do that?
View Replies View Relatedhow to show popup windows (html format) and the size is depending on the size of image?
View Replies View Relatedi m displaying only 4 lines of my main news..and after that there is one link more...if user click on this link then the detail of this news will display....but problem is i want to show the rest of content of this news at same place..i maen to say after clicking more it will display my main news content in place of 4 line and more link Code:
View Replies View RelatedI have some problems with how to show error message. Now I have two asp pages such as page "A" and page "B" and When I click a button on page "A" then the process will check conditions from page "B" ,so if there're some errors it will redirect to page "A" and show error message box.
I would like to know that how to show the message box?