Library documentation: SQL - v1.50 B4A Question Help with SQL - query - moster67    Dec 19, 2022 Don't know if it is possible but if it is, how can I using SQL get a query result as in this layout:
Person
Client 2016
Client 2017
Supplier 2016
Supplier 2017
Mr. Green
USD 500
USD 300
USD 200
USD 400
from a table (let us say an Invoice table) as follows (of course it could be an csv-file):
Mr Green
Client, year 2016
USD 500
Mr Green
Client, year 2017
USD 300
Mr Green... B4J Question JDBC driver for Microsoft SQL server - moster67    Jan 16, 2018 From this post, I found a link to download JDCB Drivers. The link points me to this page from Oracle's but I cannot find a link for the JDBC driver for Microsoft SQL server. I found this on a page from Microsoft: https://www.microsoft.com/en-us/download/details.aspx?id=55539 Is this the correct driver to use with jRDC version 2? Thanks.... B4A Question RDC java.sql.SQLException: An attempt by a client to checkout a Connection has timed out. - moster67 (first post)    Jan 28, 2016 Perhaps it is a port-forwarding issue in your router ("incoming connection -> port number -> forward to your local computer" and/or TCP/UDP)?... B4A Library SqlObject - a small composer library for sql (mysql) - moster67 (first post)    Mar 24, 2012 Thanks for this. I am not using SQL or databases in my apps (yet) but it might become handy in future. More importantly, it is nice to see contributions like yours continuously being developed for the B4A-community and which will make B4A in the future even more complete than today. Cudos to you also for supplying your sources. Those are very valuable as learning-material for others who would like to write libraries for B4A.... B4A Question Need SQL tutorial - moster67 (first post)    Nov 28, 2010 try this one as a starter: http://www.b4x.com/forum/38522-post4.html... B4A Question Null not evaluating as Null - moster67 (first post)    Aug 4, 2017   (1 reaction) Have a look at the public B4J SQL source on GitHub: https://github.com/AnywhereSoftware/B4J_SQL/blob/master/src/anywheresoftware/b4j/objects/SQL.java I guess the code is similar to the B4A Sql library.... B4J Question jServer - 2 questions - moster67    Dec 18, 2017 New stuff for me... I want to use the B4X server approach (instead of PHP) for setting up a small website. I am creating a login-page and a registration form to query and/or save users in a MySQL database (running on the same VPS as the jServer). I have two questions in this regard: 1) Would it be better to use jRDC2 as a middleware when communicating with the database? 2) When a user has logged in, how to do I check that the user is still logged in? Do I trace the user by using a cookie... B4J Library B4JMosquittoPBKDF2 library - moster67    Jan 1, 2018   (10 reactions) If you are using the original Mosquitto broker, you may be aware (or not) that there is a plugin called "mosquitto-auth-plug" which is an authentication plugin for the Mosquitto broker with multiple back-ends (MySQL, Redis, CDB, SQLite3). You need to compile it and set it up to work with Mosquitto but it is well worth the effort if you want more flexibility to handle users and topics in real time. When using this plugin and adding users to the backend database, we need to create... B4J Tutorial (B4X) Creating LAMP server with b4x on Amazon EC2 - moster67 (first post)    Nov 11, 2015 Thank you Shay. Did you modify the code in B4x pushserver to save the data in a mySQL database instead of SQLite? Just wondering since you set up MySQL (Mariadb) in your tutorial.... B4J Question reCAPTCHA error "invalid-request-cookie" - moster67    Dec 18, 2017 I am using this example: https://www.b4x.com/android/forum/threads/server-login-system-filters-tutorial.39020/#content which I seem to have deployed correctly on my VPS and set up to communicate with my MySQL database (table is created in the DB). However, using the above example and after registering for a reCAPTCHA api (the invisible one just like Erel's sample), and when clicking the Register button, I always get an "invalid-request-cookie" message. See the picture below: In... Page: 1   2   |