Sorry, It's me again.
As I work my way through DBMan SQL 2.0.3 I find myself unable to solve basic problems.
1/ I'm trying to display 4 or 5 fields from one table on another tables add_form.html (or any other html page). I understand that I need to create a sub in the Global Template section and insert the <%tag_name%> in the add_form.html but I don't know the correct coding for the sub.
Could someone please give me an example that includes how to SELECT 4 or 5 fields from a particular table WHERE the logged in user is the owner of both records (rows).
2/ Is it possible for multiple tables to share one Global Template but have different User Templates without copying the global.txt into each template directory? In other words, multiple tables share one global.txt from one directory but use different user templates. A lot of my content is the same and I think it would save a lot of time to share one template for the common items. Or can I use a seperate file or some other method?
Thanks again.
Simon.
As I work my way through DBMan SQL 2.0.3 I find myself unable to solve basic problems.
1/ I'm trying to display 4 or 5 fields from one table on another tables add_form.html (or any other html page). I understand that I need to create a sub in the Global Template section and insert the <%tag_name%> in the add_form.html but I don't know the correct coding for the sub.
Could someone please give me an example that includes how to SELECT 4 or 5 fields from a particular table WHERE the logged in user is the owner of both records (rows).
2/ Is it possible for multiple tables to share one Global Template but have different User Templates without copying the global.txt into each template directory? In other words, multiple tables share one global.txt from one directory but use different user templates. A lot of my content is the same and I think it would save a lot of time to share one template for the common items. Or can I use a seperate file or some other method?
Thanks again.
Simon.
Display field from another table