Gossamer Forum
Home : Products : DBMan : Customization :

Modify multiple records w\ all data hidden

(Page 2 of 2)
> >
Quote Reply
Re: [Dempsey] Modify multiple records w\ all data hidden In reply to
If you get an internal server error, post your files. Don't change anything from what I gave you. I won't be able to tell where the problem is.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.
Quote Reply
Re: [JPDeni] Modify multiple records w\ all data hidden In reply to
I will re-try from scratch tonight and post my files if I get an error. Thanks!
Quote Reply
Re: [Dempsey] Modify multiple records w\ all data hidden In reply to
Here are my files with the exact code above added to them.

When I use these files it produces an internal server error.

I should also mention that it's columns that I want to add are 8 and 9, and the sum can be put in column 0 which exsists and is blank\empty.

When I remove sub transform_records the internal server error is gone.

Thanks for your help :)

Mike
Quote Reply
Re: [Dempsey] Modify multiple records w\ all data hidden In reply to
It looks like there is an extra closing bracket at the bottom of that sub. Try removing one and see if that helps.
Quote Reply
Re: [Dempsey] Modify multiple records w\ all data hidden In reply to
Quote:
I should also mention that it's columns that I want to add are 8 and 9, and the sum can be put in column 0 which exsists and is blank\empty.

I went by what you had posted. ::sigh:: What is it that you want? I can only give you what you tell me that you want.

I didn't look at your files because Watt had a suggestion. Too many cooks and all that. Try his suggestion. If you still have problems, post your files again and I'll take a look at them.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.
Quote Reply
Re: [JPDeni] Modify multiple records w\ all data hidden In reply to
I'll try Watt's suggestion tonight. Thanks Watt.

I apologize if I wasn't clear earlier. I want a process that keeps all columns in each record the same, except for column 0 which I want to be a sum of column 8 and 9. Thanks.
Quote Reply
Re: [Dempsey] Modify multiple records w\ all data hidden In reply to
The code you need to change is

Code:

$data[0] = $data[2] + $data[3];
$in{$db_cols[0]} = $data[0];
$in{$db_cols[1]} = $data[1];
$in{$db_cols[2]} = $data[2];
$in{$db_cols[3]} = $data[3];


There's likely a way to do it without putting in a line for each field, but I can't think of it now. :) You should be able to see the pattern that you need to follow, though, and get it to do what you need it to do.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.
Quote Reply
Re: [JPDeni] Modify multiple records w\ all data hidden In reply to
Success! Smile It's doing exactly what I want it to do now. Thank you again, it is really appreciated.

Mike
> >