Thread

So I would have an array of users and country in a list ie.

Joe Bloggs - USA
Joe Smith - United Kingdom

Etc

try this

$u = new User();
$u->get();

$u->country->get();

foreach ($u->all as $user)
{
    echo $user->name.' -> '.$user->country->name.'
';
}

Thats excatly the same as what I had ??

post your models for user and country

Here are the models and controller.

http://stikked.com/view/62619868

Thank you

you dont have this part on the controller

foreach ($u->all as $user)
{
    echo $user->name.' -> '.$user->country->name.'
';
}

otherwise its not printing anything….

Like I have said I get the sQL error as per my first post. So no point outputting anything when I got errors 😊.

I know normal get works just for users with no errors and I have done foreach no problem with that data.

just to make sure you did update your mysql driver? if no check out the troubleshooting in the manual.

BTW do you have an instant messenger so we stop spamming the board?

Solution was to update the mysql driver….

@tdtank
Without diving into it too much something is amuck with autotransactions as turning it off in the datamapper config using similar models worked perfectly

controller

$b = new Brainstorm();
$b->short_desc = "test1";
$b->long_desc = "a long description";
$b->priority = 1;
$b->est_count_total = 77;
$b->status = 1;
$b->origin_date = now();
    

$it = new Issue_type();
$it->where('id', 2)->get();

$b->save($it);

var_dump($b);

A Debug shows that DataMapper line 614

$this->id = $this->db->insert_id();

which uses the new mysql_driver.php insert_id method on line 310
returns an id of 0

but with the config set to false it properly returns the id of the newly created record

so yeah… something is amuck in the driver i think?

hmmm…. also turning autotransactions back on and reordering DataMapper lines 604 - 615 to the following worked too:

// Begin auto transaction
$this->_auto_trans_begin();

// Create new record
$this->db->insert($this->table, $data);
                    
// Sets the id property 
// to the last insert's auto_increment value
$this->id = $this->db->insert_id();

// Complete auto transaction
$this->_auto_trans_complete('save (insert)');

Has Datamapper ceased to exist….?

http://stensi.com/datamapper/index.html

Not from what we know…

The creator is really busy at the moment…

you can download it from the wiki and the manual is in the download.
If you have questions ask them here and people will try and help!

Okay cool - it’s fantastic contribution and was worried when I saw that.

I recently talked to stensi.  He’s going through a server change, and it might be a little longer before he gets his website up.

DataMapper is still alive and kicking, however, and some additions are in the works, AFAIK.