Page 1 of 1

Lesson 3: What is wrong with my SQL syntax?

Posted: Tue Dec 31, 2013 2:58 am
by NelsonCol
Im trying to make Direct MySQL to make the search, after watching the video a couple of times and "making sure" that im copy the things right i still i get this:

revdberr,You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE '%'ach%' OR lastname LIKE '%'ach%'' at line 1

Also i have not been able to load this:
specialFolderPath("documents")& "/contacts.sqlite" into tDatabasePath
So its been impossible to make the first button (SQL lite) to work.

I dont know anything about SQL, so any answer please make it very easy.


Attached is the file

Thanks

Re: Lesson 3: What is wrong with my SQL syntax?

Posted: Thu Jan 09, 2014 2:08 pm
by LCNeil
Hi Nelson,

I've had a look at your stack and when I attempt to make a Direct MySQL connection, Everything works as expected.

Could I get you to double check your stack with the latest version of LiveCode (6.5.1) to see if the issue is still present for yourself.

In regards to to your SQlite connection, you have a slight spelling mistake on your database type group (SQLlite should be SQLite) and this is what is breaking your script.

You will need to change this in both the group and databaseConnect handler.

I hope this gives you some leads.

Kind Regards,

Neil Roger
--
RunRev Support Team ~ http://www.runrev.com