hai all, i have 2 time variables in my table: eg: intime --->9:00 Am outtime --->6:00 Pm Now i need to calculate the totalhours=outtime-intime (in Asp) how to...
Are these datetime data type fields in SQL Server, or a string datatype? If they're datetime, then you can either use the T-SQL DATEDIFF function like so :- ...
Hello, I have to develop an application has several departments, several users in those departments. some of those users can see other department's pages. How...
From a database point of view, probably the easiest way to do this is using 3 tables:- tblDepartments ... ID strDeptName tblUsers ... ID strUserName ...
just do some modifications, Is it right? for FRst=0 to Rcount For SEcnd=FRst+1 to Rcount if (rs(0)=SName) then response.write "Same Records" response.write...
You have two loops which appear to be unnecessary and can be taken out. So your code coule be :- While not rs.EOF if rs(0)=SName then response.write "Same...
I am trying to upload file attachment using Persits. Whenever I do try it the system return the following error: The system cannot find the file specified. the...
When somebody logs in you find what department they are from (and a field in your user table). Using that, you can then look up in a table that tells you what...
This is confusing because you are looping through the recordset three times. Personally something like this should be better: gr = rs.GetRows ' converts rs to...
thanks for your explanation. Can you give some sample code so that it may give me an idea. Thanks! Andrew Thorne <ahjt65@...> wrote: When somebody logs...
That looks okay top me. Have you checked what the input on your FORM is? ... _________________________________________________________________ Free blogging...
Here goes: In your database Department table deptID deptName User table userID userName userDept DepartmentCrossLinks table xlDept1 xlDept2 In your asp pages,...
Hi Andrew thanks for your reply. I did check that and it looks fine to me too. So I did try to shrink down the code to make it simple and I've also tryed the...
put the the record in a variable and then compare it to the next record returned. for ... If var = rs('cnd") Then response.write "Same Records" else ...
Hello, We have an ASP application. We are getting the HTTP Error: 404 File intermittently. How to fix and prevent this. Thanks. Related info: Windows is 2000...
Hello all, I posted this in forums.aspfree group also but have not got a response yet - there have been around 20 persons who read it but no responses. I am...
Hai all, in my project i have a Table in the following format, User id Time In Out Link 1 9:00 am 1/12/2006 9:00 am 0 7 1 6:00 pm 1/12/2006 0 6:00 pm 8 1...
hello, i can't run my ASP document in the Internet. There is alway an error in connecting ASP to IIS server. pls help me on how to connect ASP to IIS server. i...
Can you tell us what's happening (i.e. what the error is) and what version of IIS you're running, or what the OS is? Dan ________________________________ From:...
Hello Friends i have a problem that. With type attribute of input tag set to "file" in HTML, we compulsorily need to browse till the level of files. How can we...
For user security reasons the file input element is designed in such a way that you can't manipulate it by server-side code other than reading the value when...
Hello all, Again, I posted this query to the other message board and found no answers forthcoming. Is there any way in which the Description of the Table can...
Which database are you talking about ? SQL server has a lot of meta data stored in system tables. exactly what are you looking for ?? column names, types,...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
