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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Help with numeric IDs

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-01-01 : 23:14:18
Marcus writes "I want to compare the a numeric ID passed through a querystring and a numeric ID in the database. If they are equal, then screen prints out something. I have tried the following:

ID = trim(request.querystring("ID"))

if CInt(ID) <> rs("filmID") then
response.write "something"

end if

There are still erros. Can can I do? Please Help!"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-01-02 : 00:05:44
Hi

What are your errors ?

Your code will print if they are not equal too.
Some thoughts, if ID is null or can't be evaluated as an int, cint will crash.

Also you might want to cint rs("filmID")

Any more info for us ?

Damian
Go to Top of Page
   

- Advertisement -