find out how you either misspelled or what table you are actually trying to
insert into...
or make sure you are using the correct datasource...
Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]
(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487 aim: lv2bounce
http://www.cs.odu.edu/~bader
> -----Original Message-----
> From: Heidi Belal [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 18, 2001 8:09 AM
> To: CF-Talk
> Subject: NEED HELP!
>
>
> 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=Peopl
eDirectory
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
