I get a missing operator here. Anybody?<BR><BR>strSQL = "SELECT * FROM seniorTable WHERE SSN4=" & _<BR> Session("social")
Im not quite sure what you are asking. I don't get any resulting SQL because I get an error that says what I posted earlier.
Response.write your SQl statement before you open it to make sure that the SQL statement is actually being written correctly before you open it is whathe means.
SELECT * FROM seniorTable WHERE SSN4= <BR><BR>where did the Session variable go to?
Theres your problem.. for some reason your Session variable is not valid. try setting the session varaible equal to something else rather than requestng it when you write your SQL string... might help, might not.. worth a try
Check to see if you did write correctly the name of the session variable.<BR>Also don't forget to put <BR>SSN4='" & Session("social") & "'" <BR>if SSN4 is a text field.<BR>