FORM SUBMISSION 1

[doctorcoldfusion]

DEAR FRIENDS,
My form of coldfusion was working and contents were getting submitted to database.I added an inbox and form is giving me error.Now if i go to previous setting of form still it is not working.I cant see the threads for same in previous issues.The code is pasted below or you can see error yourself by visitng

http://www.poormansvoice.org.

Advice please.
thanks

POORMANSVOICE



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

Error Occurred While Processing Request
Error Executing Database Query.
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

The Error Occurred in C:\vp\doctorbush.com\POORMANSVOICE.ORG\

http://www\index.cfm:

line 9

7 : INSERT INTO info (name,address,city,state,zip,phone,email,comments)
8 : VALUES ('#form.name#','#form.address#','#form.city#','#form.state#',
9 : '#form.zip#','#form.phone#','#form.email#','#form.comments#')</cfquery>
10 :
11 : <cflocation url=&quot;

http://www.poormansvoice.com/index.cfm&quot;>

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

SQL INSERT INTO info (name,address,city,state,zip,phone,email,comments) VALUES ('','','','', '','','','')
DATASOURCE poorman
VENDORERRORCODE -3030
SQLSTATE 22018

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/4.0 (compatible; MSIE 5.5; AOL 7.0; Windows NT 5.0)
Remote Address 152.163.189.173
Referer

http://www.poormansvoice.org/

Date/Time 16-Sep-02 05:52 PM

Stack Trace (click to expand)
at cfindex2ecfm836601371.runPage(C:\vp\doctorbush.com\POORMANSVOICE.ORG\

http://www\index.cfm:9)

at cfindex2ecfm836601371.runPage(C:\vp\doctorbush.com\POORMANSVOICE.ORG\

http://www\index.cfm:9)

java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
at com.merant.sequelink.ssp.Diagnostic.toSQLException(Unknown Source)
at com.merant.sequelink.ssp.Chain.cnvDiagnostics(Unknown Source)
at com.merant.sequelink.ssp.Chain.decodeDiagnostic(Unknown Source)
at com.merant.sequelink.ssp.Chain.decodeBody(Unknown Source)
at com.merant.sequelink.ssp.Chain.decode(Unknown Source)
at com.merant.sequelink.ssp.Chain.send(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StatementContext.send(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StmtCtxtState._getDescribeInfo(Unknown Source)
at com.merant.sequelink.ctxt.stmt.CreatedStmtCtxt.getDescribeInfo(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StatementContext.getDescribeInfo(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StmtCtxtState._execDirect(Unknown Source)
at com.merant.sequelink.ctxt.stmt.CreatedStmtCtxt.execDirect(Unknown Source)
at com.merant.sequelink.ctxt.stmt.StatementContext.execDirect(Unknown Source)
at com.merant.sequelink.jdbc.SequeLinkStatement._execute(Unknown Source)
at com.merant.sequelink.jdbc.SequeLinkStatement.execute(Unknown Source)
at jrun.sql.JRunStatement.execute(JRunStatement.java:304)
at coldfusion.sql.Executive.executeQuery(Unknown Source)
at coldfusion.sql.Executive.executeQuery(Unknown Source)
at coldfusion.sql.SqlImpl.execute(Unknown Source)
at coldfusion.tagext.sql.QueryTag.doEndTag(Unknown Source)
at cfindex2ecfm836601371.runPage(C:\vp\doctorbush.com\POORMANSVOICE.ORG\

http://www\index.cfm:9)

at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
at coldfusion.filter.ApplicationFilter.invoke(Unknown Source)
at coldfusion.filter.PathFilter.invoke(Unknown Source)
at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source)
at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
at coldfusion.CfmServlet.service(Unknown Source)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
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)

 

[webmigit]

maybe zip is set to number, so you might try:

VALUES ('#form.name#','#form.address#','#form.city#','#form.state#',#form.zip#,'#form.phone#','#form.email#','#form.comments#')

Did I help?
Vote!

 

[webmigit]

Hey thanks for the vote Did I help?
Vote!