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..
Edited by Silky - 29 July 2007 at 12:37am
Topic Options
Post Options
Thanks(0)
