[Mister B.]

Here is the code.
strSQL = "SELECT * FROM post WHERE pid = '"&Request("pid")&"'"



and , I get this error.. Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

/cubularrpg/tests.asp, line 27
and the URL there is http://www28.brinkster.com/cubularrpg/tests.asp?pid=1 This is where the error is situated.

[MadDog]

what type of field is "pid"??

[Mister B.]

autonumber. Post I D

[Shane]

Originally posted by Mister B.
autonumber. Post I D

ok, well, since it's a number, then you don't need the ' in there.

so, change it to this:

strSQL = "SELECT * FROM post WHERE pid = " & Replace(Request("pid"),"'","")

Note: I put the replace function in there to protect you from SQL injection attacks. Instead of using the replace, you could check the input and make sure it's a numeric.

[Mister B.]

Thanks Shane, big help... Should have this up in no time.

[MadDog]

I was going to say that shane

[Shane]

Originally posted by MadDog
I was going to say that shane

haha..wellll I won.

[Mister B.]

Okay guys I have it up now, I will have it debugged in the next hour or three.

[Stealth]

Originally posted by Shane
haha..wellll I won.

they dont call him the Super Moderator.NET guy for nothing!

[MadDog]

He calls himself that

You can change it in your profile