Mailing List Archive


Back to the month index Back to the list index
Joao Marcos Melo Mendes (jmmm@megamedia.pt)
Mon, 2 Sep 1996 20:28:03 +0100 (BST) 

Date: Mon, 2 Sep 1996 20:28:03 +0100 (BST)
From: Joao Marcos Melo Mendes <jmmm@megamedia.pt>
Subject: Re: [mSQL] insert's query using variables in a perl5...
Message-Id: <Pine.BSF.3.91.960902202643.10218F-100000@gatekeeper.megamedia.pt>

Hi, there.:)B

On Sun, 1 Sep 1996, Luis Alberto Vianna Tavares wrote:

> How can I make a insert's query using variables in a perl5 and MsqlPerl ?
> Like:
> INSERT INTO table( field1, field2 ) VALUES ( $var1, $var2 )

As long as you put your query in double quotes, you should be fine. I.e.:

$dbh->$query("INSERT INTO table(field1,field2 ) VALUES ($var1,$var2 )");

Hope this helps.:)

                                        Joao Mendes
                                        MegaMedia, S.A.

"We're fools to make war on our brothers in arms." - Mark Knopfler

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!