Saving changes


2004-04-30 10:12:57 PM
jbuilder13
Hi,
I have 2 Tables:
StudentInfo has: StudentName, StudentID, StudentStateID, StudentZip, StudentCourseID etc.
We use ZipCode table to get the State Name based on StudentStateID.
Query is:
"select StudentInfo.Name, ZipCode.State from StudentInfo inner join ZipCode ON StudentInfo.zip = ZipCode.zip
where StudentId= 11111"
As you can see this query has 2 tbls involved, now when user enters state information, they type "KA" or "CA", but I need to save the stateID into the student table. how can I do that?
should I do it in queryResolver? thanks,