Re: [Gambas-user] Gambas Server Pages mysql

2009-04-23 Thread Dimitris Anogiatis
Thanks Benoit that works like a charm :)
Regards
Dimitris

2009/4/22 Benoît Minisini gam...@users.sourceforge.net

  Hey guys,
 
  With the example below Gambas Server Pages were introduced.
 
  My question is:
  1) how would I achieve a connection to a mysql database or any database
 for
  that matter?
  2) where in the code below would I put the necessary statements?
  3) if no direct reference to any database objects can be made is the
  alternative, by lets say, using an external gambas module or some other
  trick?
 
 
 --8---
 ---
 
  #!/usr/bin/env gbw2
  %
  DIM sEnv AS String
  %
 
  !-- Variable declaration must come before any HTML --
 
  html
 
  h2CGI script environmental variables/h2
 
  table border=1 cellspacing=0 cellpadding=2
 
tr
  th align=leftName/th
  th align=leftValue/th
/tr
 
  % FOR EACH sEnv IN Application.Env %
tr valign=top
  td%= sEnv %/td
  td%= Application.Env[sEnv] % /td
/tr
  % NEXT %
 
  /table
 
  /html
 
 --8---
 ---
 
  Thanks in advance
 
  Regards
  Dimitris

 You must add:

 %
 USE gb.db
 %

 at the beginning of the page, and then you can access any database.

 Regards,

 --
 Benoît


 --
 Stay on top of everything new and different, both inside and
 around Java (TM) technology - register by April 22, and save
 $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
 300 plus technical and hands-on sessions. Register today.
 Use priority code J9JMT32. http://p.sf.net/sfu/p
 ___
 Gambas-user mailing list
 Gambas-user@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/gambas-user

--
Stay on top of everything new and different, both inside and 
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today. 
Use priority code J9JMT32. http://p.sf.net/sfu/p
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user


Re: [Gambas-user] Gambas Server Pages mysql

2009-04-22 Thread Benoît Minisini
 Hey guys,

 With the example below Gambas Server Pages were introduced.

 My question is:
 1) how would I achieve a connection to a mysql database or any database for
 that matter?
 2) where in the code below would I put the necessary statements?
 3) if no direct reference to any database objects can be made is the
 alternative, by lets say, using an external gambas module or some other
 trick?

 --8---
---

 #!/usr/bin/env gbw2
 %
 DIM sEnv AS String
 %

 !-- Variable declaration must come before any HTML --

 html

 h2CGI script environmental variables/h2

 table border=1 cellspacing=0 cellpadding=2

   tr
 th align=leftName/th
 th align=leftValue/th
   /tr

 % FOR EACH sEnv IN Application.Env %
   tr valign=top
 td%= sEnv %/td
 td%= Application.Env[sEnv] % /td
   /tr
 % NEXT %

 /table

 /html
 --8---
---

 Thanks in advance

 Regards
 Dimitris

You must add:

% 
USE gb.db
%

at the beginning of the page, and then you can access any database.

Regards,

-- 
Benoît

--
Stay on top of everything new and different, both inside and 
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today. 
Use priority code J9JMT32. http://p.sf.net/sfu/p
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user