Undeclared variable error

[penguinspeaks]

Hello. I am hoping is a simple answer to this because I have not come across it before.
I have run similar code many times but now getting an error.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver][mysqld-5.6.33-log]Undeclared variable: BRACKET16_73

/start1.asp, line 51

SQL = "SELECT * INTO BRACKET16_"&IDT&" FROM BRACKET16_TEMP"
CONN.EXECUTE(SQL)

When I run response.write it displays perfectly.

SELECT * INTO BRACKET16_73 FROM BRACKET16_TEMP

Please help me understand what variable could be undeclared or why I am seeing this error.

Thanks,
Penguin

 

[bborissov]

This is SQL Server forum, not MySQL one


Borislav Borissov
VFP9 SP2, SQL Server

 

[penguinspeaks]

Sorry. I am using asp with MySQL.

Most of the sql language is the same. I just posted to MySQL forum.

Thanks,
Penguin