Smartsite Documentatie
>
Install & Config
>
Error Reference
>
Smartsite core functionality
>
007000-007999 Meta
> SCMS007004 Invalid named parameter in sql query
|
SCMS007004 Invalid named parameter in sql query
Problem
When this error occurs, you probably made a syntax error in the notation of named parameters. A typical example of a correctly used named parameter is:{formatexample('
<se:sqlquery sql="select title from vwActive where nr=?:mynumber"> <se:parameters> <se:parameter name="params"> <se:collection> <se:member name="mynumber">2</se:member> </se:collection> </se:parameter> </se:parameters> </se:sqlquery>','sxml')}
Resolution
Install & Config
- Getting Started
- Hardware and software requirements for Smartsite iXperion
- Platform support
- Site Installation
- Smartsite 7 Manager
- iXperion Publication Server
- iXperion tools
- Database Server
- Security
- IIS Configuration
- Asp.Net Configuration
- Outscaling
- WCF
- Smartsite Configuration files
- Knowledge Base | Installation and Configuration
-
Error Reference
-
Smartsite core functionality
- 001000-001999 Core
- 002000-002999 SXML
- 003000-003999 Viper
- 004000-004999 Expression parser
- 005000-005999 CMS
- 006000-006999 Security
-
007000-007999 Meta
- SCMS007001 No provider found.
- SCMS007002 UnknownProviderFound
- SCMS007003 Number of parameters does not match sql query.
- SCMS007005 Can't convert CLR type to database type.
- SCMS007006 Can't convert database type to CLR type.
- SCMS007007 Stored Procedure schema contains invalid table
- SCMS007008 Stored Procedure schema contains a view
- SCMS007009 View schema contains invalid table.
- SCMS007010 View schema contains view
- SCMS007011 View schema contains table twice
- SCMS007012 DatabaseSchemaContainsDuplicateObjects
- SCMS007013 Invalid foreign key schema
- SCMS007014 Unsupported MySql DataType
- SCMS007015 DataNavigator syntax error
- SCMS007016 Table reference type mismatch
- SCMS007017 Field has invalid default.
- SCMS007018 Invalid relation type found
- SCMS007019 Content Relation not found
- SCMS007020 CTFP ContentRelation is missing
- SCMS007021 Invalid table or view for Content Relation
- SCMS007023 Unable to open database
- SCMS007024 Database provider not installed
- 008000-008999 Storage handlers
- 009000-009999 Tools
- 010000-010999 Publication
- 011000-011999 Webservices
- 012000-012999 ASP.Net / IIS
- 013000-013999 Formatting
- 014000-014999 Licensing
- Smartsite modules and components
- Smartsite external applications
-
Smartsite core functionality
- EmptySix site
- Smartsite iXperion Release 1.3 Installation manual
- Smartsite iXperion Requirements - v3.6
- Implementatiehandleiding Active Directory Koppeling of LDAP Smartsite iXperion v1.1.3
- Installatiehandleiding iXperion 1.3 en hoger Win 2008 32bit-v1.4
- Installatiehandleiding iXperion 1.3 en hoger Win 2008 64bit-v1.4
- Installatiehandleiding iXperion Word Import - Word 2010 setup voor x64- v1.0
- Installatiehandleiding Oracle client iXperion 1.3 Windows 2008 R2 64bit- v1.0.1
- Installatiehandleiding Smartsite iXperion SMI 2.0 - v1.0.3