Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tdodnz
Starting Member
23 Posts |
 Posted - 2002-04-03 : 22:19:08
|
| Hi The error im getting is Data type mismatch in query expression Heres my SELECT statement, i personally can't see anything wrong with it, im hoping that you can help. strSQL = "SELECT TOP 1 url FROM tblUsers WHERE Pops >= 5 AND ID <> " & strID & " ORDER BY Pops DESC" strID is a number, Pops is a number, An obviouslt url is an http address. I got it to redirect when I pulled out that it could not redirect to the URL that it just came from, but it put a # on each end I believe that I have fixed that, but im getting this error with the extra requirements in please help. I know ive posted this before but ive tried all your suggestions and it still doesn't work, so i posted it again to see if you have another solution. OK i know your going to say response.write my SQL statement, all i can say is why i can just copy it out of my page, and where am i going to find a query analyzer. It's not like im paying for a domain.Im also connecting to an Access 2000 database via Microsoft Jet Database Engine but the statment itself is still the same cause it is still SQL Server!!!PLEASE HELPThanks in advance |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-04-03 : 22:37:35
|
| OK Here is the real deal. Fix your attitude.Firstly, keep it in one topichttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=14522Secondly, the problem I think, is an ASP problem, not a problem with the database code, so in fact you shouldn't be asking it here.I think your strID has a null value which is breaking your sql statement. This would be an asp problem.We will help though, if you change your attitude and stop being so damn rude. When you first started posting here I decided to cut you a little slack because you are 15, but now that you keep acting even younger it is getting boring.Damian |
 |
|
|
|
|
|
|
|
OK Heres the deal fix it and I won't bug you again