I'm new to ASP and a few querys
I have created my database in Access with the following fields
StockCode (Text Box, Primary Key)
Item (Memo)
Price (currency)
Picture (memo)
OnOffer (Yes/No)
and I know that access table cannot have a picture in it, only a access
form using OLE, but how do I get my asp page to display a picture for
every record? The picture would be a picture of the product with the
Stockcode as the filename - m001110.jpg?
I'm looking for a script that lets me add certain images from a directory (from like a drop down menu) plus add text (through like a text field) to a html file which would be saved in a directory. So I could then go and open the html file and the new text would be there with the embedded images.
View Replies View Relatednow I want to send a picture in my e-mails that are send using asp code
first I create the mail Object: Set objMail =
Server.CreateObject("CDONTS.NewMail")
After I fill a variable with the html code that will be the mail
txtMailBody = "<html>"
txtMailBody = txtMailBody & "<center>Hi <BR> This is a test"
txtMailBody = txtMailBody & "<center><img src='CommAd.jpg'>"
finally I send the mail using the following code:
objMail.Body = txtMailBody
objMail.Send
Anybody want to make this easy for me and show me how to upload pictures using ASP?
Users enter information through a form and it will be sent to a database (including the image name), but I need to upload the image as well.
I have a web page that displays properties for sale. The web page links to a database.
The page shows information in the database and the path to the picture.
The code is:
<p><img border="0" src="file:///D:/HousePics/<%response.write
rsData("id")%>.jpg" width="350" height="262"></p>
the rsData("id")% gives the name of the picture file and appends .jpg to it.
When I browse the page on the local machine the page displays ok and the
graphics show up ok.
When I browse to the page at work the grpahics don't show.
Permissions on the folder 'everyone full control', web sharing is enable
for the site.
This code displays all the pictures in a defined folder as thumbnails. That works fine. But I would like to have it roll over onto a new page after a certain number of thumbs have been displayed and a back forward message. Code:
View Replies View RelatedI have created a rtf document using java which also contains the image.I am including the images in Hexadecimal Form. I am able to view the document with images properly in word 2002. But same document if I open with word 2000, I am not able to view the images.I am including the images using following command
{pictwmetafile8picwNpichN
Hexadecimal data of picture
}
Where N is long integer used to specify height and width of image.Can any body tell me what is problem with this command. I am including JPEG, JPG, BMP,PNG images in hexadecimal.
I am looking for code which can rotate pictures without refreshing the page. I want to read randomly selected 5 images from database and then keep on rotating them every 5 seconds.
View Replies View RelatedI have a site with galleries of pictures and I want to add a logo watermark on them. How can I do it with ASP?
View Replies View RelatedI have this page where I want to display 3 random pictures in a vertical table. Each picture represents a record in an Access database. The field "picname" holds the name of the picture (e.g. "pic1.jpg", "pic2.jpg", etc). Each record has a unique ID. How do I go about selecting these 3 records? I want the pictures to alternate everytime someone enters the page or refreshes it. I found a couple of javascript options, but they only choose the picture from within a folder, and I need to be able to link the pictures to each record.I don't know if I made myself clear enough.
View Replies View RelatedI have an upload facility which is working fine. uploads to a folder (photos) through aspsmartupload and database. Ive checked the folder, n database to see if the file is being uploaded and it is.
ITs just not being displayed properly on the site. ALl the pictures come up with a little white box with a red cross in it, in the top left had corner.. so its identidied as an image , but its not showing the actual image. .
Can anyone tell me the simplest easiest way to upload pictures to a directory. It's for a content management page - text boxes for new record information and a file browse form box for the picture
View Replies View RelatedI have this page/form in asp that connects to my ms access database that I would like to have it either a) upload a picture or b) display the picture if one's already uploaded. I'm looking for direction on this and have no idea where to begin or even what's what. Can I upload a picture into the database?
View Replies View RelatedI have uploaded several pictures from my computer to the server. I know the file names and paths, I want to allow users to be able to see these pictures. How can I display them or better have a slide show of my pictures using ASP codes. I know there are many good JavaScript available. Is there a VBScript (ASP code) available for this?
View Replies View RelatedI don't know a thing about asp, but I want people to be able to upload their picture to me.
I've tried various codes but none of them seem to be working. Is there some kind of program I need to get to enable it (if so, a free one?). Also, I want it to fit in with the rest of my form which is built in html as of now, but I'll switch it to asp once I get the code working. Here's the form.
how to insert pictures into Word Documents using
Response.ContentType="application/MSWord" ?
Been trying this for ages, but can't seem to do it.
I have a form on my asp page that sends data to an emailing script. I am working with other peoples code which is causing a lot of hassle. Is there any way of sending a Bcc address command from the form rather than the emailing script?
View Replies View RelatedI wanted to know how I should go about doing this. I have this query:
SQLmax="SELECT Max(OrderNumber) AS intTotal FROM Status"
Which gives the Max(OrderNumber).Say in this case it is giving out put as 37.
Now i want the output to be displayed 38,which can be done by adding 1 to Max(OrderNumber).
Should i get this by doing this way?
var=RS(intTotal)
var=var+1
Response.WRite var
Is this right?
Im using this code to pass a value to a variable:
<a href="Artists.asp?cat=<%=Server.URLEncode( rsuser( "art_Artist" ) )%>"> <%=rsuser( "art_Artist" )%></a>
How do I add another value to this link with the variable name catArt so that I can add:
?catArt=<%=Server.URLEncode( rsuser( "art_Artist" ) )%>
what do you think is the best way to implement an "add new row to table" functionalilty?
am using asp(obviously )im currently using document.createElement with javascript, but im having a hard time retrieving the data.am also thinking if this is really the best way to do this.or if this would work with all other browsers other than IE...
how to add a password to using this connection string
<%
set conn = server.createobject ("ADODB.connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("dat48372.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
SQL = "SELECT Price FROM DABRadios WHERE (ID LIKE 6)"
rs.Open SQL, conn
showall=true
%>
i have a id1 field which has data like this 002,003,004 and i have to increment it by one when i add a new customer so this is what i do
Set rs1 = Server.CreateObject("ADODB.Recordset")
sql1="Select Max(id1) from table2"
rs1.Open sql1, Conn ,2,2
maxid=rs1(0)
so i get the maxid for example as 003. the next record will be added and it should be 004 and i do it in this way maxid= maxid+1
but when the record is added the id1 field has a value of 4 instead of 004
Say I have to different recordsets that have the fields:
rsA.Fields.Item("A").Value ,rsB.Fields.Item("B").Value
How would I add those to fields? It may be my inexperience but when I
tried something like
rsA.Fields.Item("A").Value + rsB.Fields.Item("B").Value
didnt work because one of the fields was a empty value. I have about
6 fields i need to add together if a value exists in any of them.
Suggestions?
I want to fix this problem, i dont no how. Bassicly there is blank data appearing in my database, for no apparant reason! Code:
View Replies View RelatedHow can I add a new user on my server using ASP?
User example: myserver/user1
I have an ASP page with a table that fills with records from a loop. Every
row gets a link to another ASP page with data from the row. The link is
written as <a href=newpage.asp?value1=xx&value2=yy .... and so on.
Now I try to let the user specify a number that should be sent to the other
page. But I do not want to clutter up every row with each an input field,
so I thought instead I would place it above all the data rows. When the user
clicks on the link, I want to include the input field to the querysting. The
problem here is that I cannot figure out how to refer to the name of the
input field.
I have just finished building my first shopping cart in asp and MS Access. Originally the shopping cart was to be built for products with no size and colour, however as usual the goal posts have moved and I now need to incorporate a size and colour option for each product. Could anyone explain to me how I can go about doing this i.e. adding the different sizes and colours in the admin website and then linking them to a specific product when it is displayed on the products page? I know they both need to be in a dynamic drop down box when displayed on the products page within the shopping cart, but I am just wondering how to read the correct values out from the table depending on which product is being displayed. I have a normal products table at the moment with general fields i.e ID, name, description etc.
View Replies View RelatedI have a web page hosted by server1. I need to add a link to a web page hosted by server2. This part is simple. However, I also need to give the linked web page the user id for the user that was validated in server1 (it's in a session variable).
At first, I thought the following would work:
mywebpageonserver1.asp:
Response.AddHeader "MYUSERID", "whatever"
Response.Redirect "http://server2/mywebpageonserver2.asp"
On server2, mywebpageonserver2.asp:
i have a page that enters numbers stored in different values e.g monday tuesday wednesday thursday friday into a database. is it possible in asp to add those values up and store the added up value in a seperate field in the database
bascially
total =monday+tuesday+wednesday+thursday+friday
How would i do that in asp.
I am using Dreamweaver MX to create ASP and MS SQL Server for database. I got a few fields like Value1 - Value5. So i have create the recordset of the 5 fields and i am extracting the total count of each field. Now i got 5 recordsets showing the total of each field. So is it possible to add the value of the 5 recordset together into one value? And is it possible to use the value of the recordset to do some simple math addition, subtraction, multiplication and division?
View Replies View RelatedI need to add a ppicture to my Database.. The table is accessed through ASP Recordset but having troubles trying to insert an individual picture to each record?
View Replies View RelatedI have a table with 2 fields, name and value
I need to be able to add multiple records quickly, for example I need to add
name value
abc 1
abc 2
abc 3
abc 4
abc 5
abc 6
etc etc, does each record have to be added separately, or is there a way I
can add a chosen number of records, lets say 10, and have the value field
increase by one each time?
sometimes I might have 30+ simple records that need adding quickly, and each
time the first records value will be one, and each record after will
increase by one, is there a way to solve this problem or does each record
have to be added separately?
i have a variable in a database that is looping that outputs numbers like:
1. 45
2. 34
3. 94
4. 34
But are all in the same variable:
DoDateTime((rsBoxEdit.Fields.Item("").Value), 3, 2057)
How can i make it so that it loops that variable and adds the numbers up and outputs 1 variable called total or something?