I used TextConverter to convert a TextFlow in Flex to String to store it in my Database. How to convert that string back to TextFlow in order to display in Rich Text format
im trying to work through some questions and im not sure how to do the following
Q:Find the hard drive sizes that are equal among two or more PCs.
its q15 on this site
http://www.sql-ex.ru/learn_exercises.php#answer_ref
The database scheme consists of four tables:
Product(maker, model, type)
PC(code, model, speed, ram, hd, cd, price)
Laptop(code, model, speed, ram, hd, screen, price)
Printer(code, model, color, type, price)
any pointers would be appreciated.
check_box is hunted in rails; but I would like to select some objects and save the relationship to the database anyways. When I debug the code all I see is the value='on' instead of the value I want to save. Any Help or tutorial would be appreciated.
I need to read the data out of database and then save it in a text file, how can I do that in Ruby? Is there any file management system in Ruby?
Thanks
Hi I am very new to both django and python... I have a html table with person information in each row...How do i get a particular row entry/id of the one i need to edit/delete to accordingly update/delete the row in database??
I have a text file sitting on client machine and want to move it to the database server (MS SQL 2008) but I don't have any access to the server except through the SQL Server client. Can I transfer this file to the server using SQL client connection?
In Oracle, you can write:
update t
set xml = updateXML(xml, '/a/b/text()', 'gaga')
This works only if you already have some text in the <b> element. How to update the document and "add some text" in <b> if the document in the database looks like:
<a>
<b/>
</a>
My google fu is weak today, but I cannot find a good article to do so. I would like to extend the Zend Adapter to check n extra columns on my database table. What is the best way to fully extend the adapter, so I can use it in the future without needing to dig through documentation again.
Some of the degree sysmbols in my sql server database are displaying like this: 173-¦F.
When I do a search for that - SELECT * FROM PRoduct WHERE description LIKE '%-¦%', it does not bring them up.
How can I find (and replace) such characters?
What sql query would you write to get the table names which have a particular foriegn key.
Eg. Person_Table(person_id,name,address,...)
Purchases_Table(purchaseid, purchased_by_id(fkey)....)
AccountDetails_Table(AccountId,PersonID,....)
Roles_Table(PersonId,RoleID)
Now i want to find the table names where Person id is used as a foreign key.
The above schema would return me
Purchases_Table,AccountDetails_Table, Roles_Table
Database: SQL Server
I have a database in MS Access and within it I am holding dates for expirations for SSL's. I want to set a reminder for any SSL that is soon to expire. Anyone know the easiest way to go about this?
Is there a succinct but complete example project or tutorial that brings together the pieces of the Microsoft stack for a complete application?
WPF
MVVM
Business Objects
EF
Database
I find plenty for WPF and plenty for EF, but am having trouble fully understanding how the EF generated classes relate to business objects, and how those business objects in turn fit into the MVVM pattern.
I am trying to move a WordPress installation from one server to another one, including all of the SQL data, and the file-system data (photos,template files).
I just have a problem changing the URLs in the database, since I need to replace the new URL with the old one.
I would love to have some suggestions about how can I replace the URLs (maybe there's a rplace statement in SQL?)
Thanks in advance.
I'm using
var retval = value.replace(/<br[\s\/]?>/gi, '\n');
To strip the <br> tags from the textarea and nl2br('$_POST('newValueHere')') to insert into my database and to return back to jeditable to display the edits. The only problem I'm having is that each click on the editable field seems to make all the <br> tags be written twice? This makes no sense, does anyone have any ideas what could be going on?
During development of a PostgreSQL database, I made foreign keys in every table. The problem is that I forgot to select ON DELETE CASCADE option.
I need to set that options on all tables. It seems I can only drop and recreate every constraint manually.
Does anybody know any shortcuts?
Hi, I'm trying to update a field in the database to the sum of its joined values:
UPDATE P
SET extrasPrice = SUM(E.price)
FROM dbo.BookingPitchExtras AS E
INNER JOIN dbo.BookingPitches AS P ON E.pitchID = P.ID
AND P.bookingID = 1
WHERE E.[required] = 1
When I run this I get the following error:
"An aggregate may not appear in the set list of an UPDATE statement."
Any ideas?
MySQL stores the date in my database (by default) as 'YYYY-MM-DD' The field type for my date is 'DATE' (I do not need any time storage).. Is there a simple way to change it by default to DD/MM/YYYY ?
I call up different dates in 2 different tables, and no where in any of my code do I have anything resembling a date variable or anything! Hopefully this is a straight forward change?
Is there some kind of Session size limitation or advisable value to not to surpass ?
In my web application i create few DataTables to store user selections which are stored in session until user approves selections so i add those values to database.
problem is i don't know whether session is reliable enough to keep few objects in or not ?
thanks
Hi,
I am having a hard time establishing a connection to my database file using JDBC-ODBC bridge. The driver I am using is sun.jdbc.odbc.JdbcOdbcDriver but I believe it is not present on Mac OSX by default and hence throws an exception for class not found.
I googled for the driver but could not find much useful information. Can somebody please help me establish the connection? Or send me any link which contains information I am looking for?
Thanks,
I last programmed actively in 2002. It is almost 8 years now. I learned C and then moved to Visual Basic for our thesis project in the university. I would like to ask suggestions on what programming language should I learn and put to profitability use in areas such as desktop applications, web development, and database applications.
I am using SQL Server 2000. I have a database with n number of tables in it. I have configured a maintenance plan. If I enable integrity check and run the plan, I am not able to enter any data through VC++/ADO.
Is there anything I have to check?
Is there a way to know if all the properties in an object are empty. My object represents fields from database and I want to know if a particular record is present or not. NULL doesnt seem to work.
I am using a textbox in winform (c#) and using the text of to make consults in a database.
But i need constantly consult the text of the textbox every time that text change. So for these i use the KeyUp. But this event is too slow.
Is any event that just fire when the textbox editing has been finished ?. I consider for finish 2 conditions
The control lost focus.
The control has 200ms without keypress