in reply to Database links

Unfortunately, with only a high-level problem description, we can only really give you high-level answers. However:

  1. Use Javascript to create your popup window.
  2. Have a script to display the information for a specific work order in that window.
  3. Generate links to that script with the work order identifier in the URL. Something like: 
    http://www.example.com/showworkorder.pl?work_id=55500

    [download]
    Use that work order ID in your SQL query.
HTH
_______________
DamnDirtyApe 
Those who know that they are profound strive for clarity. Those who
would like to seem profound to the crowd strive for obscurity.
            --Friedrich Nietzsche

Replies are listed 'Best First'.
Re: Database links
by vorteks (Acolyte) on Aug 08, 2002 at 21:24 UTC
    OK
    Here's an update to make things clearer.
    I've managed to do some coding for what I need but I'm stuck at the crucial part

        @table_fields = "field1","field2","field3","field4");
    foreach $table_fields (@table_fields)
                
                {print"<th bgcolor=#7777CC><font color=#000000><font s
+ize=\"-1\">$table_fields</th>\n";}
    print"</tr>\n";

    open (DATABASE, "$database");
    while ($inLine = <DATABASE>)
{    $line=$inLine;
{    @fields = split(/\|/,$line);
          
                {print"<td bgcolor=$bgclr><font size=\"-2\">$fields[6]
+</td>\n";}
                
                {print"<td bgcolor=$bgclr><font size=\"-2\">$fields[8]
+</td>\n";}
                
                {print"<td bgcolor=$bgclr><font size=\"-2\">$fields[0]
+<a href=http://domain.com/cgi-bin/query_call.cgi?$fields[0]><img src=
+../images/red.gif></td>\n";}

    [download]
    The rest is irrelevant as what I need to know is the correct format to make the text of $fields[0] in the last line THE submission instead of red.gif and preferably without an image.
[reply]
[d/l]
[select]

      Eh? You want to make your anchor display the text of $fields[0], rather than displaying a gif?

      print "<a href=whatever>$field[0]</a>";

      Although, in general, you ought to have a look at using some module (CGI being the usual one) to handle this, as you'll be in trouble if $field[0] happens to contain any HTML specific characters (such as <). From your description of your data, you'll be ok in this case, but use CGI; is a good habit to get into.

      --
      Tommy
      Too stupid to live.
      Too stubborn to die.

[reply]
[d/l]
[select]
        OOPS...
        I meant
        {print"<td bgcolor=$bgclr><font size=\"-2\"><a href=http://www.whatever.com/cgi-bin/query_call.cgi?call=$fields[0]>$fields[0]</a></td>\n";}
[reply]
[d/l]

In Section Seekers of Perl Wisdom