hello there, my schema.yml was generated from mysql table:
Users:
connection: doctrine
tableName: users
columns:
id:
type: integer(4)
fixed: false
unsigned: false
primary: true
autoincrement: true
userid:
type: string(50)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
profileid:
type: string(50)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
username:
type: string(50)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
pword:
type: string(50)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
fullname:
type: string(100)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
relations:
Profile:
local: profileid
foreign: profileid
type: one
Profile:
connection: doctrine
tableName: profile
columns:
id:
type: integer(4)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: true
profileid:
type: string(50)
fixed: false
unsigned: false
primary: true
autoincrement: false
profile:
type: string(50)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
description:
type: string()
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
relations:
Users:
local: profileid
foreign: profileid
type: many
-----------------------------------------------------------
I have this simple query but it gives me error
"Unknown relation alias Profile"
$q = Doctrine_Query::create()
->select('u.username, u.profileid,u.fullname,p.profile')
->from('Users as u')
->leftJoin('u.Profile p on p.profileid=u.profileid')
->where('u.username = ?', $request->getParameter('username'))
->andWhere('u.pword = ?', $request->getParameter('pword'));
$this->users = $q->execute();
-----------------------------------------------------
please help.
Thank you
-------------------------------------------------------
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
To unsubscribe, reply using "remove me" as the subject.
