HELP:Caught an exception while rendering: no such column:

2009-05-22 Thread Herta
Hi, everyone, I start learning django and met a question. It seems that i have load data into my database (sqlite3), but the webpage show some error. What is the problem.Thanks! TemplateSyntaxError at /admin/dbDECP/gene_variants/ Caught an exception while rendering: no such column: dbDECP_gene_v

Re: HELP:Caught an exception while rendering: no such column:

2009-05-22 Thread Herta
yes,i remember i altered my model. But how can i alter the table structure, or how can i see the raw table structure and change my model to the original one? On May 22, 10:25 pm, Masklinn wrote: > On 22 May 2009, at 15:41 , Herta wrote:> no such

Re: HELP:Caught an exception while rendering: no such column:

2009-05-22 Thread Herta
Thanks a lot! On May 22, 10:51 pm, Alex Gaynor wrote: > On Fri, May 22, 2009 at 9:43 AM, Herta wrote: > > > yes,i remember i altered my model. > > But how can i alter the table structure, or how can i see the raw > > table structure and change my model to the original

i have a question about model

2009-05-22 Thread Herta
hi, everyone, i have a question about model. i define some models, but some will return the records, while some only return the counts of the records on the web page? class cancer(models.Model): # it returns the count of records CancerID = models.CharField(max_length=8) NCIID = m

how to load data?

2009-05-22 Thread Herta
Hi, everyone, I want to load data to database (sqlite3 ) from file. I have already connect django and my database, and build the tables but how can i load data from file? Thanks! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Goog

Re: how to load data?

2009-05-22 Thread Herta
The input file is a plain txt file with \t, I just want to know if there is a function to import data from the existing file, if i don't write a script with a sql='insert into table values(...) ' On May 23, 8:43 am, George Song wrote: > On 5/22/2009 5:07 PM, Herta wrote: &g

How to do search

2009-05-26 Thread Herta
Hi everyone, I have a function Gquery, it works. But I don't know how to make it work with form in html with django? def Gquery(query): conn=sqlite3.Connection(db) c=conn.cursor() out_=[] query=query.strip().upper() sql='select ...' out=c.execute(sql) out_.extend(out.

a question on session

2009-05-29 Thread Herta
Hi everyone, I have a question about how to pass a variable from one view function to another view function, and how to displace the variable from one html template to another one. for example : I want Pquery(query)[1] in Psearch to be stored, and then call it in another function page. In addit