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

Reply via email to