Best Practice for multi-page form

I have a multi-page form (survey) where the user can go forward and back through the survey. I want to save the entries from each page so that I can repopulate the page if the user goes back to it. I expect to have 30-40 surveys a day. Is it better to store the data for the survey in an arra

CFQuery Select and single quotes in string

I'm doing a look up like this: SELECT Formation, Play, BallCarrier, YardsGained, Result FROM PlaysCalled WHERE (((PlaysCalled.Formation)="#Form.Formation#") AND ((PlaysCalled.Play)="#Form.Play#") AND ((PlaysCalled.BallCarrier)="#Form.BallCarrier#")); In some cases, the Ball Carrier's