[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