Lesson 3: What is wrong with my SQL syntax?

Moderators: LCNeil, heatherlaine, kevinmiller, elanorb

Post Reply
NelsonCol
Posts: 4
Joined: Mon Dec 09, 2013 4:36 pm

Lesson 3: What is wrong with my SQL syntax?

Post by NelsonCol » Tue Dec 31, 2013 2:58 am

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
Attachments
SummerS2.livecode.zip
(169.14 KiB) Downloaded 98 times

LCNeil
Livecode Staff Member
Livecode Staff Member
Posts: 1223
Joined: Wed Oct 03, 2012 4:07 pm

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

Post by LCNeil » Thu Jan 09, 2014 2:08 pm

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

Post Reply

Return to “idea2app and Coding School”