Mailing List Archive

trouble with DBIx::Recordset
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 [ In reply to ]
> <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