Classic ASP Discussion - Help For Dummy

Print Page | Close Window

Help For Dummy

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=23988
Printed Date: 29 March 2026 at 10:15am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Help For Dummy

Posted By: Silky
Subject: Help For Dummy
Date Posted: 29 July 2007 at 12:36am

I need some help on a few things... I dont know if this sorta thing is the norm around here but the website that published this script doesnt seem to want to help so here goes..

It's a news publishing script and it is, in theory, the best free one around.. Looks good and does everything i want it to without being too difficult to read for the likes of me, but it's full of bugs..

When i try to add a new user through the control panel it gives me this error..

Microsoft JET Database Engine error '80040e14'

Syntax error in INSERT INTO statement.

/guestbook/users.asp, line 12

which is;

LINE 12: connect.execute ("insert into login (user, password, name, email) values (" & struserid & "," & strpassword & "," & strname & "," & stremail & ")")

and when i try to edit the one existing user it gives me this..

Microsoft JET Database Engine error '80040e14'

Syntax error in UPDATE statement.

/guestbook/edit_users.asp, line 13

LINE 13: connect.execute ("update login set user='"& struserid &"',password='"& strpassword &"',name='"& strname &"',email='"& stremail &"' where id = "&intuser&"")

Is there any really obvious error in the code there? Sorry if i come off like a complete goose, as far as giving you enough info on solving the problem.. i really am a newbie...

any help would be MUCH appreciated..

Replies:

Posted By: Scotty32
Date Posted: 29 July 2007 at 11:11am

i think the first one is the fact you dont have single quotes ' on the text fields.

the second am not sure about

the following link should help you learn the syntax

http://www.w3schools.com/sql/default.asp - W3 Schools

click on insert to learn about that and click update to learn about that - and so on

-------------
S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins

For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum .