have you checked that you can using the YALLA datasource you can see the
PeopleDirectory table? Just a simple select will confirm. It may be that
the table was created by a different user to the one used by the
datasource. If this is the case, you may need to refer to the table as
something like dbo.PeopleDirectory
At 12:27 PM 18/04/2001, you wrote:
>Hi All,
>I'm having a bit of a problem here. I'm trying to add
>stuff entered into a form into a database table, but i
>get this error:
>
>Error Diagnostic Information
>ODBC Error Code = S0002 (Base table not found)
>
>
>[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
>object name 'PeopleDirectory'.
>
>
>SQL = "INSERT into PeopleDirectory (FirstName,
>LastName, HomeAddress, HomePhone, Mobile,
>JobDescription, Department) VALUES ('Heidi', 'Belal',
>'whatever', 23232, 23232, 'whatever', 'whatever')"
>
>Data Source = "YALLA"
>
>
>The error occurred while processing an element with a
>general identifier of (CFQUERY), occupying document
>position (8:1) to (8:27) in the template file
>C:\INETPUB\WWWROOT\YALLANESA3ED\ADMIN\SQL_ADDPERSON.CFM.
>
>
>Date/Time: 04/18/01 13:02:47
>Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows
>NT 5.0)
>Remote Address: 217.52.80.114
>HTTP Referer:
>http://217.52.80.114/yallanesa3ed/admin/index.cfm?method=PeopleDirectory
>Query String: method=AddPerson
>
>
>Could someone please tell me what this means? Or
>what's wrong and what i should do to fix it?
>Thanks!
>
>
>=====
>Heidi Belal
>ICQ# 32127109
>http://m3.easyspace.com/hmbelal
>
>A bus stops at a bus station.
>A train stops at a train station. On my desk
>I have a work station...
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
