apostrophe in field name causes edit problem

Hi,
do you have any events on your Edit page ?

Looks like you have an error in your event code.
Inspect and fix your code.

Hi,

I have events in the fr_activefile_events.php file but I cannot see anything wrong with the code, it retrieves and saves records okay. Is it somewhere else?
<?php
function BeforeAdd(&$values)

{
{

$values["MyUserID"]=$_SESSION["UserID"];

}
return true;
}
?>
<?php

function BeforeEdit(&$values, $where)

{
//** Insert a record into another table ****

global $conn;
$strSQLInsert = "insert into fr_activefile_audit (DateRequested, Surname, MemberID, Requestor, FileLocated, Comments, MyUserID, Livelink) values ('".$values["DateRequested"]."','".$values["Surname"]."','".$values["MemberID"]."','".$values["Requestor"]."','".$values["FileLocated"]."','".$values["Comments"]."','".$_SESSION["UserID"]."', '".$values["Livelink"]."')";

db_exec($strSQLInsert,$conn);

$values["MyTimeStamp"] = now();

return true;

}
?>

This error happens in the BeforeEdit event.

You need to replace all apostrophes with \' in the field values in your query:

$values["Surname"]= str_replace("'","\'",$values["Surname"]);

This error happens in the BeforeEdit event.

Jane, thanks that works good!
My users however, stay up at night to dream up new ways to make my life miserable. To prevent them from screwing up the Surname sort order I also had to remove spaces they insert before they type a name and change first letter to upper case. My code now looks like this in BeforeEdit:
$values["Surname"]= str_replace("'","\'",TRIM(UCWORDS($values["Surname"])));
This works great for saving records, but entries in the list page come out looking like:
O\'Malley
To clean this up on the list page, I use the following:
$row[$col."Surname_value"]=stripslashes($value);
This cleans the slashes nicely on the list page. The problem I am having now is on the edit page the record still displays as O\'Malley. Where do I insert the stripslashes for the edit page?

Hi,
please ignore the previoius advice.

Don't use str_replace or strip_slashes in your code.
To get your pages working modify BeforeEdit event it this way:

global $conn;

Hi,

That fixes the "\" on the edit pages nicely, thank you!
To remove the extra spaces my users are inserting and the sort order fix for mixed case entries I am still using the following in BeforeEdit before the code you suggested:
$values["Surname"]= TRIM(UCWORDS($values["Surname"]));
I can see the TRIM being necessary as an added feature, I will certainly have to use it in most of my phprunner apps. The UCWORDS may not be as popular but it does fix the sort order problem.