[sqlite] matching only part of a string

2007-03-27 Thread Lloyd K L
Hi,
  My table contains a text field called Name. Let the data be

Name
---
Abc
abcd
AB
cab
def

I want to selcct all the rows which contains the term ab (not case
sensitive). How can I do this?

Thanks in advance,
  Lloyd


-
This email was sent using SquirrelMail.
   "Webmail for nuts!"
http://squirrelmail.org/


__
Scanned and protected by Email scanner

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] sqlite backup from the program.

2006-11-03 Thread Lloyd K. L
Whether your database creation error solved? what was the problem?


- Original Message -
From: <[EMAIL PROTECTED]>
To: 
Sent: Friday, November 03, 2006 2:18 PM
Subject: [sqlite] sqlite backup from the program.



Hi All,

How to take a backup of the sqlite database (dump) from the
C program.

Is there any C API for that? Or is there any mechanism to achieve it?



Please throw some light on it.



Thanks in Advance,

Regards,

Ravi K






The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not
the intended recipient, you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately and destroy all copies of this
message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The
company accepts no liability for any damage caused by any virus transmitted
by this email.

www.wipro.com


__
Scanned and protected by Email scanner

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] sqlite backup from the program.

2006-11-03 Thread Lloyd K. L
SQLite database is stored as a normal file in the disk. Why dont you use
Operating System calls to back up the file?



- Original Message -
From: <[EMAIL PROTECTED]>
To: 
Sent: Friday, November 03, 2006 2:18 PM
Subject: [sqlite] sqlite backup from the program.



Hi All,

How to take a backup of the sqlite database (dump) from the
C program.

Is there any C API for that? Or is there any mechanism to achieve it?



Please throw some light on it.



Thanks in Advance,

Regards,

Ravi K






The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not
the intended recipient, you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately and destroy all copies of this
message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The
company accepts no liability for any damage caused by any virus transmitted
by this email.

www.wipro.com


__
Scanned and protected by Email scanner

-
To unsubscribe, send email to [EMAIL PROTECTED]
-