Re: Two Questions on Database Query Builder

[Andre Garzia]

On Jan 12, 2004, at 8:40 AM, Jan Schenkel wrote:

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.
	Jan,

Thanks for your help!

On trying it, yes I tried but there was a problem since both tables 
used the same field names so MySQL shouted that the query was ambigous, 
that was fixed, it was a problem with MySQL, SQL Query and me, nothing 
to do with revolution, but I was slow to understand.

Thanks Again
Cheers
Andre



Andre Garzia ï 2003
imac2 ibook p100 e uma torradeira
___
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: Two Questions on Database Query Builder

[Jan Schenkel]

--- Andre Garzia <[EMAIL PROTECTED]> 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 :



> 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
___
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution

Two Questions on Database Query Builder

[Andre Garzia]

	Hi Folks,

	Is there a way to change connections parameters (server, user, pass) 
at run time? 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?

	Cheers, and thanks in advance.

Andre Alves Garzia  2003  BRAZIL
http://www.soapdog.org
___
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution