helo like what i said the code above is a syntax of a wonderware software which is a Automation software but the logic is the same in vb. i just wan't to hear from you some suggestion for the logic of getting the shift in the given time.
Thank you....
klaydze
Last Activity: Feb 8 '08, 12:19 AM
Joined: Mar 30 '07
Location:
-
Calculate Time
hi everyone, i know this is easy to others but i'm going to explode now to this. the scenario is this. i would like to trace where the time is equivalent to 1st Shift, 2nd Shift and 3rd Shift where 1st Shift = 6AM - 2PM, 2nd Shift = 2PM - 10PM and the 3rd Shift = 10PM - 6AM..
i would like to trace the shift by the time format 12HR not 24HR format. i done this using 24HR but i want to change it to 12HR. The logic i made is this, i will... -
Building SQL Connection in C#.Net 2005
hi, i am a VB.Net user and i want to try C#.Net 2005. i'm converting some of my project done in vb.net to c#.net but i dont know how to start working in sql server 2000. is there someone who can help me building a Sql Connection in C#.Net and im using SQL Server 2000.
Thank You. -
Hi, if you mean searching for specific words in your database, just use LIKE to filter the word you want. Ex. if you have a item_code 101 to 110, if you type the 101 item code then your listview will automatically generate the result.
CODE OF TEXTBOX:
...Code:SELECT item_code FROM Table1 WHERE item_code LIKE '%" & txtFilter.text & "%' [I]'Put your code here to view the record in your listview[/I]
Last edited by Killer42; Dec 18 '07, 04:30 AM.Leave a comment:
-
If you mean searching using a Textbox and if you type a letter from the textbox your listview will give you automatic output. ex. if you type letter "a" from textbox then your query will execute and search all the words that have letter "a" in your database.
Example
...Code:SELECT item_code FROM tbl_inventory WHERE item_code LIKE '%" & txtsearch.text & "%'
Last edited by Killer42; Dec 18 '07, 04:30 AM.Leave a comment:
-
still it gives me this error Warning: Cannot modify header information - headers already sent by (output started at C:\kamote\Hello Database2.php:6 ) in C:\kamote\Hello Database2.php on line 65
other way to fixed this? thank you...Leave a comment:
-
Page Redirecting Problem
hi guyz, i have a difficulty in understanding the header function. they said that you must first call the header function before any output on the page will make?is that right?
because i create a simple login which when the user click the button submit the query for searching of registered user will execute and will redirect to index.php.after i click the submit here is the error that give's me Warning: Cannot modify header information... -
This is the complete code of the page
[html]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title></title>
<meta content="Micros oft Visual Studio .NET 7.1" name="GENERATOR ">
<meta content="http://schemas.microso ft.com/intellisense/ie5" name="vs_target Schema">...Leave a comment:
-
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
that is the default DOCTYPE when i create my page. yes i validated my css and i think theres no problem with my css. how can i validate my html since it gives me good output in firefox....Leave a comment:
-
i use this DOCTYPE
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd"> and the output was change in IE but in Firefox is the same which is good. i try all the DOCTYPE in that article and i get the same output in IE like the picture below. the problem now is they have space in the bottom of each link. i validate again my CSS and still no effect with that. any other idea...Leave a comment:
-
Is this possible in SQL Server 2000 and MySQL?
hi guys, is it possible that i can retrieve records from different database like SQL Server 2000 and MySQL?
example, assuming i have some table in SQL Server 2000 and i also have in MySQL. the table in SQL Server 2000 is for example Table1 and in MySQL is Table2.
if i create a query that will combine and retrieve the fields of the two database, is it possible?
if so anyone who have idea with that and how to do that?
... -
THIS IS THE COMPLETE CODE OF MY HTML
[html]
<html>
<head>
<title></title>
<meta content="Micros oft Visual Studio .NET 7.1" name="GENERATOR ">
<meta content="http://schemas.microso ft.com/intellisense/ie5" name="vs_target Schema">
<link href=CSS/homepageCSS.css rel=stylesheet type=text/css>
</head>...Leave a comment:
-
i am using Top Style Pro 3 for CSS. sometimes i also use it for HTML....Leave a comment:
-
Problem viewing in IE and Firefox
hi guys, i design a sample website and i think it looks cool to me. i browse my sample website in firefox and run it normally as i want. but when i open it in IE the design change. they said that there have some script to fixed that. anyone who can help me with my problem.Thank you.
i attach the picture what is the output in Firefox and IE.
this picture is in IE.
this picture is in firefox... -
try this one.
HTML CODE:
<div id=leftcolumn>
<p>The content of your left column</p>
</div>
<div id=rightcolumn>
<p>The content of your right column</p>
</div>
CSS CODE:
#leftcolumn, #rightcolumn
{
float: left;
width: 100px; *** this is the width of your left and right column...Leave a comment:
-
Navigation Menu
hi, i am creating a simple website and i want to create a menu just like the other website that i see.. ok this is what i want in my menu.. i have a menu namely HOME, LIBRARY, LEARN, DOWNLOAD, SUPPORT, COMMUNITY. and in the menu LEARN i have a sub menu VB.Net, ASP.Net, C#, MSSQL Server. and i have also a sub menu in DOWNLOAD which is Sample Program, Sample Code.
what i want is when i put my mouse in the LEARN menu it will show its... -
Starting in ASP
hi, im only a beginner in doing a web. im creating a simple filemaintenance just like in VB. i have my design now. i've create a function as you can see below. i put the function inside <INPUT....... onClick='btnLog Inclick()'> and its gives me an annoying output. theres no output in that code. can any give me a piece of advice. thx
<script language=VBScri pt>
function btnLogInclick()
Dim StrAuthUser,Str UserName... -
hi, try this one. assuming that i put the value of the date in textbox
txtdate.text=fo rmat(Now.AddDay s(7),"MM/dd/yyyy")...Leave a comment:
-
Uploading Image File Using Open File Dialog
hi, i don't know how to start my code in uploading an image using open file dialog control. any one who can help me? i want to view the picture that i want to upload using open file dialog and show it in Picturebox. Any one can help me with this. thanks in advance -
my idea with your question is, you can base it to the time when you save your record. you have a column for the time then make a line of query to validate all your records. thats my idea. hehe...Leave a comment:
No activity results to display
Leave a comment: