Syntax error in UPDATE statement.

WhompyJawed December 04, 2024

Tech

Syntax error in UPDATE statement.

I get this error a lot when using the Update Form Wizard in Dreamweaver. This time it turns out I was using a field called "password", which is a reserved field in MS Access. To fix the problem I had to change:

password=
<cfif IsDefined("FORM.password") AND #FORM.password# NEQ "">
'#FORM.password#'

to:

[password]=
<cfif IsDefined("FORM.password") AND #FORM.password# NEQ "">
'#FORM.password#'

Posted by Miles on 4/10/08 at 08:34 AM | Tech

Archives

Search by Keyword:

Home | Archives | TXSPT |

54 Things To Remember A Day at the Beach A Friend Made In Paris A Sea-Home A Secret Camping Spot A Tree Named Bob A Wonderful Time In Bend Algonquian Street Along The Bike Path Am I a Hacker? Amazon Offers Online Storage An exception occurred while instantiating a Java object. The class must not be an interface or an abstract class. Error: '. Art is Everywhere Auditory Illusions Back to Biking Back To Nordhoff Ridge Bear Creek Beginning To Install Weed Mat Biking Up Sulphur Mountain Road Bird of Paradise Bob Bob with All Troughs Browsing the World Wide Web Building Your Own Job Camping Camping Along Matilija Canyon Trail Camping Along Sespe Creek Camping Along the Chorro Grande Trail Camping At East Fork Lion Camp Camping at Piedra Blanca Camping on the Nordhoff Ridge Can't convert Variant of type 8 to desired type 14 Carol Christmas 2010 Christmas 2010 Coming To Town Christmas 2010 Deck The Halls Christmas 2010 Frosty Christmas 2010 Let It Snow Christmas 2010 Silverbells Cleaning Up Carol's Soil Coldfusion Coldfusion and Access Coldfusion and Dreamweaver Coldfusion Authentication Fails Coldfusion Datefield Not Opening Calendar Window Coldfusion Rounding Issue Coldfusion Testing Server Setup Coldfusion, WHERE Clause with Dates Como, Italy Computer Security Coventry Carol DailyRazor Hosting Data type mismatch in criteria expression Dealing with Antivirus2009 Detecting Mobile Device Using Coldfusion Disc Golf Distributed Everything Dumb Joke EarFull, The Game Edinburgh Electric Bicycling Eliminated Dangerous Characters Error notification Ethanol Instead of Gasoline? Excellent Advice from a Young Whippersnapper Exporting to Excel in Coldfusion 9 Feature Free First Full Day At Hatch House Flat Screen TV Focusing on Your First Form Field From a Post by Bre Pettis Funny Sign, Useful File G. Love and Special Sauce Gary and the Harp Healthiest Foods Hiking From Pine Mountain Road to Chorro Springs Hiking the Pratt Trail How To Avoid Hot-Linking How To Display Current Time Minus One Hour How To Help Kids Nowadays How to reference MS Access database in CF8 64bit Human Resource Management I've Had Just One User Since May 2010 Identity Protection If I'm Not Here When You Get Back Keep It Simple Klangfarbenmelodie Lake Como LCERPZH.exe Lenticular and Shasta LiFePO4 Battery Facts Lightning on the Water Linda and Johnny Linda's New Drawing App Linda's Words Link to Exhaustive Article on Sustainability, Energy Independence and Agricultural Policy Lock Down Coldfusion Directories in Apache Looking Ahead Making Textarea Work With iPad Mexican Poker Mobile Internet Connection Momentos From Italy and Paris More Alternative Energy Analysis More data type mismatch in criteria expression Multi-step OLE DB Operation Generated Errors Murietta Camp Music Tool My Baby In Jamaica My Daily Commute My Electric Bike My Mic My Mother In Law Passed Away Last Week My Two Latest Project Ideas MySQL Date Fields and PHP and jQueryUI Network problem, session aborted due to internal error in remote procedure call New Grandson! New Macs New Toys No "Action" No Value Given For One Or More Required Parameters. Obtain Site Visitor IP Address Off To Hawaii Optimizing Pages For iPhone Organize or Die Our Garden - 2013 Our Hawk Our New Address Our New Greenhouse Our Trip To Italy Our Trip to Jamaica Page Security in Coldfusion Palm Tree Pam makes the newspapers Paranoia Parsing Dates for MySQL Peak Oil Physical Therapy Planet 10 Poi Problem Polka Dots For Halloween Possible Futures Preparing For a Post Oil Society Preventing Session Hijacking Printing Address Labels with Coldfusion Recordcount Syntax Reminds Me Of St. Lucia Repost of Excellent Summary of Obamacare Restrict Access Based on IP Address Robert Nelson San Diego Second Day in Como Second Trip to Italy Second Trip to Nordhoff Ridge Sending bulk email with Coldfusion Setting Default Contacts List in Outlook SMTP Setting For GearHost Solar Furnace Some Nostalgia Son of a Lightning Rod Salesman Spain - Ronda Spain 2013 - Granada Spain 2013 - Malaga Spectra Cine Sprouting Tables Steel Pulse! Steps Towards Online Security Strange Datefield Behavior in Internet Explorer Syntax error in UPDATE statement. Tarot Technology, Ain't It Grand? The 16 Essential People in Your Life The Fox The Impending Doom The Order of Mystics The Things You'll Find In The Rain Forest The Third Element The Top Half Percent The Tram Above Como The Tree In Mission Park The Unique Name Syndrome Thoughts On Oil and Bicycling Three Troughs and Counting Time To Move On Toilet Art Too Few Parameters Travel Adapters Treasure Beach Treasure Hunt Tool Treating a Knee Injury Trip to Yuma Twins, Birdsong, and the End of the World Typical Daily Tamoto Harvest Uninspired At Times Union All Select Using Coldfusion To Direct Domains Using Cubasis Using Session.MM_Username in a PHP MySQL Query Validating Fields In Dreamweaver Validation in Coldfusion Forms Verity Search We Have Fish We Have Nutrients Webhostingpad Path Weekend in SF What I Did This Year What I Hear What I Use To Confirm Deletes What If US Collapses? What Not To Care About What Was Hard Is Now Easy Why Everyone Needs Their Own Server Why We Had To Move Winsock Fix Xmas Tree Yet Another Hare-Brained Scheme You Better Have Some Hobbies