Heidi,
It looks like the table you are trying two insert into (PeopleDirectory) does not
exist in the SQL database represented in the
YALLA datasource.
Heidi Belal wrote:
>
> can some one tell me the reason for this error and how
> i can solve the problem?
> Thanks!
>
> 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
>
> =====
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
