Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - Group_ID selection
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Group_ID selection

 Post Reply Post Reply
Author
cheops@collecto View Drop Down
Groupie
Groupie


Joined: 14 January 2004
Location: Denmark
Status: Offline
Points: 53
Post Options Post Options   Thanks (0) Thanks(0)   Quote cheops@collecto Quote  Post ReplyReply Direct Link To This Post Topic: Group_ID selection
    Posted: 15 April 2006 at 9:48pm

how do I allow my users to select the the Group_ID with out giving them admin or moderator status.


and only display the Group_ID's below admin and moderator...??
Sorry for my bad 3nglish..!!
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 16 April 2006 at 12:34pm
They can't you need to set the group the member is in.
Back to Top
cheops@collecto View Drop Down
Groupie
Groupie


Joined: 14 January 2004
Location: Denmark
Status: Offline
Points: 53
Post Options Post Options   Thanks (0) Thanks(0)   Quote cheops@collecto Quote  Post ReplyReply Direct Link To This Post Posted: 17 April 2006 at 3:21am

I found a snip of code, could something like this work....??

am I wrong or shouldn't something like this search trough the Group_ID, and sort out the administrator and MOD group....  and not display the admin and mod group, but list all other member groups...??

Anyone know how to make this work...!!

( I don't have the skills to make it work....???)



strsql = "SELECT * FROM " & strDbTable & " Author, " WHERE  & strDbTable & " Username " AND & strDbTable & " Author_ID " AND & strDbTable &  "Group_ID "<> 15 AND & strDbTable & "Group_ID" <> 3 "
 strAuthor.Open sql, conn, 3, 3
 If not strAuthor.eof Then
  If Not isNull(Trim(strAuthor("Group_ID"))) Then
   Group_ID = Split(Replace(strAuthor("Group_ID"), "@", ""), ", ")
  End If

Sorry for my bad 3nglish..!!
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.