Two Questions on Database Query Builder

[Jan Schenkel]

--- Andre Garzia <soapdog at mac.com> wrote:
> 	Hi Folks,
> 
> 
> 	Is there a way to change connections parameters
> (server, user, pass) 
> at run time? 

See the following answers from last month's list
archives :
<http://lists.runrev.com/pipermail/use-revolution/2003-December/026932.html>
<http://lists.runrev.com/pipermail/use-revolution/2003-December/026982.html>

> And what about SQL joins, if I try to
> use something like 
> "SELECT * FROM names, projects WHERE
> projects.manager = names.id" will 
> it work in the Database Query Builder, like being
> able to set control 
> for columns of both tables?
> 

Have you tried ?  *grin*
Just tried it here, and it seems to work just fine,
allowing you to fetch fields from both tables when you
link fields to the query.

> 	Cheers, and thanks in advance.
> 
> Andre Alves Garzia ð 2003 ð BRAZIL
> http://www.soapdog.org
> 

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!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus