[RESOLVED]-INSERT SQL question...

Maybe I'm a retard, but does anyone see anything wrong with this line of code?

Code:

---

strSQL = "INSERT INTO tblCompetitors " & _
  "( strName, strStreet, strCity, strState, strZip, strManager, strP_ID ) " & _
  "SELECT '" & strName & "' AS Name, " & _
  "'" & strStreet & "' AS Street, " & _
  "'" & strCity & "' AS City, " & _
  "'" & strState & "' AS State, " & _
  "'" & strZip & "' AS Zip, " & _
  "'" & strManager & "' AS Manager, " & _
  "'" & Session("StoreNumber") & "' AS P_ID;"

---

Because when it runs, it inserts ALL six fields worth of data into strName in tblCompetitors.

Thanks!

--Ben

Code:

---

strSQL = "INSERT INTO tblCompetitors " & _
  "( strName, strStreet, strCity, strState, strZip, strManager, strP_ID ) " & _
  "Values( '" & strName & "' AS Name, " & _
  "'" & strStreet & "' AS Street, " & _
  "'" & strCity & "' AS City, " & _
  "'" & strState & "' AS State, " & _
  "'" & strZip & "' AS Zip, " & _
  "'" & strManager & "' AS Manager, " & _
  "'" & Session("StoreNumber") & "' AS P_ID;)"

---

Try that.

Hey, thanks for the tip.

Actually, as it turns out I did a bunch of cut & pastes, and all of the data was being populated into the variable strName while the rest were blank. Stupid typo on my part.

Wish I had a good way to step-through ASP code in Interdev. Anyone know a way?

--Ben