Hi! I'm an absolute newbie here, I need help in validating my database using MySQL.
here's my query
sql.validate=SELECT * FROM `tbl_userinfo` WHERE `Username` = '" & uName.Text & "' AND `Password`='" & pWord.Text & "'
In here, I have two edit texts, uName and pWord.
It works just fine when I...
Hola a todos:
Por fin me he puesto a probar un poco con B4XPages, y he empezado a adaptar el ejemplo B4XPages + B4XDrawer
Creo que he visto algunos ejemplos con php + mysql para hacer login, etc... pero he visto pocos con jRDC2.
Los datos de la base de datos y la interfaz gráfica con bastante...
I'm starting (at last) to work with B4XPages, so I've started to adapt the B4XPages + B4XDrawer example.
I think I’ve seen more examples with php + mysql, but no projects with Jrdc2.
Maybe the dummy data and the UI are too basic, but you can get some ideas.
What do we need?
Can anyone help me? i tried to use b4a to mysql with b4j jRDC and show this error
ResponseError. Reason: java.net.ConnectException: Failed to connect to /192.168.0.8:17178, Response:
ERROR: java.net.ConnectException: Failed to connect to /192.168.0.8:17178
The IP Addresses is...
I've had this mod sitting on the sidelines since last fall. Looks like there is a need for this as shown in this post: https://www.b4x.com/android/forum/threads/rdc2-select-last_insert_id.126310/
In order to retrieve the auto generated key values for an INSERT statement, I've added the...
Looking for testers!!!!
This modification adds support for calling stored procedures that can return zero or more result sets and zero or more output parameters to my previously modified jRDC2 server (https://www.b4x.com/android/forum/threads/modded-jrdc2-w-sqlite-support-and-more.85578/). It...
I am trying to implement SSL in jRDC2, but I am not sure what I am doing wrong. can someone please help with the attached example?
Note: I have created keystore file at my cloud linux VM - but it is not on my windows PC, is this the correct process? if not and the keystore needs to...
Wondering if there is an example of jRDC2 with SSL connection, just in order to put me on the right direction.
First I'll go threw this tutorial:
And later go threw this...
I can load/SELECT ALL data in a table from jRDC2 (mysql DB) with no problem, but I think this is not perfect in case of thousands of rows to return/SELECT from App performance standpoint, also I am aware that I can use LIMIT to limit the number of rows; however I am not sure how to...
I use JRDC2 for an Android application with the MYSQL database but i have difficulties for one of my request,
Is it possible to put SQL code in query parameters?
In my case, I want to create "WHERE" code in my B4A because users can add a variable number of filters
For example, we can have...
I have reviewed the jRDC2 tutorial in which Erel has taught about accessing a database situated on a local pc. I have a mysql database on infinity free online database hosting site. How can i access it by implementing client side coding in B4A. Where i need to keep the DbrequestManager.bas file...
I'm trying to load Mysql database table data into B4XTable by using JRDC2. I can print results in logs. But the data is not showing in B4XTable columns it shows table empty. Anyone can explain how to load result rows into B4XTable?
Hi, I'm using jRDC2 to connect to MSSQLServer DB in all my projects with no problems in several servers, today after installing all the requirements and from jRDC2 source running in Debug mode (I tested in Release too), I tested using the browser with localhost and this message appears...
Sorry, pheraps this is a noob question..
How can i use IN operator with JRDC2?
Dim cmdList As DBCommand = Db.CreateCommand(Query, Array (X,"763043,763054,755123,759006"))
This return 0 records
This is in properties.config
sql.xxx=SELECT Cat, prod, x FROM supprod where id = ? and...
This is my first post so please be gentle :) and I am still pretty new to B4J but have already learnt a great deal from this fantastic community.
It looks like it is not possible but thought I would put it out there anyway to see if anyone has thought of or created an alternative...
Hi I have wrote this just in case someone needs to implement the jRDC2 on a VM on cloud, I know a lot of members already know this and it is definitely not a new information, but for someone that have not tried this before I think it will be useful to have a start to end process.
I´m running the jrdc2 , and change the parametres to use with firebird database.
#Java server port
buts sends me the following message...
how can i call procedures in jRDC2 on PostgreSQL?
I call it so:
but jRDC2 says:
org.postgresql.util.PSQLException: ERROR: procedure sdbspget_checkuser(character varying, character varying, character varying, character varying) does not exist
Hinweis: No procedure...
Hi, I have an MS SQL server for which I have the 'sa' password and I am trying to send a command, please see below: -
Private Sub SetInsertOn
'Dim req As DBRequestManager = CreateRequest
Dim cmd As DBCommand = CreateCommand("set_Insert_On", Null)
Dim j As HttpJob =...