sql select

**HankFay** · 2013-04-05, 19:07

Originally Posted by jmonte407

I'm an adminstrator on this computer.. the folder is set for "everyone" read/write.. connection is successful.. It works if i'm just creating a cursor.. all the records are returned... but outputs such as HTML.. XML... JSON ... doesnt work,,, just create the cursor as this I just used "select * from inventory"...

select * from southwind!customers into object myDataObject
myJsonString = json_encode(myDataObject)

By and large, Lianja is made for large numbers of users on a server. It saves memory by having only 1 copy of the runtime in memory, using separate memory spaces (multi-tenant) for each user. Using a memory object, then, rather than a file, is a trade-off between memory available for other uses, and speed. In most cases I don't think it will make much difference in memory, as there aren't that many applications where you have 3,000 users hitting a server: it's just something to keep in mind. And of course, it's all able to be tuned.

hth,

Hank

**barrymavin** · 2013-04-05, 20:03

Or as stated here for outputting objects as JSON.
http://www.lianja.com/doc/index.php/PRINT_JSON()

Code:

open database southwind
select * from shippers into object shipobj
print_json(shipobj)

In a .rsp page that will send the JSON straight back to the browser so you would typically use this with an AJAX call.

**barrymavin** · 2013-04-04, 09:47

Hi Jim, you can see what the default directory is like this.

select default() as def from sysresultset

**jmonte407** · 2013-04-16, 07:54

Just install the latest of everything... I was going to test the Lianja SQL server to see if the select to json stuff worked... however, nothing seemed to happen... then I looked to see if the sql server was running and it was stopped... I clicked start and got this message "Service state was not set"... I rebooted my computer.. looked to see if the sql server was running.. It was running.. so I clicked stop.. then clicked start again... same message .. "Service state was not set" ...

**barrymavin** · 2013-04-16, 07:57

Hi Jim, It will be fixed in RC5.4 -- its just the expiry date on the beta. Will be available within a day or so.

**jmonte407** · 2013-04-16, 08:02

Thanks Barry...

**barrymavin** · 2013-04-16, 08:05

Jim, make sure you stop the Lianja SQL Server before the install. Maybe thats the issue.

**yvonne.milne** · 2013-05-09, 06:11

Hi Jim,

Sorry to hear this is still causing problems. I have Submitted a Ticket to get it looked into again.

Thanks,

Yvonne

**Phjr** · 2013-07-10, 03:43

Hi, Sql Server RC6.0 still hangs when restarted ! please find log below
* Lianja SQL Server
* Version 10.0.4
* Compiled on Jun 17 2013 18:21:30
*
* logfile C:\Lianja\sqlserver\log\portserver_007.log
* started at Wed Jul 10 10:38:13 2013
* on PAM-003818 pid 4432
*
RSI: **** Recital/RSI TCP/IP port server activated ****
ident = [tcp_accept]
time = 10:38:13
pid = 00001150
RSI: **** getservbyname("db_rsibase","tcp") port=8001 ****
ident = [tcp_accept]
time = 10:38:13
pid = 00001150
RSI: **** setsockopt SO_RCVBUF=16384 ****
ident = [tcp_accept]
time = 10:38:13
pid = 00001150
RSI: **** setsockopt SO_SNDBUF=16384 ****
ident = [tcp_accept]
time = 10:38:13
pid = 00001150
RSI: **** socket buffer sizes - so_rcvbuf=16384, so_sndbuf=16384 ****
ident = [tcp_accept]
time = 10:38:13
pid = 00001150
RSI: **** Trial license has expired ****
ident = [tcp_accept]
time = 10:38:13
pid = 00001150

Regards