Troubleshooting


When I try to update my record, I get an error that tells me the operation must use an updateable query. What's going on?

This error is probably the most common error experienced by those new to dynamic pages. The error is usually generated in conjunction with Access databases and the good news is, it's an easy fix. In order for your database to be updated, you need to ensure that the folder where it is located gives the Internet Guest account for your server the rights to write to it. To resolve the issue, walk through the steps set forth by Macromedia in this TechNote:

http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_14520

Now, when I try to add a record or update a record, I get an error stating that there is a syntax error in my INSERT INTO statement. What's happening now?

Again, another common error that is easily fixed. The reason this usually occurs is because a field in your table is named with a special character like "date&time". This is not an acceptable field name because the & character is a special character that is interpreted by the SQL INSERT INTO statement. This causes the syntax error and stops your page from functioning properly. To fix the problem, adjust your field names so that they all start with alpha characters, contain no special characters or spaces, and don't use words reserved by your database. For additional information on this error, check out this TechNote:

http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_14622

I uploaded my web pages and my database to my host and now I get an error that the include file Connections/yourfilename was not found. What did I do wrong?

It's likely that you're using a Custom Connection string and simply forgot to upload the Connections folder and its contents to your web server. Try uploading that folder and the error should be resolved.



Special Edition Using Macromedia Studio 8
Special Edition Using Macromedia Studio 8
ISBN: 0789733854
EAN: 2147483647
Year: 2003
Pages: 337

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net