Error Executing Database Query.
|
|
Syntax error or access violation: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition, label, value
from acrs_formfields ff
left join acrs_forms f on ff' at line 1
|
| |
The error occurred in C:\Websites\166951yf6\clients\acrs\xtras\form.cfm: line 10 Called from C:\Websites\166951yf6\displaypage.cfm: line 100 Called from C:\Websites\166951yf6\clients\acrs\xtras\form.cfm: line 10 Called from C:\Websites\166951yf6\displaypage.cfm: line 100 |
8 : left join #dbPrefix#_forms f on ff.formID = f.formID
9 : left join #dbPrefix#_formvalues fv on fv.fieldID = ff.fieldID
10 : where f.pageID = #pageID#
11 : order by ff.fieldID, ff.orderBy, fv.orderBy
12 : </cfquery>
|
|
| SQLSTATE |
42000 |
| SQL |
select fieldType, fieldName, fieldLabel, condition, label, value
from acrs_formfields ff
left join acrs_forms f on ff.formID = f.formID
left join acrs_formvalues fv on fv.fieldID = ff.fieldID
where f.pageID = 115
order by ff.fieldID, ff.orderBy, fv.orderBy
|
| VENDORERRORCODE |
1064 |
| DATASOURCE |
vault |
|
|
Resources:
|
| Browser |
publishScript |
| Remote Address |
76.12.244.203 |
| Referrer |
|
| Date/Time |
24-Sep-08 11:17 PM |
|