Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Undeclared variable error

Status
Not open for further replies.

penguinspeaks

Technical User
Nov 13, 2002
234
US
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

Code:
SQL = "SELECT * INTO BRACKET16_"&IDT&" FROM BRACKET16_TEMP"
CONN.EXECUTE(SQL)
When I run response.write it displays perfectly.
Code:
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
 
This is SQL Server forum, not MySQL one :)


Borislav Borissov
VFP9 SP2, SQL Server
 
Sorry. I am using asp with MySQL.

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

Thanks,
Penguin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top