Win32::ODBC question ; updating an MS Access table

2001-03-15 Thread Vinicius Alves

I´ve read the perldoc and I´ve found several things, except how to update my
DSN.
My script blurts out an html page containing several text fields with the
data that is in my access file. I want to be able to change that data by
simply changing the info in the text fields and clicking the button.
Until now I´ve always done it using flat .txt or .csv files, creeated a new
file with the info I wanna keep and unlink()´ed and rename()´ed them as
needed.

How´s the best way (if there is one - which I believe there is) to access
the table and set a cell with the data I want to update?

Vinicius Alves
Prosites - Soluções em Internet
Webmaster

___
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users



Help with Regexp

2001-03-14 Thread Vinicius Alves


Hi all...

I´m using an HTML template to put the values of a database in the values of
the fields. I´ve been tying to do that by setting the field value:
$variable, to that when I call

while (){
print;
}

the html code  shows up, when what I
want is .

So I need a regexp that would look for

s/value="$(wildcard)"/value="$variable_with_same_name_as_wildcard/g

one I tried is

s/value="$(*)"/value="$main::$1"/g;

but I get an error: "/value="$(*)"/: ?+*{} follows nothing in regexp at
c:\mydir\mycode line 61"

Can anyone help me out?

Vinicius Alves
Prosites - Soluções em Internet
Webmaster

___
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users



Problem with scallar assignment

2001-03-06 Thread Vinicius Alves



Hi all...
 
Let me see if I can explain my 
problem.
 
I´m testing Win32::ODBC and I´m trying to 
make the same script work for several options, guided only by 
hidden fields in my html form.
 
What I want to do is to assign $listed_object = 
$form{'option'}, thus having 'domain' as value for $listed_object. So far no 
problem, of course. 
But later down I have a scallar $domain (along with 
several others) to which is assigned my Access field and a bit further yet, 
I want the value of $listed_object (right now, 'domain') to become $domain, with 
$domain ´s value. Like a reference to the scallar. 
I´m having troule finding the right syntax to do 
that, since I´ve been getting a list of '$domain' one on top of another, instead 
of $domain ´s value.
Can anyone help me? (IF anyone´s understood my 
terrible explanation, that is :-)
Thanks
 
Vinicius Alves