trouble with DBIx::Recordset

[Jon Brisbin <br...@ipa.net>]

I'm having trouble with the following snippet of code, found here:

http://38.240.49.7/virtual/bowenwhite.com/orders

why is the info showing up blank??

thanks!

Jon Brisbin
www.jbrisbin.net
mail@jbrisbin.net

[-
$fdat{'!DataSource'} = "dbi:mysql:dbname";
$fdat{'!Username'} = "user";
$fdat{'!Password'} = "pass";
$fdat{'!Table'} = "orders";
*set = DBIx::Recordset->Search(\%fdat);
-]

<table cellpadding=0 cellspacing=0>
  <tr bgcolor=#dddddd><th width=125>View Info</th><th>Order ID</th></tr>
  <tr>
    [- $rec = $set[$row] -]
    <td align=center>
      <a href="customer.ehtml?cid=[+ $rec->{oCustomer} +]">Customer</a><br>
      <a href="product.ehtml?pid=[+ $rec->{oItemNumber} +]">Product</a><br>
    </td>
    <td>[+ $rec->{oSessionId} +]</td>
  </tr>
</table>

[- $set->Disconnect; -]

Re: trouble with DBIx::Recordset

[Gerald Richter <ri...@ecos.de>]

>       <a href="customer.ehtml?cid=[+ $rec->{oCustomer}
+]">Customer</a><br>

DBIx::Recordset translastes fieldnames to lowercase to be compatible between
different DBMS

write:

       <a href="customer.ehtml?cid=[+ $rec->{ocustomer} +]">Customer</a><br>

Gerald