[ic] [query] tag insert
Eric
eric at 80s.com
Mon Jan 12 11:37:39 EST 2004
Is it possible to insert data into a table using the [query] tag?
I'm getting the error:
Safe: Search pattern not terminated at (eval 193) line xxx
I'm using interchange 4.8.6 and perl 5.8.0
Here's a snip of my code:
[set order_changes]
[perl]
my $sqldsn = $::Variable->{SQLDSN};
my $sqluser = $::Variable->{SQLUSER};
my $sqlpass = $::Variable->{SQLPASS};
# first we need to insert data into the order_changes_log table
my $ordernumber = $CGI->{order};
my $username = $Session->{username};
my $comment = $Values->{comment};
[query sql="insert into order_changes_log (order_number, username,
timestamp, comment)
values($CGI->{order}, $Session->{username}, now(), $Values->{comment})"]
[/query]
. more code going here .
[/perl]
[/set]
Thanks,
Eric Terry
More information about the interchange-users
mailing list