I am using SQLite to store school classes. I want to fill in a Spinner with the classes that get stored in the database. How would I grab all the classes in the DB and load them into a spinner?
I am working on a big application on SQL Server 2008 with 60 000 stored procedures and over 10 000 tables. Is there a tool through which I can do impact analysis to find out all SPs doing a DML on a table?
Using VB6, I need to load a bitmap image and subsequently manipulate some of its data - specifically, I want to rotate a section within the image, and in the end keep the image intact with the rotated section. How do I (1) find out where an image gets loaded into memory (a physical address), and (2) in what format is it stored, a 1-D array, 2-D array, or what? Maybe you can even suggest a better way to do this. Thanks.
hi,
I'm using the following lines to store the location of an object.
var lightboxTop = $('#lightbox').css('top');
var lightboxLeft = $('#lightbox').css('
left');
I'm successively moving this object in my element, and I want to restore it previous position with the stored variables.
But, I'm afraid javascript is saving the values by reference so I lose the initial positions. Am I correct ? How can I solve this ?
thanks
I have a field aliases of type java.util.Set in one Entity. This Set doesn't denote any relationship to an Entity.
Q1. How can I store this aliases field through JPA?
Q2. How this field get stored in database? I think that for the database, this field is a multi-valued attribute.
I am stuck on how to pass data from one control to another. If I have a listbox control and the Contol Item contains a datatemplate which renders out 5 fields ( first name, last name, email, phone and DOB) all of which come from an observable collection. How can I allow the user to select a listbox item and have the valuesbe stored within a new listbox control?
Is this done through the creation of a new collection or is there a more simple way to bind these values to a new control?
thank you,
Hi,
I want to store the images related to a each person's profile in the DB and retrieve them
when requested and save it as .jpg file - and display it to the users.
How could I render the image data stored in the DB as an image and store it locally??
I'm working with a binary file that I disas'd in gdb. Right now I'm just examining the return value of a function.
0x08048604 <playGame+78>: ret
Is the address shown the address where ret is stored in the function? Or is it just the address of the instruction to return the ret value?
So I want to make a program that allows you to store and search for user names/passwords for online sites there signed up to.
I know C# has some database options but I don't know much about it. I also heard that it can read/write excel files.
Whats do you think is best for storing the data?
ALSO do databases need to be stored online on a sever, or can they reside in the program
files?
UPDATE polls_options SET `votes`=`votes`+1, `percent`=ROUND((`votes`+1) / (SELECT voters FROM polls WHERE poll_id=? LIMIT 1) * 100,1)
WHERE option_id=?
AND poll_id=?
Don't have table data yet, to test it properly. :)
And by the way, in what type % integers should be stored in database?
Thanks for the help!
I'd like to fill System.Windows.Forms.ListView with the items I've stored in a separate System.Collections.Generics.List<. I would like to avoid to store the data twice, once in the List< and once as a string in ListViewItem. Is there a way to make ListViewItem use some callback function to obtain the text to put in its columns from the Tag property, instead of using its Text property?
I have a few tables where Foreign Key constraints are added. These are used with code generation to set up specific joins in generated stored procedures.
Is it possible to override these constraints by calling multiple deletes within a transaction, specifically "TransactionScope" in C# or is cascaded deleting absolutely required?
DELETE FROM #tItem_ID
WHERE #tItem_ID.Item_ID NOT IN (
SELECT DISTINCT Item_ID
FROM Item_Keyword JOIN Keyword ON Item_Keyword.Keyword_ID = Keyword.Record_ID
WHERE Keyword LIKE @tmpKW)
The Keyword is %macaroni%. Both temp tables are 3300 items long. The inner select executes in under a second. All strings are nvarchar(249). All IDs are int.
Any ideas? I executed it (it's in a stored proc) for over 12 minutes without it finishing.
Hi All
I want to generate image on server side. My Image is stored in server side's database in blob format and I am able to convert it into string_image;
Then How to convert that string_image into actual .jpg or .png format.
Actually I am posting attachment as image on users facebook' wall.
How to generate Image at server side in Java?
Is there any sample code to do it?
I'm doing a web application for articles
Articles must be shown by month, with its published date stored as mm/yyyy
Now:
1- Should I use a DATE type field for storing?
2- Will jQuery UI datePicker be useful for showing mm/yyyy?
3- How could I sort by mm/yyyy?
I guess it will be more complicated if I store date normally and extract the day from date each time I want to do something, right?
Thanks,
Using Seam 2.1.2 and JSF 1.2 I wonder how to store the users login name in the database.
In plain JSF I would simply lookup FacesContext.getCurrentInstance().getExternalContext().getRemoteUser();in a backing bean and set the value into a persistent object.
How can I achieve that the users name will be stored in the DB?
Let's say I have the following array (which is the returned value of a database query):
Array ( [0] => PHP [1] => Webdesign [2] => Wordpress [3] => Drupal [4])
And the following string:
Working With Wordpress Shortcodes
How can I compare the array with the string to see if the string contains any word stored in the array? (hopefully that made sense to you :d )
When he finds a match (eg: Wordpress) it should create a hashtag like so:
Working With #Wordpress Shortcodes
Do all deadlocks indicate a problem with the query or does this kind deadlock indicate a problem with something else like SQL mail or something? The stored proc in question uses SQL mail.
My requirement is to display localized text messages in a J2EE web application. I know J2EE provides very good support for this.
My question is what is the practice followed to have the localized messages stored to be used by the application. If I want to display Japanese / Chinese kind of messages which are not like English like char sets how do we get that messages/text into the properties files or Database tables.
I use the applicationUpdater framework with an Air application.
The delay property is set (in AS code) to 1 day.
However, the application checks every time it is run: the delay property seems to be ignored.
Does any one know where last run time is stored, so I can check if there's a reason it can't seem to remember ;-)
the app is at http://muchoswing.com/cantoyo
Hi i am fairly new to objective c and have been doing some iphone programming.
Is it possible to look up the value of a variable in a different class?
Basically what i am doing is running a function that exists in my app delegate from a view controller, but the app delegate needs to use a variable stored in the view controller from which the app delegate function was called. Make sense???
Any help would be grateful.
James
Hey guys, I am just trying to pull all the records from my database who have a rec_date (varchar) stored as m/d/Y and are expired (as in, less than curdate()), and this call isn't giving me what I want:
SELECT member_id, status, DATE_FORMAT(STR_TO_DATE(rec_date, '%m/%d/%Y'), '%Y-%m-%d') AS rec
FROM members WHERE rec_date CURDATE() AND status = '1'
I'm obviously doing something wrong, so can you help?
Thanks.
My c# application opens the Internet explorer for different web URL/ domains.
And I have all those credential information (username, password and domain name) stored in the database for each web application.
Now how I can authenticate automatically without entering credential in “Network Credential” dialog box using code or bypass that dialog box? In other words I need to store those credential on system so no need to enter.
I am using c#
I have so store a very long value of type integer that can't be stored in a variable of long type. how can i store such a long integer value in a c programme.
Please illustrate it through an example/ programme if possible.