Re: sqlite newbie questions

2007-06-26 Thread Carsten Haese
On Tue, 26 Jun 2007 08:38:29 GMT, Dennis Lee Bieber wrote: > In both cases, the whole idea behind letting the adapter do > parameter substitution is that the adapter will add the appropriate > delimiters (quote marks, for the most part) needed for the data type. That's only the case if the a

Re: sqlite newbie questions

2007-06-22 Thread [EMAIL PROTECTED]
On Jun 21, 11:54 am, Luis M. González <[EMAIL PROTECTED]> wrote: > You need to learn sql if you want to deal with databases. > Don't worry, it's very easy, and here is a very good resource to get > you up and running in a few minutes:http://www.sqlcourse.com > > Good luck! > Luis Thanks Luis, will

Re: sqlite newbie questions

2007-06-21 Thread Luis M . González
On Jun 21, 4:24 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Hello, > > I have a sqlite database table which has a table named "Transmittal". > Before inserting a new record into the database, i'd like to perform > some checking. How do i select all records with certain value (say > "Smith"

Re: sqlite newbie questions

2007-06-21 Thread [EMAIL PROTECTED]
Thank you Carsten. Problem solved. -- http://mail.python.org/mailman/listinfo/python-list

Re: sqlite newbie questions

2007-06-21 Thread Carsten Haese
On Thu, 2007-06-21 at 19:24 +, [EMAIL PROTECTED] wrote: > Hello, > > I have a sqlite database table which has a table named "Transmittal". > Before inserting a new record into the database, i'd like to perform > some checking. How do i select all records with certain value (say > "Smith") for

sqlite newbie questions

2007-06-21 Thread [EMAIL PROTECTED]
Hello, I have a sqlite database table which has a table named "Transmittal". Before inserting a new record into the database, i'd like to perform some checking. How do i select all records with certain value (say "Smith") for a column (say "Last_Name")? Knowing almost nothing about SQL, i just sel