ETC - Reserved Word?

[OrWolf]

I have an ASP page with a SQL statement. The SQL statement successfully ran until I attempted to add a new field to pull called ETC. I get an error 'Too few parameters - Expected 1'. I tried using referencing the field as Table.ETC As EstTime but that didn't work either. The statement does work for all other custom fields. Anyone know if ETC is reserved?

 

[cbokowski]

I check Sql Bol, not showing as a reserved word. Have you run the query outside of the asp?

 

[OrWolf]

The query ran successfully from an Access DB with attached tables. The ETC is recognized as a field just fine.

 

[lobstah]

can you post your sql statement here for us to review?

also, before you execute the sql statement, try doing a response.write (your sql statement) to see what it is trying to execute. possibly your variables are empty, or you might have a comma in the wrong place, or missing a space between a parameter and a variable's value. (that's a frequent error that I've seen: WHERE time = " & yourTime & "AND day = " & yourDay

Note that there is no space between 'yourTime' and the keyword 'AND'