2. PHPRunner General questions
  3. [SOLVED]  why don't work "Edit record" in a custom vie
This topic is locked
[SOLVED]

 why don't work "Edit record" in a custom vie

 		12/20/2009 12:23:21 PM
PHPRunner General questions
S
 sadisticmagician author

hi why don't work "Edit record" in a custom view ?

ERROR = You have an error in your SQL syntax; check the manual that corrisponds to your MySQL server version for the right syntax to use near "where codice=........"
Sergey Kornilov admin 12/20/2009

It depends on what kind of SQL query you use for this custom view. Post your SQL query here.
S
 		sadisticmagician author 12/20/2009



It depends on what kind of SQL query you use for this custom view. Post your SQL query here.


i don't know, in original table content product 1 product 2 product 3 product 4 product 5 all types "INT" . in a custom view i want see and edit only product 1 , in second custom view i want see and edit only product 2 etc.
where i take the sql query?
Sergey Kornilov admin 12/20/2009

If you created the Custom View already you can find SQL query on 'SQL Query' screen in PHPRunner.
S
 		sadisticmagician author 12/20/2009



If you created the Custom View already you can find SQL query on 'SQL Query' screen in PHPRunner.


hi, i have resolved in Edit SQL query, just a click on "Group by" <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=46307&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' /> thanks for the help.