sql syntax error help

this query show syntax error .. i am unable to figure it out

insert into order (orderdate, dpname, paymethod, tamount, pquantity,shipid)

values(now(),'$dpname' ,cod, '$tamount', '$itmqty', '$ship_id')

where is the error ?

View Answers

March 23, 2012 at 3:18 PM

Please send the error details and the datatype you are using for the given fields.

Ads

Advertisements

Syntax error in my UPDATE..please advise
Syntax error in my UPDATE..please advise Hi experts, I tested my code and NetBean IDE gave me the following message:- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

SQL Avg Syntax
SQL Avg Syntax SQL Avg Syntax is used to compute the average of the records in a table. Understand with Example The Tutorial illustrate an example from 'SQL Average Syntax

SQL Alter Column Syntax
SQL Alter Column Syntax SQL Alter Column Syntax modifies the existing table definition. Understand with Example The Tutorial illustrate an example from SQL Alter Column Syntax

SQL Alter Table Syntax
SQL Alter Table Syntax SQL Alter Table Syntax modifies the existing table definition. Understand with Example The Tutorial illustrate an example from SQL

SQL Error Version 5.5.15
SQL Error Version 5.5.15 SQL Error Version 5.5.15

SQL QUERY ERROR
SQL QUERY ERROR Im writing a query which shows error of INVALID... THE FORM IS THROWING THE ERROR OF INVALID CHARACTER BUT THE SAME QUERY IS RUNNING IN THE DATABASE. PLEASE HELP ME. Syntax of insert query is: INSERT

correct the sql error
correct the sql error i am getting a SQL Error while retriving data... help me and studentId's datatye is number...... private void...(null,"Please enter the Student ID to Search","Error",0); } else { try

Logic error? HELP PLEASE! :(
Logic error? HELP PLEASE! :( Hello Guys! i have a huge problem. What... rs = null; try { String sql ="SELECT * FROM..."); st= con.createStatement(); rs =st.executeQuery(sql

JSP SQL Error
JSP SQL Error Hi While trying to execute the below code i'm getting the following error "java.sql.SQLException: Io exception: Got minus one from a read call ". please help me out. <% try{ String Username

SQL connection error in android
SQL connection error in android hi, i am android developer . recently i made one application connect with sql server 2005 using jtds...:sql:Exception : BUFFERDIR connection property invalid. if you have any answer

help me in solving this error
help me in solving this error Hello, i have installed tomcat 6.0, i am getting following error while running application. java.lang.NullPointerException org.apache.jsp.loginjsp.jspInit(login_jsp.java:23

error : not an sql expression statement
error : not an sql expression statement hii I am gettin followin error in connecting to database SQLserver 2005 in Jdeveloper,i m usin struts and jsp my pogram: import java.sql.*; public class TaskBO { public TaskBO

How to Checking Syntax Error in PHP from Command Line
How to Checking Syntax Error in PHP from Command Line Checking Syntax Error in PHP from Command Line PHP allows you to check your script.... It will check the syntax error in your script and show the �??Unexpected token �

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. String sql = "UPDATE emp_details SET empEname... = ?"; PreparedStatement pst = connection.prepareStatement(sql); pst.setString

How to resolve this error The filename, directory name, or volume label syntax is incorrect
How to resolve this error The filename, directory name, or volume label syntax... getting this error java.io.FileNotFoundException: http:\www.queen.com... label syntax is incorrect) at java.io.RandomAccessFile.open(Native Method

foreign key error in sql
foreign key error in sql create table matchdetails(mid varchar2(10),mdate date,team1 varchar2(10),team2 varchar2(10...) references matchdetails(mid)); ->for the above batsman table it shows error

ModuleNotFoundError: No module named 'error-help'
ModuleNotFoundError: No module named 'error-help' Hi, My Python... 'error-help' How to remove the ModuleNotFoundError: No module named 'error-help' error? Thanks Hi, In your python environment you

MY Sql Query Error - Not able to Understand the issue
MY Sql Query Error - Not able to Understand the issue I am new... END I am getting an error as follow: Schema Creation Failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server

correct the sql error and retrive data....plez
correct the sql error and retrive data....plez i am getting a SQL Error while retriving data from access to jframe called "datatype mismatch in criteria expression" plez do help me and studentId's datatye is number

ModuleNotFoundError: No module named 'error-help-topcatthomas'
ModuleNotFoundError: No module named 'error-help-topcatthomas' Hi...: No module named 'error-help-topcatthomas' How to remove the ModuleNotFoundError: No module named 'error-help-topcatthomas' error? Thanks

help with JDateChooser to insert date into sql
help with JDateChooser to insert date into sql TextField3 = new com.toedter.calendar.JDateChooser(); TextField3.setDateFormatString("MM-d-y�?� private void buttonActionPerformed(java.awt.event.Act�?� evt) { try{ DateFormat df

Upgraded MySQL from 5.1 to 5.5, running into PDOException: SQLSTATE[42000]: Syntax error or
Upgraded MySQL from 5.1 to 5.5, running into PDOException: SQLSTATE[42000]: Syntax error or Upgraded MySQL from 5.1 to 5.5, running into PDOException: SQLSTATE[42000]: Syntax error or �

Error while SQL Server connection to Java
Error while SQL Server connection to Java import java.sql.*; public..."); con=DriverManager.getConnection("jdbc:odbc:SQL_SERVER;user=DTHOTA;password...("password", " "); con=DriverManager.getConnection("jdbc:odbc:SQL_SERVER", prop

Grid World project Run Error !! help please!!
Grid World project Run Error !! help please!! i'm trying to make...); } } } } and Here is my error...: (it runs at first but when the bug hits a side, the error occurs and i exit the error but run does not work anymore

how do i update my database with the help of update syntax in html <text/javascript>? How to write 'where' statement in this?
how do i update my database with the help of update syntax in html ? How to write 'where' statement in this? var sqlmek="update into Student_info set(ID,s_name,l_name,address,pincode,mobile_no,mail_id)values ("; sqlmek

error
/ServletUserEnquiryForm.shtml getting an error given below SQLException caught: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error please suggest...error I am running a program insert into statement in sql using

ModuleNotFoundError: No module named 'syntax'
, ModuleNotFoundError: No module named 'syntax' error will be solved. Thanks...ModuleNotFoundError: No module named 'syntax' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named

Error-
Error- Hello, I would like to know about XSD file. I try to print XML file but I am getting error SAXException-- says Content is not allowed in prolog. Please help me

Ads