Detail View Problem with Contacts

[chrislynch8]

Hi,

If you have seen my other threads recently I have a logic hook that is checking data on the Client, this is setting a flag when a certain match is made. In my Detail View of the Contact I am checking this flag and running a Javascript.

THis works fine, after the Javascript run and I continue some of my fields are showing a emtpy on the detail view but if I then refresh the page they appear.

I have captured what is happening and you can see it at the link below.

http://www.youtube.com/watch?v=4p6bJlRpdxM

[chrislynch8]

If this helps,

In the detail view in an IF Statment I have the following code

 $this->bean->alert = 0;
$this->bean->save(); 
  

When I comment out the $this->bean->save(); I do not have the issue but then I lossthe functionality I was creating...

Rgds
Chris

[eggsurplus]

The save() call may be triggering the logic hooks (is there a way to tell the save to skip the logic hooks? This would be awesome!)

If that's the case you may want to look at doing a direct db update instead of doing a save() call like:
update contacts
set fieldname = 'hello world'
where id = $bean->id

Ignore the syntax but that idea should work.

[chrislynch8]

I will do that and let you know.

How is the save() triggering a logic hook? What exactly is happening when the $this->bean->save(); is run.

*********EDIT**********

Tried the following

 $id = $this->bean->id;
$query = "UPDATE contacts_cstm SET fdc_spouse_partner_alert_c = '0' WHERE id_c = '$id'"
$bean->db->query($query, true); 
  

I get message etc before the query, and then the view is not loading - Do I need to run a query against that DB in a different way in hte detail view as I do in the edit view?

**EDIT***

I had to use this

 $this->bean->db->query($query, true);
instead of
$bean->db->query($query, true); 
  

Rgds
Chris