Hi, I need to access an excel spreadsheet and insert the data from the spreadsheet into a SQL Database. However the Primary Keys are mixed, most are numeric and some are alpha-numeric. The problem I have is that when the numeric and alpha-numeric Keys are in the same spreadsheet the alpha-numeric cells return blank values, whereas all ...
Hi, I have a SSRS report. When i tried to export to PDF it was taking 4 pages due to its width., where the 2nd and 4th pages were displaying one of my field from the table. So i tried to set the layout size in report properties as width=18in and height =8.5in. It gave me the whole table in a single page of PDF. But I am getting 2nd and ...
I'm using MS SQL Server but welcome comparitive solutions from other databases. This is the basic form of my query. It returns the number of calls per day from the 'incidentsm1' table: SELECT COUNT(*) AS "Calls", MAX(open_time), open_day FROM ( SELECT incident_id, opened_by, open_time - (9.0/24) AS open_time, DATEPART(dd...
Hello, This is probably really simple but I really could not word it properly on Google. See, I have a ArrayList that keeps the info for each thread. Each thread has it's own ID. So, at the beggining: myList.add(theIdOfTheThread, new InfoForTheThread()); //Add new thread info at index theIdOfTheThread And when I want info: myList.get...
I've come across a strange problem with a ASP.net MVC project. the following code works fine in Firefox, chrome, Safari IE8 - BUT not IE8 in IE7 Compatability mode <% Using Ajax.BeginForm("SetStatus", "StatusControl", New AjaxOptions With {.Confirm = "Are you sure you wish to change the Status?", .OnBegin = "Show_Updating", .OnComplet...
I am using NuSOAP to try to consume a Web Service built in Java. I have this code so far: <?php require_once('lib/nusoap.php'); $wsdl="http://localhost:8080/HelloWorldWS/sayHiService?WSDL"; $client=new nusoap_client($wsdl, 'wsdl'); $param='John';#array('name'=>'John'); echo $client->call('Hey', $param); unset($client); ?> but when t...
Hi there, I'm having a problem implementing custom 404 error pages on my Windows/IIS/PHP webhost. Whenever I try to send the 404 status message in the header no content is sent to the client and a blank page is displayed instead. Here is a very simple script I'm using: <?php header('HTTP/1.1 404 Not Found'); header('Status: 404 No...
Hey! In my current simple project, Copybin, there is some space at the bottom of the page that I cannot seem to be able to remove it. Any ideas? ...
I find myself repeatedly looking for a clear definition of the differences of nil?, blank?, and empty? in Ruby on Rails. Here's the closest I've come: blank? objects are false, empty, or a whitespace string. For example, "", " ", nil, [], and {} are blank. nil? objects are instances of NilClass. empty? objects are class-specific, and...
Probably easy to answer for you guys: How can i get awk to put a blank line into my file every n lines? ...
It's consistent on certain documents too. The only solution I have at the moment is to print a PDF of the document and then secure that version of the document. That seems to bypass the issue. But I have 5000 documents I'm batch processing and I'd rather not have to mess with such things.. ...
Hi, we faced very strange issue (really strange for such mature product): how to get number of characters in unicode string using Transact-SQL statements. The key problem of this issue that the len() TSQL function returns number of chars, excluding trailing blanks. the other variant is to use datalength (which return number of bytes) and...
Hi All, Please help me to solve this. This is my string str = "aaa\n\n\nbbb\n\nccc\ddd\n" means four blank lines, all together eight lines I want to return this in one line Output should be like this (aaabbbcccddd) in single line I used various trim functions to get the output but still i am failing to do it. if Anyone know the pos...
This problem has been bothering me for days. Hopefully someone has come across this before and has developed a workaround. So I've developed a middleware Java app which during its execution invokes a SOAP action. Now, the behavior of this bit of code under the 1.6 JDK is working well: // inside a try-catch block SOAPCon...
In JOGL, there is the addGLEventListener, I add a listener to it. When the display() "callback on gl" is called, the screen is printed in black, just after four frames the display() prints something. How to make display() print something on the first callback display()? ...
Hi All, I have a crystal report which when generated has a last page that is blank except for the page footer (which indicates the current page, as well as the report title). This only occurs when the data displayed on the second last page completely fills the page. Would anyone have any ideas as to why this might be? Thanks in adva...
I'm just starting out writing this code and when I add in the db select and refresh the page, instead of showing all the other html on the page or an error, it just shows up blank. Here's what I've got- $link = mysql_connect('vps2.foo.com:3306', 'remote_vhost30', 'password'); if (!$link) { die('Could not connect: ' . mysql_error())...
Hi, I've just moved a site across to a production server, and a once working CI installation, now returns a blank screen. I believe it is due to whitespace, but how are you supposed to find something like that?!!! Hope someone can help. Thanks in advance. Tom ...
I am building an online article website. I have a php script called view_article.php that displays articles. The way the page knows what article to show is by using a $_GET variable in the URL. For example: /view_article.php?article_id=1 views article 1 /view_article.php?article_id=2 views article 2 Here's the catch. In IE8 whe...
Hi guys I'm getting nuts here with this: ObservableCollection<Employee> list = new ObservableCollection<Employee>(); dgEmployees.ItemsSource = list; When you debug the list variable, it's empty (list.Count =0), but then I bind it to a DataGrid (WPFToolkit), it shows me a blank row. In immediate window, for dgEmployees.Items it's sho...