Are you planning for vacation, holiday?
We would like you to spare your valuable time!
Visit our website www.magical-nepal.com for information on Nepal,
Tibet and Bhutan.

Thanking you in advance visiting and look forward to assist you.

Regards,

Rath Nepal Tours and Travels
P O Box 10691, 2nd Floor Mountain Plaza
Tel: 977-1-4268948, 4258141, 4264512
Fax: 977-1-4264512
E-mail: sales@magical-nepal.com
website: www.magical-nepal.com

I have many tables of results, a sample record looks like as below
in my code together with fields in the db.

The problem is this. Not every table I receive has the same fields.
Sometimes there are fields, "test4", "test5" for example.There is always
a fixed number of 7 fields.

Is it possible to have my code change the INSERT INTO statement so that the
fields change
depending on the fields in each table?....of course the db will have all
possible fields
included.
In other words, can the field names be variables?...if so what is the syntax
for this?

Any help appreciated!

#!/usr/bin/perl -w
use strict;
use warnings;

use Win32::ODBC;
use dbi;

Amy Lee gmail.com> wrote:

You appear to not have followed step 3...

[A complimentary Cc of this posting was sent to
Uri Guttman
stemsystems.com>], who wrote in article mail.sysarch.com>:

Yet another case of broken documentation. Still, //o helps (though
nowhere as dramatically as before). It avoids CHECKING that the
pattern did not change.

Hope this helps,
Ilya

On Jan 16, 9:28 am, thellper gmail.com> wrote:

Just a guess but splitting into pieces and then applying the regex
to each piece may well be a signifcant slowdown. Have you considered
trying to tweak the regex to avoid the split and resultant copies...

Hi,

I have two text files: each one has has four fields (delimited by a
space) on each line: id, group, email and manager_id. First file is a
small file with 50 entries and the second one is a huge file with
5,000 entries. The "id" field is same in both files, but the
manager_id's may be different. By comparing all the entries in the
second file (that has the correct manager id), I need to update the
manager_id field in the first file.

Here is the code, I am thinking of:

-----------------------------------------
open (INPUT1,"smallFile.txt") or die "Cannot open the file: $!";
open (INPUT2,"bigFile.txt") or die "Cannot open the file: $!";

while $line1 ()
{
@small_arr = split /\s+/, $line1;
}

This is an excerpt from the latest version perlfaq8.pod, which
comes with the standard Perl distribution. These postings aim to
reduce the number of repeated questions as well as allow the community
to review and update the answers. The latest version of the complete
perlfaq is at http://faq.perl.org .

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

8.20: How can I call my system's unique C functions from Perl?

In most cases, you write an external module to do it--see the answer to
"Where can I learn about linking C with Perl? [h2xs, xsubpp]". However,
if the function is a system call, and your system supports syscall(),
you can use the syscall function (documented in perlfunc).

Remember to check the modules that came with your distribution, and CPAN
as well--someone may already have written a module to do it. On Windows,
try Win32::API. On Macs, try Mac::Carbon. If no module has an interface
to the C function, you can inline a bit of C in your Perl source with
Inline::C.

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

In article <1200583365.481814@nntpcache01.si.eunet.at>, Peter
Ludikovsky gmail.com> wrote:

[top-posting fixed]

... or trying entering 'perldoc -q ftp' at a command-line prompt.

In article
<4f375943-9bfe-475b-8a1f-a48f8c42b5b6@j20g2000hsi.googlegroups.com>,
vineet gmail.com> wrote:

vineet wrote: