Search:

Type: Posts; User: barrymavin

Search: Search took 0.05 seconds.

  1. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    Yep it seems the distro did not build properly....

    Yep it seems the distro did not build properly. We will get that fixed up tomorrow.
  2. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    Yes I saw that. Someone in support will take a...

    Yes I saw that. Someone in support will take a look today (US time).
  3. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    Ok but is the \lianja\sqlserver directory still...

    Ok but is the \lianja\sqlserver directory still there and does it contain anything?
  4. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    Submit a ticket and attach a directory listing of...

    Submit a ticket and attach a directory listing of c:\lianja and all its subfolders with dates.

    Lianja SQL server is normally installed in c:\lianja\sqlserver do you still have that directory on...
  5. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    Someone in support will look into it and see why...

    Someone in support will look into it and see why thats happening.
  6. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    You need to download the RC6 version again and...

    You need to download the RC6 version again and reinstall. That version has expired as stated in the logs.

    RSI: **** Trial license has expired ****

    Make sure you have stopped it before...
  7. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    Ah. Sorry. You don't have RC5.4 yet. Hang off a...

    Ah. Sorry. You don't have RC5.4 yet. Hang off a few days.
  8. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    Jim, try it at the console in the App Builder.

    Jim, try it at the console in the App Builder.
  9. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    Thats good.

    Thats good.
  10. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    Jim, make sure you stop the Lianja SQL Server...

    Jim, make sure you stop the Lianja SQL Server before the install. Maybe thats the issue.
  11. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    Hi Jim, It will be fixed in RC5.4 -- its just the...

    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.
  12. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    Or as stated here for outputting objects as JSON....

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



    open database southwind
    select * from shippers into object shipobj
    print_json(shipobj)
  13. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    Ans the cloud server handles OData calls. Just...

    Ans the cloud server handles OData calls. Just point at a URI and it all goes back as JSON. Images too are handled and can be data bound into a Web Client.
  14. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    It can. Just write a stored procedure that loads...

    It can. Just write a stored procedure that loads it into a VARCHAR and read it on your client.

    If you want to just do it from a URI, use the Cloud Server and .rsp pages. Very fast and simple.
  15. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    Hi Jim, I have fixed that now so it will be...

    Hi Jim, I have fixed that now so it will be available in the next build. If you try it now with SELECT ... INTO HTML myfile.html that should work now.

    I anticipate that we will ship Lianja App...
  16. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    I am not on my computer at the moment. I will...

    I am not on my computer at the moment. I will investigate and get back to you when I am.
  17. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

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

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

    select default() as def from sysresultset
  18. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    SQL selects always produce a temporary set of...

    SQL selects always produce a temporary set of data, then process it depending on the output type. If its not producing the file it may be file permissions. Where is it you want the JSON to go to?...
  19. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    Hi Jim, check that the connection is successful....

    Hi Jim, check that the connection is successful. Try it interactively in te console to verify the syntax.
  20. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    It does, on the server where the SQL select is...

    It does, on the server where the SQL select is being executed.
  21. Thread: sql select

    by barrymavin
    Replies
    40
    Views
    12,079

    Jim, when you say "sent back to the client", what...

    Jim, when you say "sent back to the client", what client are you referring to?

    JSON, XML and HTML output types from SQL SELECT are textual. You normally use these in server pages (.rsp pages) to...
Results 1 to 21 of 21
Journey into the Cloud
Join us