i spose technically it might be an SQL problemit could be one of two things.
1)i screwed up my connection to the database, which doesn't seem to be it
2)my SQl INSERT INTO statement is screwed, as the debugger thing says.
I'll post it here anyway to see if anyone can see something obvious I cant:
(if this breaks teh board, i'm very sorry Cal)
strSQLQuery2 = 'INSERT INTO Users ' _
& '(Username, Password, EmailAddress, AccountStatus) ' _
& 'VALUES (@Username, @Password, @EmailAddress, @AccountStatus)'
It looks fine to me, and all the parameters and values and shit are typed right, i copy and pasted them in from the DB to be sure, so I think it's a problem with my DB connection some how.
(1)i screwed up my connection to the database, which doesn't seem to be it
2)my SQl INSERT INTO statement is screwed, as the debugger thing says.
I'll post it here anyway to see if anyone can see something obvious I cant:
(if this breaks teh board, i'm very sorry Cal)
strSQLQuery2 = 'INSERT INTO Users ' _
& '(Username, Password, EmailAddress, AccountStatus) ' _
& 'VALUES (@Username, @Password, @EmailAddress, @AccountStatus)'
It looks fine to me, and all the parameters and values and shit are typed right, i copy and pasted them in from the DB to be sure, so I think it's a problem with my DB connection some how.
StickFigureNinja is worried he may be on the list,
Thu 22 Apr 2004, 5:43,
archived)
ughI don't understand SQL at all. I wish I did, but I just struggle through each time I want to use it. I've never learnt it properly
(
kitty meow meow,
Thu 22 Apr 2004, 5:44,
archived)
Same hereYou know what the real bitch is, i'm making a whole site based upon a bit of example code a friend did for me, and this is copied from a bit of code he's done which works fine but just with all the relevant variable bits changed.
( StickFigureNinja is worried he may be on the list,
Thu 22 Apr 2004, 5:45,
archived)
are you using a different sort of SQL?they all vary slightly
( kitty meow meow,
Thu 22 Apr 2004, 5:48,
archived)
I dont think soI mean, i've got both pages here, his works, mine doesnt.
My best chance is to just hope he can give it a quick look before work tomorrow.
(My best chance is to just hope he can give it a quick look before work tomorrow.
StickFigureNinja is worried he may be on the list,
Thu 22 Apr 2004, 5:50,
archived)
do you have the right table name?/silly question
just thought maybe you called your table something different
(just thought maybe you called your table something different
kitty meow meow,
Thu 22 Apr 2004, 5:51,
archived)
Yep,I've gone over it all plenty of times.
My current plan of action is leave it as is, and moveon to other bits of the site, which shouldn't cause such troubles *he prays*
(My current plan of action is leave it as is, and moveon to other bits of the site, which shouldn't cause such troubles *he prays*
StickFigureNinja is worried he may be on the list,
Thu 22 Apr 2004, 5:55,
archived)
I thank yaI have a feeling I'll need it.
( StickFigureNinja is worried he may be on the list,
Thu 22 Apr 2004, 5:57,
archived)
