Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - A polite request for help...
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

A polite request for help...
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
slave View Drop Down
Newbie
Newbie


Joined: 08 February 2003
Location: England
Status: Offline
Points: 29 		Post Options Post Options   Thanks (0) Thanks(0)   Quote slave Quote  Post ReplyReply Direct Link To This Post Topic: A polite request for help...
    Posted: 27 February 2003 at 4:07pm

Hi, I need a spot of help... You can skip the pre-amble story if you like... by the way, i'm relatively new to this but i have little bit of knowledge...

I'm currently putting together a small website for a photographer and I'm doing it using ASP/Access so she can upload the photos herself and i don't have to be messing about with it every five minutes whenever she's taken a new pic...

It will basically be a frame on the left with some thumbnails (generated by ASPJpeg, I sussed that out, eventually) which, originally, she wanted the ordered by the date she uploaded them (which was easy enough as i just got it to datestamp the record in the DB)

However... she now wants to be able to change the order of the thumbnails herself which, at first, i thought would be kinda simple...

I added a 'picorder' field to the DB which was set up as a 'number' and i planned on setting up a page for her which would put all the thumbs into a list with a textbox next to each one where she would simply tap in a number ('1' for the first she wanted in the list, '2' for the second and so on) and then hit an 'update order' button, but i've no idea how to make a page that updates 20-odd records at once, i can only do single records...

So, can anyone help me on this?

If i dont work this out she will sack and/or stab me...



Edited by slave
Back to Top
MorningZ View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MorningZ Quote  Post ReplyReply Direct Link To This Post Posted: 27 February 2003 at 4:34pm
have something like (all stuff in parenthesis i don't know what it's called in your DB:

<%
Do while not rst.EOF %>
<input type="text" name="pic<%= rst("PicID") %>" value="<%= rst("picOrder") %>"/>
<%
rst.MoveNext
Loop
%>

and when you process them, extract the ID out of the name and update the DB, for example

<%
if however you check that the form is posted then
   For each item in Request.Form
     if Left(item,3) = "pic" then 'We have a pic order field
        ThisID = Mid(item,4)    'Extracts the ID from the Field's Name
        strSQL = "UPDATE table SET picorder = " & Request.Form(item) & _
           " WHERE PicID = " & ThisID
        objConn.Execute(strSQL)
     end if
   Next
end if
%>
Contribute to the working anarchy we fondly call the Internet
Back to Top
slave View Drop Down
Newbie
Newbie


Joined: 08 February 2003
Location: England
Status: Offline
Points: 29 		Post Options Post Options   Thanks (0) Thanks(0)   Quote slave Quote  Post ReplyReply Direct Link To This Post Posted: 27 February 2003 at 5:11pm
ok thanks i'll give that a whirl
Back to Top
slave View Drop Down
Newbie
Newbie


Joined: 08 February 2003
Location: England
Status: Offline
Points: 29 		Post Options Post Options   Thanks (0) Thanks(0)   Quote slave Quote  Post ReplyReply Direct Link To This Post Posted: 27 February 2003 at 6:57pm

Thanks so much, that works great

 
Back to Top
faubo View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 May 2002
Location: Brazil
Status: Offline
Points: 560 		Post Options Post Options   Thanks (0) Thanks(0)   Quote faubo Quote  Post ReplyReply Direct Link To This Post Posted: 27 February 2003 at 9:54pm

Suggestion for your own sake:

take a little look in Server Side Includes (SSI), in order to not use frames, they can mess up a lot of things and SSI can do exactly the same without the trouble.
I don't know how to make you click here
Back to Top
MorningZ View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MorningZ Quote  Post ReplyReply Direct Link To This Post Posted: 27 February 2003 at 11:11pm
i dont see any situation where frames would cause an issue on a layout like he desribes, its not going to get in the way of anything
Contribute to the working anarchy we fondly call the Internet
Back to Top
faubo View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 May 2002
Location: Brazil
Status: Offline
Points: 560 		Post Options Post Options   Thanks (0) Thanks(0)   Quote faubo Quote  Post ReplyReply Direct Link To This Post Posted: 28 February 2003 at 1:38am
Don't frames mess with some brownsers and give a hard time to some robots of search engines?
I don't know how to make you click here
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.