What exactly is the error you are getting?
Double check to make sure dbo is the owner of the table.
J.
John Wilker
Web Applications Consultant
Macromedia Certified ColdFusion Developer
www.red-omega.com <http://www.red-omega.com>
"Losing - If at first you don't succeed, failure may be your style."
~despair.com
-----Original Message-----
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 20, 2001 2:54 PM
To: SQL
Subject: INSERT problem
I am running the following query and getting a syntax
error or access violation error when I do. It is
being run from a ColdFusion template, but also will
give the same error from the SQL Query Analyzer.
INSERT INTO dbo.CDsTrack {TitleID,TrackName}
VALUES {157,'This is a track'}
I have filled in the values where a variable would
otherwise be. The CDsTrack table is linked by a
foriegn key (TitleID) to the CDsTitle table. The
CDsTrack table also has another column, the TrackID
column that is an autonumbered primary key. If I
enter the information in to the database manually it
works fine, and entering information in to the other
tables from a query is not a problem either, just
inserting information in to the CDsTrack table.
=====
Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
ICQ UIN: 916324
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
