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

Posts: 7
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 01:57 PM. Reason: typo
WGHSwebmaster is offline
Reply With Quote
View Public Profile
 
When You Register, These Ads Go Away!
Old 10-13-2004, 11:58 PM
WebcyteDesign's Avatar
Extreme Talker

Posts: 159
Location: Hamilton
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

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 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.10643 seconds with 12 queries