[Virtuoso-users] Problem with TOP queries

2007-10-04 Thread Sören Auer
Hi all, I tried the following code with both Virtuoso for Windows and Linux: $db=odbc_connect('virtuoso','dba','dba'); $result = odbc_exec($db,'SELECT TOP 3 * FROM DB.DBA.SYS_USERS'); print_r(odbc_result_all($result)); However, I always get the full result set and not just the top three as I wou

[Virtuoso-users] ENUM and SET column types

2007-10-04 Thread Sören Auer
Hi all, MySQL has the neat feature of defining a table column to be a enumeration or set of a number of elements, e.g.: create table person ( name varchar, sex enum('male', 'female') ) or: create table person ( name varchar, likes_fruits set('apple', 'pear','orange') ) I guess somethin

Re: [Virtuoso-users] virtuoso-php5-t crashes on Vista with malformed SQL

2007-10-04 Thread Mitko Iliev
Hi Sören, I found that odbc driver causes this problem. We have a fix for it so we will update the driver soon. Best Regards, Mitko Mitko Iliev wrote: > Hi Sören, > > I tried the case locally, but just getting : > > Warning: PHP Startup: SQL error: [OpenLink][Virtuoso ODBC > Driver][Virtuoso Se

Re: [Virtuoso-users] virtuoso-php5-t crashes on Vista with malformed SQL

2007-10-04 Thread Mitko Iliev
Hi Sören, I tried the case locally, but just getting : Warning: PHP Startup: SQL error: [OpenLink][Virtuoso ODBC Driver][Virtuoso Server]SQ074: Line 1: syntax error at '*' before 'FROM', SQL state 37000 in SQLExecDirect in C:\dbs\var\lib\virtuoso\vsp\vos1.php on line 3 Warning: odbc_result_all():

Re: [Virtuoso-users] virtuoso-t dumping core on Solaris 10

2007-10-04 Thread Virtuoso Maintainer
Hi Trevor, Seems like passing CFLAGS=-O no longer prevents 'virtuoso-t' from dumping core in version 5.0.2 on Solaris. Which compiler (+version) are you using to compile virtuoso on your Solaris 10 sparc system? Patrick -- Patrick van KleefEmail : Virtuoso Maintainer

Re: [Virtuoso-users] Problems compiling on OS X

2007-10-04 Thread Virtuoso Maintainer
Hi Trevor, Having some trouble compiling on OS X 10.4.10 % uname -a Darwin names-computer.local 8.10.1 Darwin Kernel Version 8.10.1: Wed May 23 16:33:00 PDT 2007; root:xnu-792.22.5~1/RELEASE_I386 i386 i386 Output from 'make': [..cut..] Making all in ODS-Polls make[2]: Nothing to be done for