|
|
I am trying to get an update query to work. I keep getting errors and I am
probably doing something stupid. I just cant see it.
I keep getting errors that say:
Syntax error (missing operator) in query expression
This error appears to come from me trying to update a field called
DateUpdated. Here is the query code:
<cfquery name="UpdateMember" datasource="itla_Membership">
UPDATE MemberList
Set
Password = '#Trim(FORM.Password)#',
LastName = '#Trim(FORM.LastName)#',
FirstName = '#Trim(FORM.FirstName)#',
RanchName = '#Trim(FORM.RanchName)#',
AltName = '#Trim(FORM.AltName)#',
Listing = '#Trim(FORM.Listing)#',
Street = '#Trim(FORM.Street)#',
City = '#Trim(FORM.City)#',
State = '#Trim(FORM.State)#',
Country = '#Trim(FORM.Country)#',
Region = '#Trim(FORM.Region)#',
Zip = '#Trim(FORM.Zip)#',
Phone1 = '#Trim(FORM.Phone1)#',
PhoneTitle1 = '#Trim(FORM.PhoneTitle1)#',
Phone2 = '#Trim(FORM.Phone2)#',
PhoneTitle2 = '#Trim(FORM.PhoneTitle2)#',
Phone3 = '#Trim(FORM.Phone3)#',
PhoneTitle3 = '#Trim(FORM.PhoneTitle3)#',
Phone4 = '#Trim(FORM.Phone4)#',
PhoneTitle4 = '#Trim(FORM.PhoneTitle4)#',
EMail = '#Trim(FORM.EMail)#',
Website = '#Trim(FORM.Website)#',
Comments = '#FORM.Comments#',
DateAdded = '#FORM.DateAdded#',
DateUpdated = '#CreateODBCDateTime(now())#',
Active = '#FORM.Active#',
ShowOnSite = '#FORM.ShowOnSite#',
EmailList = '#FORM.EmailList#'
WHERE MemberID = #FORM.MemberID#
</cfquery>
And here is the error that it generates:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Syntax error (missing operator) in query expression ''{ts
'2008-01-30 19:01:36'}''.
The error occurred in D:\Virtual\itla\web\ITLA_Members\Change\addedit.cfm:
line 168
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 168
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
166 : ShowOnSite = '#FORM.ShowOnSite#',
167 : EmailList = '#FORM.EmailList#'
168 : WHERE MemberID = #FORM.MemberID#
169 : </cfquery>
170 : </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', DateUpdated = '{ts '2008-01-30 19:01:36'}', Active = '1',
ShowOnSite = '1', EmailList = '1' WHERE MemberID = 278
DATASOURCE itla_Membership
VENDORERRORCODE -3100
SQLSTATE 42000
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:01 PM
Stack Trace
at
cfaddedit2ecfm200115393._factor1(D:\Virtual\itla\web\ITLA_Members\Change\addedit
.cfm:168) 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:168) 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] Syntax error (missing
operator) in query expression ''{ts '2008-01-30 19:01:36'}''.
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:168)
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)
|
|