Jump to content

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

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.