At the mo i'm trying to make my own forum sorta thing. It sort of works at the moment but i do have one major problem.
(BTW this is more of a test than a useful thing at the moment)

Anyway I have an access database which has stored queries in it to add and select posts/messages.
But when i try to post a message that's a certain size it doesn't work. I either get a general SQL error, or it adds the new record but just fills the fields with random crap, or sometimes adds bits but not others.
There doesn't seem to be one thing defining when it happens but if i delete some of the message it then works.

As far as I know there is no validation on the memo field in question, or the query but i may have missed something (i doubt it tho).

Anyway I can provide a lot more info if anyone thinks they may be able to help.

You can take a look at what I have done @ www.steamingturdforums.cjb.net

I wanna start adding a nice design on to it, but I've gotta get it to work first.

Also if when posting/testing anyone notices any other probs let me know.

Thanks!
Will

Well it seems to work OK, but whats that zero above the poster name? Other than that, a redirect on the "thanks for posting" -page would be handy. Also, are you not going to have a user database (login)?

Bar those questions, it looks like most of what remains is mostly cosmetics.

The number above the name will respond to emoteicons/smilies when I get round to it.

When i get this prob fixed the redirect will go on.
I have a login system all tested and up and running used for something else. I will integrate the 2 of them soon. I've also got quite a few more ideas but i need the damn thing to work first.

Try posting about 200+ characters you'll see what I mean! It's got me quite confuzzled.

Will

you might have the wrong data type in your db. use "memo" in access for BLOBs.
the site crashed when I tried to post. huh.

I am using a memo field (checks to make sure he's not being dumb again!).

Whatd'ya mean the site crashed?
It didn't crash ur browser did it?
Or do u just mean a http500 error (or the real error behind that)?

no, it just wouldn't load. it finally did.
You should take that error massage and search for it on MSDN.

good luck.

quote:Originally posted by 13kft:
no, it just wouldn't load. it finally did.
You should take that error massage and search for it on MSDN.

good luck.

Ahh thats just brinkster being an arse.

The problem is the error it gives is
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

Which afaik pretty much means nothing apart from there is something wrong with what i'm entering and i already know that!

Help....someone, anyone, please

Trying to get to your site now, but I noticed you said it's Brinkster, and having a couple of sites there myself, I know how long it can take to respond. Maybe you could either put a limit on the number of characters in your textbox field. One other thing I can think of, which I will test soon, is that maybe the single quote is causing a problem. When you do a response.write strSQL (or whatever you call your SQL string), what does it look like? Could you post your form submission code?
quote:Originally posted by Wollington:
Help....someone, anyone, please

I did have the problem with the single quote when i first made it but i put a Replace() in to change from ' to ` which solved that one.

If I have to limit the message to about 200-300 characters its really not gonna be of much use. I just don't see why it won't accept it.

Here is the SQL statement from the query in Access:

INSERT INTO tblMessages ( PostID, Emote, Message, ReplyBy, ReplyOn, IP )
SELECT [@PostID], [@Emote], [@message], [@Replyby], [@ReplyOn], [@IP];

I'll try that response.write idea later. Ooh and I'll put all the code up in txt files aswell.

Thanks
Will

I've added the Response.Write bit and tested it. It writes out exactly what goes in and is correct to be entered into the DB. So its the SQl stored query or database that is causing the probs, as I thought.

Any ideas as to what it could be then?

Will

Have you tried screaming at your computer?

I would ditch the stored queries and put a SQL statement directly in your vbScript. See if that works. I dunno. Just a guess.