Win a copy of Head First Android this week in the Android forum!

Sakshi Narang

Greenhorn
+ Follow
since Apr 10, 2020
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
2
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Sakshi Narang

I am using useEffect() to validate my Signup Form.



Now, the form validation method is like this:
How shall I validate fields other than fullName(other fields: Email and password), the state changes and it doesn't check other input fields.



1 year ago

Campbell Ritchie wrote:Moving to our Groovy and databases fora.


Din't get you man

Stephan van Hulst wrote:So what was the actual result?



Input is two tables InputInvoice and inputBookingRef:
inputInvoice
abcd123
efgh456
ijkl789
mnop1012


inputBookingRef
456
789


Output should be:
resultInvoiceresultBookingRef
efgh456456
ijkl789789


Stephan van Hulst wrote:Try the following:



This was giving more data rather than filtering it,
Din't have much time to look into the reason.
Maybe because bookingRef is a list of different bookings and invoice is another list of different invoices containing booking references in it.
Ended up making a small utility for the same in java.
But, your code dint break.

"/*inputInvoice
           abcd123
           efgh456
           ijkl789
           mnop1012*/
   /*inputBookingRef
       456
       789*/
result expect was:
   /*resultInvoice, resultBookingRef
   efgh456,456
   ijkl789,789
    */"

Stephan van Hulst wrote:Welcome to CodeRanch!

I don't know what "mySQL LIte" is. I know about MySQL and I know about SQLite. I'm assuming you meant the latter.

I don't think SQLite has CONTAINS operator. What's wrong with just using LIKE?




Thanks, corrected the technology in description.
With just using like no data is added.
Can someone help in resolving one of following commented lines please?
I tried with LIKE as well as CONTAINS.
Got no result with like but the values are there.

Also, CONTAINS doesn't seem to work in mySQL LIte.



I tried using LIKE statement as mentioned above (commented line) but since its not a constant field, how to we do it if not by this?