On Friday 06 Jun 2003 14:59 pm, Jim Kraft wrote:
> SQL insert into 2003QR (NAME,PASSWORD) values ( (param 1) , (param 2) )
>This table name my be illegal (doesn't start with a char.
>I've seen this form MS SQL server when there is a reserved word or
something
>like that in the query.
This does not seem to be the issue as there is another page that uses a
table with a char. It seems to be in the phrase "Operation must use an
updateable query." That is what I do not understand as it has always worked
as an updateable query. Thanks
Error Executing Database Query.
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Operation must use an updateable query.
The Error Occurred in D:\wwwroot\Kraft\Calendar\Calendar.cfm: line 8
6 : (TitleofEvent, Organization, ContactName, Phone,
Email, Instructor, TypeofEvent, Topic, ClassStarts, ClassEnds, TimeofEvent,
CityofEvent, CountyofEvent, Web, Description)
7 : VALUES ('#TitleofEvent#', '#Organization#', '#ContactName#',
'#Phone#', '#Email#', '#Instructor#', '#TypeofEvent#', '#Topic#',
'#ClassStarts#', '#ClassEnds#', '#TimeofEvent#', '#CityofEvent#',
'#CountyofEvent#', '#Web#', '#Description#')
8 : </CFQUERY>
9 :
10 : <CFELSEIF #ParameterExists(EditArtist)# IS "Yes">
----------------------------------------------------------------------------
----
SQL INSERT INTO calendar (TitleofEvent, Organization, ContactName, Phone,
Email, Instructor, TypeofEvent, Topic, ClassStarts, ClassEnds, TimeofEvent,
CityofEvent, CountyofEvent, Web, Description) VALUES ('x', 'x', 'x', 'x',
'x', 'x', 'x', 'Managing-A-Business', '12/22/2003', 'x', 'x', 'x', 'x', 'x',
'xx')
DATASOURCE wsbdc
VENDORERRORCODE -3035
SQLSTATE HY000
--
Tom C
"Land of the free, home of the brave... you have to be brave to live there
and
enjoy the freedoms"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
