Click here to Skip to main content
15,887,379 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi Sir,

I am getting these errors when i execute a query in my db.

[root@localhost:3306] ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

ERROR[HYT00][Mysql][ODBC 3.51 Driver]Can't connect to My SQL Server on 'localhost'10048)


Please help.

Thanks,
Narendra
Posted
Comments
[no name] 23-Sep-12 22:29pm    
Uhm..... okay.... check your code
narendrag999 23-Sep-12 22:37pm    
thank you..
Mohibur Rashid 23-Sep-12 22:53pm    
What is the query?
narendrag999 23-Sep-12 23:10pm    
Hi pls find the query.

Insert into temp_a2_dly_work (STORE_ID,DAILY_DATE,SALES_CCAR,SALES_PCAR,SALES_OTC,MAST_TOTAL,VOID_ORDER ,
BAD_ORDER, TOT_SALES, SALES_TAX, BOTTLE_DEP, NET_SALES, COUPONS,NON_ROYAL_SALES,ROYAL_SALES,FOOD_BOUGHT,
CUST_CHARGE,RAISE_TILL,MILEAGE,CONT_LABOR,CPO_01_DESC,CPO_01,CPO_02_DESC,CPO_02,CPO_03_DESC,CPO_03,CPO_04_DESC,
CPO_04,CPO_05_DESC,CPO_05,CPO_06_DESC,CPO_06,CPO_07_DESC,CPO_07,CPO_08_DESC,CPO_08,CPO_09_DESC,CPO_09,CPO_10_DESC,
CPO_10,CPO_11_DESC,CPO_11,CPO_12_DESC,CPO_12,CPO_13_DESC,CPO_13,CPO_14_DESC,CPO_14,CPO_15_DESC,CPO_15,CPO_TOTAL,
FOOD_SOLD,CUST_PAY,LOWER_TILL,MROTS_01_DESC,MROTS_01,MROTS_02_DESC,MROTS_02,MROTS_03_DESC,MROTS_03,MROTS_04_DESC,
MROTS_04,MROTS_05_DESC,MROTS_05,MROTS_06_DESC,MROTS_06,MROTS_07_DESC,MROTS_07,MROTS_TOTAL,TOT_ACCT,DEP_TOTAL,
CASH_OS,END_TILL,CARRY_OUT,CO_COUPON,DLRY_COUPON,LUNCH_SALE,FC_FOOD,FC_COLA,FC_PAPER,FC_NON,IFC_FOOD,
IFC_COLA,IFC_PAPER,IFC_NON,LAB_SALARY,LAB_HOURLY,LAB_INSIDE,LAB_OUTSIDE,LAB_OVERTIME,TOT_MILE,TOT_COUPON_COST,
IN_CHARGE,BEG_ORDER,END_ORDER,HOLIDAY,NUM_PIZZA,PIZZA_SALE,NUM_ORD,ORDER_SALE,TOT_ORD,COMMENT1,COMMENT2,
COMMENT3,COMMENT4,COMMENT5,COMMENT6,NUM_OT_TIME,TOT_OT_TIME,NUM_LOAD_TIME,TOT_LOAD_TIME,NUM_OTD_TIME,
TOT_OTD_TIME,NUM_DLRY_TIME,TOT_DLRY_TIME,REPORT_DATE_TIME , YEAR_PD, USERID,CRED_CARD_TOTAL,GOVT_TAX,
CRED_VISA_TOTAL,CRED_MASTER_TOTAL,CASH_SALES_TOTAL,FOOD , LABOR, COUPON1, KMETER, FOODPER, LABORPER,
COUPONPER,KMETERPER , DELCOMPPER, DELPERSPER, OTCPER,flcmcost,flcmcostper,pctotal,WEBCASH_TOTAL,TOT_ACCT_BEF_ROUND,
TOT_ACCT_ROUND_DIFF)

SELECT STORE_ID,DAILY_DATE,SALES_CCAR,SALES_PCAR,SALES_OTC,MAST_TOTAL,VOID_ORDER , BAD_ORDER, TOT_SALES, SALES_TAX, BOTTLE_DEP, NET_SALES, COUPONS,NON_ROYAL_SALES,ROYAL_SALES,FOOD_BOUGHT,CUST_CHARGE,RAISE_TILL,MILEAGE,CONT_LABOR,CPO_01_DESC,CPO_01,CPO_02_DESC,CPO_02,CPO_03_DESC,CPO_03,CPO_04_DESC,CPO_04,CPO_05_DESC,CPO_05,CPO_06_DESC,CPO_06,CPO_07_DESC,CPO_07,CPO_08_DESC,CPO_08,CPO_09_DESC,CPO_09,CPO_10_DESC,CPO_10,CPO_11_DESC,CPO_11,CPO_12_DESC,CPO_12,CPO_13_DESC,CPO_13,CPO_14_DESC,CPO_14,CPO_15_DESC,CPO_15,CPO_TOTAL,FOOD_SOLD,CUST_PAY,LOWER_TILL,MROTS_01_DESC,MROTS_01,MROTS_02_DESC,MROTS_02,MROTS_03_DESC,MROTS_03,MROTS_04_DESC,MROTS_04,MROTS_05_DESC,MROTS_05,MROTS_06_DESC,MROTS_06,MROTS_07_DESC,MROTS_07,MROTS_TOTAL,TOT_ACCT,DEP_TOTAL,CASH_OS,END_TILL,CARRY_OUT,CO_COUPON,DLRY_COUPON,LUNCH_SALE,FC_FOOD,FC_COLA,FC_PAPER,FC_NON,IFC_FOOD,IFC_COLA,IFC_PAPER,IFC_NON,LAB_SALARY,LAB_HOURLY,LAB_INSIDE,LAB_OUTSIDE,LAB_OVERTIME,TOT_MILE,TOT_COUPON_COST,IN_CHARGE,BEG_ORDER,END_ORDER,HOLIDAY,NUM_PIZZA,PIZZA_SALE,NUM_ORD,ORDER_SALE,TOT_ORD,COMMENT1,COMMENT2,COMMENT3,COMMENT4,COMMENT5,COMMENT6,NUM_OT_TIME,TOT_OT_TIME,NUM_LOAD_TIME,TOT_LOAD_TIME,NUM_OTD_TIME,TOT_OTD_TIME,NUM_DLRY_TIME,TOT_DLRY_TIME,REPORT_DATE_TIME , YEAR_PD, 'MIS',CRED_CARD_TOTAL,GOVT_TAX,CRED_VISA_TOTAL,CRED_MASTER_TOTAL,CASH_SALES_TOTAL,'14226.93','17026.94','527.2','4.6','1053.61','1260.97','39.04','0.34','78.27','0','18.16','31785.67','2353.96','0',WEBCASH_TOTAL,TOT_ACCT_BEF_ROUND,TOT_ACCT_ROUND_DIFF from a2_dly_work where store_id = '85004' and daily_date = 'YYYY-MM-DD'


Thanks,
Naren
Mohibur Rashid 23-Sep-12 23:29pm    
which query is the problem? I have no plan to check all of these queries

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900