Hello Dossy,
An i using a too new libmysql? Does nsmysql needs updating to support this?
kind regards,
On Oct 25, 2007 3:41 PM, shedis <[EMAIL PROTECTED]> wrote:
> Without the call i get a different error message like:
>
> Database operation "select" failed (exception Error, "You have an
> error in your SQL syntax; check the manual that corresponds to your
> MySQL server version for the right syntax to use near
> 'MYPROC('SCANRES,'2007-10-2' at line 1")
>
> My ns_mysql version is: Ns_MySQL_DriverInit(nsmysql): Loaded
> Panoptic MySQL Driver v0.6, built on Jul 19 2007 at 19:30:40.
>
> kind regards,
>
> On Oct 25, 3:00 pm, Dossy Shiobara <[EMAIL PROTECTED]> wrote:
> > On 2007.10.24, shedis <[EMAIL PROTECTED]> wrote:
> >
> > > set sqlstmt "call MYPROC('SCANRES','2007-10-24 00:00:01','2007-10-24
> > > 23:59:59','%','%','%','%','%','%','%')";
> > ...
> > > Output:
> > > Database operation "select" failed (exception Error, "PROCEDURE
> > > MYDB.MYPROC can't return a result set in the given context")
> >
> > Remove the "call" from the SQL statement. Do you still get the error?
> >
> > -- Dossy
> >
> > --
> > Dossy Shiobara | [EMAIL PROTECTED] |http://dossy.org/
> > Panoptic Computer Network |http://panoptic.com/
> > "He realized the fastest way to change is to laugh at your own
> > folly -- then you can let go and quickly move on." (p. 70)
> >
> > --
> > AOLserver -http://www.aolserver.com/
> >
> > To Remove yourself from this list, simply send an email to <[EMAIL
> > PROTECTED]> with the
>
> > body of "SIGNOFF AOLSERVER" in the email message. You can leave the
> > Subject: field of your email blank.
>
>
> --
> AOLserver - http://www.aolserver.com/
>
> To Remove yourself from this list, simply send an email to <[EMAIL
> PROTECTED]> with the
> body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
> field of your email blank.
>
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]>
with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
field of your email blank.
