Thank you for you very usefull reply Bill!!!!
I have cocoaMySQL here but it keeps quiting, so I use my phpmyAdmin from my web host control pannel, it's all integrated so no fuss here.
Also, we used to have a nice "show all records" on that "database" part of the inspector, I used that to create listboxes like:
SQL: select name from records.
On the inspector I would choose a field and use the "show all" on the database part of the inspector, that worked fine! where did that option go? that what I was talking about, not that it showed only one record, I reviewed my old code and that the way I used to do. I would create a listbox, fill it with names from the show all option, then on the double click of the listbox I would acquire the desired name, change the SQL query to reflect that choice, query the server, and move to a nice record editing card. It worked fine, but now with the "show all" missing, I think I'll have to code it by hand (and not by mouse as I wanted).
cheers andre
On Jul 21, 2004, at 3:42 PM, Bill wrote:
On 7/21/04 1:38 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
is anyone here using Database Query Builder on Rev 2.2.1? I am using it
and using it to display the contents of a query in a nice listbox
field. The query should return 3 rows (it does that on phpMyAdmin, the
same query). It returns only one row on rev. Also I am making use of
the arcane function revSetSQLOfQuery to change the parameter of the
query on runtime. it is working for when I check the Database Query
Builder, the query is the last one I set. Any clues here? That appears
a nasty bug...
The query builder and its nice show record function only works for one record at a time. You can do this:
on mouseUp put first word of selectedtext of me into tshipID
put "SELECT * FROM voyages WHERE shipID='" & \ tshipID & "'" \ into tSQLStatement
revSetSQLOfQuery "Connect",tSQLStatement end mouseUp
(sorry my example is not more generic -- my query builder query is called
"Connect") and then you will get a subset of your data but still only one
record will show at a time in the fields that are show a connection and
update data etc. Then you use buttons set to move to next record to see each
record from your query.
If you want to see a list of records like to put them in a pop-up or
something you don't use the query builder but instead do it manually (and
you can make a nice front end that mixes what the query builder does well
with what you have to do manually).
Also try using CocoaMySQL instead of phpMyAdmin and you have more functions
and can look stuff up quickly (especially if you have a complex multi-table
database) while programming in RUNREV at the same time.
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
-- Andre Alves Garzia 2004 Soap Dog Studios - BRAZIL http://studio.soapdog.org
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
