Hello, i've been tasked with creating a random quote app for a web site. The
trouble i'm having is figuring out how to store the data in my table and
then be able to retrieve data once the client has deleted a quote. For
example, i can use a PK to define each quote and then just pull a random
number within the range of quotes available (eg. 45 quotes, so a random
number between 1 and 45), but the client wants to be able to modify or
delete quotes so once a deletion occurs, it's possible that the random
number chosen might just not exist. What is the SOP for something like this?
If the record doesn't exist, select a different random number (seems like a
lot of overhead) or is there a way that i should be keying the data to make
the possibility of pulling an id that doesn't exist. Oh, i'm working with
Access too. Thanks for any help.
d
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
