Re: Trouble configuring refDB

On Tue, Jan 23, 2007 at 02:34:35PM -0500, Martin Hicks wrote:
> 
> > return anything?  I'm not sure about the hang, but certainly SQLite
> > doesn't support regular expression in query strings, and so you need to
> > use SQL LIKE syntax, which is basically using '%' instead of '.*'
> > and '_' instead of '.'.
> 
> Hmm...No regular expressions, eh?  Well this really isn't sister
> friendly (the person who is actually going to be using this).  I could
> probably teach her regexps but I don't know enough SQL foo to get by.
> 

Actually there is not SQL foo to know.  Everything there is I've
described above.  Basically use an underscore (_) like a single
character wild card, and a percent (%) like a multicharacter wild card,
and that's your lot.  Regular expressions give you more flexibility, but
in my opinion are far less "sister friendly" than using a '%'.  So
you're probably good as you are.

> All of the manpages talk about regexps, as does the manual.  Which
> backends support this?  Both MySQL and pgsql?

I'm not sure of pgsql, but mysql does.  However it only does when
the client code uses the right query operator.  The SQL standard
only supports a pattern matching query (LIKE) with % and _ as special
characters, which is why SQLite does that.  To be honest use of
regular expressions in refdbc is a bit overkill for most queries.

> > I'm not sure about the hanging.  I had the same problem myself, until I
> > started using strings that worked.  For instance 'getref' on its own
> > hung, and I needed to press 'control C' to return control, but then the
> > database connection appeared to have broken, and I needed to close
> > refdbc and reload it again.
> 
> Ditto...If I do "getref" with no arguments no further valid getref
> queries work.

Yes.  I'm sure that's a bug (or feature)!

Joe
-- 
=== Josef Karthauser ([email protected]) === http://x2obuilder.com/tao ===

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
Refdb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/refdb-users

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.4 (FreeBSD)

iEYEARECAAYFAkW2dHsACgkQXVIcjOaxUBbU6QCeL8Gi1S1Sa8/B4u9a04y9lAtS
n1EAnA+FE9ooT04tJXtp20OCksKaEPRH
=SMqB
-----END PGP SIGNATURE-----