Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

ASP.NET Forum


You are currently viewing our ASP.NET Forum as a guest. Please register to participate.
Login



Reply
Old 10-06-2004, 02:57 PM Dwmx / Asp Help !!!
Novice Talker

Posts: 7
Trades: 0
At my highschool im in charge of settin up an ASP database for the page. I have been messing around using the "webthang" tutorial trying to get used to it. I got to the add part of the tutotial and ran into an error. The error was this
• Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/sportasp/add.asp, line 115
Line 115 says the following: MM_editCmd.Execute

If you could help me figure this out greatly appreciated!

Last edited by WGHSwebmaster; 10-06-2004 at 02:57 PM.. Reason: typo
WGHSwebmaster is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 10-14-2004, 12:58 AM
WebcyteDesign's Avatar
Registered User

Posts: 159
Location: Hamilton
Trades: 0
Well it would really help if we could see the Query String, otherwise I don't think we really can. But this is what it should look like, in some way:

query = "INSERT INTO table_name (column1, column2,...) "
query = query & "VALUES ('value1', 'value2',....);"

single quotes around text no quotes around numbers.
WebcyteDesign is offline
Reply With Quote
View Public Profile Visit WebcyteDesign's homepage!
 
Reply     « Reply to Dwmx / Asp Help !!!
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.11168 seconds with 12 queries