[RESOLVED]-INSERT SQL question...

[BenFinkel]

Maybe I'm a retard, but does anyone see anything wrong with this line of 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

[ober0330]

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.

[BenFinkel]

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