Skip to main content
A
Anonymous
February 10, 2012
Question

How do I Pass a Value during UPDATE process

  • February 10, 2012
  • 1 reply
  • 679 views

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

This topic has been closed for replies.

1 reply

B
bregent
Participating Frequently
February 10, 2012

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?

A
Anonymous
February 10, 2012

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.

B
bregent
Participating Frequently
February 13, 2012

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?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices