Welcome Guest, Not a member yet? Register   Sign In
Can I get the last inserted IDs from an INSERT SELECT?
#4

[eluser]Unknown[/eluser]
Thank you Fuzzy that's what I thought.

After looking at this for another several hours I can't associate the jobs with their parent tasks unless I do them as you suggest and add the task then all it's associated jobs, then the next task and it's jobs etc.

I was going to create a unique key for each project, then use the key and the template_task row id to associate the jobs which leaves my inserts really clean but the logic. Oh the logic.

Again, thank you for the sets of eyes.


Messages In This Thread
Can I get the last inserted IDs from an INSERT SELECT? - by El Forum - 04-11-2013, 03:24 PM
Can I get the last inserted IDs from an INSERT SELECT? - by El Forum - 04-11-2013, 11:50 PM
Can I get the last inserted IDs from an INSERT SELECT? - by El Forum - 04-12-2013, 01:30 AM
Can I get the last inserted IDs from an INSERT SELECT? - by El Forum - 04-12-2013, 09:04 AM



Theme © iAndrew 2016 - Forum software by © MyBB