madiaz91911
Technical User
I really want to use parameterized queries in my web site. But sometimes, Id rather eat a can of worms than use these typoe queries.
Here is my latest nightmare.
##################################
date = 2/20/2013
cmdStoredProc.parameters.append cmdStoredProc.createparameter("@MDate",7,1,0,Date) ' no work
ERROR MESSAGE - Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query.
so changed date valued to : 20130320
ERROR MESSAGE - Application uses a value of the wrong type for the current operation.
#######################################
Date = 3/20/2013
cmdStoredProc.parameters.append cmdStoredProc.createparameter("@MDate",135,1,0,Date) ' no work
ERROR MESSAGE - Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query.
#################################
strDate=20130320
cmdStoredProc.parameters.append cmdStoredProc.createparameter("@MDate",133,1,0,Date) ' no work
ERROR MESSAGE - Application uses a value of the wrong type for the current operation.
################################
Iim so pissed I just want to spit!
Here is my latest nightmare.
##################################
date = 2/20/2013
cmdStoredProc.parameters.append cmdStoredProc.createparameter("@MDate",7,1,0,Date) ' no work
ERROR MESSAGE - Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query.
so changed date valued to : 20130320
ERROR MESSAGE - Application uses a value of the wrong type for the current operation.
#######################################
Date = 3/20/2013
cmdStoredProc.parameters.append cmdStoredProc.createparameter("@MDate",135,1,0,Date) ' no work
ERROR MESSAGE - Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query.
#################################
strDate=20130320
cmdStoredProc.parameters.append cmdStoredProc.createparameter("@MDate",133,1,0,Date) ' no work
ERROR MESSAGE - Application uses a value of the wrong type for the current operation.
################################
Iim so pissed I just want to spit!