btintermedia
asked on
Proper formatting/need for cfqueryparam w/CF_SQL_TIMESTAMP & TimeFormat
I am getting the following error:
The error occurred in E:\CustomerData\webspaces\
Called from E:\CustomerData\webspaces\
Called from E:\CustomerData\webspaces\
Called from E:\CustomerData\webspaces\
Called from E:\CustomerData\webspaces\
810 : <cfqueryparam cfsqltype="cf_sql_integer"
811 : <cfqueryparam cfsqltype="CF_SQL_TIMESTAM
812 : <cfqueryparam cfsqltype="CF_SQL_TIMESTAM
813 : SELECT @@Identity AS MusicID
814 :
do I even need to be using the cfqueryparam?
The dateformat(now() seems to be working but not the TimeFormat(Now()
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for you help