Member Avatar

Hi, I have a data, employee attendance record with following format > 01-0002,I,4/21/2014,07:34:00 01-0002,O,4/21/2014,18:09:00 01-0002,I,4/22/2014,07:47:00 01-0002,O,4/22/2014,18:09:00 01-0002,I,4/23/2014,07:54:00 01-0002,O,4/23/2014,18:07:00 where I is in and O is out The table contains lots of records for this saves records from the start how can i search a record with no In or no Out from the date range specified? I need to create a report for those employees with no In but with Out, or with In but no Out. Another report needs to generate percentage of lates (individually or all) For now this is the query I used but no luck query …

Member Avatar
0
23
Member Avatar

Ok so im working on a script that reads a large file then splits it up into seperate files using the field in it called PC Number. What im wanting to do is check if the file already exist if it does then it just appends the new data but if it doesnt it writes a new file with headers and everything. If there is a simple way to do this i would b greatly appriciated to know how to do it cause so far its got me really confused. Below is the the code that im useing to read …

Member Avatar
0
70
Member Avatar

Hi Guys, is there a Code snippet which allows me to check if a certian ADO Connection has been setup on a clients Local machine and if not then disable certian Radio buttons? The reason I ask is I have a 'Read-Only' Connection to a DB (Don't ask.. that's all the 3rd Party will give us access to). Some of the local machines will not have the program installed (hence the ADO connection won't exisit) Any adivce would be great. Kind regards Mark.

Member Avatar
0
22
Member Avatar

Alright guys, I've been looking at this on google and I can't seem to find an answer. Any help is definitely appreciated! Here is the code, then I will explain my problem. void printMenu() { cout<<"||============================||"<<endl; cout<<"||=========Main Menu==========||"<<endl; cout<<"||===1.Begin DNA Creation"; cout<<"||===2.Load the Files"; if(!dna1[].strand1){ cout<<"<0>";} else{ cout<<"<"<<sizeof(dna1.strand1)<<">";} cout<<endl; cout<<"=========||"<<endl; cout<<"||===3.Save the Files=========||"<<endl; cout<<"||===4.Exit===================||"<<endl; cout<<"||============================||"<<endl; cout<<"||===Enter a Choice <1-4>: "; } Now I'm assuming that my variable dna1 in the structure I created "dna" would behave like any other array and I won't need to pass it over. If this is incorrect then thanks for the heads up. Basically this …

Member Avatar
0
9
Member Avatar

when user login it will check if user exist in database or not what is wrong with this code Dim a As New System.Data.DataView Dim b As New System.Web.UI.DataSourceSelectArguments Dim usname As String Dim password As String SqlDataSource1.SelectCommand = " select usname , password from userinfo " a = SqlDataSource1.Select(b) If ( usname == textbox1.Text & password == textbox2.Text ) Response.Redirect("fill.aspx") Else Label8.Text = "not valid" End If

Member Avatar
0
15
Member Avatar

so i have a form with 4 textbox; idnum, lname, fname, dept 1 button i need help about when I type in the idnum.Text there will be results based on the database table (ms access)and auto fill lname.Text... and if it doesn't exist there'll be a prompt.

Member Avatar
0
6
Member Avatar

Hi I have a folder containing a lot of shortcuts so i need to check if the shortcuts paths exist Thank you

Member Avatar
0
2

The End.