Digital Workshop

Welcome to the Digital Workshop Message Boards
It is currently December 23rd, 2024, 2:22 am

All times are UTC [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Access database, randomly selecting records but no duplicate
PostPosted: January 26th, 2010, 4:29 pm 
Offline

Joined: October 9th, 2006, 10:06 am
Posts: 15
Location: Llanfyllin
Opus: Opus Professional 6.4
OS: Xp and Windows 7
System: Acer ?
Hi, I have an access database holding links to picture (bmp) files, these are all categorise using a numeric identifier, i.e. Celebraties are categorised as 1, groups as 2, sports as 3 etc.

I want to display up to 30 of the pictures logged in the database randomly on a page, by simply clicking a button and it populates the page, selecting the file location, file name from the access database, loading the picture from the location and entering the name into a text field underneath the displayed picture. at present the database holds around 2000 links to pictures, and I want to select as stated 30 but ensuring none of them are duplicate

Is it possible and if so can anyone help with an example, many thanks


Top
 Profile  
 
 Post subject:
PostPosted: January 26th, 2010, 8:17 pm 
Offline
Godlike
Godlike

Joined: November 12th, 2005, 1:56 am
Posts: 1474
Location: SFBay Area
Opus: OpusPro v9.0x, & Evol.
OS: Vista32
System: Core 2 duo 2Ghz, RAM 3GB, Nvidia Go 7700 - laptop
Evan
welcome to the forum.
What is your skill level here? As you posted in the Advanced section, are you comfortable with scripting?
What Digital Workshop product/version are you using?

(It helps me, and others, to see Opus info, PC info etc... in your Profile. Take a look at other's posts/profiles for what to include)

There are many ways to accomplish work in Opus. Choosing one to start, depends on your experience... and your vision. Also, will you be distributing your publication and the database?

- - - - -
I've not toyed with the random ordering challenge much.

There have been some very recent posts on a similar topic ( random selecting ), and several 'old' posts which are related to random display of quiz questions, etc. If you did a bit of searching, you would get some ideas as well.

_________________
_good things come to those who wait(0)_


Top
 Profile  
 
 Post subject:
PostPosted: January 27th, 2010, 9:19 am 
Offline
Godlike
Godlike
User avatar

Joined: March 21st, 2007, 10:44 am
Posts: 3188
Location: UK
Opus: Evolution
There's loads of posts on this with one as recent as a week old:

viewtopic.php?t=3820

The principle is the same as the code kindly provided by Onsi. Simply create an array of numbers and use the example function to shuffle the array.

Mack

_________________
When you have explored all avenues of possibilities, what ever remains, how ever improbable, must be the answer.

Interactive Solutions for Business & Education
Learn Anywhere. Learn Anytime.

www.interaktiv.co.uk
+44 (0) 1395 548057


Top
 Profile Visit website  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 39 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group