Recordsets without using Session Variables Help

Ask a Question related to Macromedia Exchange Dreamweaver Extensions, Design and Development.

  1. #1

    Default Recordsets without using Session Variables Help

    Help, Please,

    I'm trying to build a recordset for users with administration rights, so that
    once the user logs in it validates their rights and then on a section of the
    page it returns the names of all the people associated with the company id that
    the user is is assosiated with (I don't want to use Session variables due to
    bandwith) the formula i'm thinking of is something like -
    Select EmployeeFirstname, EmployeeId, ClientID, CoClientID, EmployeeFirst,
    EmployeeUsername, EmployeeID from dbo.Employee, dbo.client where EmployeeID
    =ClientID AND ClientID = CoClientID AND CoClientID = EmployeeID AND
    EmployeeUsername = MMColParam AND EmployeeAccessLevel = Admin.
    (where EmployeeUsername id the text field that user enterred their email
    address whilst logging in)

    The site is an ASP site, I would be grateful for your thoughts on this one
    !!!! Many thanks -
    Gareth

    GTN1707 Guest

  2. Similar Questions and Discussions

    1. #39833 [NEW]: Session variables overwritten by local variables (register_globals=off)
      From: sup1382 at accedo dot es Operating system: OpenBSD 3.9 PHP version: 5.2.0 PHP Bug Type: Session related Bug...
    2. #39447 [NEW]: Want to optionally handle apc_upload_progress variables using session variables
      From: krudtaa at yahoo dot com Operating system: All PHP version: 5.2.0 PHP Bug Type: Feature/Change Request Bug...
    3. Persisted XML Recordsets - Disconnected Recordsets - problems
      I have a recordset, client side .ASP that I save as a DOM. I pass to a server side .ASP to reconnect the recordset and update. I keep getting an...
    4. Session problem when setting session variables in files that are in different directories
      I am running PHP 4.3.0 on a WinXPpro machine and I recently got problem with sessions. What I am building is a loginsystem and I need to save...
    5. variables that change session variables
      Hi, I'm currently writing a mulit-page form app that uses a session to retain data from each form element in order for the user to jump between...
  3. #2

    Default Recordsets without using Session Variables Help

    Help, Please,

    I'm trying to build a recordset for users with administration rights, so that
    once the user logs in it validates their rights and then on a section of the
    page it returns the names of all the people associated with the company id that
    the user is is assosiated with (I don't want to use Session variables due to
    bandwith) the formula i'm thinking of is something like -
    Select EmployeeFirstname, EmployeeId, ClientID, CoClientID, EmployeeFirst,
    EmployeeUsername, EmployeeID from dbo.Employee, dbo.client where EmployeeID
    =ClientID AND ClientID = CoClientID AND CoClientID = EmployeeID AND
    EmployeeUsername = MMColParam AND EmployeeAccessLevel = Admin.
    (where EmployeeUsername id the text field that user enterred their email
    address whilst logging in)

    The site is an ASP site, I would be grateful for your thoughts on this one
    !!!! Many thanks -
    Gareth

    GTN1707 Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139