Beefy Boxes and Bandwidth Generously Provided by pair Networks vroom
Syntactic Confectionery Delight
 
PerlMonks  

Re: DBI: $sth->{NAME}

by BlueBlazerRegular (Friar)
on Sep 12, 2002 at 16:44 UTC ( [id://197348]=note: print w/replies, xml ) Need Help??

This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.


in reply to DBI: $sth->{NAME}

From "Programming the Perl DBI", p. 323:

"The names of identifiers, such as tables and columns, cannot exceed thirty characters in length."

From what I remember, this limitation is in Sybase (at least up thru 10.2) itself. MS SQL Server also appears to have this limitation.

Pat

Replies are listed 'Best First'.
Re: Re: DBI: $sth->{NAME}
by crouchingpenguin (Priest) on Sep 12, 2002 at 16:57 UTC
    Indeed this seems to be the case:
    The names of Sybase identifiers, such as tables and columns, cannot exceed 30 characters in length.
    from the dbd-sybase.pod.

    I guess I will have to cheat. Thanks for the time and help.
[reply]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://197348]
help
Sections?
Information?
Find Nodes?
Leftovers?
    Notices?
    • hippo‥ epoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    • erzuuli‥ Anonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.