Server: www.site.com
Server: 'www.site.com'
Date / Time: 06/26/02 00:13:38
Browser: Mozilla/4.5
Error: ODBC Error Code = S1000 (General error)
[Oracle][ODBC][Ora]ORA-00936: missing expression 

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (394:3) to (394:60).

##</code><code>##

#!/usr/lib/perl

use strict;
use warnings;

use LWP::UserAgent;
use HTTP::Request::Common;
use HTTP::Cookies;
use LWP::Simple;

my $ua = LWP::UserAgent->new;
$ua->cookie_jar(HTTP::Cookies->new(file => 'cookie_jar', autosave =>1));
$ua->agent( "Mozilla/4.5" );
# do redirects after post
push @{ $ua->requests_redirectable }, 'POST';

$ua->request(POST "http://www.site.com/login.cfm",
						{
							username	=>"test",
							password	=>"testabc",
							sid			=>"$sid",
							submit		=>"Submit"
						});

my $request = $ua->request(POST "http://www.site.com/editproduct.cfm",
			{			
							name			=>"test",	
							version			=>"1.1",
							prodnote		=>"test",
							file			=>'/docroot/filename.exe'
							product_ID		=>"888999",
							session_id		=>"3298220938434",
							update			=>"Update"
						});

$b = $request->is_success ? "Worked\n" : "Error.\n";
my $a = $request->as_string;
print $a;