Hi Everyone,
I'm moving a rather large application from Access to MySQL right now, and I'm having nothing but problems with errors now! Here is the first problem I'm having:
<cfupdate Datasource="#session.ds#" tablename="ForumVariables" FormFields="BGColor,BGImage,Text,Link,ALink,Vlink,TimeColor,Column1,Column2,CatBGColor,CatTextColor,FontFace,FontSize,TitleColor,CopyColor,TableWidth,TitleImage,ReplyImage,NewTopicImage,ImageDir,HomeURL,ForumURL,ForumEmail,Mailserver,MailPort,DisplayCat,ForumTitle,HomeTitle,BadWordList,Copyright,TimeZone,Header,Footer,ForumRules">
Gives me this error:
SQL operation updated no rows.
The SQL operation affected no rows.Either the Key value has changed or the row has been deleted.
Any ideas on how to fix this? As I'm sure almost every query I encounter will have to be fixed to work with MySQL, can anyone also give me an overview on the difference between writing syntax for MySQL as opposed to Access? I'm kind of a novice at this stuff, and I just assumed it would all work the same
Thanks!
I'm moving a rather large application from Access to MySQL right now, and I'm having nothing but problems with errors now! Here is the first problem I'm having:
<cfupdate Datasource="#session.ds#" tablename="ForumVariables" FormFields="BGColor,BGImage,Text,Link,ALink,Vlink,TimeColor,Column1,Column2,CatBGColor,CatTextColor,FontFace,FontSize,TitleColor,CopyColor,TableWidth,TitleImage,ReplyImage,NewTopicImage,ImageDir,HomeURL,ForumURL,ForumEmail,Mailserver,MailPort,DisplayCat,ForumTitle,HomeTitle,BadWordList,Copyright,TimeZone,Header,Footer,ForumRules">
Gives me this error:
SQL operation updated no rows.
The SQL operation affected no rows.Either the Key value has changed or the row has been deleted.
Any ideas on how to fix this? As I'm sure almost every query I encounter will have to be fixed to work with MySQL, can anyone also give me an overview on the difference between writing syntax for MySQL as opposed to Access? I'm kind of a novice at this stuff, and I just assumed it would all work the same
Thanks!