Professional Web Applications Themes

I am lost, multiple tables to one recordset. - ASP Database

Hi, I am completely lost. I have a stored procedure that creates a temp table and inserts and eventid. Afterwards other fields are gathered via an innerjoin. The problem is that I have a created another table with only the changes to these events. So tblEvent is eventid / eventname / eventdate / userid / eventtime tblEventHistory is versionid / eventId / eventdate / eventtime / changeDate tblUser is userid / username tblEvent has one record and tblEventHistory could have multiple records but with only the changes at a certain time. Problem is that I don't know how to create ...

  1. #1

    Default I am lost, multiple tables to one recordset.

    Hi,

    I am completely lost. I have a stored procedure that creates a temp
    table and inserts and eventid. Afterwards other fields are gathered
    via an innerjoin. The problem is that I have a created another table
    with only the changes to these events.

    So
    tblEvent is eventid / eventname / eventdate / userid / eventtime
    tblEventHistory is versionid / eventId / eventdate / eventtime /
    changeDate
    tblUser is userid / username

    tblEvent has one record and tblEventHistory could have multiple
    records but with only the changes at a certain time.

    Problem is that I don't know how to create a recordset that provides
    all the records via an inner join and also get the records from
    tblEventHistory.

    Furthermore I have to use the records on an asp page and mark the
    changes between records. Is there an easy way to do this. Any pointers
    would be greatly appreciated.

    I am using the resource on
    http://www.4guysfromrolla.com/webtech/020701-1.2.shtml as a basis.

    Apologies for my explanation but hopefully someone will be able to
    help me out.

    Cheers.
    Pascal
    Pascal Guest

  2. #2

    Default Re: I am lost, multiple tables to one recordset.

    You might want to use a shaped recordset instead of a huge JOIN.

    http://support.microsoft.com/kb/189657/EN-US/

    --
    Manohar Kamath
    Editor, .netWire
    www.dotnetwire.com


    "Pascal" <com> wrote in message
    news:google.com... 


    Manohar Guest

  3. #3

    Default Re: I am lost, multiple tables to one recordset.

    Manohar,

    Thanks for the answer. I have given it a try and after some work it
    seems to work just fine. The Shape command is pretty cool.

    Thanks again.

    Pascal

    "Manohar Kamath" <com> wrote in message news:<phx.gbl>... 
    Pascal Guest

Similar Threads

  1. Question pagivation multiple recordset + asp
    By nelsonprem in forum Brainstorming Area
    Replies: 0
    Last Post: April 9th, 06:08 AM
  2. update multiple records in multiple tables from one form
    By Anj01 in forum Coldfusion Database Access
    Replies: 1
    Last Post: May 17th, 05:54 AM
  3. HELP.. Recordset JOIN tables
    By Addy_31 in forum Dreamweaver AppDev
    Replies: 1
    Last Post: May 4th, 01:51 AM
  4. lost database tables
    By mygraneboy in forum Dreamweaver AppDev
    Replies: 1
    Last Post: April 27th, 07:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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