Re: Trouble configuring refDB
Martin Hicks <[email protected]>
| Newsgroups | gmane.text.refdb.general |
|---|---|
| Message-ID | <[email protected]> |
On Tue, Jan 23, 2007 at 06:16:47PM +0000, Josef Karthauser wrote: > On Tue, Jan 23, 2007 at 12:39:40PM -0500, Martin Hicks wrote: > > > > Should actually return something. And I can't get getref to work > > either. Using an example similar to that found in the Query Lanuage > > section of the manual: > > > > refdbc: getref :AU:~^Tyson > > > > Does > refdbc: getref :AU:~'tyson%' Yes, this does work... > > 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. All of the manpages talk about regexps, as does the manual. Which backends support this? Both MySQL and pgsql? > 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. mh -- Martin Hicks || [email protected] || PGP/GnuPG: 0x4C7F2BEE ------------------------------------------------------------------------- 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
signature.asc
(application/pgp-signature, 189 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFFtmNL0ZUZrUx/K+4RAu7AAKDBdXH5v/BDnJ0K/86oiGYKr8q+NQCcCgb3 /AcFjkltYNmZbd/FXugEWUE= =Kz12 -----END PGP SIGNATURE-----