Is it possible to aggregate data in Excel?
I now have a table which displays:
Name Paper ImpactFactor
Rick Sun 1
James Star 3
Tom Guardian 6
Rick Independent 9
I want to create another spread sheet that displays Name and ImpactFactor, however, in the case where a person is...
I have the following formula on each row
=SUM(N3,E3,G3,I3,K3)
Is there a more gneric way of creating this formular so that it can be applied to the how column, so that I would get the equiv of:
=SUM(N2,E2,G2,I2,K2)
=SUM(N3,E3,G3,I3,K3)
=SUM(N4,E4,G4,I4,K4)
etc??
I've 4 months into developing my website.
All was going well... but I've hit a brick wall.
I have different types of content, all of which is quite different. The data for each type is stored in its own table..
i.e. artist table, gig table, music table.
My site allows this content to be...
I am writing a Newsletter class that will send bulk emails from my website to subscribed members.
In my opinion, this should run in its own thread.
Should I place the thread code within the newsletter class, or place this around the call to the class?
Look up tables?
I have a sheet which I would like to populate automatically from a couple of look up tables.
Are lookup tables possible?
How do I approach this?
I have a common task that all my applications use.
We use kerberos to log the user in, but get additional user information from SQL.
I was therefore thinking that a web service would be ideal for this.
Pass a string name value and return the associated data.
How easy would it be to get the...
I am about to add a newsletter system to my website.
Emails are also generated through out the site.
I want to update this so that the emails use templates so that the format of the emails can be easily controlled and edited.
Does anybody know of any existing templating systems?
If I cant...
I have just imported some data from an excel document into a sql database.
Currently there is no primary key column, so I have added a new column of type uniqueidentifier.
I have 3000 rows. How can I generate the guid values for this column?
Has any body written any code to check to see if a string contains HTML or SQL?
I want to ensure that my users dont try to inject HTML, Javascript or SQL into my sites content.
I am currently reading the MCAD Training manual for web apps.
The book talks about derived classes containing methods that shadow a base class method.
I'm not sure why you would want to do this. Why not just override?
I have the following javascript:
<script lang="javascript">
function window::onload()
{
if(window.self!=window.top)
{
document.write("<link media=\"screen\" href=\"css/slam_mythomson.css\" type=\"text/css\" rel=\"stylesheet\">");
}
}
</script>
This is embbedded within a page.
The function...
I am writing a bespoke Contacts Information system.
The system will allow the user to search for companies, employees based on the data stored about them.
Each company will have a core set of information. For example Name, Head office address, telephone number. Each company will also have a...
I'm playing with the CSS for my site.
I have defined a css file for print purposes.
In the print version of my site, I would like to display the text in the alt attributes of the images on my site.
Is this possible to do with CSS?
I have a table which contains tabular data. Included in this data are URLS.
These URLS can be very long.
I cannot programitcally split the URL, so I am stuck with these long URLS.
In IE the width of the table column takes precidence over the width of the url and it wraps.
This does not...
Scenario -
User fills in a form
Presses submit
Then once the page response has occurred, refreshes the page
Results in double posts.
Has anybody found an elegant solution to this problem?
I have created an image upload usercontrol that allows me to upload an image. When an image has been uploaded it throws an event and the image is passed as an image object as an arguement of the event.
This works really well and integrates with my site very well.
I re-size the image to...
I have just uploaded my website to my host.
I am experiencing issues with SQL Server user defined functions.
I have a user defined function called fnSplitter.
A stored procedure GetArtistsView uses this.
The default page of website calls this stored proceedure, however it
claims that the...
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.