Mailing List Archive


Back to the month index Back to the list index
Francesco Pasqualini (francesco@glamm.com)
Mon, 2 Sep 1996 19:04:04 +0200 (MET DST) 

Date: Mon, 2 Sep 1996 19:04:04 +0200 (MET DST)
Message-Id: <199609021704.TAA20192@sea.glamm.com>
From: Francesco Pasqualini <francesco@glamm.com>
Subject: Re: [mSQL] mSQL + msql PERL interface

At 12.04 02/09/96 +0100, you wrote:
>On Fri, 1 Sep 1995 jcoy@arkansas.net wrote:
>
>> Here is a sample script I'm trying to get working, but it
>> fails because the information in the getpwent() array is
>> not quoted.
>
>I had a similar problem a while ago. You have to quote the fields
>yourself.
>
>> create table pwent (
>> uname char(8),
>> passwd char(32),
>> uid int,
>> gid int,
>> quota int,
>> comment char(32),
>> gcos char(32),
>> homedir char(32),
>> shell char(32)
>> )
>
>

to quote all char fields you can use:

foreach $field ( $uname,$passwd,$comment,$gcos,$homedir,$shell){
        $field="'$field'"
}

Francesco

--------------------------------------------------------------------------
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!