#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2004
    Posts
    20
    Rep Power
    0

    Perl DBI and Varchar fields


    Hi,
    I am using FireBird 1.5 on linux with Perl DBI 0.43.
    All Varchar type fields are returning me blank values.

    Any ideas???

    JS
  2. #2
  3. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Transylvania (Romania)
    Posts
    309
    Rep Power
    24

    Question


    Originally Posted by singhjoga
    Hi,
    I am using FireBird 1.5 on linux with Perl DBI 0.43.
    All Varchar type fields are returning me blank values.

    Any ideas???

    JS
    Do you have some example code (in perl)
    and can you give the database script to test it ?
    My home page: http://www.firebirdsql.org and work place :http://www.reea.net
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2004
    Posts
    20
    Rep Power
    0
    I have found the problem. It requires all the field names to be in Upper Case. Now I am using NAMES_lc, which gives me the field names in lower case.

    Thanks;

    JS

IMN logo majestic logo threadwatch logo seochat tools logo