if statement

2001-06-20 Thread Ward, Stefan
This isn't working for me. Help please. What is wrong with the second if statement while ( ($timestamp, $report_type, $game_name, $data_name, $data_value) = $ora_sth->fetchrow_array) { if (($data_name eq 'min') || ($data_name eq 'time')) {$data_value = $data_value * 144

Two questions in one.

2001-06-18 Thread Ward, Stefan
I have two question related to the question below: 1. Is fetchrow() the fastest way in and out of the DB? I don't want the data warehouse tied up while someone is loading a huge report. 2. I would like to create frames with CGI so the list stays on the left side and the data is displaye

Question about submit buttons

2001-06-14 Thread Ward, Stefan
Below I want to take the value they select form a list and place it into the where clause of the SQL statement. How do I get there from here? I know I need a submit button, where does that go in the structure of the print $query??? if ($guess eq "") { print header; print $que

Noobie question

2001-06-13 Thread Ward, Stefan
Does anyone have an example of a way to write a perl script that will go out hit a data base table, pull in a column for that table and use that column in a dropdown list? I know what to do once I get that variable selected by RTFriendlyM, but couldn't find a clear example of this. Thanks, Ste