Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Syntax error after form submission

Status
Not open for further replies.
doctorcoldfusion

doctorcoldfusion

Programmer
Sep 16, 2002
14
US
DEAR FRIENDS,
My form is giving me syntax error insted of acknowleding the submission of form(No thank you reply)Please visit Advice please
_________________________________________________
<CENTER><H1>POORMANSVOICE</H1>
<font size=2 face=&quot;arial,helvetica&quot;>

<cfif IsDefined(&quot;form.name&quot;)>
<cfquery datasource=&quot;poorman&quot;>
INSERT INTO info (name,address,city,state,zip,phone,email,comments)
VALUES
('#form.name#','#form.address#','#form.city#','#form.state#',#form.zip#,#form.phone#,'#form.email#','#form.comments#')
</cfquery>



<cflocation url=&quot;
<cfelse>

<form action=&quot;index.cfm&quot; method=&quot;post&quot;>
<table>
<tr><td><font size=2 face=&quot;arial,helvetica&quot;><html>
</head>
<body bgcolor=&quot;#0000FF&quot;><CENTER><h1>You want to serve Kashmiris<br> Fill the form please</h1><br><br color=#04jjjj>
NAME<br><input type=&quot;text&quot; name=&quot;name&quot; value=&quot;&quot;><BR>
Address<br><input type=&quot;text&quot; name=&quot;address&quot; value=&quot;&quot;><BR>
City<br><input type=&quot;text&quot; name=&quot;city&quot; value=&quot;&quot;><BR>
State<br><input type=&quot;text&quot; name=&quot;state&quot; value=&quot;&quot;><BR>
Zip<br><br><input type=&quot;text&quot; name=&quot;zip&quot; value=&quot;&quot;><BR>
Phone<br><input type=&quot;text&quot; name=&quot;phone&quot; value=&quot;&quot;><BR>
email<br><input type=&quot;text&quot; name=&quot;email&quot; value=&quot;&quot;><BR>
<center><h3>Comments,Affiliation and Profile</h3><br>
<textarea name=&quot;comments&quot; rows=&quot;&quot; cols=&quot;&quot;>
 
Sort by date Sort by votes
#form.Phone# may have to be in 'single quotes' Did I help?
Vote!
 
Upvote 0 Downvote
I checked this page out and the error message is as follows:

SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.

The error is not coming from your code, per se; it is coming from an inability on the part of the CF server to make a connection with your database. Check the datasource setup in the Administrator, or provide login information in the
Code: 
<cfquery>
tag.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

HansKok
  • Locked
  • Question
Error after only changing text and not codes
Replies
0
Views
202
HansKok
HansKok
miagriff
  • Locked
  • Question
Coldfusion if statement syntax
Replies
1
Views
254
LyndonOHRC
LyndonOHRC
FALCONSEYE
  • Locked
  • Question
Error: no known VMs. (check for corrupt jvm.cfg file) !!! How I Fixed It !!!
Replies
0
Views
323
FALCONSEYE
FALCONSEYE
lwfg
  • Locked
  • Question
getting form values from ColdFusion programn to asp.net program
Replies
2
Views
107
LyndonOHRC
LyndonOHRC
hifispin2015
  • Locked
  • Question
Creating a slect all button for A Multiple Slect HTML Form Field
Replies
1
Views
90
LyndonOHRC
LyndonOHRC

Part and Inventory Search

Sponsor

Back
Top