|
|
So, I take out that offending line just to see what happens.
DateUpdated = '#CreateODBCDateTime(now())#',
And I get this error:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Data type mismatch in criteria expression.
The error occurred in D:\Virtual\itla\web\ITLA_Members\Change\addedit.cfm:
line 167
Called from D:\Virtual\itla\web\ITLA_Members\Change\addedit.cfm: line 133
Called from D:\Virtual\itla\web\ITLA_Members\Change\addedit.cfm: line 58
Called from D:\Virtual\itla\web\ITLA_Members\Change\addedit.cfm: line 35
Called from D:\Virtual\itla\web\ITLA_Members\Change\addedit.cfm: line 1
Called from D:\Virtual\itla\web\ITLA_Members\Change\index.cfm: line 2
Called from D:\Virtual\itla\web\ITLA_Members\Change\addedit.cfm: line 167
Called from D:\Virtual\itla\web\ITLA_Members\Change\addedit.cfm: line 133
Called from D:\Virtual\itla\web\ITLA_Members\Change\addedit.cfm: line 58
Called from D:\Virtual\itla\web\ITLA_Members\Change\addedit.cfm: line 35
Called from D:\Virtual\itla\web\ITLA_Members\Change\addedit.cfm: line 1
Called from D:\Virtual\itla\web\ITLA_Members\Change\index.cfm: line 2
165 : ShowOnSite = '#FORM.ShowOnSite#',
166 : EmailList = '#FORM.EmailList#'
167 : WHERE MemberID = #FORM.MemberID#
168 : </cfquery>
169 : </cfif>
SQL UPDATE MemberList Set Password = 'itla', LastName = 'Dickinson',
FirstName = 'Kirk', RanchName = 'Dickinson Cattle Co., Inc.', AltName = '',
Listing = 'Ranch', Street = '62715 Barnesville Hendrysburg Rd.', City =
'Barnesville', State = 'OH', Country = '', Region = 'Ohio', Zip = '43713',
Phone1 = '740/425-2892', PhoneTitle1 = 'Phone', Phone2 = '', PhoneTitle2 =
'Ranch', Phone3 = '', PhoneTitle3 = 'Office', Phone4 = '', PhoneTitle4 =
'Cell', EMail = 'kirk@xxxxxxxxxxxxxxxxx', Website =
'http://www.texaslonghorn.com', Comments = '', DateAdded = '2000-01-01
00:00:00.0', Active = '1', ShowOnSite = '1', EmailList = '1' WHERE MemberID =
278
DATASOURCE itla_Membership
VENDORERRORCODE -3030
SQLSTATE 22018
Please try the following:
* Check the ColdFusion documentation to verify that you are using the
correct syntax.
* Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.11)
Gecko/20071127 Firefox/2.0.0.11
Remote Address 70.142.138.63
Referrer http://www.itla.com/ITLA_Members/change/index.cfm?act=edit
Date/Time 30-Jan-08 07:18 PM
Stack Trace
at
cfaddedit2ecfm200115393._factor1(D:\Virtual\itla\web\ITLA_Members\Change\addedit
.cfm:167) at
cfaddedit2ecfm200115393._factor2(D:\Virtual\itla\web\ITLA_Members\Change\addedit
.cfm:133) at
cfaddedit2ecfm200115393._factor3(D:\Virtual\itla\web\ITLA_Members\Change\addedit
.cfm:58) at
cfaddedit2ecfm200115393._factor6(D:\Virtual\itla\web\ITLA_Members\Change\addedit
.cfm:35) at
cfaddedit2ecfm200115393.runPage(D:\Virtual\itla\web\ITLA_Members\Change\addedit.
cfm:1) at
cfindex2ecfm725351641.runPage(D:\Virtual\itla\web\ITLA_Members\Change\index.cfm:
2) at
cfaddedit2ecfm200115393._factor1(D:\Virtual\itla\web\ITLA_Members\Change\addedit
.cfm:167) at
cfaddedit2ecfm200115393._factor2(D:\Virtual\itla\web\ITLA_Members\Change\addedit
.cfm:133) at
cfaddedit2ecfm200115393._factor3(D:\Virtual\itla\web\ITLA_Members\Change\addedit
.cfm:58) at
cfaddedit2ecfm200115393._factor6(D:\Virtual\itla\web\ITLA_Members\Change\addedit
.cfm:35) at
cfaddedit2ecfm200115393.runPage(D:\Virtual\itla\web\ITLA_Members\Change\addedit.
cfm:1) at
cfindex2ecfm725351641.runPage(D:\Virtual\itla\web\ITLA_Members\Change\index.cfm:
2)
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria
expression.
at macromedia.sequelink.ssp.Diagnostic.toSQLException(Unknown Source)
at macromedia.sequelink.ssp.Chain.cnvDiagnostics(Unknown Source)
at macromedia.sequelink.ssp.Chain.decodeDiagnostic(Unknown Source)
at macromedia.sequelink.ssp.Chain.decodeBody(Unknown Source)
at macromedia.sequelink.ssp.Chain.decode(Unknown Source)
at macromedia.sequelink.ssp.Chain.send(Unknown Source)
at macromedia.sequelink.ctxt.stmt.StatementContext.execDirect(Unknown
Source)
at macromedia.jdbc.sequelink.SequeLinkImplStatement.execute(Unknown
Source)
at macromedia.jdbc.slbase.BaseStatement.commonExecute(Unknown Source)
at macromedia.jdbc.slbase.BaseStatement.executeInternal(Unknown Source)
at macromedia.jdbc.slbase.BaseStatement.execute(Unknown Source)
at
coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
at coldfusion.sql.Executive.executeQuery(Executive.java:974)
at coldfusion.sql.Executive.executeQuery(Executive.java:886)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:229)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
at
cfaddedit2ecfm200115393._factor1(D:\Virtual\itla\web\ITLA_Members\Change\addedit
.cfm:167)
at
cfaddedit2ecfm200115393._factor2(D:\Virtual\itla\web\ITLA_Members\Change\addedit
.cfm:133)
at
cfaddedit2ecfm200115393._factor3(D:\Virtual\itla\web\ITLA_Members\Change\addedit
.cfm:58)
at
cfaddedit2ecfm200115393._factor6(D:\Virtual\itla\web\ITLA_Members\Change\addedit
.cfm:35)
at
cfaddedit2ecfm200115393.runPage(D:\Virtual\itla\web\ITLA_Members\Change\addedit.
cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871)
at
cfindex2ecfm725351641.runPage(D:\Virtual\itla\web\ITLA_Members\Change\index.cfm:
2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilt
er.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
|
|