{"action":"created","issue":{"url":"https://api.github.com/repos/oracle/node-oracledb/issues/575","repository_url":"https://api.github.com/repos/oracle/node-oracledb","labels_url":"https://api.github.com/repos/oracle/node-oracledb/issues/575/labels{/name}","comments_url":"https://api.github.com/repos/oracle/node-oracledb/issues/575/comments","events_url":"https://api.github.com/repos/oracle/node-oracledb/issues/575/events","html_url":"https://github.com/oracle/node-oracledb/issues/575","id":196959682,"number":575,"title":"node.js | oracledb - Query Help","user":{"login":"jncolvin","id":9312413,"avatar_url":"https://avatars.githubusercontent.com/u/9312413?v=3","gravatar_id":"","url":"https://api.github.com/users/jncolvin","html_url":"https://github.com/jncolvin","followers_url":"https://api.github.com/users/jncolvin/followers","following_url":"https://api.github.com/users/jncolvin/following{/other_user}","gists_url":"https://api.github.com/users/jncolvin/gists{/gist_id}","starred_url":"https://api.github.com/users/jncolvin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jncolvin/subscriptions","organizations_url":"https://api.github.com/users/jncolvin/orgs","repos_url":"https://api.github.com/users/jncolvin/repos","events_url":"https://api.github.com/users/jncolvin/events{/privacy}","received_events_url":"https://api.github.com/users/jncolvin/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-12-21T15:26:07Z","updated_at":"2016-12-21T15:59:41Z","closed_at":null,"body":"#### Answer the following questions:\r\n\r\n1. What error(s) you are seeing?\r\n\r\n-- No specific error. Need help with syntax.\r\n\r\n2. What *exact* command caused the problem (e.g. what command did you try to install with)?  Who were you logged in as?\r\n\r\n-- No specific command. Syntax question.\r\n\r\n3. What environment variables did you set?  How *exactly* did you set them?\r\n\r\n-- NA\r\n\r\n4. What is your version of Node.js?\r\n\r\n-- v6.9.2\r\n\r\n5. What is your version of the Oracle client (e.g. Instant Client)?  How was it installed?  Where it is installed?\r\n\r\nVersion: 12.1\r\nHow: Created directory under /opt/oracle/instantclient. Installed basic and sdk under directory. Symlinked libclntsh.dylib.12.1 => libclntsh.dylib. \r\n\r\nPath: # Oracle Path\r\nexport OCI_LIB_DIR=/opt/oracle/instantclient\r\nexport OCI_INC_DIR=/opt/oracle/instantclient/sdk/include\r\n\r\n6. What is your OS and version?\r\n\r\n-- macOS 10.12.2\r\n\r\n7. What compiler version did you use?  For example, with GCC, run `gcc --version`\r\n\r\nConfigured with: --prefix=/Library/Developer/CommandLineTools/usr --with-gxx-include-dir=/usr/include/c++/4.2.1\r\nApple LLVM version 8.0.0 (clang-800.0.42.1)\r\nTarget: x86_64-apple-darwin16.3.0\r\nThread model: posix\r\nInstalledDir: /Library/Developer/CommandLineTools/usr/bin\r\n\r\n\r\n### My Question\r\n\r\nHello All.\r\n \r\nI needed to reach out for some help with the oracledb module for node.js. I'm attempting to pass in dynamic variables to bind variables using a form. I'm trying to test my setup and need to see the final SQL query string. I've been reading the documentation for the module, but haven't found what I needed.\r\n \r\nCan someone help me understand how to console.log the complete execution query with bind variables in place?\r\n \r\nFor example, \"SELECT * FROM TABLE_NAME WHERE IDENTIFIER = :first_name\", [\"John\"]\r\n \r\nI'd like to see the final query to prove my bind variable is working. So it should end up looking like... \"SELECT * FROM TABLE_NAME WHERE IDENTIFIER = 'John'\"\r\n"},"comment":{"url":"https://api.github.com/repos/oracle/node-oracledb/issues/comments/268559216","html_url":"https://github.com/oracle/node-oracledb/issues/575#issuecomment-268559216","issue_url":"https://api.github.com/repos/oracle/node-oracledb/issues/575","id":268559216,"user":{"login":"dmcghan","id":585767,"avatar_url":"https://avatars.githubusercontent.com/u/585767?v=3","gravatar_id":"","url":"https://api.github.com/users/dmcghan","html_url":"https://github.com/dmcghan","followers_url":"https://api.github.com/users/dmcghan/followers","following_url":"https://api.github.com/users/dmcghan/following{/other_user}","gists_url":"https://api.github.com/users/dmcghan/gists{/gist_id}","starred_url":"https://api.github.com/users/dmcghan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dmcghan/subscriptions","organizations_url":"https://api.github.com/users/dmcghan/orgs","repos_url":"https://api.github.com/users/dmcghan/repos","events_url":"https://api.github.com/users/dmcghan/events{/privacy}","received_events_url":"https://api.github.com/users/dmcghan/received_events","type":"User","site_admin":false},"created_at":"2016-12-21T15:59:41Z","updated_at":"2016-12-21T15:59:41Z","body":"@jncolvin No worries... The code you're showing uses jQuery, which indicates it's front-end code. That should work fine as is, meaning you're creating an object with 2 properties and their values.\r\n\r\nHowever, you would need to send the object from the front-end to the Node.js middle-tier. This is typically done by creating RESTful (or RESTlike) end points using something like Express.js. Have you already done this?\r\n\r\nOnce the web server is set up to accept the filters you want, you'd call the web service and pass the filters along. The web service would then take the filters and pass them along to the logic that executes the query.\r\n\r\nDoes that make sense? I can provide more info if needed..."}}
{"actor":{"display_login":"dmcghan"}}