Perl DBI and Varchar fields

Dev Shed Forums Sponsor:

March 24th, 2004, 08:14 AM

singhjoga

Registered User

Join Date: Mar 2004

Posts: 20

Time spent in forums: 1 h 13 m 31 sec
Reputation 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

March 24th, 2004, 02:35 PM

mariuz

Bug Hunter

Join Date: May 2003

Location: Transylvania (Romania)

Posts: 309

Time spent in forums: 1 Day 9 h 38 m 4 sec
Reputation Power: 22

Quote:

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

March 26th, 2004, 11:02 PM

singhjoga

Registered User

Join Date: Mar 2004

Posts: 20

Time spent in forums: 1 h 13 m 31 sec
Reputation 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

Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Perl DBI and Varchar fields

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump