I am having an issue with displaying information properly for reporting.
This is the structure of the raw data in the Table FTB_MHF
DateandTime TagIndex Val
9/1/2013 00:31:15 AM 129 6.2
9/1/2013 00:33:15 AM 130 0
9/1/2013 00:33:15 AM 131 1
9/1/2013 01:33:15 AM 132 0...
I have data logged that I need to average per hour between a date range and I am clueless where to start. I am using Microsoft SQL Server 2000 to access old data...
table name = ftb_analogs
fields:
DateandTime as datetime
tag as smallint
val as float
I am trying to grab data between July 1...
Hi,
I currently use Veritas Backup Exec 8.6 with SQL 2000 Agent. I have a SQL database over 30 gigs in size and get an error that says
"Connection to the restore target has been lost. Operation Canceled"
I have restored other databases from the same tape using the SQL redirect option and...
Hi,
I currently have 2 Domain controllers that run windows 2000 server. I am trying to figure out if installing a new windows 2008 server(standard) and adding it to my domain will limit my sharepoint possibilities? I am reading about upgrading the rest of my domain to a 2008 AD and this seems...
I have SQL data and I know how to pull it in from my code behind pages in VB. I am just a little confused how to stick it in my page for viewing. I was adding lots of labels on my page and writing data that way but the page load was soo slow. now i want to write some extra html data too from...
Hi,
I am trying to get a setup configured that involves placing 1 PC in an office that has a DVI Widescreen Monotor, USB Keyboard, and USB Mouse... I want to run 2 extra USB Keyboard and Mouse to about 50 feet in another room. How can I mirror the display so if i am in the other room with the...
Hi,
Is there a way to print a header on every page. I have 5 GridViews populated with data that create about 11+ pages. Only the first page has the titles of each column. How can I print the titles on each page? I am binding 5 gridviews to Sqldatasource.
Thanks
Hi,
I am lost again in SQL programming...
Last year I posted this question
http://www.tek-tips.com/viewthread.cfm?qid=1499691&page=1
I am now trying to take the days I have rain logged from this query GMMastros gave me...
SELECT FTBL_RainGauge.DateAndTime, ROUND(FTBL_RainGauge.Val, 3) AS...
Hi,
I am trying to use a yahoo search box and open the search results in a new window. I'm having some difficulty understanding how to use variables between my function and my form. can some one tell me what I am doing wrong?
Thanks
<%@ Page Language="VB" AutoEventWireup="false"...
I am looking for the best way to backup and remove old data.
I have a large SQL database that is over 90gigs.
I am using SQL Server 2000.
I have years of data that I want to back up and remove from the original database to free up space and hopefully improve performance. I have information...
Having a problem...
I have a Bound DropDownList to a SQL table, when selectedindex is changed it is suppose to update the text boxes and labels in the update panel. It is working but the page is still refreshing? This latest code, I tried to move the Dropdownlist out of the Update Panel to see...
I am having a hard time opening a new page from a button click. I have 2 calendar controls to get 2 dates before i parse a report on another asp page. I display these dates in 2 labels to the user.
when you select the date from the 2 calendar controls and press the button. I set the...
Please help.
I have rain gauges that record how much rain fall is in any give time in my city. The tools that record the data in SQL sever record every minute for charting purposes, weather there is rain or not.
I am not good at writing SQL queries other then normal select,insert,delete, &...
I am using a Text box to gather a Date from a User. I use this information to parse a sql statement for more data. Unfortunately when a user enters a date like
5/5/08
I get a
Syntax error converting datetime from character string.
but when i enter
5/5/2008 it works?
is there anyway...
Hello,
I am having issues updating fields I edit in my gridview. When I try to edit a field and click update, my edits to not update to SQL Server? They revert back to the old data... I was getting an error that said I needed to use DataKeyNames for updating. I have since added it with my...
I have a search button to apply the search variables for text boxes and dropdownlists & textboxes.
I have an original posting in the VB.net 2005 forum here...
http://www.tek-tips.com/viewthread.cfm?qid=1463563&page=1
upon clicking the search button...
Protected Sub btnSearch_Click...
I am confused...
I am making an error list tool to consolidate fixes for computer issues for my job.
I am trying to make an asp.net page to search multiple fields.
I have a tblError
SoftwareID
ErrorDescription
EventID
ErrorCode
The problem is I want to be able to search 1 field, or all 4 at...
Hi,
I have a treeview populated like so...
Node01
subNode01
subsubnode01
subsubnode02
subnode02
subnode03
Node02
Subnode01
Subnode02
I am trying to select a node and get the entire treelist location of that node. For instance, if you clicked subsubnode02 then how...
I am making a work order system for my computer work...
I have several tables
TBLJob
JobID (Autoincriment)
ComputerID (Relationship to TBLComputer.ComputerID)
UserID (Relationship to TblUser.UserID)
SoftwareID (Relationship to TBLSoftware.SoftwareID)
ErrorID...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.