Hi,
I have a super simple query that still throws up an error in a cfml page:
Syntax error: Stopped parse at References(id137)
SELECT References.ItemID
FROM References
WHERE ReferrerID = #URL.ArtID#
ORDER BY References.ID
The variable is a number, I have no idea what I am doing wrong here.
|
REFERENCES is a SQL keyword used for MS Access' relation verification.
CREATE TABLE [IF NOT EXISTS] table_name [(column_identifier data_type [constraint] [,...] [, constraint_clause [,...] ] )] [ [AS] SELECT query | ? ]
constraint_clause: [ CONSTRAINT constraint_name ] PRIMARY KEY (column1, column2, . column_n) | CONSTRAINT constraint_name FOREIGN KEY (column1, column2, ... column_n) REFERENCES parent_table (column1, column2, ... column_n) [ON DELETE CASCADE] [ON UPDATE CASCADE] | [ CONSTRAINT constraint_name ] UNIQUE (column1, column2, . column_n) | CONSTRAINT constraint_name CHECK (column_name condition)
You should use "References" for the older version. Today HXTT will release a new version which allows your sql.
|
Main
webmaster@hxtt.com