I have a log table.
I want to get record of latest date. Meaning if 1-May-2008 13:32:22 and 1-May-2008 2:22:21, it will retrieve 1-May-2008 13:32:22 as a result.
how the statement should be?
thaanks in advanced.
SunshineInTheRain
Last Activity: Nov 18 '08, 05:37 AM
Joined: Jan 28 '08
Location:
-
get latest date record
-
Appreciating your reply.
That mean there has no way to do like server.mappath in asp.net? which we know only the file name, then get the path from mappath. -
mapping path of a file
Hi all,
I am using "master..xp_get filedetails @path" method to get file details.
I am not sure, maybe the @path must in this format "C:\TestFolder\ SubFolder\TestF ile.pdf" only can work, because i get error of "xp_getfiledeta ils() returned error 3, 'The system cannot find the path specified.'".
So if it is true, the @path i have now is in this format : "../../../../../TestFolder/SubFolder/TestFile.pdf".... -
copy filtered datarow to datatable's datarow
...Code:Dim dtUn As DataTable dtUn= New DataTable dtUn = BindICUN() Dim i As Integer Dim irow As DataRow Dim mailBody As String = "" Dim myRow As DataRow Dim rowSet As DataRow() rowSet = dtUn.Select("Distinct Member_id is not null") Dim dt As DataTable dt = New DataTable -
thanks for help. i ever use this solution for my previous ajax website that located in server with window server 2003 and it work well.
But this time, i use the same method, it doesn't work. this time my project is on window server 2000.
I suspect is it the visual studio 2005 did not installed in this server may causes this issue, anyone can answer me? or give me other solution?
I cannot simply install...Leave a comment:
-
ok. thanks very much....Leave a comment:
-
Yes, it is javascript error. But I did not put any javascript actually. It is caused by ajax setting as i guess....Leave a comment:
-
'Sys' is undefined error
can anyone please help me on problem of 'Sys' is undefined error? I know a lot forum has discussed about this, but none i success to solve the error.
I have run it on Window server 2000, IIS 5, Ajax extension 1.0 Installed, Just newly install .net Framework 2.0 where .net framework 1.0 are still using at the same time. The root application are using version 2.0.
when create website from vs.net2005 and compile, does not... -
master page affect firefox get the ID of parent's iframe
My project has 3 files,
File1 has included master page.
file1 consists of iframe1 that load file2.
File2 consists of iframe2 that load file3.
Javascript used on each file to resize the iframe height based on the each iframe's content height.
It is work well on IE, but the error "has no properties" occured with firefox on code as below. Where both code is to get the id of iframe on file1.
parent.document .getElementById ("file1iFrame") .height... -
SunshineInTheRain started a topic mouseover function not work on firefox with dynamic created dropdown menuin Javascriptmouseover function not work on firefox with dynamic created dropdown menu
The following code is dynamic create dropdownmenu which data within pulled from database
However, the code work well on IE but not on Firefox. On Firefox, the whole mouseover and mouseout function din't work. what is not supported on Firefox? the javascript syntax? please help as i am not familiar with javascript. thanks in advanced. this is quite urgent.... please..
By the way hope there has somebody may help me find out why... -
problem of Firefox support for resize iframe's height javascript
Hi everyone, anyone please kindly help me check out the javascript below? The code run well for IE but do not work on firefox. while on firefox, it promt error of "obj has no properties". I think it may be the syntax that not supported on firefox, but i do not know what the syntax suppose for firefox. Could anyone expert in javascript lend me a hand? Thanks in advance, this is quite urgent...please help!
... -
SunshineInTheRain started a topic Active Directory logonuser API cannot work with correct login detailsin .NETActive Directory logonuser API cannot work with correct login details
I have 2 servers, server1(window server 2003) and server2(window server 2000). The LogonUser work on server1 but show error code 1326 (which mean bad userName or Password) on server2 with both same and correct login detail on same application. ASPNET account has been set in "Act as part of the operating system" too. what else reason that may cause such error? I had "ping" the server2, it show server2.OneName .com, is it mean that... -
Yes, I'm doing and a lot, however problem solved. Appreciating your kindness to help and thank you for your reply....Leave a comment:
-
VB-WEB:The SqlCommand is currently busy Open, Fetching.
I'm trying to modify a long long code within a button click by make the insert/update/delete/select using the same transaction. Purpose is to make sure every operation can be rollback instead of some table inserted but some not. But I get this error:
The SqlCommand is currently busy Open, Fetching.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for...Last edited by SunshineInTheRain; Jan 28 '08, 02:58 AM. Reason: make the post title more clarity of what language it used
No activity results to display
Leave a comment: