ckroon
Posts: 869
|
| Posted: 05/22/2006, 3:17 AM |
|
Hi all.
I am new at CCS but picking it up quickly. One thing I cannot figure out is how to set up this one to many: a teacher logs in and gets a display of only students in their class, which they can then edit.
I don't need you to tell me how to do it :), just point me in the right direction please.
A total new question now: In the class list table, do I need a Key ID AND the teachers ID for each student, or just the teachers ID?
Thanks!
_________________
Walter Kempees...you are dearly missed. |
 |
 |
Rene S
|
| Posted: 05/22/2006, 8:56 AM |
|
Hi,
Assuming you have a TeacherID in your student or class table, let the teacher login, turn it into a session and then you are set. (just pointing in the right direction....)
Good luck,
Rene
|
|
|
|
WKempees
|
| Posted: 05/22/2006, 10:17 AM |
|
And to get even closer:
Generate the grid to show all students.
Do as Rene said, and change the SQL of the Grid to include a Where somefield
= UserID type Session.
<ReneS@forum.codecharge (Rene S)> schreef in bericht
news:24471df2689736@news.codecharge.com...
> Hi,
>
> Assuming you have a TeacherID in your student or class table, let the
> teacher
> login, turn it into a session and then you are set. (just pointing in the
> right
> direction....)
>
> Good luck,
>
> Rene
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Carsten
|
| Posted: 05/22/2006, 12:22 PM |
|
Thanks! This should get me started in teh right direction.. I hope!
|
|
|
|
Carsten
|
| Posted: 05/22/2006, 3:03 PM |
|
Ok: Running out of energy as you can see by the times of my posts :)
Here is what I got: USing a Acces DB, running IIS, on WInxp using ASP as the language.
I made a nice, large editable grid that teachers iwll use to edit student demographic info. I go to the Visual Query Builder and set up the following: teacher_id equals user_id. I change the type to Session.
It still does not work...any ideas?
|
|
|
|
WKempees
|
| Posted: 05/22/2006, 3:44 PM |
|
"Still doesn't work"
If you remove the Where in the Visual Builder, is your grid then showing any
datarows?
It should.
Next:
"I go to the Visual Query Builder and set up the following: teacher_id
equals user_id. I change the type to Session.
Have a look at your source code do a find on "user_id" and if that gives
results see if that is declared as a sessionvariable.
If not do the same for UserID, because that is the variable created in the
Login.
So maybe:
" teacher_id equals UserID type to Session works. "
Walter
"Carsten" <Carsten@forum.codecharge> schreef in bericht
news:24472351736527@news.codecharge.com...
> Ok: Running out of energy as you can see by the times of my posts :)
> Here is what I got: USing a Acces DB, running IIS, on WInxp using ASP as
> the
> language.
> I made a nice, large editable grid that teachers iwll use to edit student
> demographic info. I go to the Visual Query Builder and set up the
> following:
> teacher_id equals user_id. I change the type to Session.
>
> It still does not work...any ideas?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Carsten
|
| Posted: 05/22/2006, 7:36 PM |
|
Woot! I got it to work.Thanks!
Different users bring up their class lists accordingly. Thanks. However, when logged in and I submit the changes to the grid, I get this lovely piece of prose: No value given for one or more required parameters. (Microsoft JET Database Engine)
I have hunted down all that I can, still no go. When I start CodeCharge and preview the grid, without logging in, I get all the records and it submits fine. When I log in, then submit, I get that error.
It's got to be something simple.. I'm hoping it is anyway.
Thanks! You guys rock.
|
|
|
|
WKempees
|
| Posted: 05/23/2006, 1:54 AM |
|
Yes it is something simple!
Walter
|
|
|
|
WKempees
|
| Posted: 05/23/2006, 1:57 AM |
|
Previous post, just kidding  .
Still only giving directions:
I would say you would have to stuff the CCGetUserID() or the UserID
(session) into the Teacher_id as soon as you are inserting new data.
Have fun!
|
|
|
|
|
