tim,
have you tried the sql drivers, vs. the odbc drivers?
tw
On 6/3/05, Tim Laureska <[EMAIL PROTECTED]> wrote:
> Can't quite figure out why this would generate an error AND what
> " Operation must use an updateable query " means:
>
> Error Executing Database Query.
> [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
> Microsoft Access Driver] Operation must use an updateable query.
>
> The error occurred in
> E:\Inetpub\wwwroot\test\admin\calendar_admin\addevent.cfm: line 51
>
> 49 : <cfquery datasource="testdsn" name="EventsCalendar" dbtype="ODBC" >
> 50 : INSERT INTO EventsCalendar(EventName, EventDesc, CreatedBy)
> 51 : Values('#form.EventName#', '#form.eventdesc#',
> '#form.createdby#')
> 52 : </cfquery>
>
>
>
>
> Tim
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208542
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54