user117701 - Developer IT

Parse JSON in TSQL

- by user117701

Is it possible to parse JSON in TSQL? I dont mean to create a JSON string, i mean to parse a json string passed in as a parameter.

Android: How to create an onclick event for a SimpleCursorAdapter?

I have this code: db=(new DatabaseHelper(this)).getWritableDatabase(); constantsCursor=db.rawQuery("SELECT _ID, title, subtitle, image "+ "FROM news ORDER BY title", null); ListAdapter adapter=new SimpleCursorAdapter(this, R.layout.row, constantsCursor, new String[] {"title", "subtitle", "image"}, new int[] {R.id.value, R.id.title, R.id.icon}); setListAdapter(adapter); registerForContextMenu(getListView()); Which displays a list of titles. I dont however for the life of me know how to create a click event so that i can call another view when i click an item from that list. Anyone?

Read the article

Calculate fiscal year in SQL Server

- by user117701

How would you calculate the fiscal year from a date field in a view in SQL Server?

Read the article

Jump to specific page in reporting services

- by user117701

I have a multipage reporting services report, and i would like to start from a specific page, not page one as default. Is there a way to do this?

Read the article

Restore NewForm.aspx file

- by user117701

How do i restore a deleted NewForm.aspx file? I dont want it back through the recycle bin, since i made a mess of it, i just want to recreate the original file. Sharepoint 2003 was able to do this.

Read the article

Javascript eval limits

- by user117701

Is there a limit to javascript's eval, like in lenght? I'm trying to build an app where you can store JS code in the DB, which you can later load and eval in order to execute it, but i'm reaching a limit. First of all, the code has to all be in one line. Any multiline statements are not executed. Next, i'm reaching a limit in length (i guess). If i execute the code manually, it works, but put that same code in the db, load it via ajax, and try to execute it, and it fails. Any ideas why?

Read the article

Android: ListAdapter populating image (icon) source

- by user117701

I'm populating a list from the DB, and i have a image field in the DB which contains a URL to a image file. ListAdapter adapter=new SimpleCursorAdapter(this, R.layout.row, constantsCursor, new String[] {"title", "subtitle", "image"}, new int[] {R.id.value, R.id.title, R.id.icon}); However, the other fields are populated, but the image remains empty. Why?

Read the article

Android: Cannot invoke toString() on the primitive type int

- by user117701

If i try nltxt = nllen.toString(); with nllen being int nllen = nl.getLength(); i get the error Cannot invoke toString() on the primitive type int. I want to convert the int to string so i can display the number of entries with Log... Why doesnt it work?

Read the article

Javascript Source to textarea value

- by user117701

I am creating some JSON on the fly, serializing it and saving it to the DB. To run it, i create a script element, and load it that way. Is there a way to load the script source to a textarea?

Read the article

include link list depending on category

- by user117701

I want to display the linklist widget only on a certain category. The current way the sidebar is fetched is: if (!function_exists('dynamic_sidebar') || !dynamic_sidebar(1)) Which doesnt give me a say in the calling of the links widget. If i put an if clause there, then the rest of the widgets dont get loaded. So i either need to customize the links widget it self or find a way to call the links widget directly? And how do i check which category i'm on?

Developer IT