Front Office Football Central  

Go Back   Front Office Football Central > Archives > FOFC Archive
Register FAQ Members List Calendar Mark Forums Read Statistics

Reply
 
Thread Tools
Old 05-02-2006, 03:43 PM   #1
GoldenEagle
Grizzled Veteran
 
Join Date: Dec 2002
Location: Little Rock, AR
ASP Question

I am using a form that is pulling off an ID from the previous page and writting to the database. I think I need to conver it to a number format (its being sent as text) to write it into the database. It is set up as a number in the database. I am using this code:

objComm.CommandText = "INSERT INTO Classes(StudentID, CourseID, Taken) VALUES (StudentID, 'ENG101', '" & Taken1 & "')"

and it is returning this error:

Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/grg/cisprogramming0506add.asp, line 62
__________________
Xbox 360 Gamer Tag: GoldenEagle014

GoldenEagle is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump


All times are GMT -5. The time now is 08:58 AM.



Powered by vBulletin Version 3.6.0
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.