Question about best style

Jan Erik Moström lists at mostrom.pp.se
Tue Dec 28 18:11:37 CST 2004


A few questions about "style" when using Valentina. I'm for the first time
developing a "more than trivial" application using Valentina and there are a
few things that I'm wondering about:

+   Valentina has a kind of OO approach but my problem is that the
    way I model the objects in my app has little to do with how I design
    the database. This means that I would have to "double" the
    number of classes to do the design and then move the data from
    the "valentina objects" to "my objects". This has resulted in
    that I've been using SQL to do all the "database talking" with
    Valentina.

    Is there any kind of "penelty" for doing things with SQL
    directly (speed etc)?

+   Second problem is "escaping characters", for example if I 
    have question 
    
    select somedata from sometable where x = y
    
    and y comes from user input, is there some way of escaping 
    the content of y (so that the content doesn't interfer
    with the SQL question). I've been looking in the manual
    but I couldn't find anything, am I missing something or
    how do I handle this in the best way?


                        jem
-- 
Jan Erik Moström   www.mostrom.pp.se


More information about the Valentina mailing list