Search results for query: *

I am trying to do an update of a field based where I am getting the data from a join between 2 other tables. Can somebody tell me what is wrong with my syntax below? update ContactExtensionBase set New_DateEnquiryTaken = ( SELECT l.createdon FROM ContactBase c inner join LeadBase l...

Can somebody please tell me what is wrong with this SQL? I am getting the following error whenever I add the final line : 'ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator' select * from ( SELECT top 5 COUNT(*) AS 'TotalEnquiries'...

I have a result set like this : Other 34% Dan 24% Ken 17% Claire 16% Helen 9% How do I other this so that the Other always shows as the last row, even if it isn't the lowest percentage?

I have a problem with my SQL. I am trying to order a top expression with a union, but the union prevents me from using order by. Here is my SQL before the union. How do I change this to work with order by? SELECT top 5 COUNT(*) AS 'TotalEnquiries', createdbyname as 'Name', round(100 *...

I have the following SQL to calculate percentages which works fine, but because it is rounding down for example 0.7 to 0 and 15.6 to 15, the total is no where near 100%. Can anybody tell me how to do this so it rounds up correctly? SELECT createdbyname, COUNT(*) AS 'Total', 100 * COUNT(*)...

I have some XML (see snippet below) and I have got so far with it, but I don't know how to get at the text within the <Value> tags : <ResponseGroup refID="AnswerGroup184"> <ResponseText refID="Textbox25"> <Value>Mike</Value> </ResponseText> <ResponseText...

I am reading an image from a database and writing it to the screen. But now I also need to put a border around this image. Here is my code : public void showSelectedImage(string strEncodedImage) { Response.Clear(); Response.ContentType = "image/jpeg"...

How would you go about creating a blank System.Drawing.Image object (i.e. an image with just a white backcolour)?

I am creating a number of System.Drawing.Image objects in my code, and I want to be able to add them to an object such as a Panel so that I can view them all together on screen. Is there a way to do this?

I am working from this example to resize an image : http://aspnet.4guysfromrolla.com/articles/012203-1.2.aspx I have converted most of the code to C# : Response.Clear(); Response.ContentType = "image/jpeg"; System.Drawing.Image image = retrieveImage(strEncodedImage)...

I am displaying images from a database using the code below. Is there any way I can resize the images before rendering them? public void showSelectedImage(string strEncodedImage) { Response.Clear(); Response.ContentType = "image/jpeg"; System.Drawing.Image image...

I have images in my database that are stored as bytes, and I want to show them on screen on my webpage. I can do this with the code below : Response.Clear(); Response.ContentType = "image/jpeg"; System.Drawing.Image image = retrieveImage(strEncodedImage)...

How do I post parameters to a web page in Javascript? I want to do the equivalent of this : "http://webpage.aspx?param=1

I need to pass a parameter from a CRM page to an iframe. The parameter is an ID field which is not shown on screen but is in the database. Can someone tell me how to do this?

I need to return a text data type as my output type, but I get the error : Invalid parameter 2 ('@FileLocation'): Data type 0x23 is a deprecated large object, or LOB, but is marked as output parameter. Deprecated types are not supported as output parameters. Use current large object types...

I need to be able to gain access in my code to certain image files that have been uploaded by users to the CRM. I have found that the details of these files are stored in the AnnotationBase table, and it gives the name of the file in the FileName field. But in which directory are these files...

I have the following XML document : How do I go about getting for example the refID for a ResponseGroup tag, and the refID and selected status for a ResponseOption tag? <ScriptedFaqSession> - <Data> - <Section refID="Section38" sequence="1"> - <ResponseGroup refID="AnswerGroup39">...

I am posting XML to a webpage but I get the following error : ‘A potentially dangerous Request.Form value was detected from the client (xml="<?xml version="1.0" ...").’ How do I prevent this error?

On my report I can show what has been selected for a single select parameter like this : Parameters!ParameterName.Value But how do I show what has been selected for a multi-select parameter? I am using the same syntax as for the single select parameter and getting '#Error'.

How in a report do you format a date as 29-Jun-09 rather than 29/06/2009 00:00:00 AM?