How to get single records in PlaySQL Forms

[Michael Theis]

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]

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]

Thank you,

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

columnname LIKE '$pageTitle'

[Alex Medved _ConfiForms_]

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