947740 Posted August 17, 2009 Share Posted August 17, 2009 There is something wrong with this query, but I am not sure what it is. I probably just need some freshe eyes. Thanks. UPDATE afterschool set `ParentName` = 'Magic Johnson' AND `NumberStudents` = '1' AND `CheckIn` = '1250518740' AND `CheckOut` = '' WHERE ID = 50 I get this error: Truncated incorrect DOUBLE value: 'Magic Johnson' The table: +----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+-------+ | ID | bigint(20) | NO | PRI | 0 | | | ParentName | varchar(255) | YES | | NULL | | | NumberStudents | varchar(255) | YES | | NULL | | | CheckIn | varchar(255) | YES | | NULL | | | CheckOut | varchar(255) | YES | | NULL | | +----------------+--------------+------+-----+---------+-------+ Link to comment https://forums.phpfreaks.com/topic/170703-solved-query/ Share on other sites More sharing options...
rhodesa Posted August 17, 2009 Share Posted August 17, 2009 Check to make sure you are connecting to the correct database and table, cus that error means you have the datatype of the ParentName field as Double and not Varchar Link to comment https://forums.phpfreaks.com/topic/170703-solved-query/#findComment-900306 Share on other sites More sharing options...
947740 Posted August 18, 2009 Author Share Posted August 18, 2009 I did this query and it worked. Huh. UPDATE afterschool set `ParentName` = 'Magic Johnson', `NumberStudents` = '1', `CheckIn` = '1250518740', `CheckOut` = '' WHERE ID = 50 Thanks for the help. Link to comment https://forums.phpfreaks.com/topic/170703-solved-query/#findComment-900968 Share on other sites More sharing options...
rhodesa Posted August 18, 2009 Share Posted August 18, 2009 DUH...how did i miss that... Link to comment https://forums.phpfreaks.com/topic/170703-solved-query/#findComment-900984 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.