Thanks to SheldonLinker my earlier question has been answered. I continue to have 1 issuse and it is with my conditional SQL statement. I'm thinking someone will be able to correct this very easily. Here's the statement:
If ("SELECT DataID FROM table1") = UserID
I don't know if SELECT will actually work in an IF statement so that could be the issue. I want it to check the sql table and compare the DataID to a variable (UserID) entered by a hidden field. If the equal each other an Update is made otherwise an Insert is performed. If I do this: IF "9" = UserID the Update works fine. The problem is with the SELECT statement.
Does anyone know what I'm doing wrong or how to get around it?
March 2, 2007 8:21 AM
March 5, 2007 8:47 AM