ghimh
|
| Posted: 03/29/2002, 1:03 AM |
|
ive generated perl codes for a registration system. the whole code works perfectly. i am also able to insert values to database. however, when i tried to view the data using a grid table or text field, i am not able to see the values on the table but only empty lines. lets just say i have 4 data in the oracle database, i can see 4 empty lines when i view the grid table. ive tried to print the values in the cgi file and i can see the value, but when i tried using the grid table, everything is empty. ive checked the code and found out one funny thing... the sql statement works but it is not able to pass the value from database using the GetValue($ref_db_record,"first_name"); and first_name is a column from the table.
please help...ASAP... thanks :)
|
|
|
 |
Nicole
|
| Posted: 03/29/2002, 1:39 AM |
|
Hello,
what is your CC version (see Help/About) and what pattern do you use (Perl pr Perl+templates)? And what are db connection settings for live site?
|
|
|
|
ghimh
|
| Posted: 03/29/2002, 1:53 AM |
|
its version 2.0.5
im just using .pl no templates
db connection
my $strConn = "dbi:Oracle:ebpp.etv.com.my";
my $strLogin = "regform_msaccess";
my $strPassword = "regform_msaccess";
i mean i can connect to db... insert data.. but cant view the data..all i see is empty lines that should be populated with data...
|
|
|
|
ghimh
|
| Posted: 04/04/2002, 7:41 PM |
|
ah i found the solution to this problem..its because it needs to have uppercase letter in the
$hashref->{UPPERCASE} then only itll get the columns in the ORACLE database... i guess its only for ORACLE databases only... [cool]
|
|
|
|
roy
|
| Posted: 12/16/2002, 3:57 PM |
|
I have the same problem but then with using PHP.
I don't understand in which file you adjusted
$hashref->{UPPERCASE}
in uppercase?
Please let me know!
|
|
|
|
roy
|
| Posted: 12/16/2002, 4:27 PM |
|
i am using ccs by the way.
The strange thing is that the page exactly displays 5 rows which relates to the result of the query. It just doesn't display the values in the rows!
|
|
|
|
Roy
|
| Posted: 12/18/2002, 5:11 AM |
|
Somebody, anybody help!
|
|
|
|
RonB
|
| Posted: 12/20/2002, 4:57 AM |
|
try setting the labels to text instead of what it is now. I'm using oracle 8 and php and have no trouble what so ever. I've noticed that when setting labels to text instead of int etc I always get output. Maybe there's some type mismatch?
RonB
|
|
|
|
Roy
|
| Posted: 12/22/2002, 4:15 AM |
|
Thanks for you respons,
I downloaded the new beta version 2.0 of CCS. There was an option database names in uppercase. As soon as i used that everything was fine. Unfortunately I didn't now that the databasename was in uppercase. The program I am making is for an assignment at University. So the database names where already given, so i couldn't see whether they are in uppercase. What I don't understand is that i didn't had a connection error, when I was connecting to it before????
Roy
|
|
|
|
