Jump to content


Photo

Insert record into database...


  • Please log in to reply
3 replies to this topic

#1 Plazman65

Plazman65
  • Members
  • PipPipPip
  • Advanced Member
  • 46 posts

Posted 25 February 2006 - 05:56 AM

Hi all, Its me again, stuck again... sort of so here is what I have done and what I want to do
I used the master/detail page to create listings job/job detail.
Now I want to have a member be able to add one of the details(recordset) on the detail page to their own page to watch the status (hiring versus not hiring).
I created another table that has the username,idcode
The details are being passed with the idcode of the job but I am unsure of where to go now? any suggestions?
Thanks, Michelle

#2 kraftycuts

kraftycuts
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 27 February 2006 - 10:11 PM

[!--quoteo(post=349251:date=Feb 25 2006, 06:56 AM:name=plazman65)--][div class=\'quotetop\']QUOTE(plazman65 @ Feb 25 2006, 06:56 AM) View Post[/div][div class=\'quotemain\'][!--quotec--]
Hi all, Its me again, stuck again... sort of so here is what I have done and what I want to do
I used the master/detail page to create listings job/job detail.
Now I want to have a member be able to add one of the details(recordset) on the detail page to their own page to watch the status (hiring versus not hiring).
I created another table that has the username,idcode
The details are being passed with the idcode of the job but I am unsure of where to go now? any suggestions?
Thanks, Michelle
[/quote]
I'm having a similar problem if any one can help?! :-) Thanks

#3 Plazman65

Plazman65
  • Members
  • PipPipPip
  • Advanced Member
  • 46 posts

Posted 01 March 2006 - 04:36 AM

[!--quoteo(post=350007:date=Feb 27 2006, 02:11 PM:name=kraftycuts)--][div class=\'quotetop\']QUOTE(kraftycuts @ Feb 27 2006, 02:11 PM) View Post[/div][div class=\'quotemain\'][!--quotec--]
I'm having a similar problem if any one can help?! :-) Thanks
[/quote]
OK let me see if I can explain what I have done to make it work still need help with one part though-
Hi all, I have run into a couple of problems and I think that its because Im trying to filter a record set by saying username= session variable, MM_username.

The first problem-
I have two tables now-
jobs-jobid,city, etc
Myjobs-jobid,idcode,username, with jobid being the common columns.
I wrote the query as follows here's what I did;

SELECT jobs.CityName, jobs.idcode, jobs.nowhiring, mydepartments.depid, mydepartments.username
FROM jobs, mydepartments
WHERE jobs.idcode = mydepartments.depid and mydepartments.username = 'colname' (which is MM_username)

I get nothing but when I do this just sort by the job I get all the jobs!
SELECT mydepartments.depid, jobs.idcode, jobs.CityName
FROM mydepartments, jobs
where mydepartments.depid = jobs.idcode
however I do need it to come up by the current username only.

The second problem is the update record page I did the record set to update the record to filter username=MM_username since I only want logged in users to update their own info.


If ANYONE can help I greatly appreciate it. Thanks, Michelle

Anyone see what I miss? I appreciate your time. Thanks, Michelle

#4 Plazman65

Plazman65
  • Members
  • PipPipPip
  • Advanced Member
  • 46 posts

Posted 02 March 2006 - 05:49 AM

woohooo ok I got that part working
my mistake? MM_username was what I was using should have been MM_Username, another duh'.
So now what I need to do is to be able to limit the # of entry that a person puts in. Any ideas?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users