should be pretty simple for a pro. i have images in sql server database and i want to retrieve them in my aspx (vb.net) file. i have in aspx this image control - in vb.net i have started this code - Private Sub ImageDisplay() Dim SqlCnn As SqlConnection = Nothing, sql As String = "" ConnectDB(SqlCnn) Try sql = "SELE...
I am developing my application in Silverlight with MVVM pattern support. Now I use Sql server 2008, but I am start thinking about in future use also Oracle and XML as storage for my data. I query with linq to sql. It is pattern which I can use to completely automated and independent from database my application? Where I will only replac...
I have some really good books for SQL Server, like: SQL Server 2008 Bible Pro SQL Server 2008 - Relational Database Design and Implementation SQL Server 2008 for Developers. Can you suggest/recommend some other titles, that may address other topics perhaps, that you found truly useful? ...
Hi UserTransaction ut=lookup.... ut.beginTransaction(); saveToFooDB(); statelessEjb.transactionSupportedMethod(); //saves something to the Foo DB saveToFooDB(); ut.commit(); If i was doing the above then my understanding is that it is not an XA transaction as it doesn't span across multiple resources (like DB plus JMS). Is my understa...
I have a datastore model representing items in an ecommerce site: class Item(db.Model): CSIN = db.IntegerProperty() name = db.StringProperty() price = db.IntegerProperty() quantity = db.IntegerProperty() Is there some way to enforce integrity constraints? For instance, I would like to make sure that quantity is never s...
I'm trying to build out a mysql database design for a project. The problem is coming up with the best solution. Basically in my application, I will have to insert approximately 10-30 rows per user. The primary key will be a random CHAR(16) string. There will also be an datetime index, and an additional row (with an index) called "data". ...
Suppose my model is this: class Ego(models.Model): event = models.ForeignKey(Event) user = models.ForeignKey(User) As you can see, this table has 2 columns, and they're both foreign keys. How do I "order by" User.first_name? Is this it? But it doesn't look like it. Ego.objects.all().order_by("User.first_name") ...
Is it a good practice to have timestamps for the last row update in every table? Or should they only be set where really needed? How do I know where I will need an update timestamp later? For which kind of information do they make sense? ...
I do my web development and testing on my laptop running an installation of xampp - I upload things to my host, but I always go through cpanel's file manager to do it. I realize that there's definitely a better way to go about it, but I need to be pointed in the right direction to do so, also other tips on how to manage stuff would be ap...
I have just downloaded SQL Server 2005 express edition from here: To be used as a database for a vb.net program. But I'm confused in using sql server. I do not know where to start from here: http://screencast.com/t/ZTdiMDU5 Do I have to create the database in vb.net?--> http://screencast.com/t/ZjRlYjkx If not, where could I create...
We have a table in mysql of 18GB which has a column "html_view" which stores HTML source data, which we are displaying on the page, but now its taking too much time to fetch html data from "html_view" column, which making the page load slow. We want an approach which can simplify our existing structure to load the html data faster from ...
I had a simple table: class test(Base): __tablename__ = 'test' id = Column(Integer, primary_key=True) title = Column(String) def __init__(self, title): self.title = title When using this table, id was set automatically. I want to add another field that is unique and efficient to search, so I added the field: ...
I'm interested in T-SQL source code for synchronizing a table (or perhaps a subset of it) with data from another similar table. The two tables could contain any variables, for example I could have base table source table ========== ============ id val id val ---------- ------------ 0 1 0 3 ...
Heya since monday, i'm working as an intern in a company (final year at college) i need to make a c#project working with a ldap database i've seen there a library made by novell that can be used. there's also a built-in lib "System.DirectoryServices.Protocols" specially made for ldap, but there's not much documentation for it. Has any...
Django's get_or_create function always cause "get() returned more than one Model name" error in a multi-threaded program. I even tried to put get_or_create statement inside a lock.acquire() and lock.release() block but still didn't work. The program only works when I set thread_count=1 The database is on InnoDB engine. How to fix this...
Do you know of any beginner tutorial on how to manipulate(Add, Edit, Delete, Search, List) sql Server database in vb.net? ...
I'm working on a data warehouse and I'm trying to figure out how to best verify that data from our data cleansing (normalized) database makes it into our data marts correctly. I've done some searches, but the results so far talk more about ensuring things like constraints are in place and that you need to do data validation during the E...
I'm new to PHP and have a two part question. I need to take rows from two separate tables, and arrange them in descending order by their date. The rows do not correspond in order or number and have no relationship with each other. ---EDIT--- They each contain updates on a site, one table holds text, links, dates, titles etc. from a bl...
When I create a view I can base it on multiple columns from different tables. When I want to create a lookup table I need information from one table, for example the foreign key of an order table, to get customer details from another table. I can create a view having parameters to make sure it will get all data that I need. I could also...
I could use some advice on my move from the Windows world to Linux. For my business, I have used VB6 and Microsoft Access with both Access databases and SQL server in the past. The easy to use forms, report writers and programming language were perfect for CRUD apps and analysis for our small hotel/restaurant business. After using L...