[ic] Stock Notification System that works - maybe not elegant :)

[J.M.R.]

Hi Russ,

I´ve tried to use your code. Seems that table  created OK but, when I submit
the stock_alert.html and loads stock_alert_added.html which means that write
data in the created stock_alert table, it writes nothing and I can see this
error in error.log

----------------------------------------------------------------------------
-----
localhost.localdomain yC9hgJoj:localhost.localdomain -
[22/marzo/2002:13:14:49 +0100] cc /cgi-bin/cc/process.html Safe: Can't call
method "query" on an undefined value at (eval 577) line 14.



 $sql_req = "
 INSERT INTO stock_alert SET
 sku = '$Values->{bo_sku}',
 price = '". $Tag->filter('sql', $Values->{bo_price})."',
 description = '". $Tag->filter('sql', $Values->{bo_description})."',
 author = '". $Tag->filter('sql', $Values->{bo_author})."',
 fname = '". $Tag->filter('sql', $Values->{fname})."',
 lname = '". $Tag->filter('sql', $Values->{lname})."',
 email = '". $Tag->filter('sql', $Values->{email})."',
 date = '$Scratch->{bo_time}'
 ";
 $Db{stock_alert}->query("$sql_req");
 return;

----------------------------------------------------------------------------
---------

Could you help, please.

Thanks you.

> -----Mensaje original-----
> De: interchange-users-admin@interchange.redhat.com
> [mailto:interchange-users-admin@interchange.redhat.com]En nombre de Russ
> Mann
> Enviado el: martes, 19 de marzo de 2002 20:47
> Para: interchange-users@interchange.redhat.com
> Asunto: [ic] Stock Notification System that works - maybe not elegant :)
>
>
> This Stock Notification system works.  All the maintainer has to do is
> update the inventory of the products and the users will automatically be
> sent notification that the product they want is now in stock.  It
> uses 2 IC
> pages and one separate perl script, and relies on mysql data.  If someone
> could write the separate perl script into some sort of Interchange page,
> that would probably help for ultimate integration.
>
> -Russ Mann
>