ennedy [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 16, 2005 10:34 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Convert and isnumeric function
>
> > There's a former Nigeria dictator Charles Taylor that is even worse.
>
> Liberia! Not t
> There's a former Nigeria dictator Charles Taylor that is even
> worse.
Liberia! Not that I could tell one from the other :)
Yahoo! Mail
Stay connected, organized, and protected. Take the tour:
http://tour.mail.yahoo.com/mailtour.html
Message-
> From: Cory Nelson [mailto:[EMAIL PROTECTED]
> Sent: Sunday, May 15, 2005 1:36 PM
> To: sqlite-users@sqlite.org
> Cc: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Convert and isnumeric function
>
> for a nice speed increase (no strlen and only one pointer
> d
t; }
> default: {
> sqlite3_result_int(context, 0);
> break;
> }
> }
> }
>
> > -Original Message-
> > From: Wolfgang Rohdewald [mailto:[EMAIL PROTECTED]
> > Sent: Saturday, May 14, 2005 8:39 AM
> > To: sqlite-use
sqlite3_result_int(context, 0);
break;
}
}
}
> -Original Message-
> From: Wolfgang Rohdewald [mailto:[EMAIL PROTECTED]
> Sent: Saturday, May 14, 2005 8:39 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Convert and isnumeric function
>
rg
> Subject: Re: [sqlite] Convert and isnumeric function
>
> On Samstag 14 Mai 2005 00:31, Michael Evenson wrote:
> > case SQLITE_TEXT: {
> > const char *z = sqlite3_value_text(argv[0]);
> > for (i = 0; i < strlen (z); i++) {
> >
On Samstag 14 Mai 2005 00:31, Michael Evenson wrote:
> case SQLITE_TEXT: {
> const char *z = sqlite3_value_text(argv[0]);
> for (i = 0; i < strlen (z); i++) {
> if (!isdigit (z[i])) {
> nResult = 0;
> break;
> }
this should return FALSE for -5, 1
cType from
WorldCheckData_Companies where isNumeric (cCompany) = 1 and cCompany != '.'
Mike
> -Original Message-
> From: Jay Sprenkle [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 13, 2005 3:47 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Convert an
Here is the isnumeric function. Don't forget to add the line to the
sqlite3RegisterBuiltinFunctions function.
{ "isnumeric", 1, 0, SQLITE_UTF8,0, isnumericFunc},
I put it right after the abs function declartation
/*
---
> All or any,
>
> Has anyone implemented these as built in functions in sqlite 3? If
> not - I was thinking of doing it and submitting to the sqlite.org web site
> for submission.
The api converts data types for you. Isnumeric might be useful but
since the database isn't strongly typed it
10 matches
Mail list logo
