Search found 7 matches

by tomerb
Wed Aug 27, 2008 12:37 pm
Forum: Databases
Topic: Editing a ResultSet's values
Replies: 11
Views: 1103

Re: Editing a ResultSet's values

Yeah... I wanted to avoid that. :)

I think I prefer just solving it with a MySql function that does the text manipulation I need.

Thanks a lot for the help.
by tomerb
Wed Aug 27, 2008 12:14 pm
Forum: Databases
Topic: Editing a ResultSet's values
Replies: 11
Views: 1103

Re: Editing a ResultSet's values

Thanks a lot,
but i've already been through all that plenty.
getArray - returns 1 column, not the entire ResultSet as an array.
setFetchMode - just sets the method that you access the arrays with.

I dont think there's a way to change the values of the resultSet... :?
by tomerb
Wed Aug 27, 2008 11:13 am
Forum: Databases
Topic: Editing a ResultSet's values
Replies: 11
Views: 1103

Re: Editing a ResultSet's values

One more thing..
I am able to iterate through it, I do it on other parts of my app, but I only vie the fields, I never change them.
by tomerb
Wed Aug 27, 2008 11:11 am
Forum: Databases
Topic: Editing a ResultSet's values
Replies: 11
Views: 1103

Re: Editing a ResultSet's values

gettype= object get_class= MySQLResultSet MySQLResultSet Object (     [fetchmode:protected] => 2     [conn:protected] => MySQLConnection Object         (             [database:private] => test             [transactionOpcount:protected] => 0             [dblink:protected] => Resource id #65          ...
by tomerb
Wed Aug 27, 2008 7:25 am
Forum: Databases
Topic: Editing a ResultSet's values
Replies: 11
Views: 1103

Re: Editing a ResultSet's values

I'm sorry, I didnt get what you wrote correct.

It gives me an error: " Cannot use object of type MySQLResultSet as array in "...
Problem.
by tomerb
Wed Aug 27, 2008 7:23 am
Forum: Databases
Topic: Editing a ResultSet's values
Replies: 11
Views: 1103

Re: Editing a ResultSet's values

This doesnt work since it only changes a local copy of the val.
by tomerb
Wed Aug 27, 2008 5:12 am
Forum: Databases
Topic: Editing a ResultSet's values
Replies: 11
Views: 1103

Editing a ResultSet's values

Hello all, I need to edit values in a resultSet got from a SQL query. I've tried referecing it like this: foreach ($temp as &$val) { $val["place"] = "SOMETHING"; } But I'm getting "An iterator cannot be used with foreach by reference". I also tried to clone the $tem...