|
-
 Originally Posted by danielkessler
That works, but doesn't bring in a_lname because there's not a pipe after the comma - but the comma does the right thing
I'm sorry, I forgot to type the pipe after ','
Not reason for it not to work... a ColdFusion issue perhaps?... can you trick ColdFusion to show you the query is trying to submit?
Originally Posted by danielkessler
It's the order that they were entered, so it's the UID publicationa_id
So... if a publication has three authors you will have three entries in publications_authors, all of them with the same publicationa_id value, am I right?
If YES... you do not have an order there, Oracle might retrive first any of the three entries matching the key.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote