Assuming have is required, the following 417 results were found.
-
Why? It's similar to javascript's message box or confirm box, only Android let's you redesign the dialog. For my purposes I have used an XML as the layout. How? This displays a standard Ok/cancel message popup which you attach to some event import...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
the PcWorldRssParser.java (without it crashing the app). The gist is to check for a description (the first two items do not have one). The following will also return a publishing date: Find the List function in: PcWorldRssParser.java (readFeed) and...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
use a "Standard View", I just used the Datasheet one) Give the view a name, select what columns you want the form to have (I included the IDs for functional purposes) Further down the "Create View" page, there should be a Sort section, specify the...
- Type: Article
- Author: Joel Lipman
- Category: Infopath
- Language: *
-
people think to themselves every time they see the error they programmed in. Apparently this problem also happens when you have a Data File of varying column numbers. My solution below will also fix this. How? My data file had some empty rows amongst...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
and to populate a database table with this data. Note that this only works if all the text files to be used as source data have the same number of columns and where the column widths match. How? I've adapted my real working product with an example. As...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
[student_nationality_code], [student_ethnicity_code] FROM [sourcedb].[dbo].[events] Simple bit of SQL but as you can see we have a few fields that need decoding (suffixed by "_code"). Run as it is, yields something like the following: sequenceID...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
&rc:FindString=foo Note: I have no idea what this is for. Render a snapshot http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rs:Snapshot=2004-03-30T15:45:02 Use a specific stylesheet (handy for...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
This article serves to describe several workarounds or proofs of concept. Why? We have a first report which acts like a search page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page, then...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
value. The Gist Add database level parameter check Add IIF in SSRS to confirm Database Level AlphaNumeric Check You may have better ways to do this but here are my database level checks for alphanumeric values: -- ORACLE -- 0 if is alphanumeric, 1 or...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
because it meant modifying the SQL query. The zero padding would need to be applicable within an MDX query. The Situation We have a database using Oracle 10g, and a SQL Server Reporting Services v2008 R2 environment. My use for this was when displaying...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
are set to false or it will error): Save and test on the ReportServer. Background: If you need to visualize how I could have ended up in such a situation, here's the design mode of the report (apologies for the red censoring but this allows the images...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Using encryption This one activates SSL encryption for all data sent between the client and server. The server needs to have a certificate installed. Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Encryption=true; This option...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
Why? We get problems with this because none of our staff are full administrators of their local workstation. As IT staff we have elevated privileges but not absolute rights to configuring our computer. And we still need to re-login for every change....
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
access (in this example "adventureworksro"). Select Properties. Select User Mapping. Map the login to the database they will have access to. Tick the boxes for role membership next to public and db_datareader. Confirm by clicking OK. You should get...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
I have just spent all morning on Microsoft websites to determine what number is the TimeDataRetrieval column displaying. Thank you I know it's an INT. There is just a serious lack of documentation as to what this database is and how it populates its...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone SQL scripts that can simply be used to search an...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Cursor1; DEALLOCATE Cursor1; PRINT ' ) AS t1 GROUP BY column_value ORDER BY MIN(column_source)'; END Step 2 of 2 You now have a big SELECT query which you can copy, paste and run against your SQL database. Simply run the query that the above outputted...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called "WarehouseLoadKey" and the value we want to search on is...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
memory aids for me so that I don't have to keep looking them up: MySQL T-SQL Strings String Replace REPLACE(haystack,needle,replacement) REPLACE(haystack,needle,replacement) String Position INSTR(haystack, needle) LOCATE(needle, haystack [, offset])...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
how to format the returned value to a more user-friendly date format (such as Month name then year - eg. November 2010). I have been told that data types are a nightmare in SQL Server Reporting Services and that all data types should be kept in their...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *