Undeclared variable error
Undeclared variable error
(OP)
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
When I run response.write it displays perfectly.
Please help me understand what variable could be undeclared or why I am seeing this error.
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
RE: Undeclared variable error
If you want to create a new table look at this:
https://stackoverflow.com/questions/16809393/selec...
or more direct in the MySQL reference:
https://dev.mysql.com/doc/refman/8.0/en/create-tab...
In short, the syntax in MySQL is
CODE
Bye, Olaf.
Olaf Doschke Software Engineering
https://www.doschke.name
RE: Undeclared variable error
Is this not correct??
Thanks,
Penguin
RE: Undeclared variable error
Thanks for the help and reply.
Thanks,
Penguin
RE: Undeclared variable error
https://dev.mysql.com/doc/refman/8.0/en/select-int...
The target is never a new table, it's a variable list, a file (TXT/CSV) or a dumpfile, but not a new table.
And if you have an existing table the command also is vice versa, the overall is an INSERT INTO then, and the SELECT as the source of data still comes afterwards:
CODE
Bye, Olaf.
Olaf Doschke Software Engineering
https://www.doschke.name