Creating List Of Images From SQL Record
I'm building a simple image gallery. When I upload the photos, they all have the same filename except for an incremental number. For example:
photo_of_event_1.jpg
photo_of_event_2.jpg
photo_of_event_3.jpg
photo_of_event_4.jpg
I have a SQL table where enter in the filename "suffix" ("photo_of_event_") and then I enter a start number (1) and an ending number (4).
So, each gallery only has one record entry.
Now, I need some advise on how to take this record and generate a page that displays all three photos.
Is there a SQL statement that would generate an incrimental list of number (1,2,3,4 in this example?).
View Replies
ADVERTISEMENT
I have only been developing small sites using asp and Access database. I want to advance my skills and develop a large site. Basically, I need direction in relation to having a user set up an acct., and once set up, being able to upload images. FrontPage (dare I say it) has always enabled me to allow visitors to upload one image at a time, and then only to a specific directory. What I want is the ability to have someone upload a specified amount of images to a directory that is created when they opened their account. ie., /tom/images If anyone knows of of good tutorials on this, I sure would appreciate it. I also want the ability to check images file size and dimesions, and resize or reject if neccessary. Can I learn how to do this w/out buying some program online.
View Replies
View Related
I would like some advice on creating a wish list for our customers. We sell car part's and eventually would like to have a feature where a customer can add to a wish list or project list for their dream purchases. Basically, new to asp and would like an idea on how to approach this.
View Replies
View Related
I'm building a website and I want to include a mailing list. I just
want a form where a user could enter their email address, so I could
send them more information. I assume that the best way to do this is
with ASP. Right now, I'm learning ASP by testing pages using Abyss
web sever with Active HTML. I have XP Home, so I can't use IIS. Here
are my questions:
1. Is ASP the best way to create a mailing list
2. Can I just use excel for the database - not access
3. How do I connect to the database. I've read about using ODBC, but
I think that would only work when the web server is on my computer. If
I got someone to host the site for me, I don't think that would work.
4. Is there an easy way to mail to the names in the database?
View Replies
View Related
In my Access database I have multiple images for some of the records. What is the best way to retrieve and display the multiple images. I am storing the images in a folder and only the path in the DB. Some of them have just 1 image, some 2, some 3 and so on. I have the record ID # and the image name same, for eg. if the record id is R01 then the image name would be R01.jpg if there is only 1 image otherwise R01a.jpg, R01b.jpg, R01c.jpg etc. Is there any way I can open the folder and check for the name and list the image file names as a link to display the images if the ID name and image name matches.
View Replies
View Related
I have a tbl.pictures on my website, several of the columns have refferal links to images. Having read through another link on this site, apparently it's the best way to do it. (Keeping the images in file rather than on/in the database)
My problem is that when a photographer deletes a photograph from my database the image files remain on my server. For the moment its ok but long term when they delete the record I would also like the images to removed from my server.
Any ideas where I could start to look to do this?
View Replies
View Related
I'm creating an online shop which has an area showing the top ten best selling products. I'd like to generate the list of the best selling products from my OrdersDetail table (which is table showing listing purchases made on the site), ordered by the most popular at the top and the least popular at the bottom.
I thought if I could use the SQL DISTINCT command this would create a list of products without duplicates, then if I could COUNT them I'd generate a list of the most popular products in the OrdersDetails table. This nearly works but the list won't ORDER BY the COUNT column (I get an error). This is my code so far:
SELECT DISTINCT ProductDescription, COUNT(ProductDescription) AS bestSellers
FROM OrdersDetail
GROUP BY ProductDescription
View Replies
View Related
I am trying to creating a function to find a record that was entered in a database. I have created the add button with no problem and it works. The links are:
Text file
ASP file
When I placed the script in the code (lines #524 - #547), I now get an error message looking for an "end" statement. Before this everything worked fine. If I have and "else" statement after closing the form and and "else" statement after opening the recordset, I don't understand where I need the "end statement."
View Replies
View Related
How can i make the URL to be a link that is in record set (coming from the database)? Along with URL this field might alo contain some text message.
View Replies
View Related
How can i list out all the email address into my website from the hotmail caontact list? i am successful log in into the yahoo contact list by using serverxmlhttp and list out all the email address from the page source, but i could not access to hotmail by using the serverxmlhttp. Is any other methos can list out the email address from hotmail contact list?
View Replies
View Related
I'm getting this error message: Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'employees'. Code:
View Replies
View Related
My page have background image,on that image have more images and text. My problem is whenever resize browser that images are not resized and also not moved correct place .(i.e look not like before alignment).I want to do everything in dyanamic....
View Replies
View Related
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
View Replies
View Related
I have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
View Replies
View Related
I have an asp page that displays thumbnails from my database. I want the user to click on the thumnbnails to open up the larger image which is also stored in a DB.
View Replies
View Related
i am uploading 3 images(jpg) to sql server 2000 using asp 3.0.i was using this code
http://www.stardeveloper.com/articles/display.html?article=2001033101&page=1
which was working fine when i uploaded 2 images when i tried to upload 3 images its not working.i had posted in the forum earlier about this issue
since i work for a non profit organization who cant spend money on buying some component for uploading images is there any other way or any other code or a free component thats not going to expire
View Replies
View Related
I have an image page in which has a line of small images in a row. click on it it makes it larger below. The images aren't binary form, just the lnik to the image it self. I add the images in a form, so i type in 'image1.jpg' and then it adds it to the database, and then it routs to it and shows it in the database. Now on the image page which shows the image i want a little bit of writing below the image saying its properties. So when i add the image to the database i have to write about the image for example 'A picture of Joe Bloggs' and then when it veiws the image it will say that writing underneith
View Replies
View Related
ive been looking for a .net script that will upload an image to the server, but saved an optimised thumbnail into a different directory (or under a different name) with the main image being saved as usual.
can you run regular asp within a .net page? anyone got those .net friendly url/querystring scripts again, my NG browser doesnt go that far back.
View Replies
View Related
I am designing a website that is based from an Access database; in the database I have a table called "Categories" with fields called "Category" and "CategoryPic". On my index page I have coding to get the list of Categories, called rsCategories.
What I am attempting to do is create ASP code that would retrieve an associated GIF file from my images folder when a particular "Category" is chosen (ie. if you choose CategoryA from the recordset, then CategoryA.gif would appear on the page, CategoryB would retrieve CategoryB.gif, etc.). Can anyone kindly assist me in completing this one piece of code.
View Replies
View Related
anyone here got an idea on what codes am i going to use? I got a folder full of images (jpg) and I want my asp page to display those images.
View Replies
View Related
I currently use ASPImage and resize JPG files with no problem. How, though, do I resize GIF images? Is there a different component?
View Replies
View Related
I wanted to know that is there someway in ASP that I can generate images on-the-fly without using ne 3rd party component?? Like its possible in CGI-Perl to generate ne type of image on-the-fly, is there a way 2 that in ASP? OK, if the 3rd party components r the only way, then r there ne free ones available?
View Replies
View Related
Does anyone knows how to print images to a pringter connected on the Web Server (IIS) Machine using ASP?
View Replies
View Related
I've had some periodic problems on certain (intranet)servers where IIS seems
to be caching thing in an unexpected way, or is server cached pages where
new content is expected.
The first situation is where we have a standard Top + Left + Content
framset; the left frame contains a menu which shows standard options - when
the user logs in, extra menu options are available to them, depending on
their priveleges. The menu is generated from a DB in ASP, and when the user
logs in, Javascript is used to reload the page in the left frame - eg.
re-generate menu based on logged-in user.
This used to work on all servers, but at some point in time I found that
people were logging in but were stuck with the standard menu. If we
right-clicked in the menu and chose refresh, often the correct (eg expanded)
menu would be shown.
I'm not sure where the problem is IIS or could be controlled in ASP...
The second problem is on my development machine; when I browse to my
development copy of the intranet, I dont get the icons for each menu item.
However, when I browse to the live Intranet system, the correct graphics are
shown.....
View Replies
View Related
I am trying to get a feature to work on a clients website.
I am building a image library in ASP VB Script and I want the user to be
able to select the amount of images they view on the page.
eg. Images per page 12 - 16 - 32 - 64
So selecting 12 for example would only show 12 records.
I am using the Horizontal Looper extension to display my images in 4
columns.
Have anyone ever done this before or know of how to do it?
View Replies
View Related
Alright, so I'm experimenting with some asp, trying to make a dynamic page. My problem is such:
I have a bunch of images displayed on a page, and when I click one, I would like to create a cookie with a value associated to that image. Kinda like a catalogue. Here's my body thus far:
<form action="Browse.asp" method="get" name="View">
<input type="image" name="350-43730" src="SW.jpg">
<input type="image" name="787-48930" src="MO.gif">
</form>
<%
dim ID
ID=request.QueryString()
response.write(ID)
%>
The name is the ID number I'm trying to get from the image. How do I go about getting this?
View Replies
View Related
This is my scenario...I have three images that I want to put on a website that will change to one another constantly. There will be three table columns on the top that indicate what the available three images are. If the user's mouse hovers over one of the table cells, the image will immediately change to what the table cell corresponds, and the user will be able to click on either the table cell or the image to go to another website.
I have included an image to better illustrate what I am talking about.
image
What is the best scripting language to do this? javascript, css, asp, flash?
All of the above seems hard to me, especially the last two....
View Replies
View Related
I made a program which exports a file asp to Excel file, but export included of the images, and I want an export without images.
View Replies
View Related
is there sombody who can helpme witht he following, i am ''pretty new'' to
php and am looking for a script to show images randomly at a 10/ 15 seconds
interval. is there anybody who can help me with this or does know where to
find a good template script for this?
View Replies
View Related
I'm using ADODB objects to download the images. Is there any way I can disable 'Save' option on a prompt. Also, when display the image (it could be any of the following files: .doc, xls, txt, pdf...), I need to disable 'Save' option or hide the toolbar.
View Replies
View Related
Does anyone know how I can place ALT tags on images which are driven by ASP and a database. (So each image has a separate alt tag).
e.g.
This is a image of a ball
This is a image of a Boot
View Replies
View Related
Why all of this javascript and css image preloading.
IE has picked up on the CSS hidden-preloading and doesn't see to pull the image if it is 'hidden' and the javascript way is ok
why not this though?
<img src="/image.jpg" height="0" width="0"> .....
View Replies
View Related
Why do sites dragged in through XMLHTTP only download half or so of the images associated with the site?
View Replies
View Related