Radicore Forum: How To » Use the ADD5 template

Home » RADICORE » How To » Use the ADD5 template

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Use the ADD5 template [message #1580 is a reply to message #1572]

Thu, 28 August 2008 10:37

gpatti
Messages: 283
Registered: August 2008

Senior Member

Thanks Tony - I used a debugger and found my mistake. I had deleted an incorrect relationship but needed to regenerate the php for the ADD5 transaction as that was still using the old relationship.

However, I still having difficulty achieving the functionality I want - hoping you might be able to provide some pointers. I'm learning how to use the framework fast, but this one has stumped me.

I want to be able to retrieve data from a table using a key and list it (that part is easy). I then want to be able to select some of the rows (prob with the select box) and change some of the data on those rows - then INSERT those rows back into the table with a new key.

I suspect it's not going to be possible exactly as I've described, but maybe it could be done in two stages:

1. INSERT...SELECT.... to insert the rows using one key to another
2. Retrieve the new rows based on the new key and perform updates/deletes as necessary

I suppose the main question is whether it is possible to create a transaction that will work with an InSERT...SELECT... statement.

Any ideas?

Report message to a moderator

[Message index]

		Use the ADD5 template By: gpatti on Tue, 26 August 2008 13:46
		Re: Use the ADD5 template By: AJM on Tue, 26 August 2008 14:33
		Re: Use the ADD5 template By: gpatti on Tue, 26 August 2008 14:42
		Re: Use the ADD5 template By: AJM on Tue, 26 August 2008 18:19
		Re: Use the ADD5 template By: gpatti on Thu, 28 August 2008 10:37
		Re: Use the ADD5 template By: AJM on Thu, 28 August 2008 10:47
		Re: Use the ADD5 template By: gpatti on Thu, 28 August 2008 11:08
		Re: Use the ADD5 template By: AJM on Thu, 28 August 2008 11:33
		Re: Use the ADD5 template By: gpatti on Thu, 28 August 2008 11:43

Previous Topic:	pickup subdir from table and put into upload_subdir
Next Topic:	Display of task description

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Nov 26 05:54:42 EST 2024

Total time taken to generate the page: 0.01130 seconds