I would use two SQL statements, one to get the place ID from its name, then the big insert which needs the result of the former statement. And I would: - never publish code in a proportional font (they invented PRE tags to get readable code here); - not build such complex statements; why not building a string first, so you can see it, log it, whatever; - not take user input without validating it; - use SqlParameters. And finally you could consider creating a stored procedure to do this. :)
Luc Pattyn [My Articles] Nil Volentibus Arduum