Hi all,
I asked the question before but I wasn't clear, so I'm re-wording it. I have a page with the fck editor and a sql update statement (dreamweaver behaviour). For some very wierd reason, when my client uses text with the word from or select, the update craps out... it never updates the database. It looks to me like the content is being mistaken as part of the SQL statement. Does anyone know what I can do? Do I have to add quotes or encode something before the update/insert?
Thanks a million
Nelson
I asked the question before but I wasn't clear, so I'm re-wording it. I have a page with the fck editor and a sql update statement (dreamweaver behaviour). For some very wierd reason, when my client uses text with the word from or select, the update craps out... it never updates the database. It looks to me like the content is being mistaken as part of the SQL statement. Does anyone know what I can do? Do I have to add quotes or encode something before the update/insert?
Thanks a million
Nelson
Re: Text in content field (from, select) being mistaken as SQL
If it fails with the same content then your problem is on the server side, and you'll have better luck asking in a PHP/Apache forum.
Re: Text in content field (from, select) being mistaken as SQL
Thanks for the help. Does anyone have guidence?
Nelson
Re: Text in content field (from, select) being mistaken as SQL
See if this helps:
http://kb.adobe.com/selfservice/viewCon ... &sliceId=1