无法正确格式化日期字段 [英] Cannot get to format the date field correctly yet
问题描述
我无法在动态sql语句中正确获取日期格式,之后
尝试各种方式处理它。我需要一些关于日期格式的帮助
以下动态sql语句。提前感谢任何帮助。
运行asp页面时,我仍然收到错误
错误类型:
Microsoft VBScript运行时( 0x800A000D)
类型不匹配:''格式''
DYNAMIC SQL语句:
sql =" INSERT INTO tblExpense(ENO,EntryDate,ContractedServiceExpense,"
sql = sql&" TravelExpense,PersonnelExpense)"
sql = sql& " VALUES(''"& l_ENO&"''','& Format(l_Date,
" \#mm \ / dd \ / yyyy \#" ;&","& l_contractedserviceexpense&","
& l_travelexpense&","& l_personnelexpense&")"
您的格式化功能是什么样的?你用什么样的数据库?
使用?
看看这里的功能。 http://www.aspfaq.com/show.asp?id= 2313
Ray在工作
" Jack" < JA ** @ discussions.microsoft.com>在留言中写道
news:62 ********************************** @ microsof t.com ...
在尝试各种处理方式后,我无法在动态sql语句中正确获取日期格式。我在以下动态sql语句中需要一些日期格式
的帮助。提前感谢任何帮助。
运行asp页面时,我仍然收到错误
错误类型:
Microsoft VBScript运行时(0x800A000D)
类型不匹配:''格式''
DYNAMIC SQL语句:
sql =" INSERT INTO tblExpense(ENO,EntryDate,ContractedServiceExpense,
" sql = sql&" TravelExpense,PersonnelExpense)"
sql = sql& " VALUES(''"& l_ENO&"'',&& Format(l_Date,
" \#mm \ / dd \ / yyyy \#")& ","& l_contractedserviceexpense&","
& l_travelexpense&","& l_personnelexpense&")"
>
VBScript中没有格式,抱歉。请停止使用模糊的
格式,如mm / dd / yyyy。 http://www.aspfaq.com/2023
>
-
请发布DDL,样本数据和所需结果。
参见 http://www.aspfaq.com/5006 获取信息。
" Jack" < JA ** @ discussions.microsoft.com>在留言中写道
news:62 ********************************** @ microsof t.com ...
在尝试各种处理方式后,我无法在动态sql语句中正确获取日期格式。我在以下动态sql语句中需要一些日期格式
的帮助。提前感谢任何帮助。
运行asp页面时,我仍然收到错误
错误类型:
Microsoft VBScript运行时(0x800A000D)
类型不匹配:''格式''
DYNAMIC SQL语句:
sql =" INSERT INTO tblExpense(ENO,EntryDate,ContractedServiceExpense,
" sql = sql&" TravelExpense,PersonnelExpense)"
sql = sql& " VALUES(''"& l_ENO&"'',&& Format(l_Date,
" \#mm \ / dd \ / yyyy \#")& ","& l_contractedserviceexpense&","
& l_travelexpense&","& l_personnelexpense&")"
>
Ray,
我在后端使用访问权限。我的问题是弄清楚如何操作日期变量
,以便response.write sql返回日期为
#10/01/2005#。我现在得到它的方式,它不允许response.write
语句工作。此时我并不关心任何日期格式,而是通过在日期中添加分隔符来使sql语句正常工作。
谢谢。问候。
" Jack"写道:
在尝试各种处理方式后,我无法在动态sql语句中正确获取日期格式。我需要一些关于日期格式的帮助,以下是动态的sql语句。提前感谢任何帮助。
运行asp页面时,我仍然收到错误
错误类型:
Microsoft VBScript运行时(0x800A000D)
类型不匹配:''格式''
DYNAMIC SQL语句:
sql =" INSERT INTO tblExpense(ENO,EntryDate,ContractedServiceExpense,"
sql = sql&" TravelExpense,PersonnelExpense)"
sql = sql& " VALUES(''"& l_ENO&"'',&& Format(l_Date,
" \#mm \ / dd \ / yyyy \#")& ","& l_contractedserviceexpense&","
& l_travelexpense&","& l_personnelexpense&")"
>
Hi,
I cannot get the date format correctly in dynamic sql statement, after
trying various ways of handling it. I need some help with the date format in
the following dynamic sql statement. Any help is appreciated in advance.
While running the asp page, I still get an error as
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: ''Format''
DYNAMIC SQL STATEMENT:
sql = " INSERT INTO tblExpense (ENO, EntryDate, ContractedServiceExpense, "
sql = sql & "TravelExpense, PersonnelExpense)"
sql = sql & " VALUES(''" & l_ENO & "'', " & Format(l_Date,
"\#mm\/dd\/yyyy\#") & ", " & l_contractedserviceexpense & ", "
&l_travelexpense & ", " &l_personnelexpense & ")"
What does your format function look like? What kind of database are you
using?
Take a look at the functions here. http://www.aspfaq.com/show.asp?id=2313
Ray at work
"Jack" <Ja**@discussions.microsoft.com> wrote in message
news:62**********************************@microsof t.com...Hi,
I cannot get the date format correctly in dynamic sql statement, after
trying various ways of handling it. I need some help with the date format in the following dynamic sql statement. Any help is appreciated in advance.
While running the asp page, I still get an error as
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: ''Format''
DYNAMIC SQL STATEMENT:
sql = " INSERT INTO tblExpense (ENO, EntryDate, ContractedServiceExpense, " sql = sql & "TravelExpense, PersonnelExpense)"
sql = sql & " VALUES(''" & l_ENO & "'', " & Format(l_Date,
"\#mm\/dd\/yyyy\#") & ", " & l_contractedserviceexpense & ", "
&l_travelexpense & ", " &l_personnelexpense & ")"
There is no Format in VBScript, sorry. And please stop using ambiguous
formats like mm/dd/yyyy. http://www.aspfaq.com/2023
--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Jack" <Ja**@discussions.microsoft.com> wrote in message
news:62**********************************@microsof t.com...Hi,
I cannot get the date format correctly in dynamic sql statement, after
trying various ways of handling it. I need some help with the date format in the following dynamic sql statement. Any help is appreciated in advance.
While running the asp page, I still get an error as
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: ''Format''
DYNAMIC SQL STATEMENT:
sql = " INSERT INTO tblExpense (ENO, EntryDate, ContractedServiceExpense, " sql = sql & "TravelExpense, PersonnelExpense)"
sql = sql & " VALUES(''" & l_ENO & "'', " & Format(l_Date,
"\#mm\/dd\/yyyy\#") & ", " & l_contractedserviceexpense & ", "
&l_travelexpense & ", " &l_personnelexpense & ")"
Ray,
I am using access in the backend. My problem is figure out how to manipulate
the date variable so that a response.write sql throws back date as
#10/01/2005#. The way I got it now, it does not allow the response.write
statement to work. At this point I do not care about any date format, rather
the sql statement to work properly by adding the delimiters to the date.
Thanks. Regards.
"Jack" wrote:
Hi,
I cannot get the date format correctly in dynamic sql statement, after
trying various ways of handling it. I need some help with the date format in
the following dynamic sql statement. Any help is appreciated in advance.
While running the asp page, I still get an error as
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: ''Format''
DYNAMIC SQL STATEMENT:
sql = " INSERT INTO tblExpense (ENO, EntryDate, ContractedServiceExpense, "
sql = sql & "TravelExpense, PersonnelExpense)"
sql = sql & " VALUES(''" & l_ENO & "'', " & Format(l_Date,
"\#mm\/dd\/yyyy\#") & ", " & l_contractedserviceexpense & ", "
&l_travelexpense & ", " &l_personnelexpense & ")"
这篇关于无法正确格式化日期字段的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!