[symfony-users] schema query problem-- 2 tables only generated from mysql- please help
Schema.yml Im just new to Symfony. please help.--- wasted whole day
fixing this.
-
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
relations:
User:
local: profileid
foreign: profileid
type: many
User:
connection: doctrine
tableName: user
columns:
id:
type: integer(4)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: true
userid:
type: string(50)
fixed: false
unsigned: false
primary: true
autoincrement: false
profileid:
type: string(50)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
relations:
Profile:
local: profileid
foreign: profileid
type: one
query--
$q = Doctrine_Query::create()
-select('u.userid,u.profileid')
-from('Profile p')
-leftJoin('p.user')
-where('u.profileid=?', 'profile-01');
Gives me out error (try using aliases but it doesnt work foreignAlias: user)
Unknown relation alias user
--
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
Re: [symfony-users] schema query problem-- 2 tables only generated from mysql- please help
Try:
...
-leftJoin('p.User u')
...
Tom
On Fri, Apr 16, 2010 at 2:46 PM, Andro Fumero fugitive...@yahoo.com wrote:
Schema.yml Im just new to Symfony. please help.--- wasted whole day
fixing this.
-
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
relations:
User:
local: profileid
foreign: profileid
type: many
User:
connection: doctrine
tableName: user
columns:
id:
type: integer(4)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: true
userid:
type: string(50)
fixed: false
unsigned: false
primary: true
autoincrement: false
profileid:
type: string(50)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
relations:
Profile:
local: profileid
foreign: profileid
type: one
query--
$q = Doctrine_Query::create()
-select('u.userid,u.profileid')
-from('Profile p')
-leftJoin('p.user')
-where('u.profileid=?', 'profile-01');
Gives me out error (try using aliases but it doesnt work foreignAlias:
user)
Unknown relation alias user
--
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
--
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
Re: [symfony-users] schema query problem-- 2 tables only generated from mysql- please help
Thank you so much. i don't know that symfony is this sensitive.
From: Tom Haskins-Vaughan t...@templestreetmedia.com
To: symfony-users@googlegroups.com
Sent: Fri, April 16, 2010 2:57:41 PM
Subject: Re: [symfony-users] schema query problem-- 2 tables only generated
from mysql- please help
Try:
...
-leftJoin('p.User u')
...
Tom
On Fri, Apr 16, 2010 at 2:46 PM, Andro Fumero fugitive...@yahoo.com wrote:
Schema.yml Im just new to Symfony. please help.--- wasted whole day
fixing this.
-
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
relations:
User:
local: profileid
foreign: profileid
type: many
User:
connection: doctrine
tableName: user
columns:
id:
type: integer(4)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: true
userid:
type: string(50)
fixed: false
unsigned: false
primary: true
autoincrement: false
profileid:
type: string(50)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
relations:
Profile:
local: profileid
foreign: profileid
type: one
query--
$q = Doctrine_Query::create()
-select('u.userid,u.profileid')
-from('Profile p')
-leftJoin('p.user')
-where('u.profileid=?', 'profile-01');
Gives me out error (try using aliases but it doesnt work foreignAlias:
user)
Unknown relation alias user
--
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
--
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
--
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
