You can't use cfqueryparam w/ cfupdate, but the error output that you were getting is similar if you were.
A 'normal' query is written using the cfquery tag. cfupdate (and cfinsert) are just a layer of abstraction above that. Write your own SQL and the error will probably go away. At 07:44 PM 10/20/2006, you wrote: >Well, I have to admit you all have confused me. Jeffrey said switch to a >"normal" query. Claude said this is the problem when using >CFQueryParam. I thought I was doing normal queries and didn't know I was >using CFQueryParam. The line causing the problem is "CFUPDATE". I'm >handing it a form (and I thought checking for blanks before I sent it >over. I'll have to look into that.) and telling it to update the database >with the info from the form. What makes it not a "normal" query and where >does CDQueryParam come from? (and please remember, all of this sounds >VAGUELY familiar, but nothing's clicking) > >Thanks, >Indy -- Jeffry Houser, Software Developer, Writer, Songwriter, Recording Engineer AIM: Reboog711 | Phone: 1-203-379-0773 -- My Company: <http://www.dot-com-it.com> My Books: <http://www.instantcoldfusion.com> My Recording Studio: <http://www.fcfstudios.com> Connecticut Macromedia User Group: <http://www.ctmug.com> Now Blogging at <http://www.jeffryhouser.com> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2590 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
