that would make sence, thanks. Quoting Joe Wilson <[EMAIL PROTECTED]>:
> No error when run with most recent SQLite. > replace() may not have existed in 3.3.7. > > --- Jim Dodgen <[EMAIL PROTECTED]> wrote: > > I get an error in version 3.3.7 when using the replace function as defined > here: > > > > http://sqlite.org/lang_expr.html > > > > "replace(X,Y,Z) Return a string formed by substituting string Z for > > every occurrance of string Y in string X. The BINARY collating sequence is > used > > for comparison" > > > > --- test case --- > > > > create temp table temp_x (a,b); > > insert into temp_x values ("foo/bar",1); > > select a,b from temp_x where replace(a,"/","-") <> "foo-bar"; > > > > --- error message --- > > > > error: 1 - no such function: replace(1) at dbdimp.c line 271 select a,b > from > > temp_x where replace(a,"/","-") <> "foo-bar" > > > > > > ________________________________________________________________________________ ____Luggage? > GPS? Comic books? > Check out fitting gifts for grads at Yahoo! Search > http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
