Error on send email |
4/16/2014 5:01:12 PM |
PHPRunner General questions | |
B
btman author
Hi all |
|
S
|
stiven 4/16/2014 |
you can try this
|
B
|
btman author 4/17/2014 |
you can try this is the field name id or ID??
0. include/dbconnection.my.mysqli.php:42 trigger_error 1. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1; 2. 256; 1. include/dbconnection.my.mysqli.php:42 db_query 1. select Name, Email, DatePicker, Les_dag, Les_tijden, ID from rfs_training_copy where id=; 2. mysqli; 2. include/dal.php:9 CustomQuery 1. select Name, Email, DatePicker, Les_dag, Les_tijden, ID from rfs_training_copy where id=;3. include/rfs_training_copy_events.php:44 eventclass_rfs_training_copy->AfterDelete 1. ID=1202; 2. Array ( [Name] => Evelijne [Email] => Evelijnealessie@blabla.com [Les_dag] => Woensdag [DatePicker] => 2013-04-24 [Les_tijden] => 20.15 - 21.15 uur [ID] => 1202 ) ; 4. classes/listpage.php:672 ListPage->deleteRecords N/A5. classes/listpage.php:1916 ListPage->prepareForBuildPage N/A6. rfs_training_copy_list.php:175 Global scope N/A
|
A
|
Anapolis 4/17/2014 |
Your query doesn't look right to me -- is ID the primary key of the records you want to pull? |
S
|
stiven 4/17/2014 |
You might want to put that code on Before record deleted events page because if you do it after, wouldn't have the record been deleted already?
|
B
|
btman author 4/17/2014 |
Your query doesn't look right to me -- is ID the primary key of the records you want to pull? Is the table you are pulling from something like this? Is the Field ID the primary id for the table? ID | Name | Email | DatePicker | Les_dag | Les_tijden 1202 |Evelijne | Evelijnealessie@blabla.com | 2013-04-24 |Woensdag | 20.15 - 21.15 uur if that is true then shouldn't your WHERE statement be "..where ID= " to match the same ID column name in your table? If ID is the key to each row of rfs_training_copy table then the query should read "where ID= '".$deleted_values["ID"]."'");
|
B
|
btman author 4/18/2014 |
You might want to put that code on Before record deleted events page because if you do it after, wouldn't have the record been deleted already? also this should work for you?
|
A
|
Anapolis 4/18/2014 |
You might try this...since you are trying so MANY things <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=74596&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' /> I have not tested:
foreach($data as $field=>$value)
foreach($data as $key =>$value)
if(!$ret["mailed"])
|