Re: [sqlite] newie question
Oscar Alejandro Alvarado Prieto wrote: > Thanks for all your answers and suggestions and sorry for my message, this > was my very first one.As Martin already answer me don't worry any more. > Thanks again, next time I will do better. This document has many good suggestions on how to ask questions: http://www.catb.org/~esr/faqs/smart-questions.html Roger ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] newie question
Thanks for all your answers and suggestions and sorry for my message, this was my very first one.As Martin already answer me don't worry any more. Thanks again, next time I will do better. 2008/12/8 P Kishor <[EMAIL PROTECTED]> > On 12/8/08, Oscar Alejandro Alvarado Prieto <[EMAIL PROTECTED]> > wrote: > > how can I retrieve the result of a "SELECT COUNT(*) FROM atable" > statemen? > > thanks > > > > > > Hi Oscar, > > As MikeW mentioned, please use a subject line more descriptive than > "newie question." Additionally, please pose a better question as well. > Martin already explained some of the basics, but your question, as is, > doesn't make any sense. "SELECT COUNT(*) FROM atable" *is* the way to > retrieve the result. If you run that query in the sqlite3 shell, or > through the interface of your choice, you will get back a count of > rows in atable. Perhaps you want to provide some additional > information about where and how you want to "retrieve" the desired > result. > > -- > Puneet Kishor > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Oscar A. Alvarado ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] newie question
On 12/8/08, Oscar Alejandro Alvarado Prieto <[EMAIL PROTECTED]> wrote: > how can I retrieve the result of a "SELECT COUNT(*) FROM atable" statemen? > thanks > > Hi Oscar, As MikeW mentioned, please use a subject line more descriptive than "newie question." Additionally, please pose a better question as well. Martin already explained some of the basics, but your question, as is, doesn't make any sense. "SELECT COUNT(*) FROM atable" *is* the way to retrieve the result. If you run that query in the sqlite3 shell, or through the interface of your choice, you will get back a count of rows in atable. Perhaps you want to provide some additional information about where and how you want to "retrieve" the desired result. -- Puneet Kishor ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] newie question
Oscar Alejandro Alvarado Prieto <[EMAIL PROTECTED]> writes: > > how can I retrieve the result of a "SELECT COUNT(*) FROM atable" statemen? > thanks > Please use a better Subject line !! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] newie question
Hi, this is a normal select statement, you can retrieve the result in the same way as for 'select foo from bar' - Statement. The tecnical way depends on the interface you use. If you need a name of the result field, you can use 'SELECT COUNT(*) as MyField FROM atable'; the result field is the named "MyField". HTH Martin Oscar Alejandro Alvarado Prieto wrote: > how can I retrieve the result of a "SELECT COUNT(*) FROM atable" statemen? > thanks > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users