gosql.exec error

[jingc1413]

hi gosql.exec 不支持字段内容为空吗？

currTime := time.Now().Format("2006-01-02 15:04:05")
			_, err := gosql.Exec("update man_Task set tsk_state = %d, tsk_lasttime = '%s', tsk_nexttime = '%s' where tsk_Taskid= %d",
				TASKRUNING_STATE, currTime, "", 12)

把SQL 格式化后就可以正常执行

szSql := fmt.Sprintf("update man_Task set tsk_state = %d, tsk_lasttime = '%s', tsk_nexttime = '%s' where tsk_Taskid= %d",
				TASKRUNING_STATE, currTime, “”, 12)
		_, err := gosql.Exec(szSql)
		这里可以正常执行

[fifsky]

currTime := time.Now().Format("2006-01-02 15:04:05")
			_, err := gosql.Exec("update man_Task set tsk_state = ?, tsk_lasttime = ?, tsk_nexttime = ? where tsk_Taskid=?",
				TASKRUNING_STATE, currTime, "", 12)

[jingc1413]

currTime := time.Now().Format("2006-01-02 15:04:05")
			_, err := gosql.Exec("update man_Task set tsk_state = ?, tsk_lasttime = ?, tsk_nexttime = ? where tsk_Taskid=?",
				TASKRUNING_STATE, currTime, "", 12)

多谢，确实这样