Syntax error in INSERT INTO statement

Stephan · July 13th, 2004, 10:50 AM

It looks like it does not pick up a value for StockId. This is the code from the form:

<input type="hidden" name="txtStockId" VALUE="<%Request.QueryString("StockId")%>">

which is supposed to retreive the StockId from the database.

Snib · July 13th, 2004, 11:05 AM

Request.QueryString retrieves values from the address bar, not a database.

Snib

<><

Stephan · July 14th, 2004, 02:19 AM

Sorry, it is suppose to retrieve it from the address bar, but it doesn't, although i can clearly see the value in the address bar.

Stephan · July 14th, 2004, 04:25 AM

That's what the address bar looks like:

http://localhost/test_database/buyitem.asp?StockId=5

Snib · July 14th, 2004, 09:12 AM

Ohhhhhhhhhhh OK i see the problem now. You're missing an equals sign:

<input type="hidden" name="txtStockId" VALUE="<%Request.QueryString("StockId")%>">
should be:
<input type="hidden" name="txtStockId" VALUE="<%=Request.QueryString("StockId")%>">

Man, I can't believe I didn't catch that.... ;)

HTH,

Snib

<><

Stephan · July 14th, 2004, 10:03 AM

Cheers Mate, that sorted it.

lloyd_m · February 22nd, 2005, 01:43 PM

I'm having the same problem. I have used the book code plus the suggested code from terry s above - still getting a syntax error problem.

Here's my code that supplies the data: -

<body bgcolor="#FFFFFF">
<p align="center">Please enter your customer ID and the number of seats you would
  like to reserve</p>
<form name="form1" language=JavaScript method="post" action="AddTable.asp" onsubmit="return form1_onsubmit()">
<input type="text" name=txtBook_ID value="<%=Request.QueryString("Booking_ID")%>">
<input type="text" name=txtDate value="<%=Request.QueryString("DateBooked")%>">
<input type="text" name=txtTime value="<%=Request.QueryString("Time")%>">
<input type="text" name=txtSeatNo value="<%=Request.QueryString("SeatsRemaining")%>" >
  <table width="700" border="1" align="center">
    <tr>
      <td>
        <div align="right">Customer ID</div>
      </td>
      <td>
        <input type="text" name="txtCustID">
      </td>
      <td>
        <div align="right">Number of Seats</div>
      </td>
      <td>
        <input type="text" name="txtSeatNo">
      </td>
    </tr>
    <tr>
      <td colspan="2">
        <div align="center">
          <input type="reset" name="Reset" value="Reset">
        </div>
      </td>
      <td colspan="2">
        <div align="center">
          <input type="submit" name="Submit" value="Book this table">
        </div>
      </td>
    </tr>
  </table>
</form>
<p> </p>
<p align="center"> </p>
<p>  </p>
</body>

And the code on the page that inserts the data: -

<%

var ci = Request.Form("txtCustID");
var dt = Request.Form("txtDate");
var tm = Request.Form("txtTime");
var sn = Request.Form("txtSeatNo");

adoConnection = Server.CreateObject("ADODB.Connection");
adoConnection.Open("DSN=SunInnDB");

var SQL = "INSERT INTO tblBookings (CustID,Date,Time,SeatsBooked)";
SQL = SQL + "VALUES('"+ci+"','"+dt+"','"+tm+"','"+sn+"')";

adoConnection.Execute(SQL);
adoConnection.Close();
adoConnection = null;

%>

Help appreciated