Colin J. Williams | 3 Nov 15:34
Picon
Favicon

I am trying to explore SQLObject

TortoiseSVN gives Error: URL 
'http://svn.colorstudy.com/SQLObject/trunk%20SQLObject' 
doesn't exist

Any suggestions?

I would like to download the 
documentation, is there some 
straightforward way of doing this?

Colin W.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
Colin J. Williams | 3 Nov 16:40
Picon
Favicon

Re: I am trying to explore SQLObject

Colin J. Williams wrote:
> TortoiseSVN gives Error: URL 
> 'http://svn.colorstudy.com/SQLObject/trunk%20SQLObject' 
> doesn't exist
> 
> Any suggestions?
> 
> I would like to download the 
> documentation, is there some 
> straightforward way of doing this?
> 
> Colin W.
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/

I have dropped SQLObject from the first 
line and the install seemed to go
OK.

However, the setup.py install fails, 
please see below:

C:\Python25\Lib\site-packages>python 
"C:\Documents and Settings\cjw\My 
Documents\My 
(Continue reading)

pkoelle@gmail.com | 3 Nov 18:57
Picon

Re: I am trying to explore SQLObject

Colin J. Williams schrieb:

> I have dropped SQLObject from the first 
> line and the install seemed to go
> OK.
Do you mean the checkout from SVN?
> 
> However, the setup.py install fails, 
> please see below:
> 
> C:\Python25\Lib\site-packages>python 
> "C:\Documents and Settings\cjw\My 
> Documents\My 
> Downloads\Python\SQLObject\setup.py"
>   install
Please try again from a location without spaces in the path.

cheers
  Paul

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
Colin J. Williams | 3 Nov 20:58
Picon
Favicon

Re: I am trying to explore SQLObject

pkoelle <at> gmail.com wrote:
> Colin J. Williams schrieb:
> 
>> I have dropped SQLObject from the first 
>> line and the install seemed to go
>> OK.
> Do you mean the checkout from SVN?
>> However, the setup.py install fails, 
>> please see below:
>>
>> C:\Python25\Lib\site-packages>python 
>> "C:\Documents and Settings\cjw\My 
>> Documents\My 
>> Downloads\Python\SQLObject\setup.py"
>>   install
> Please try again from a location without spaces in the path.
> 
> cheers
>   Paul
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/

Paul,

It seems that I need to go back to 
basics.  When I do a tortoisesvn checkout
(Continue reading)

pkoelle@gmail.com | 4 Nov 13:07
Picon

Re: I am trying to explore SQLObject

Colin J. Williams schrieb:
> pkoelle <at> gmail.com wrote:
>> Colin J. Williams schrieb:
>>
>>> I have dropped SQLObject from the first 
>>> line and the install seemed to go
>>> OK.
>> Do you mean the checkout from SVN?
>>> However, the setup.py install fails, 
>>> please see below:
>>>
>>> C:\Python25\Lib\site-packages>python 
>>> "C:\Documents and Settings\cjw\My 
>>> Documents\My 
>>> Downloads\Python\SQLObject\setup.py"
>>>   install
>> Please try again from a location without spaces in the path.
>>
>> cheers
>>   Paul
>>
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by: Splunk Inc.
>> Still grepping through log files to find problems?  Stop.
>> Now Search log events and configuration files using AJAX and a browser.
>> Download your FREE copy of Splunk now >> http://get.splunk.com/
> 
> Paul,
> 
> It seems that I need to go back to 
(Continue reading)

Colin J. Williams | 4 Nov 16:06
Picon
Favicon

Re: I am trying to explore SQLObject

pkoelle <at> gmail.com wrote:
> Colin J. Williams schrieb:
>> pkoelle <at> gmail.com wrote:
>>> Colin J. Williams schrieb:
>>>
>>>> I have dropped SQLObject from the first 
>>>> line and the install seemed to go
>>>> OK.
>>> Do you mean the checkout from SVN?
>>>> However, the setup.py install fails, 
>>>> please see below:
>>>>
>>>> C:\Python25\Lib\site-packages>python 
>>>> "C:\Documents and Settings\cjw\My 
>>>> Documents\My 
>>>> Downloads\Python\SQLObject\setup.py"
>>>>   install
>>> Please try again from a location without spaces in the path.
>>>
>>> cheers
>>>   Paul
>>>
>>> -------------------------------------------------------------------------
>>> This SF.net email is sponsored by: Splunk Inc.
>>> Still grepping through log files to find problems?  Stop.
>>> Now Search log events and configuration files using AJAX and a browser.
>>> Download your FREE copy of Splunk now >> http://get.splunk.com/
>> Paul,
>>
>> It seems that I need to go back to 
(Continue reading)

cmhofer@gmail.com | 5 Nov 15:25
Picon

own sql and procedures

Hi,
i have 2 questions.

1) is there a possibiliti' to start my own (complex) sql update script.
example

insert into webstats (uname,tipoctr)
(Select 
        cbl.codice, 
        1+IFNULL((select 1 from collab2 where cbl.codice =
collab2.codice),0)
from collab cbl);

2) How can i start procedures from sqlobject.

thanks mike

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
Oleg Broytmann | 5 Nov 17:46
X-Face
Picon
Favicon

Re: own sql and procedures

On Mon, Nov 05, 2007 at 03:25:13PM +0100, cmhofer <at> gmail.com wrote:
> 1) is there a possibiliti' to start my own (complex) sql update script.
[skip]
> 2) How can i start procedures from sqlobject.

   connection.query("INSERT...")

   result = connection.queryAll("SELECT...")
   for row in result:
      print row

Oleg.
--

-- 
     Oleg Broytmann            http://phd.pp.ru/            phd <at> phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
Diez B. Roggisch | 5 Nov 18:08
Favicon

Re: own sql and procedures

On Monday 05 November 2007 15:25:13 cmhofer <at> gmail.com wrote:
> Hi,
> i have 2 questions.
>
> 1) is there a possibiliti' to start my own (complex) sql update script.
> example
>
> insert into webstats (uname,tipoctr)
> (Select
>         cbl.codice,
>         1+IFNULL((select 1 from collab2 where cbl.codice =
> collab2.codice),0)
> from collab cbl);
>
>
> 2) How can i start procedures from sqlobject.

Obtain a connection to your DB, which you should be able to using

MySQLObjectClass._connection

and then just proceed as if you were using the DB API itself.

There is no support for more in SO because calling procedures & running 
hand-tailored SQL somewhat defeats the purpose of introducing an ORM layer in 
the first place.

Be also aware of synchronisation-caveats when your procedures update the DB 
but the SO-cache doesn't reflect the changes.

(Continue reading)

Petr Jakeš | 7 Nov 23:30
Picon

how to get generator number

Hi,
I would like to use IDs generated by generator in my application. I am using Firebird DB.

Now I go like:

genVal = connection.queryOne("SELECT GEN_ID( GEN_PERSON, 1 ) FROM RDB$DATABASE")

or for Firebird 2.0

genVal = connection.queryOne("SELECT NEXT VALUE FOR GEN_PERSON FROM RDB$DATABASE")

Is there some other (more Pythonic) way how to get generator value?

Thanks for your reply

Petr Jakes
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Gmane