I'm not buying that, but here you go: function view($id){ $this->set('user', $this->User->find($id)); }
>From the debug output, it appears that the uuid is being passed intact, but the generated sql garbles the where clause. Just in case, here is the "3" level debug output for the action: Query: SELECT `User`.`id`, `User`.`username`, `User`.`password` FROM `users` AS `User` WHERE 4796ed47-ec68-42d0-8b57-30402d55369f LIMIT 1 Warning (512): SQL Error: 1054: Unknown column '4796ed47' in 'where clause' [CORE\cake\libs\model\datasources\dbo_source.php, line 440] Code | Context $sql = "SELECT `User`.`id`, `User`.`username`, `User`.`password` FROM `users` AS `User` WHERE 4796ed47-ec68-42d0-8b57-30402d55369f LIMIT 1" $error = "1054: Unknown column '4796ed47' in 'where clause'" e("<p style = \"text-align:left\"><b>Query:</b> {$sql} "); if ($error) { trigger_error("<span style = \"color:Red;text- align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING); DboSource::showQuery() - CORE\cake\libs\model\datasources \dbo_source.php, line 440 DboSource::execute() - CORE\cake\libs\model\datasources \dbo_source.php, line 166 DboSource::fetchAll() - CORE\cake\libs\model\datasources \dbo_source.php, line 297 DboSource::read() - CORE\cake\libs\model\datasources\dbo_source.php, line 565 Model::find() - CORE\cake\libs\model\model.php, line 1752 UsersController::view() - APP\controllers\users_controller.php, line 11 Dispatcher::_invoke() - CORE\cake\dispatcher.php, line 268 Dispatcher::dispatch() - CORE\cake\dispatcher.php, line 240 [main] - APP\webroot\index.php, line 84 CakePHP: the rapid development php framework User Id Username Password * List CakePHP: the rapid development php framework Controller dump: UsersController Object ( [name] => Users [here] => /cake/cake_time/users/view/4796ed47- ec68-42d0-8b57-30402d55369f [webroot] => /cake/cake_time/ [action] => view [uses] => [helpers] => Array ( [0] => Html [1] => Form ) [params] => Array ( [pass] => Array ( [0] => 4796ed47-ec68-42d0-8b57-30402d55369f ) [named] => Array ( ) [controller] => users [action] => view [plugin] => [form] => Array ( ) [url] => Array ( [url] => users/view/4796ed47- ec68-42d0-8b57-30402d55369f ) [bare] => 0 [webservices] => [models] => Array ( [0] => User ) ) [data] => [paginate] => Array ( [limit] => 20 [page] => 1 ) [viewPath] => users [layoutPath] => [viewVars] => Array ( [user] => [cakeDebug] => UsersController Object *RECURSION* ) [pageTitle] => [modelNames] => Array ( [0] => User ) [base] => /cake/cake_time [layout] => default [autoRender] => [autoLayout] => 1 [components] => Array ( [0] => Session ) [view] => View [ext] => .ctp [__viewClass] => View Object ( [base] => /cake/cake_time [here] => /cake/cake_time/users/view/4796ed47- ec68-42d0-8b57-30402d55369f [plugin] => [name] => Users [action] => view [params] => Array ( [pass] => Array ( [0] => 4796ed47- ec68-42d0-8b57-30402d55369f ) [named] => Array ( ) [controller] => users [action] => view [plugin] => [form] => Array ( ) [url] => Array ( [url] => users/view/4796ed47- ec68-42d0-8b57-30402d55369f ) [bare] => 0 [webservices] => [models] => Array ( [0] => User ) ) [passedArgs] => Array ( [0] => 4796ed47-ec68-42d0-8b57-30402d55369f ) [data] => [helpers] => Array ( [0] => Html [1] => Form ) [viewPath] => users [viewVars] => Array ( [user] => [cakeDebug] => UsersController Object *RECURSION* ) [layout] => default [layoutPath] => [pageTitle] => [autoRender] => 1 [autoLayout] => 1 [ext] => .ctp [subDir] => [themeWeb] => [cacheAction] => [validationErrors] => Array ( ) [hasRendered] => [loaded] => Array ( [html] => HtmlHelper Object ( [tags] => Array ( [meta] => <meta%s/> [metalink] => <link href="%s"%s/> [link] => <a href="%s"%s>%s</a> [mailto] => <a href="mailto:%s" %s> %s</a> [form] => <form %s> [formend] => </form> [input] => <input name="%s" %s/> [textarea] => <textarea name="%s" %s>%s</textarea> [hidden] => <input type="hidden" name="%s" %s/> [checkbox] => <input type="checkbox" name="%s" %s/> [checkboxmultiple] => <input type="checkbox" name="%s[]"%s /> [radio] => <input type="radio" name="%s" id="%s" %s />%s [selectstart] => <select name="%s"%s> [selectmultiplestart] => <select name="%s[]"%s> [selectempty] => <option value=""%s> </option> [selectoption] => <option value="%s"%s>%s</option> [selectend] => </select> [optiongroup] => <optgroup label="%s"%s> [optiongroupend] => </optgroup> [checkboxmultiplestart] => [checkboxmultipleend] => [password] => <input type="password" name="%s" %s/> [file] => <input type="file" name="%s" %s/> [file_no_model] => <input type="file" name="%s" %s/> [submit] => <input type="submit" %s/> [submitimage] => <input type="image" src="%s" %s/> [button] => <input type="%s" %s/> [image] => <img src="%s" %s/> [tableheader] => <th%s>%s</th> [tableheaderrow] => <tr%s>%s</tr> [tablecell] => <td%s>%s</td> [tablerow] => <tr%s>%s</tr> [block] => <div%s>%s</div> [blockstart] => <div%s> [blockend] => </div> [para] => <p%s>%s</p> [parastart] => <p%s> [label] => <label for="%s"%s>%s</ label> [fieldset] => <fieldset><legend> %s</legend>%s</fieldset> [fieldsetstart] => <fieldset><legend>%s</legend> [fieldsetend] => </fieldset> [legend] => <legend>%s</legend> [css] => <link rel="%s" type="text/ css" href="%s" %s/> [style] => <style type="text/ css"%s>%s</style> [charset] => <meta http- equiv="Content-Type" content="text/html; charset=%s" /> [ul] => <ul%s>%s</ul> [ol] => <ol%s>%s</ol> [li] => <li%s>%s</li> [error] => <div%s>%s</div> ) [base] => /cake/cake_time [here] => /cake/cake_time/users/view/ 4796ed47-ec68-42d0-8b57-30402d55369f [params] => Array ( [pass] => Array ( [0] => 4796ed47- ec68-42d0-8b57-30402d55369f ) [named] => Array ( ) [controller] => users [action] => view [plugin] => [form] => Array ( ) [url] => Array ( [url] => users/view/ 4796ed47-ec68-42d0-8b57-30402d55369f ) [bare] => 0 [webservices] => [models] => Array ( [0] => User ) ) [action] => view [data] => [_crumbs] => Array ( ) [__docTypes] => Array ( [html4-strict] => <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/ strict.dtd"> [html4-trans] => <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/ html4/loose.dtd"> [html4-frame] => <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/ html4/frameset.dtd"> [xhtml-strict] => <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/ DTD/xhtml1-strict.dtd"> [xhtml-trans] => <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/ xhtml1/DTD/xhtml1-transitional.dtd"> [xhtml-frame] => <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN" "http://www.w3.org/TR/ xhtml1/DTD/xhtml1-frameset.dtd"> [xhtml11] => <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/ xhtml11.dtd"> ) [helpers] => [webroot] => /cake/cake_time/ [themeWeb] => [plugin] => [namedArgs] => [argSeparator] => [validationErrors] => [__tainted] => [__cleaned] => [_log] => ) [form] => FormHelper Object ( [helpers] => Array ( [0] => Html ) [fieldset] => Array ( [fields] => Array ( ) [key] => id [validates] => Array ( ) ) [__options] => Array ( [day] => Array ( ) [minute] => Array ( ) [hour] => Array ( ) [month] => Array ( ) [year] => Array ( ) [meridian] => Array ( ) ) [fields] => Array ( ) [requestType] => [base] => /cake/cake_time [webroot] => /cake/cake_time/ [themeWeb] => [here] => /cake/cake_time/users/view/ 4796ed47-ec68-42d0-8b57-30402d55369f [params] => Array ( [pass] => Array ( [0] => 4796ed47- ec68-42d0-8b57-30402d55369f ) [named] => Array ( ) [controller] => users [action] => view [plugin] => [form] => Array ( ) [url] => Array ( [url] => users/view/ 4796ed47-ec68-42d0-8b57-30402d55369f ) [bare] => 0 [webservices] => [models] => Array ( [0] => User ) ) [action] => view [plugin] => [data] => [namedArgs] => [argSeparator] => [validationErrors] => [tags] => Array ( ) [__tainted] => [__cleaned] => [_log] => [Html] => HtmlHelper Object ( [tags] => Array ( [meta] => <meta%s/> [metalink] => <link href="%s"%s/> [link] => <a href="%s"%s> %s</a> [mailto] => <a href="mailto:%s" %s>%s</a> [form] => <form %s> [formend] => </form> [input] => <input name="%s" %s/> [textarea] => <textarea name="%s" %s>%s</textarea> [hidden] => <input type="hidden" name="%s" %s/> [checkbox] => <input type="checkbox" name="%s" %s/> [checkboxmultiple] => <input type="checkbox" name="%s[]"%s /> [radio] => <input type="radio" name="%s" id="%s" %s />%s [selectstart] => <select name="%s"%s> [selectmultiplestart] => <select name="%s[]"%s> [selectempty] => <option value=""%s> </option> [selectoption] => <option value="%s"%s>%s</option> [selectend] => </select> [optiongroup] => <optgroup label="%s"%s> [optiongroupend] => </ optgroup> [checkboxmultiplestart] => [checkboxmultipleend] => [password] => <input type="password" name="%s" %s/> [file] => <input type="file" name="%s" %s/> [file_no_model] => <input type="file" name="%s" %s/> [submit] => <input type="submit" %s/> [submitimage] => <input type="image" src="%s" %s/> [button] => <input type="%s" %s/> [image] => <img src="%s" %s/> [tableheader] => <th%s>%s</ th> [tableheaderrow] => <tr%s> %s</tr> [tablecell] => <td%s>%s</ td> [tablerow] => <tr%s>%s</ tr> [block] => <div%s>%s</div> [blockstart] => <div%s> [blockend] => </div> [para] => <p%s>%s</p> [parastart] => <p%s> [label] => <label for="%s"%s>%s</label> [fieldset] => <fieldset><legend>%s</legend>%s</fieldset> [fieldsetstart] => <fieldset><legend>%s</legend> [fieldsetend] => </ fieldset> [legend] => <legend>%s</ legend> [css] => <link rel="%s" type="text/css" href="%s" %s/> [style] => <style type="text/css"%s>%s</style> [charset] => <meta http- equiv="Content-Type" content="text/html; charset=%s" /> [ul] => <ul%s>%s</ul> [ol] => <ol%s>%s</ol> [li] => <li%s>%s</li> [error] => <div%s>%s</div> ) [base] => /cake/cake_time [here] => /cake/cake_time/users/ view/4796ed47-ec68-42d0-8b57-30402d55369f [params] => Array ( [pass] => Array ( [0] => 4796ed47- ec68-42d0-8b57-30402d55369f ) [named] => Array ( ) [controller] => users [action] => view [plugin] => [form] => Array ( ) [url] => Array ( [url] => users/ view/4796ed47-ec68-42d0-8b57-30402d55369f ) [bare] => 0 [webservices] => [models] => Array ( [0] => User ) ) [action] => view [data] => [_crumbs] => Array ( ) [__docTypes] => Array ( [html4-strict] => <! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/ html4/strict.dtd"> [html4-trans] => <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http:// www.w3.org/TR/html4/loose.dtd"> [html4-frame] => <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/ html4/frameset.dtd"> [xhtml-strict] => <! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http:// www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> [xhtml-trans] => <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http:// www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> [xhtml-frame] => <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN" "http://www.w3.org/TR/ xhtml1/DTD/xhtml1-frameset.dtd"> [xhtml11] => <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/ DTD/xhtml11.dtd"> ) [helpers] => [webroot] => /cake/cake_time/ [themeWeb] => [plugin] => [namedArgs] => [argSeparator] => [validationErrors] => [__tainted] => [__cleaned] => [_log] => ) ) [session] => SessionHelper Object ( [helpers] => [__active] => 1 [valid] => [error] => [_userAgent] => 8443614ede9110c387754e7b64103530 [path] => [lastError] => [security] => [time] => 1201076568 [sessionTime] => [watchKeys] => Array ( ) [id] => [_log] => [base] => /cake/cake_time [webroot] => /cake/cake_time/ [here] => /cake/cake_time/users/view/ 4796ed47-ec68-42d0-8b57-30402d55369f [params] => Array ( [pass] => Array ( [0] => 4796ed47- ec68-42d0-8b57-30402d55369f ) [named] => Array ( ) [controller] => users [action] => view [plugin] => [form] => Array ( ) [url] => Array ( [url] => users/view/ 4796ed47-ec68-42d0-8b57-30402d55369f ) [bare] => 0 [webservices] => [models] => Array ( [0] => User ) ) [action] => view [data] => [themeWeb] => [plugin] => ) ) [modelScope] => [model] => [association] => [field] => [fieldSuffix] => [modelId] => [uuids] => Array ( ) [__passedVars] => Array ( [0] => viewVars [1] => action [2] => autoLayout [3] => autoRender [4] => ext [5] => base [6] => webroot [7] => helpers [8] => here [9] => layout [10] => name [11] => pageTitle [12] => layoutPath [13] => viewPath [14] => params [15] => data [16] => webservices [17] => plugin [18] => passedArgs [19] => cacheAction ) [__scripts] => Array ( ) [__paths] => Array ( [0] => C:\www\wamp\www\cake\cake_time\views\ [1] => C:\www\wamp\www\cake\cake\libs\view\ ) [_log] => [webroot] => /cake/cake_time/ [webservices] => ) [output] => [plugin] => [cacheAction] => [persistModel] => [webservices] => [passedArgs] => Array ( [0] => 4796ed47-ec68-42d0-8b57-30402d55369f ) [_log] => [modelClass] => User [modelKey] => user [Session] => SessionComponent Object ( [__active] => 1 [__started] => 1 [__bare] => 0 [valid] => 1 [error] => [_userAgent] => 8443614ede9110c387754e7b64103530 [path] => /cake/cake_time/ [lastError] => [security] => high [time] => 1201076568 [sessionTime] => 1201077768 [watchKeys] => Array ( ) [id] => [_log] => [host] => localhost [cookieLifeTime] => 0 ) [User] => User Object ( [name] => User [validate] => Array ( [username] => /^[\w\d]{8,20}$/ [password] => /^[\S]{8,20}$/ ) [useDbConfig] => default [useTable] => users [displayField] => id [id] => 4796ed47-ec68-42d0-8b57-30402d55369f [data] => Array ( ) [table] => users [primaryKey] => id [_schema] => Array ( [id] => Array ( [type] => string [null] => [default] => [length] => 36 [key] => primary ) [username] => Array ( [type] => string [null] => [default] => [length] => 20 [key] => unique ) [password] => Array ( [type] => string [null] => [default] => [length] => 40 ) ) [validationErrors] => Array ( ) [tablePrefix] => [alias] => User [tableToModel] => Array ( [users] => User ) [logTransactions] => [transactional] => [cacheQueries] => [belongsTo] => Array ( ) [hasOne] => Array ( ) [hasMany] => Array ( ) [hasAndBelongsToMany] => Array ( ) [actsAs] => [behaviors] => Array ( ) [whitelist] => Array ( ) [cacheSources] => 1 [findQueryType] => [__behaviorMethods] => Array ( ) [recursive] => 1 [order] => [__exists] => [__associationKeys] => Array ( [belongsTo] => Array ( [0] => className [1] => foreignKey [2] => conditions [3] => fields [4] => order [5] => counterCache ) [hasOne] => Array ( [0] => className [1] => foreignKey [2] => conditions [3] => fields [4] => order [5] => dependent ) [hasMany] => Array ( [0] => className [1] => foreignKey [2] => conditions [3] => fields [4] => order [5] => limit [6] => offset [7] => dependent [8] => exclusive [9] => finderQuery [10] => counterQuery ) [hasAndBelongsToMany] => Array ( [0] => className [1] => joinTable [2] => with [3] => foreignKey [4] => associationForeignKey [5] => conditions [6] => fields [7] => order [8] => limit [9] => offset [10] => unique [11] => finderQuery [12] => deleteQuery [13] => insertQuery ) ) [__associations] => Array ( [0] => belongsTo [1] => hasOne [2] => hasMany [3] => hasAndBelongsToMany ) [__backAssociation] => Array ( ) [__insertID] => [__numRows] => [__affectedRows] => [__findMethods] => Array ( [all] => 1 [first] => 1 [count] => 1 [neighbors] => 1 [list] => 1 ) [_log] => ) ) 1 query took 1 ms Nr Query Error Affected Num. rows Took (ms) 1 SELECT `User`.`id`, `User`.`username`, `User`.`password` FROM `users` AS `User` WHERE 4796ed47-ec68-42d0-8b57-30402d55369f LIMIT 1 1054: Unknown column '4796ed47' in 'where clause' 1 On Jan 23, 4:34 am, "Dardo Sordi Bogado" <[EMAIL PROTECTED]> wrote: > It seems like there is a problem in your controller, rather than in > the FormHelper. Could you paste the view function ? > > On Jan 23, 2008 6:38 AM, rogwei <[EMAIL PROTECTED]> wrote: > > > > > I have a db table that happens to have both uuid and int values in the > > id column. The following code works for the int value but not the uuid > > values. > > > <?php echo $html->link('View',array('action'=>'view', $user['User'] > > ['id'])); ?> > > > Here is the generated sql and error: > > > Query: SELECT `User`.`id`, `User`.`username`, `User`.`password` FROM > > `users` AS `User` WHERE 4796ed47-ec68-42d0-8b57-30402d55369f LIMIT 1 > > > Warning (512): SQL Error: 1054: Unknown column '4796ed47' in 'where > > clause' [CORE\cake\libs\model\datasources\dbo_source.php, line 440] > > > I cannot find anything in trac about this. Is this a bug or pilot > > error? > > > Regards, > > Roger --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---