Yes, because it is a method call, you can't do it inside a quoted string. You could do something like:

$result->execute() or print "Error while executing query --- " . $resu
+lt->errstr();
[download]

/J\

I think you might be able to put a method call inside a double-quoted string by surrounding it with list constructor and de-references like this

$result->execute()
   or print "Error while executing query --- @{[$result->errstr()]}";
[download]

but whether you would want to is another matter as it looks a bit messy. If you have a call in the middle of a string then it might make more sense as you don't have to keep closing and opening quotes.

Cheers,

JohnGG

Thanks.

The following error message was printed..



Error while executing query ---
[Microsoft][ODBC SQL Server Driver]Connection is busy with results for
+ another hstmt 
(SQL-HY000)(DBD: st_execute/SQLExecute err=-1)
[download]



The solution to the problem is to include the following line in the code.

$dbh->{odbc_SQL_ROWSET_SIZE} = 2;

Regards