How do I Pass a Value during UPDATE process

[Guest]

I'm using ASP within MX 2004 and have a MySQL database. One table needs to be updated to flag it is being processed. Knowing it is flagged we need its RecID to bring up its information to build a new record from it plus what we need to add to the new record.  

Thanks your your support...

www.ICBLA.org

[bregent]

I've read your question a dozen times and still not sure what you are asking. You are updating a table. One row? Multiple rows? Show us the update statement.

Now, what is it you want to do? What is the workflow involved here?

[Guest]

Maybe this will help:

We do relief and humanitarian work worldwide and we allow our aid workers at the crisis to post their needs, see http://www.icbla.org/Crisis/CatalogBuild.asp  - They use a digital camera, notebook computer and a small satellite dish to connect to the above page.

Once the system has their needs posted our buyers review their needs from USA, Philippines, South Africa and Uruguay, see http://www.icbla.org/Crisis/CatalogUpdate.asp to source the produce at the lowest price and compute the cost to get it to the crisis within the time-frame.

Now we need as the buyers a form that will draw the RecID (CatalogBuild.asp) that is passed and rather the link to update an existing record but build a new record with information like this update page, http://www.icbla.org/Crisis/CatalogBuyer.asp.

I hope by seeing the flow of the information this will help.

[bregent]

I'm starting to understand a little better, but it's still not totally clear. If I understand correctly, you need a form that will populate a link table -  that is, a table that links the need to the source item. Is that correct?

How do the buyers select the needed item they are working on? Is it from a list page, or a dropdown list on the form? How may tables (table names?)  are involved in this process?

[Guest]

http://www.icbla.org/Crisis/CatalogUpdate.asp is where we use a form to update items posted at the crisis site as "Needed" but rather than going our standard Admin Page we wish to pass on the RecID so we may build a record much like http://www.icbla.org/Crisis/CatalogBuyer.asp has. I envision a URL come out of CatalogUpdate looking like this: http://www.ICBLA.org/Crisis/CatalogAssignment.asp?RecID=22 but placing it into the Update Form it gives me a 500 error.

Thanks for your support,

Glen

[bregent]

A 500 error is generic and can mean anything. You need to disable friendly error messaging to get more usefull info for troubleshooting. Start by disabling it in your browser and see if that helps. You may have to reconfig your server too.

Also please explain which pages you want to pass the RecID from and to.

There are several ways to pass values. You can populate a form field, or pass them in the querystring. Of course, you then need to take appropriate measures to retrieve them in the receiving page.

You can also store them in a session variable, but that does not seem appropriate in this case.