2. PHPRunner General questions
  3. [SOLVED]  Define exported records
This topic is locked
[SOLVED]

 Define exported records

 		7/21/2013 09:44:32
PHPRunner General questions
G
 g_parry author

I am trying to flag when a record has been exported but can't find a way of defining what records have been.
So far I am using events - before export record - CustomQuery
I need to define the chosen records - can anyone help?
The query starts as follows:
UPDATE permits SET printed = "Yes" WHERE (What goes here to select the actual records exported?)
If you're feeling generous, a way of confirming tha the user wishes to make the changes would be appreciated too <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=21247&image=1&table=forumtopics' class='bbcemoticon' alt='<<' />
Sergey Kornilov admin 7/22/2013

According to PHPRunner manual you can access any field value as $data["FieldName"]
Assuming that key column is a numeric field you can use the following code:

CustomQuery("UPDATE permits SET printed = 'Yes' WHERE KeyColumnName=".$data["KeyColumnName"]);
G
 		g_parry author 7/22/2013



According to PHPRunner manual you can access any field value as $data["FieldName"]
Assuming that key column is a numeric field you can use the following code:

CustomQuery("UPDATE permits SET printed = 'Yes' WHERE KeyColumnName=".$data["KeyColumnName"]);



That worked perfectly - thamk you Sergey