Re: [sqlite] User defined functions and SQL Expressions

2008-01-08 Thread Kees Nuyt 
On Wed, 09 Jan 2008 11:21:43 +1000, [EMAIL PROTECTED]
wrote:

>Hello.  I've written a UDF named ENCRYPT.  I want to do something like this:
>
>  UPDATE Employees SET EncryptedName = ENCRYPT(LastName + ', ' + FirstName)
>
>The UDF gets called, but not with my data - rather something like "0.0".  Kind
>of weird.  Does Sqlite handle SQL expressions inside the parentheses?  I also
>tried this but without success:
>
>  UPDATE Employees SET EncryptedName = ENCRYPT(LastName) + ', ' +
>ENCRYPT(FirstName)
>
>Thx
>-brett

I think the + sign forces SQLite into thinking this is a
numerical expression ( + ) of which the outcome is zero, because
from a numerical viewpoint all the terms have value zero.

In other words: The contatenation operator is || , not +.
-- 
  (  Kees Nuyt
  )
c[_]

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

[sqlite] User defined functions and SQL Expressions

2008-01-08 Thread brettg 
Hello.  I've written a UDF named ENCRYPT.  I want to do something like this:

  UPDATE Employees SET EncryptedName = ENCRYPT(LastName + ', ' + FirstName)

The UDF gets called, but not with my data - rather something like "0.0".  Kind
of weird.  Does Sqlite handle SQL expressions inside the parentheses?  I also
tried this but without success:

  UPDATE Employees SET EncryptedName = ENCRYPT(LastName) + ', ' +
ENCRYPT(FirstName)

Thx
-brett






This message was sent using IMP, the Internet Messaging Program.



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