Search found 10 matches
- Thu Jul 09, 2015 7:11 pm
- Forum: Issues
- Topic: How to format a string parameter for comparison with MySQL like condition?
- Replies: 6
- Views: 1517
- Jump to post
How to format a string parameter for comparison with MySQL like condition?
I'm sorry, I'm confused about what you're trying to show me The code entered as in that screen shot does not produce results. '%:keywords%' is also not standard SQL. '%keywords%' would be standard MySQL SQL for a like statement. However I did already try '%:keywords%' and many other variations based...
- Thu Jul 09, 2015 11:25 am
- Forum: Issues
- Topic: How to format a string parameter for comparison with MySQL like condition?
- Replies: 6
- Views: 1517
- Jump to post
How to format a string parameter for comparison with MySQL like condition?
The example I gave is valid SQL. Either this is a bug in ATI Express or you need some special input to identify the string parameter in string comparison. Try it yourself.
- Thu Jul 09, 2015 11:23 am
- Forum: Issues
- Topic: How to format a string parameter for comparison with MySQL like condition?
- Replies: 6
- Views: 1517
- Jump to post
How to format a string parameter for comparison with MySQL like condition?
?
I'm doing it correctly in terms of MySQL. I'm a SQL professional and the queries work fine from MySQL workbench they just don't work on Appery. Give it a try and you'll see what I mean.
- Wed Jul 08, 2015 7:23 pm
- Forum: Issues
- Topic: Errors again!!
- Replies: 4
- Views: 684
- Jump to post
Errors again!!
I clicked good answer because it is one, though I am curious what the %uptime (or % fully functional time) has been over the past year
- Wed Jul 08, 2015 7:21 pm
- Forum: Issues
- Topic: api express custom rest
- Replies: 5
- Views: 879
- Jump to post
api express custom rest
I experienced this as well, but I don't think that Path or Map apply to the way that we're using API Express (and maybe don't work yet, I don't know about that part). The solution to server errors for me was to figure out the proper way to format the SQL statement. The same exact error you got, inci...
- Wed Jul 08, 2015 7:02 pm
- Forum: Issues
- Topic: How to format a string parameter for comparison with MySQL like condition?
- Replies: 6
- Views: 1517
- Jump to post
How to format a string parameter for comparison with MySQL like condition?
What's the correct way to format a parameter for string comparison (i.e. a like statement in MySQL)? My query looks like this: select * from a_database where cost between 'min_price' and 'max_price' and (title like '%keywords%' or description like '%keywords%' or caption like '%keywords%') ; and doe...
- Tue Jul 07, 2015 10:15 pm
- Forum: Issues
- Topic: Google Cloud SQL Successfully Conntected but GET Queries Return 500 Errors
- Replies: 0
- Views: 1025
- Jump to post
Google Cloud SQL Successfully Conntected but GET Queries Return 500 Errors
Thanks to the execellent help of Appery's staff, I was able to successfully connect Appery API Express to my Google Cloud SQL (MySQL) database: ]http://i.imgur.com/9egsWa9.png[/img] In addition to the successful test connection, I'm able to see the table names contained within my database. However, ...
- Tue Jul 07, 2015 10:14 pm
- Forum: Issues
- Topic: Google Cloud SQL Successfully Conntected but GET Queries Return 500 Errors
- Replies: 0
- Views: 1024
- Jump to post
Google Cloud SQL Successfully Conntected but GET Queries Return 500 Errors
Thanks to the execellent help of Appery's staff, I was able to successfully connect Appery API Express to my Google Cloud SQL (MySQL) database: ]http://i.imgur.com/9egsWa9.png[/img] In addition to the successful test connection, I'm able to see the table names contained within my database. However, ...
- Sun Jul 05, 2015 7:37 pm
- Forum: Issues
- Topic: Authorize API Express
- Replies: 2
- Views: 511
- Jump to post
Authorize API Express
Awesome! Thanks Evgene
- Sun Jul 05, 2015 7:33 pm
- Forum: Issues
- Topic: Authorize API Express
- Replies: 2
- Views: 511
- Jump to post
Authorize API Express
If I want to use API Express to provide a REST API for my self-hosted Postgres DB then how do I determine what IP Appery will use to connect to it, so that I can authorize that address (in pg_hba.conf on my server)?