GRA
On Wednesday, Apr 2, 2003, at 13:45 US/Mountain, JT MacNeil wrote:
Hello, Are you sure you need the \G in the statement? I think the following would work: my $query = "SELECT * FROM MESSAGES WHERE pkey = $pkey";
J-T MacNeil Design Team Member, Connect 24 Division Digital Security Controls Phone: (905) 760-3000 x7302 e-Mail: [EMAIL PROTECTED]
-----Original Message----- From: Gregg Allen [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 3:51 PM To: [EMAIL PROTECTED] Subject: Perl DBI & MySQL Importance: Low
Can someone tell me why this statement works interactively but not from a perl script?
MySQL> SELECT * FROM MESSAGES WHERE pkey = $pkey\G ;
This prints the output in a very nice, readable format.
but:
my $query = " SELECT * FROM MESSAGES WHERE pkey = $pkey\\G ";
$sth->prepare($query);
$sth->execute();
This chokes on the prepare and execute statements. (It says the \G is invalid syntax.) All I want is a simple little script that will put an arbitrary database record into a file, after I feed it the primary key, but will output the record's file in a format that's readable and printable.
Thanks in advance,
Gregg Allen
