My site is using Symfony 1.4.1 with Propel and a database running on
Microsoft SQL 2008.
I'm using a form class defined in /lib/form to allow users to view
and edit rows in a table. I've added a use_fields() line to it to
limit what shows up and changed one of the fields to use a checkbox
widget.
In my routing.yaml I have the following lines:
client:
class: sfPropelRouteCollection
options: { model: Client, column: ID }
Calling /frontend_dev.php/modulename/25/edit.html correctly loads the
form with data form record with ID #25. When I hit submit however I
get this error:
[wrapped: SQLSTATE[22018]: Invalid character value for cast
specification: 206 [Microsoft][ODBC SQL Server Driver][SQL
Server]Operand type clash: text is incompatible with bigint
(SQLExecute[206] at ext\pdo_odbc\odbc_stmt.c:133)]
I dug into the problem a bit, and it appears that some queries are
being issued that look like this [....] WHERE ID = '25'. ID is a
bigint field (and is defined as such in schema.yml:
ID: { phpName: Id, type: BIGINT, size: '8', scale: '0', primaryKey:
true, required: true }
The superficial cause of the problem appears to be that the propel
Criteria class binds the incoming ID parameter to the query as a
string. I notice this is the default type when using
PDOStatement::bindParam() (not sure if that's relevant. I'm not sure
why this is happening though.
I'm going to continue to dig, but wanted to find out if this was a
known problem, or if there are configuration settings I should be
looking at.
Additional note:
One thing I've noticed is changes caused by the capitalization of the
column: field. If I change it to column: Id to match the
capitalization of the phpname I get no errors, but everything always
defaults to loading record #1. (/frontend_dev.php/modulename/25/
edit.hml loads record 1 not 25).
--
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-us...@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.
