cffileupload - return record id after database storage

[David_Rotondo]

I am using the cffileupload tag to upload images to a server and store some information about each image into a database.

I'm having trouble working out how to get the Ids of these new records from the process page to be used later on.

The process page successfully moves the file and creates a new record in my database and I can successfully retrieve the new ID for that record I just don't know what to do with it.

I would like to have a list of ids that I can query in the next page.

I've tried using a session variable but that doesn't seem to work, what other options can I look into?

[Dan_Bracuk]

If you can successfully retrieve the id of a single record, what exactly went wrong when you tried to store that in a session variable?

[David_Rotondo]

I had a look into it and I was trying to add the session info + some other variables in the url path to process the uploading.

I saved the extra info i was passing through the URL into the session and now everything is working.

I don't know if I was concatinating the URL variables wrong or the session variables did not like extras with it.