I've been playing around with the Database Query Builder and the Database properties of fields and buttons. OK! It's easy to understand, nice UI, runs fast. I'm connecting to a remote MySQL server via SSL.

One thing that I can't figure out though:

Can the SQL query (as specified in the Database Query Builder) be parameterized? I understand the primary key is parameterized as you can connect buttons up to navigate between records. But what about parameterizing by non-primary key columns? For example: things like putting a search term into a LIKE query, or putting a foreign key into a JOIN query.

Macromedia Dreamweaver has the ability to fill in variables into a SQL query. So you can use URL variables, POST variables, or environment variable and evaluate them into the SQL query before the query is executed.

If the Database Query Builder doesn't support this, how can I safely modify the query via my own script at runtime?

Alex Rice <[EMAIL PROTECTED]> | Mindlube Software | http://mindlube.com

what a waste of thumbs that are opposable
to make machines that are disposable  -Ani DiFranco

_______________________________________________
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to