[Sysadmin] Article Editing Problem

[Dean Mah]

I just tried to update the WAP article and I got an error.  Looks to
be a problem with setting the signdate.


Error Executing Database Query.
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid column name 'sysdate'.
 
The error occurred in F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm: line 89
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm: line 137
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm: line 212
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm: line 215
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm: line 340
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\app_article.cfm: line 29
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\app_chooser.cfm: line 6
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\home_design.cfm: line 53
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\index.cfm: line 21
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm: line 89
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm: line 137
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm: line 212
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm: line 215
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm: line 340
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\app_article.cfm: line 29
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\app_chooser.cfm: line 6
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\home_design.cfm: line 53
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\index.cfm: line 21

87 :           body = <cfqueryparam value="#Trim(form.body)#" cfsqltype="cf_sql_longvarchar">
88 :         WHERE contentid = #Val(form.contentid)#
89 :       </cfquery>
90 :       <cfquery name="getcontent" datasource="#data#">
91 :                SELECT content.contentid

SQL    UPDATE content SET userid = 40372, categoryid = 17, signdate = sysdate, datemod = '03-Mar-03', contentname = 'WAP for fun and profit - Part 1 - Basic WML format', synopsis = 'Though regarded by some as a flop and by many as at least a disappointment, the use of WAP continues to increase. Add some WAP skills to your quiver and see if you can make use of this quirky beast. *Note - for those of you without a WAP capable device, you can download a free PC-based WAP browser from Apache Software. (Windows only at the moment sorry).', keyphrase = '', body = (param 1) WHERE contentid = 58151
DATASOURCE   evolt
VENDORERRORCODE   207
SQLSTATE   42S22
Please try the following:

    * Check the CFML Reference Manual to verify that you are using the correct syntax.
    * Search the Knowledge Base to find a solution to your problem.

Browser   Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2) Gecko/20021126
Remote Address   209.115.153.66
Referrer   http://evolt.org/evolt/index.cfm?section=article&action=preview
Date/Time   12-Mar-03 04:17 PM
Stack Trace
at cfact_process2ecfm640912652._factor1(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm:89) at cfact_process2ecfm640912652._factor2(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm:137) at cfact_process2ecfm640912652._factor5(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm:212) at cfact_process2ecfm640912652._factor8(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm:215) at cfact_process2ecfm640912652.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm:340) at cfapp_article2ecfm1146154231.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\app_article.cfm:29) at cfapp_chooser2ecfm667961807.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\app_chooser.cfm:6) at cfhome_design2ecfm1077247409.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\home_design.cfm:53) at cfindex2ecfm348465346.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\index.cfm:21) at cfact_process2ecfm640912652._factor1(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm:89) at cfact_process2ecfm640912652._factor2(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm:137) atcfact_process2ecfm640912652._factor5(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm:212) at cfact_process2ecfm640912652._factor8(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm:215) at cfact_process2ecfm640912652.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm:340) at cfapp_article2ecfm1146154231.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\app_article.cfm:29) at cfapp_chooser2ecfm667961807.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\app_chooser.cfm:6) at cfhome_design2ecfm1077247409.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\home_design.cfm:53) at cfindex2ecfm348465346.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\index.cfm:21) at cfact_process2ecfm640912652._factor1(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm:89) at cfact_process2ecfm640912652._factor2(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm:137) at cfact_process2ecfm640912652._factor5(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm:212) at cfact_process2ecfm640912652._factor8(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm:215) at cfact_process2ecfm640912652.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\article\act_process.cfm:340) at cfapp_article2ecfm1146154231.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\app_article.cfm:29) at cfapp_chooser2ecfm667961807.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\app_chooser.cfm:6) at cfhome_design2ecfm1077247409.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\home_design.cfm:53) at cfindex2ecfm348465346.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\index.cfm:21)

[Ljava.lang.StackTraceElement;@1c9d4d5