Make your own free website on Tripod.com

InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: InstantDB: Problem with DatabaseMetaData.getTables and hyphenated db names


Well, the problem is that if you insert 'tim's' into the database, it thinks you
only want to insert 'tim' but have the left over s' that is giving the problem,
and exception is thrown by instantDB.  So you shlould replace it with some
characters that it takes, i like using double quotes so it inserts 'tim"s'.  Not
sure if it is in the doc, but that is just how it works.



William Graham wrote:

> The sql that is being executed is not mine: it's what InstantDB uses to
> implement the DatabaseMetaData.getTables method.  This means I cannot check
> and embed anything it's doing in quotes.
>
> Is the problem that hyphens are not "allowed characters" in names?  Is this
> in the docs somewhere?  I did look, but didn't find any mention.  Maybe
> there should be a section outlining allowable names for databases and
> database objects?
>
> Also, if the hyphen is not allowed, imho, InstantDB should throw an
> exception if you specify a database name containing hyphens.
>
> Regards,
> Bill Graham
>
> ----- Original Message -----
> From: "Tom Ngo" <tngo@waterford.org>
> To: <instantDB@enhydra.org>
> Sent: Wednesday, January 10, 2001 8:10 AM
> Subject: Re: InstantDB: Problem with DatabaseMetaData.getTables and
> hyphenated db names
>
> > i usually replace hypens with double quotes.  depending how you set up
> your
> > field, if you put the fields as char, usually inserting char requires
> 'tim' with
> > hypens to work.  Thus any name or words that may have character, you
> should check
> > and replace it with double quotes, then replace it back when you query it.
> It is
> > a simple check.
> >
> >
> >
> >
> > Luke Lonergan wrote:
> >
> > > > If I do a DatabaseMetaData.getTables call on a database
> > > > with a hyphen in the name, I get an error.  I set
> > >
> > > I also get errors with a hyphen in the DB name. I stopped putting
> hyphens in
> > > DB names...
> > >
> > > Luke
> > >
> >
> > --------------------------------------------------------------------------
> ---
> > > To unsubscribe from this mailing list, send email to
> majordomo@enhydra.org
> > > with the text "unsubscribe instantdb" in the body of the email.
> > > If you have other questions regarding this mailing list, send email to
> > > the list admin at owner-instantdb@enhydra.org.
> >
>
> -----------------------------------------------------------------------------
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
begin:vcard 
n:Ngo;Tom
tel;work:801-576-4917
x-mozilla-html:TRUE
url:www.waterford.org
org:The Waterford Institute;Programming Dept.
adr:;;1590 East 9400 South;Sandy;Utah;84093;
version:2.1
email;internet:tngo@waterford.org
title:Programmer
note:ICQ# 74302099
fn:Tom Ngo
end:vcard