You are storing these 8 possible URLs in a seperate table, correct? Just add a colun to any query that is a count of these. Then now 'uselink' column is needed. In oracle something like this
SELECT main.*, (select count(*) from favourites WHERE main.id = favourites.id) as favcount FROM main Doug On Wed, 8 Dec 2004 11:12:40 -0500, Phillip Perry <[EMAIL PROTECTED]> wrote: > Hi, > > ok here is the situation. I'm allowing users to enter up to 8 urls into a > form to put into a "favorites" section of my site. To determine if the user > has entered at least one url in the db I have a column called uselink > updated to YES. The problem is I can't find an easy way to detect if the > user has deleted ALL of the urls from their list. If they did that I want > the uselink column to be "NO". Any clues on an easy solution? > > Phil > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186672 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
