Plazman65 Posted February 25, 2006 Share Posted February 25, 2006 Hi all, Its me again, stuck again... sort of so here is what I have done and what I want to doI 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,idcodeThe details are being passed with the idcode of the job but I am unsure of where to go now? any suggestions? Thanks, Michelle Quote Link to comment Share on other sites More sharing options...
kraftycuts Posted February 27, 2006 Share Posted February 27, 2006 [!--quoteo(post=349251:date=Feb 25 2006, 06:56 AM:name=plazman65)--][div class=\'quotetop\']QUOTE(plazman65 @ Feb 25 2006, 06:56 AM) [snapback]349251[/snapback][/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 doI 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,idcodeThe 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 Quote Link to comment Share on other sites More sharing options...
Plazman65 Posted March 1, 2006 Author Share Posted March 1, 2006 [!--quoteo(post=350007:date=Feb 27 2006, 02:11 PM:name=kraftycuts)--][div class=\'quotetop\']QUOTE(kraftycuts @ Feb 27 2006, 02:11 PM) [snapback]350007[/snapback][/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, etcMyjobs-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.usernameFROM jobs, mydepartmentsWHERE 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.CityNameFROM mydepartments, jobswhere 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, MichelleAnyone see what I miss? I appreciate your time. Thanks, Michelle Quote Link to comment Share on other sites More sharing options...
Plazman65 Posted March 2, 2006 Author Share Posted March 2, 2006 woohooo ok I got that part workingmy 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? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.