Re: Multiple tables

[..hidden..]

I imagine its the quoting.
I would use qq| for the sql and Form.pm sub quote for the data.
I like the idea of a separate table for anything extra makes upgrades safer.

We use <table_name>_xtras so for parts we have a parts_xtras.

Here is the code I use:

for (qw(vndr_invoice monthly_bill )) {
	  $form->{$_} = $form->quote( $form->{$_} );
	}

	$query = qq|
		INSERT INTO parts_xtras (parts_id,vndr_invoice,monthly_bill) VALUES
(?,?,?);
|;

	$sth = $dbh->prepare($query);
	$sth->execute(
		      $form->{id},
		      $form->{vndr_invoice},
		      $form->{monthly_bill}
		     ) || $form->dberror($query);
      }
    }
I really enjoyed this book:
http://shop.oreilly.com/product/9781565926998.do
Cheers
turtle

> The situation is that multiple Amazon product identifiers (ASIN) can be
> assigned to one of our products (parts).  We have a custom field
> ("asin") on the Add Part screen.  When data reaches *ic.pl*, the code
> (snippet) below is exercised to insert a row in the parts table.  Since
> there can be multiple ASINs, it would be better to store them in a
> separate table with a foreign key.
>
> I'm an experienced Python developer, but a novice at Perl.  The last
> three lines of code are causing the queries to not work.  What syntax
> should I introduce into ic.pl to store ASINs in a separate database table?
>
> Thanks.
> Brian
>
>
>      $sth = $dbh->prepare($query);
>      $form->{partnumber} = trim($form->{partnumber});
>      $form->{description} = trim($form->{description});
>
>      <snip>
>
>      $sth->execute(
>          $form->{partnumber},      $form->{partname},
>
>      <snip>
>
>          $form->{expense_accno},   $form->{obsolete},
>          $form->{image},           $form->{drawing},
>          $form->{microfiche},      $partsgroup_id,
>          $form->{id}
>      ) || $form->dberror($query);
>
> *   $query = "insert into part_asin (part_id, asin) values (?, ?)";**
> **    $sth = $dbh->prepare($query);**
> **    $sth->execute( $form->{id}, 'B005QUQP8U');**
> ***
>
> Activus Technologies
> Brian Wolf
> Phone: 410.367.2958
> Email: ..hidden..
>
>   * Integrated Payment Solutions
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk_______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>