Page 2 - insert records in junction table

Hi Carmen - the purpose is to output the SQL statement, so that you can ensure it is being correctly assembled (specifically, that URL.PictureID is being passed properly). Sounds like it is?

Yes, I can see the pictureID.
You know another idea that I had (that's in case you run out of ideas :-), is maybe I can get rid of the general_categories table, and insert an array of checkboxes (associated with categories, including one that defaults to none) in the media table. This way, I don't have to go across tables to look for things. What do you think? Is this a good solution, given that I have 48 categories? Can you recommend an optimal way to do this instead?
Thank you soooo much!
Carmen
Oh - I sent you a message to your forum mailbox (do you ever check those?) I just discovered that feature recently :-)

Hi Carmen -

The setup you've described is doable, but it won't be as efficient in most cases. Not to mention it's a pain to maintain. The join/lookup table approach that you already have would be my recommendation. I'll defer to any DBA on that, though...

Sorry - can't shed any more light on the Access problem... I've heard that Access has some quirkiness about it with respect ot INNER JOINS. Are you sure that all the fields being referenced as IDs are numeric? You might try submitting a post to the SQL or Access forums to see if anyone there might be able to help.

Good luck!

Hi Brad,
I took your advice and posted the question about the inner join code to another forum and I found out that access requires multiple joins to be parenthesized!!! So now, I can actually see the info about a graphic I select. However, even though I see the checkboxes, there is no category name next to them, and none of them are checked. I am using the query you suggested
<cfoutput query="getAllCategories">
<td width="20%" align="left" valign="left" class="labelcell">
<input type="checkbox" name="General_CatID" value="#gc_ID#" <cfloop index="x" from="1" to="#ListLen(ActualList)#"><cfif #ListGetAt(ActualList, "#x#")# eq #gc_ID#>CHECKED</cfif></cfloop>#General_Category#

</td>
...Any idea what may be wrong? I am not getting any errors.
Thanks again,
Carmen

Brad, I figured it out! There was an end tag missing. Everything is working now! Thanks again for all your help!
C

no you didn't

i did

http://forums.devshed.com/showthread.php?t=147758

LOL!

If you read two messages up, I did give you credit!!! So I don't feel bad :-) Thanks again guys for helping me!

Great, Carmen