Jump to content

Archived

This topic is now archived and is closed to further replies.

Plazman65

Insert record into database...

Recommended Posts

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

Share this post


Link to post
Share on other sites
[!--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 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

Share this post


Link to post
Share on other sites
[!--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, 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

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.