Getting data from SQL database

Hmm, the dangers of answering threads in reverse chronological order. Apparently you are familiar with the Socket api.

Something like that should work, yes.

But your question is quite oddly phrased. I assume you've tried that and it does not work [else why would you be posting]? But you do not tell us how it fails!

How does it fail?

conn.write(" GET /getassetstatus.php?enc=10.1.1.234~38~11~13446~PASSWORD");

I dont know what the "GET" does, and the code I used as a base had "HTTP/1.0\n\n" at the end of the url.

 

With all my tests, the variable reply is always empty.

You need the <SPACE>HTTP/1.0\n\n! Why did you take it out? Check the protocol spec, http://www.ietf.org/rfc/rfc2616.txt.

You also have a leading space that looks wrong. So:

conn.write("GET /getassetstatus.php?enc=10.1.1.234~38~11~13446~PASSWORD HTTP/1.0\n\n")

Sigh...

I'm sorry, Roy, I really thought that the example in the JS Tools Guide told you how to seperate the actual response from the server's headers. But it doesn't!

Anyhow, RFC2616 tells us:

6 Response

 

   After receiving and interpreting a request message, a server responds

   with an HTTP response message.

 

       Response      = Status-Line               ; Section 6.1

                       *(( general-header        ; Section 4.5

                        | response-header        ; Section 6.2

                        | entity-header ) CRLF)  ; Section 7.1

                       CRLF

                       [ message-body ]          ; Section 7.2

So, that means the message body is seperated by two CRLF pairs. Except that because of API magic each CRLF turns into a single \n. So you want to look for \n\n.

So, you should be able to seperate it like this:

body = reply.substr(reply.indexOf("\n\n")+2);

It should be available for the help menu in the ESTK.

Harbs

I have the "javascript tools guide cs3" but dont seem to have the CS5 version.  Do you know where I can get it?

Harbs is certainly right, but you should bookmark the Adobe InDesign Scripting Resources page.

But it links to http://wwwimages.adobe.com/www.adobe.com/content/dam/Adobe/en/products/indesign/pdfs/JavaS criptToolsGuide_CS5.pdf.

Out of interest I used

myDataToUse = reply[reply.length-1];

As I am only interested in a single digit!

You realize this is a bad idea...what if it goes to ten? Or if you try to repurpose the code for something else? Etc.

Sorry I missed your question yesterday, Roy.

Are you trying to send a second query in the same connection as the first? Try a seperate connection.

What is "errorText" Can it contain spaces? Please $.writln() out the exact text being sent and post it here...

I am standing by for the complete line. But are you re-using the same connection, yes or no?

As I said, please $.writeln() the complete line being sent and post it here.

Err, this code can't be write:

myServerAddress = "automation.yappp.net:80";

    myFullScriptString = "do shell script \"curl -0  "+ myServerAddress + "sendSrcError.php?e=" + errorText + "\"";

This works perfect.

Because it would give you "curl -O automation.yappp.net:80sendSrcError.php?e=something" with no slash before sendSrcError.

Care to clarify?

I don't want to muddy things up, but if you want some other options for OSX, I've been using some scripts and frameworks to talk to an MS-SQL db, and it should work for some other SQL db's also. Send me a PM if interested.

Sorry about that!

Can you explain in more detail what you are asking?

Sure! I wasn't trying to be cryptic, and I guess I missed your first request for clarification.

We want to know exactly what is being sent to the server, so we can understand what might be wrong.

So, just add this line beforehand:

$.writeln("SENDING: <<"+"GET /sendSrcError.php?e=" + errorText+"\ HTTP/1.0\n\n"+">>");
Conn.write("GET /sendSrcError.php?e=" + errorText+"\ HTTP/1.0\n\n");

Then it will print the GET line on the console and you can paste it here and we can see what (if anything) is wrong with it.

Sorry for the delay, I was gone for the long weekend.

I should also have asked you, as part of the diagnostic process, to tell us what was in reply.

This question is being continued in http://forums.adobe.com/message/3963484#3963484

I don't know about other people, but I find that practice annoying. Stick with your thread, don't try to bump it. IMNSHO.

Anyhow, the problem appears to be that your server does not accept HTTP/1.0 queries in this case, it requires HTTP/1.1. I am not sure why that would be it seems surprising to me.

So, you should restructure your code like this, to be HTTP/1.1 compliant, which basically means including the Host: header to support HTTP/1.1 Virtual Hosting:

function combinedErrorReportWithSocket(errorText)
    //errorText is something like "Library not found"
     {  
     myServer = "automation.yappp.net"; myPort=80;
     myServerAddress=myServer+myPort;
     errorText = encodeURI(errorText);
     conn = new Socket();
     conn.open(myServerAddress); 
     conn.write("GET /sendSrcError.php?e=" + errorText+
        " HTTP/1.1\nHost: "+myServer+"\n\n");
     reply = conn.read(999999);
     conn.close;
    }

Whoops, typo. Left out the colon, should be:

myServerAddress=myServer+":"+myPort;

hi all,

just wanted to reactivate this topic as we've proudly released an innovation: http://www.porky.io

porky is a ESTK/JavaScript extension/functions library and you can use various data types like SQL databases, XML- and JSON files as a variable source.

So: create entire publishing workflows based on your JavaScript code!

Happy coding :-)

Cheers

HI Dr. TYPO

I'm interested in your innovation and downloaded/installed it, but when i follow the instructions and double click the "start-porky-data-source-access.jsx" as it states I get a warning that says "not yet implemented, sorry"

I am using CC, would that be the issue?

Nevermind, looked at the code and noticed it was applescript.  Do you have a PC workaround?

Thanks for your interest in porky!

On OS-X we have a php interpreter (which handles the database connection) already included out of the box.

The launcher script for the windows platform will be implemented pretty soon – I'll let you know as soon as it is ready!

Hi csparrowsugoi,

the Windows version of porky (JavaScript library with database access for Adobe InDesign) is now available!

Please check porky.io and follow the installation guide in the download section.

Cheers

thank you kindly sir. I'll check it out!  Hopefully I'm smart enough to get by installation lol

Amazing.. works like a charm. I think I can easily work this for a direct to mySQL connection using the SQLLite examples.  Kudos!