Tahnks for the help, I found it finally once I knew where to look. It was in the JScript the web developer put together that passes the patient id from...

Ahhh now we are getting somewhere. The querystring is dropping all numbers after the 6th digit, therefore I am getting the error becuase there is no data that matches. So...

Don't know for sure but I see people double click on web pages all the time, you might see if a double click on the submit button causes the same...

Any digit that contains 6 or less numbers works, examples:

000000

012345

999999

When adding 7 or more digits irregardless of the number it generates the exception error. But only when running the querry...

Here's the DDL:

patidpri,int,no,4,10 ,0 ,no,(n/a),(n/a),NULL

ClientID,int,no,4,10 ,0 ,yes,(n/a),(n/a),NULL

CProviderID,int,no,4,10 ,0 ,yes,(n/a),(n/a),NULL

PhysicianID,int,no,4,10 ,0 ...

Sorry to be such a problem here. I opened the table in SQL Enterprise Manager, clicked the SQL button at the top, typed in the code you gave me, and...

jpipes,

Here is the code:

lexicorSQL = "Select * from patient where patientid = '" & request.querystring("pID") & "'"

doQuery(lexicorSQL)

How do I get you a DDL? I was sort of thrown into dealing...