Search results for query: *

I have a SP that gets data from parameters in Asp.net the .net form passes data from an excel spreadsheet. This all works except that when it inserts any of the fields that contain numbers they end up in sql looking like 9.37123e+009 or 4.581e+008 I have tried cast and convert to no avail. The...

I have an encrypted page that had a detailsview to insert data. Problem it the page only works half the time for some reason. I have a click event that inserts data via a sql datasource. It used to work great I have it set to do a response direct to another page when it is done inserting. Now...

Ok I am new to javascript, saying I know almost nothing about to would be accurate. My site is set up with the javascript from google so I can track web traffic to my site. I have this code on all my pages to monitor my site. Except I want to know how often the mp3 files on my site are...

Asp.net 1.1 I am trying to create a contact form with asp.net 1.1 page and a vb code behind. when i reference a control in my vb code it acts as if it does not know what controls i am referencing I get "Name 'txtFrom' is not declared" I get this for any aspx control I call in my vb code. Here...

I have report viewer on an asp.net 2.0 page with a Sql report from sql 2005 embedded in the report viewer. I thought I could just put report parameter in the query string and it would just pass the parameter to the report but that did not work. For instance I have a report the has a...

I have a report with some hidden fields, the report spans the hidden field to another page. The data is hidden, but it still shows the page as if data were there. I can you supress blank pages in a Sql 2005 report? Thanks

I set up IIS client certificates for an internal site in IIS. From IE I went to the sitename/certsrv page requested the certificate, then I issued the cert from the server. Went back to IE installed the issued client cert and it worked just fine. I then exported the cert to a p7b file and tried...

My laptop keeps giving me blue screen of death when it tries to boot into windows 2000. The windows 2000 start up screen comes up and the blue progress bar shows progress then it shows the BSOD and reboots. I see the BSOD, but it reboots so fast I have no idea what the error message is. I...

Is there a way to disable error checking when creating a Stored Procedure in SQL 2005 or when a particular SP is run? I keep getting Operand type clash: varbinary(max) is incompatible with float My SP exec another SP that changes the column type of the column from VarBin to VarChar. Then...

I have a Sql 2005 Table that has an encrypted field by Asymmetric encryption. Data is imported to this table via an Access DB. That data has sensitive data that is not encrypted. in order to properly import the data the Stored Procedure in Sql checks for Sensitive (unencrypted) data in the...

I have 2 problems that are related 1st problem: I am trying to pull data from an excel spreadsheet IF i just execute the query with no where statement it runs fine if i use where fieldname is null it works, but if i try to i use a specific date on the check date field i just get Data type...

ASP.Net 2.0 I have a asp menu control that has dynamic links depending on the value of the EMPID For instance if a employee record also has a 'HID' then the menu would be something like Health and the navigate url value would be like health.aspx?empid=509 i also change the text value depending...

I am trying to export remotes from pc anywhere 10.5 into a pc anywhere 9. I read some articles on symantec site that said to export some registry keys even mentioned that it would work going from 10.5 to 9. I tried that to no avail. It doesn't even look like those keys held any pertinent...

ASP.NET 2.0 and SQL 2005 I have a stored procedure that is the datasource for a form. This form allows new employees to be entered etc. Once this data is inserted I want to redirect the user to that employees page based on the ID. I know how to do something like...

I have a page that has a GridView and Details view on it. the detailsview is only used for Inserting, thus my default mode is set to insert. I created a VB Sub that populates some of the detailsview fields with data from the gridview. All that works great when the page is first loaded, once...

I have a date field that is stored as an INT (yes an INT) I hate it,it's a 3rd party db. IT stores the date the same way some unix systems do. IT stores the number of seconds since the epoch, or 1 January 1970. I am able to convert the int to date, but the time is off. It is actually ahead by...

I want to combine all the results for the areacodes into one column for each user. like a csv. I want the count of the top 5 for each particular name. I know how to get that, I don't know how to get it to display in one column I tried reading a few articles on putting multiple colums in one...

How can I subtract one day from getdate() without it returning the time? If i do select DateAdd(dayofyear,-1,GetDate()) then it goes back exactly 24 hours how can i get it to just go back one date and then I would do a where clause to compare that to another date whose time is all 00:00:00.000...

I am trying to do a group by that will give me the top 5 sales items for each sales man on each date. I know if i do something like select date,salesman,salesitems,Numberofitemssold group by date,salesman,salesitem,Numberofitemssold it will give me all of the items sold by everysales men I...

I have a page that imports data from an excel file it works great if none of the columns in excel are null, but if one column is null is throws the specified cast is not valid error. I tried doing If Not (rdr.GetString(1)= DbNull.Value.ToString()) then...