[Helma-user] Is it possible to use SQL Queries directly without collections or mappings etc.?

[VividVisions, Walter Krivanek]

hi,

just take a look at global.getDBConnection() [http://helma.org/ 
stories/47668/].
there's an example for directly accessing the database.

best,
walter

Am 23.01.2007 um 10:12 schrieb AndiSkater:

>
> Hi All!
>
> I'm completely new to helma and I just made the tutorial some time  
> ago. At
> the moment I'm planning a Web 2.0 Web Application which will be  
> almost like
> a Desktop Application (so much client-side javascript and almost no
> classical pages). I'm considering helma because I want to use  
> javascript on
> the server-side, too, for sake of code portability. In a running  
> project I'm
> using ASP with JScript and an connected SQlite Database and  
> programming is
> really nice, but ASP is from Microsoft and I don't want to use a  
> Windows
> Server for my next project.
>
> helma seems very interesting an offers many features, but  I have  
> to admit,
> that I don't understand the concept of object-relational mapping. I  
> searched
> this forum and I found some posts of people knowing which SQL  
> statemant they
> would use to get the data they want, but who did not know how to  
> map this.
> Why does hemla hide the power of SQL behind these rather limited
> collections?
>
> I often use complex SQL statemants and I know how to construct  
> them, isn't
> it possible to use SQL Queries directly? This morning I woke up and  
> thought,
> well, there is this sqlshell... it seemed to accept a SQL query. So  
> I had a
> look at the code of helma.sqlshell.js and found the method:
> helma.sqlshell.Datasource.prototype.query = function(con, param) {
>     // some SQL has been submitted - evaluate it
> ...
>
> So, is it possible to use this capability to query the database  
> directly and
> create a helma application which is a bit more like PHP oder ASP?  
> My project
> will use the server-side mostly for DB and File Access and security  
> relevant
> methods through AJAX (respectively AJAJ).
>
> I had a look at http://en.wikipedia.org/wiki/Server-Side_JavaScript  
> but most
> of the other implementation implementing JS on server-side are in  
> early
> development or make things even more complex. :-/
>
> Probably you can give me some hints if helma is right for me or if  
> there is
> an alternative.
>
> Thanks in advance,
> Andi
>
> -- 
> View this message in context: http://www.nabble.com/Is-it-possible- 
> to-use-SQL-Queries-directly-without-collections-or-mappings-etc.-- 
> tf3063012s2589.html#a8517935
> Sent from the Helma - User mailing list archive at Nabble.com.
>
> _______________________________________________
> Helma-user mailing list
> Helma-user at helma.org
> http://helma.org/mailman/listinfo/helma-user
>