Search results for query: *

I am trying to get a count of entries per month. The date created field is the field that holds the date of an entry. When i run the below query it only gives me data from one day for each month, it does not iterate through the whole month. How can i have it so it will give me the total count...

I have a stored procedure that gets the month name and the number of items for that month from a table. I get all that fine however I cannot get it to orderby or group by the date name properly. it sorts it by the actually name instead of the order of the month. ie july is sorted before june...

I am having a brain cramp as i have done this several times in the past. I want to run multiple queries just one after another. I either get ERROR at line 1: ORA-00911: invalid character if i have ; to end line one, or if i remove ; from line 1 i get sql command not properly ended properly. I...

I am trying to set up themes in ASP.Net 2.0 I set up an page load event that grabs the themes by checking the app_themes folder. Added some events for my dropdown list. There are 2 issues i am having 1. When i choose a theme from my dropdown it changes my themes. However when I choose the theme...

For asp.net 2.0 I have a gridview with two hyperlink fields. I want to execute different events depending on which of the hyperlink columns is clicked. The only event I can get for this is gridview selected index changed. I want to call an event depending on which hyperlink column is clicked not...

I have 3 tables Albums, Photos, Videos The albums table is related to the videos table by the albumid in the video table. The album table is also related to the photo table by the albumid field. I want to get the count of the videoid's that are related to the albumid and also a seperate...

I want to have a bound button that will show some text and the row value on the button. It would say click here to view The field name. I tried a few variations of the below code with + sumbol and the &. I am using .net 2 but i guess it would be at least similar to .net 1.1 I am doing this in...

I am using ASP.Net 2.0 I want my code to look at each control i have, find the data in the control, and then insert it to a DB. This works, except I have only got it to work with a for each loop, which i don't want. Of course this inserts the same data 9 times which is how many rows I have...

I want my code to look at each control i have, find the data in the control, and then insert it to a DB. This works, except I have only got it to work with a for each loop, which i don't want. Of course this inserts the same data 9 times which is how many rows I have. which i don't want If I...

I need to spool a query to a unc path on a different domain than my oracle db is on. Normally if i was going to spool to a folder i would not need to have username since it would be on the same domain. where can i add domain\user name and password to spool? normally i would do this spool...

I have a scheduled job that runs a query and spools the sql file to a folder on another server. They are getting a new server that they want me to spool this file too, and moving it to a different domain than what my server is on. I have a user name for that domain for the purposes of this...

Ok I have an Dell Inspiron 9100. None of my usb ports are working now, however they are all recognized in device manager. When i plug in a device nothing happens . The only thing i have noticed is when i plug in my usb flash drive it lights up for a split second, but still is not seen by my pc...

I am trying to supress a section if the previous result was the same. We have main workorders that have sub workorders to them all of the sub workorders relate back to one main workorder. I want the main workorder to only show up once in the report and all the sub orders after. I have it working...

I want to create a VB.net script that will save a web site to a file. How can i do this? I actually will want to save several pages. This would be a weekly job. I know how to create jobs in job scheduler. I don't know how to do the VB. I know one way would be to use httpwebrequest and response...

I have a date field(starttime) that is formated date time. 2 questions 1. I did a mass update and the time in this field is all set to 00:00 for all the dates. Is there a way that I can update just the time for these fields? 2. I have another field that is an enddate column. How can I have sql...

I am trying to instert data from one table into another. The source table does not have a uniqueIDentifier but the destination table does. How can I get the uniquid field to autopopulate when I do this insert? insert into...

I am trying to find a way to shrink the backup file for our DB. The database file it self is only 607 megs, the transaction log is only 6 megs. The backup file is 11 GIGS. I run a complete backup on the DB. Part of this may be due to me having to delete millions of records every few months and...

How can i import a xml file into ISA Server 2000? I thought there was a tool out there to do this, but i can't seem to find it. I thought i had done it in the past but...? Thanks

I am trying to get an average of some row totals. I know how to do that, but my average depends on what value is selected in my listbox(lbxwkid) I have tried this 2 ways I either get Conversion from string "" to type 'Double' is not valid. for this line ElseIf lbxWkid.SelectedValue().ToString >...

I keep getting these errors I have a sub that looks at my gridview and then is supposed to update my database with the parameters below but I get these errors below... Value of type 'Decimal' cannot be converted to 'System.Web.UI.WebControls.Parameter'. for this line...