EasyCFM.COM ColdFusion Forums / MS SQL Server Related Issues / Weird error given during update query

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Weird error given during update query

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

brds
09-21-2010 @ 2:11 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 50
Joined: Jun 2007

Hey all,
While trying to run the following command:

<cfquery name="updateUser" datasource="#request.directoryDSN#">
        UPDATE directory_members
        SET
            lastname = <cfqueryparam value="#lastname#" cfsqltype="cf_sql_varchar" />,
            firstname = <cfqueryparam value="#firstname#" cfsqltype="cf_sql_varchar" />,
            middlename = <cfqueryparam value="#middlename#" cfsqltype="cf_sql_varchar" />,
            suffix = <cfqueryparam value="#title#" cfsqltype="cf_sql_varchar" />,
            email = <cfqueryparam value="#email#" cfsqltype="cf_sql_varchar" />,
            url = <cfqueryparam value="#dURL#" cfsqltype="cf_sql_varchar" />
        WHERE directoryid = <cfqueryparam value="#makeChanges#" cfsqltype="cf_sql_integer" />
    </cfquery>


I get the following error:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'vchfullname'.


Nowhere in the file is 'vchfullname' called or even mentioned.

Any ideas?

Thanks in advance,
Brds

tgruen
03-07-2011 @ 9:35 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 59
Joined: Aug 2006

are you able to turn on debugging on this server for your IP?

Tony


Website Designed and Developed by Pablo Varando.