• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Error Executing Database Query.

New Here ,
Jul 09, 2007 Jul 09, 2007

Copy link to clipboard

Copied

Error Executing Database Query.
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

The Error Occurred in C:\CFusionMX\wwwroot\paidwealth\member\editpassword.cfm: line 60

58 : </cfif>
59 : WHERE Register.RefID = #SESSION.MM_Username#
60 : </cfquery>
61 : <cflocation url="editpasswordnow.cfm">
62 : </cfif>



--------------------------------------------------------------------------------

SQL UPDATE Register SET FullName= 'olabisi oyleke' , Password= 'you' , Sex= 'male' , State= 'lagos' , Country= 'nigeria' , Email= 'bisijacobs@yahoo.com' , Telephone= '234-8035216235' WHERE Register.RefID = 1183581076
DATASOURCE paid
VENDORERRORCODE -3010
SQLSTATE 07002
TOPICS
Advanced techniques

Views

266

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jul 09, 2007 Jul 09, 2007

Copy link to clipboard

Copied

1) check data types of all your fields used in the query and make sure
the data you are inserting into them matches the required type (i.e. you
are not trying to enter a text string into an integer type field).
2) specifically check the data type of RefID field - if it is Text then
make sure #session.MM_username# is surrounded with ' (single quotes)

---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jul 09, 2007 Jul 09, 2007

Copy link to clipboard

Copied

LATEST
If Azadi's answer does not solve your problem, it could be a reserved word issue with your db field "password"

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation