MM_ERROR 1064 cant insert dynamic result

Report · May 23, 2007

Can anyone help? I get the following error when I create a recordset:

MM_ERROR:1064 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 '' at line 2

I have checked the syntax of my query direct in MYSQL (4.1.14) using PHPmyAdmin and it works perfectly. Even when creating the Recordset it works perfectly when I click Test.

Can anyone give me any ideas?

Thanks

Report · May 24, 2007

faisal81 wrote:
> Can anyone help? I get the following error when I create a recordset:
>
> MM_ERROR:1064 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 '' at
> line 2

Use echo to display onscreen the query being created by Dreamweaver.
It's impossible to tell what the problem is from the error message
alone. However, I suspect that it's caused by a conflict of quotation
marks. Since Dreamweaver 8.0.2, quotes are placed automatically around
runtime variables. For example, before 8.0.2, you might have this in a
query:

WHERE columnName = 'colname'

Now it should be this:

WHERE columnName = colname

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/