Sorry Blackout!? Field should expect specific input
This topic is locked
Sorry Blackout!? Field should expect specific input
5/1/2023 4:34:20 AM
PHPRunner General questions
A
Andreas G. author
Sorry, but I've blacked out before though. A fixed code is to be entered in a text field Example 12345 How do I check the entry for 12345 before submitting/saving? Version 10.6, unfortunately I haven't worked with it for a long time Translated with Google
Hello Andreas, you can do that with a field event https://www.youtube.com/watch?v=4WGWbCUHCOc or in event Before record added / updated Here an example when you want to check 12345 in database (in OnServer of field event or in Before added/updated): $sql = "select * from table where field = 12345"; $rs = DB::Query($sql); if ( $rs ) { $data = $rs->fetchAssoc(); if ( $data ) { 12345 exists } else { 12345 missing } } else { problem with select or db-connect }Regards, wedi
A
Andreas G. author5/4/2023
Thank you, I'd like to take a look Translated with Google