Captain Dondo a écrit :
(snip)
> c=masterDB.cursor()
> c.execute("""SELECT title, subtitle, starttime FROM recorded""")
>
> # build our dialog checkbox
>
> d = dialog.Dialog(dialog="dialog")
> d.add_persistent_args(["--backtitle", "Myth2Go"])
>
> recordings=[]
> for listing in c.fetchall():
>
BartlebyScrivener wrote:
>>>that one column is always the same, the name of the host that
>>>the database resides on.
>
>
> Then why are you pulling all of the other stuff out of the db? Why
> don't you just
>
> UPDATE tablename
> SET hostname(or colname) = 'localhost'
> WHERE search con
>> that one column is always the same, the name of the host that
>> the database resides on.
Then why are you pulling all of the other stuff out of the db? Why
don't you just
UPDATE tablename
SET hostname(or colname) = 'localhost'
WHERE search condition = the rows you want to change
--
Brian wrote:
> Captain Dondo wrote:
>
>>What I'd like to do is build the correct selectlist in the first place,
>>rather than build the wrong one and then rebuild a correct one.
>
>
> This is sounding more like a SQL/DB problem and less like a Python one.
> If you have a field that is being pul
Captain Dondo wrote:
> What I'd like to do is build the correct selectlist in the first place,
> rather than build the wrong one and then rebuild a correct one.
This is sounding more like a SQL/DB problem and less like a Python one.
If you have a field that is being pulled from the database that
BartlebyScrivener wrote:
>>>I've looked at various search-and-replace snippets but none that address
>>>what I am trying to do
>
>
> I think you need to tell more about what you're trying to do. You say
> it's in a database? Is that why you can't just put the whole blob in
> your text editor
