--- Toma Tasovac <[EMAIL PROTECTED]> wrote: > hello. > > i've started learning how to use rev with mySQL > today -- it's very > exciting. the database query builder is easy enough > and i had no > problems displaying the contents of the entire > record set in the field > -- but i'm having difficulties going beyond the > query builder. > > could some kind soul tell me how to implement a > simple query in a rev > text field on mouseUp > > SELECT * FROM dictionary WHERE word = "blahblah" > > where "blahblah" is the clickText ? > > muchas gracias. > > T. > >
Hi Toma, If you're already using database linked fields, then here's another trick to make dynamic queries: 1) Add another query to the same database, let's call it "DynamicDictionaryQuery" 2) Add your fields for the dynamic dictionary info, and link them to this query (Hint: you can use a 'table' field if you like to see everything in a single field) 3) Now set the script of the field on which the user can click to : on mouseUp -- build our new dynamic query put "SELECT * FROM dictionary WHERE word='" & \ the clickText & "' ;" into tSQLQuery -- now update our dynamic query revSetSQLOfQuery "DynamicDictionaryQuery", \ tSQLQuery end mouseUp Now when you click on a word in the field, the dynbamic query will be updated and the controls linked to it will be refreshed at the same time. Hope this helped, Jan Schenkel. ===== "As we grow older, we grow both wiser and more foolish at the same time." (La Rochefoucauld) __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com _______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution