Smartsite Documentatie
>
Install & Config
>
Error Reference
>
Smartsite core functionality
>
007000-007999 Meta
> SCMS007003 Number of parameters does not match sql query.
SCMS007003 Number of parameters does not match sql query.
Problem
The numbers of of parameters you supplied for a sql query does not match the number of parameters you used in the sql query. A typical example of an sqlquery macre where this may occur is:
Smartsite SXML | Copy Code |
---|---|
<se:sqlquery sql="select title from vwActive where nr=?" /> |
In this example there is an sql parameter (the question mark) but there is no parameter specified.
Resolution
Make sure the number of parameters in the sql query matches the number of parameters specified.
- 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
- SCMS007004 Invalid named parameter in 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