2. PHPRunner General questions
  3. MSSQL ERROR bei stored procedure results
This topic is locked

MSSQL ERROR bei stored procedure results

 		4/21/2008 6:47:10 AM
PHPRunner General questions
rjks author

Hallo Support,
i´m using PHPR 4.2 for a MSSQL DB and recieve the following error when I call the List page.
PHP ... Fehler ist aufgetreten
Technische Information

Fehlertyp 256

Fehlerbeschreibung Source: Microsoft OLE DB Provider for SQL Server

Description: Falsche Syntax in der Nähe des top-Schlüsselwortes.

URL server01/procedure/Zweiterseite_list.php?

Fehlerdatei C:\Inetpub\wwwroot\webroot\isoft\procedure\include\dbconnection.mssql.win.php

Fehlerzeile 40

SQL Abfrage top 20
Where can I see the SQL string to check it`?

Connection to Server OK.

In the PHPRunner system the sql procedure works and returns a result.
I need this site to be finished in in 2 hrs??
thanks Robert
Alexey admin 4/21/2008

Hi,
unfortunatelly PHPRunner doesn't support stored procedure calls.

We plan to add this feature to the next version of PHPRunner.
rjks author 4/21/2008

Hello Alexey,
oops, and I was building my Site on them.
Is it possible to call a remote procedure and use the results to show a list by calling it in an event and using the results in the List?
Robert.