Re: SQL::Statement confusing literals and identifiers

Update: Nevermind ... I just tried it and it doesn't like those either.

~~Try using square brackets or single quotes:~~

SELECT id, gid, [foo bar]
[download]

~~I know some SQL servers don't care for double quotes (e.g., MS SQL server), so perhaps SQL::Statement doesn't like 'em either....~~

Comment on Re: SQL::Statement confusing literals and identifiers Download Code

Replies are listed 'Best First'.
Re^2: SQL::Statement confusing literals and identifiers by ikegami (Patriarch) on Mar 11, 2008 at 04:39 UTC
The error occurs on the `execute` line after `prepare` successfully parsed the statement.	[reply] [d/l] [select]