I just found out there was a mistake in the csv file i used when importing.
The problem was i open the csv exported from admin in libreoffice,
but i didnot notice that the separator converted to tab.
--
---
You received this message because you are subscribed to the Google Groups
"web2py-user
Your are welcome!
Richard
On Tue, Feb 7, 2012 at 5:46 PM, Omi Chiba wrote:
> Thank you, Richard !
> I came up the same idea using excutesql and it's done in a seconds !!
>
> db.executesql('INSERT INTO request (subject, result) SELECT subject,
> result FROM result;')
> * my database is db2
>
> >
Thank you, Richard !
I came up the same idea using excutesql and it's done in a seconds !!
db.executesql('INSERT INTO request (subject, result) SELECT subject,
result FROM result;')
* my database is db2
> In your case you need input of user so you need to import from CSV... But I
> don't see why
I was think of something like this...
INSERT INTO dict_table (table_name)
SELECT relname
FROM pg_class
WHERE relnamespace='2200' AND relname LIKE 'test_%' AND relname NOT LIKE
'%_id_seq'
That could be write in raw SQL or with web2py request syntax
In your case you need input of user so you need
I think my case is the former. Like Sales support team prepare the
reply for the open request at the end of the day and upload. In the
evening, I have scheduled job on my AS400 do the upgrade from result
to request table with other information.
Insert each rows takes long time compared to update o
5 matches
Mail list logo