How to get single records in PlaySQL Forms

Question

I want to use PlaySQL Forms to show one single record without the possibility to switch between records.

Example: Show only the record where SoftwareID is 17 (perfect would be: where SoftwareName is Pagetitle

Can anyone please help?

Thanks, Michael

Steve Boydon · Answer

Hi

I've tried this and it doesn't work with the following SQL as a query

SELECT * FROM table WHERE field = '$pageTitle'

It does not appear to be dynamic.

If I replace with the page title text it works

Regards

Steve

Michael Theis · Answer

Thank you,

I already found out. The syntax in the WHERE clause had to be:

columnname LIKE '$pageTitle'

Alex Medved _ConfiForms_ · Answer

@Adrien Ragot (Play SQL / CYO) as author of PlaySQL forms could answer this 
 Just adding him to the thread