Thread: For Next Loop Within another For Next Loop

Code:

    SQL = "INSERT INTO [performances] (showID, SeatNumber, SeatPrice, performance_time, ShowDate, Status) " & _
        "VALUES ( " & _
        showID & ", " & _
        x & ", " & _
        Request.Form("SeatPrice") & ", " & _
        Request.Form("performance_time") & ",#" & _
        Request.Form("ShowDate") & "#, " & _
        "'" & Request.Form("Status") & "')"
    conn.Execute SQL

Or, you can put the #'s on the same line:

Code:

SQL = "INSERT INTO [performances] (showID, SeatNumber, SeatPrice, performance_time, ShowDate, Status) " & _
	"VALUES ( " & _
	showID & ", " & _
	x & ", " & _
	Request.Form("SeatPrice") & ", " & _
        Request.Form("performance_time") & ", " & _
        "#" & Request.Form("ShowDate") & "#, " & _
        "'" & Request.Form("Status") & "')"
conn.Execute SQL

Originally Posted by BLaaaaaaaaaarche

Or, you can put the #'s on the same line:

Yep, or that...