I'm having a few integration issues. I have 2 models which need to be mapped so as to enable them to talk to the same table. So one model has a few attributes that are mapped to the corresponding columns in the table and likewise for the other model. I've heard of aliasing, a technique that can be used. Help would be appreciated. Thank...
Hi, I have a table with One-To-Many reflexive association. I need insert the first value disabling temporary the constraint. Any idea how to do it? I use MS SQL 2008, thanks guys for your support! CREATE TABLE dbo.CmsCategories ( CategoryId int NOT NULL IDENTITY (0,1) -- Seed = 0 and Increment= 1 ...
Speaking of in-browser (having not much experience with a SL, I can only assume this is a very common usage scenario) SL applications - do they have any programming restrictions with respect to database access and multi-threading? ...
Hi, I'm working on an PHP/Jquery autosuggest tool that'll query a large table of tags but I need some suggestions for the db schema that'll return related tags as well as match-based results. For example: I type 'Web': Results 'Web Developer' 'Web Designer' 'Web Analyst' and also related tags... 'PHP Developer' 'Flash Program...
I need to make a connection to an Access Database. In order to do that I created a System DSN. I had success making that connection using local files. However, the database must be at a remote server and I mapped a network drive so I can access the database files. Mapping the drive and using the remote files, an error arises when I try ...
Suppose I have a table with a column name varchar(20), and I store a row with name = "abcdef". INSERT INTO tab(id, name) values(12, 'abcdef'); How is the memory allocation for name done in this case? There are two ways I can think of: a) 20 bytes is allocated but only 6 used. In this case varchar2 does not have any significant adva...
In MySQL Im having two tables: PRODUCTS (id, Name) SEEALSO (id, prodLeft, prodRight) SEEALSO defines which PRODUCTS are related together and are represented as binded fileds "prodLeft"-"prodRight". For Example: PRODUCTS: 1 Desk 2 Table 3 Chair 4 Doors 5 Tree 6 Flower SEEALSO 1 1 2 2 2 3 3 3 4 4 5 6 From that we can see bin...
Hey Any Ideas how I can build the following query with the zend_db_table class? SELECT SUM(x) FROM traffic thanks ...
Hi, I am puzzled with a query. I need find out the LAST row added in a table with a column with datatype Uniqueidentifier column is: aspnet_Applications.ApplicationId Notes: This column Uniqueidentifier it is NOT and IDENTITY Column. I need also take the last row inserted and update it on a different table aspnet_Users.ApplicationId I...
Hello all, Ive developed a DB for use with my app but I've realised that I actually want extend my db to incorporate images! I will be hosting the db online but for now I am using it locally for development purposes. To create my db I have been using SQLiteBrowser, which I think is a standalone version of the Firefox SQLiteManager plugi...
I have 2 separate queries that returns to me the following tables: =========================== Id f_name l_name =========================== 15 Little Timmy 16 John Doe 17 Baby Jessica --------------------------- =========================== Id item_name item_price =========================== 15 Camera...
Developers have expressed a desire to deploy a single database object from a Sql Server 2008 project, such as a stored procedure, without having to use the build/deploy or schema comparison functions. To enable this, developers have created their database object scripts including 'if exists.. drop' checks at the top of the script and ...
I am developing one Blog Website and I was wondering how to save the large blog post data - in a XML file, as a HTML file or directly in database. Any suggestion? ...
I have two distinct databases as a source for a Silverlight RIA application. They are exposed through separate RIA services. There is one relationship between the databases, meaning that I have a foreign key (no constraint) between the databases. My Entities currently load this as an Int32. How would I go about mapping this to an act...
Quick intro I've built a system which requests stats from social network apis for 1000s of different subjects every 20mins. So I do a call to each social network for each subject. This means im making 1000s of http requests for each 20 mins slot. The results are then processed in a separate task. Current solution I'm running php from ...
Assuming that I created a cloud-based website application that people literally all over the world could use, are there any countries in particular that do not like personal data being encrypted and stored within a database and used in this manner? I'm not saying about storing unencrypted data, I mean about countries that do not like th...
Hello I am building an application that will allow a user to record weekly activity over a 6 week period. Each week has 3 benchmarks to record against, here is an example: Week 1 +------------+-----------+------------+-----------+ | Day | Minutes | Location | Miles | +------------+-----------+------------+-----------+...
Hi, my query is as follows: SELECT r.name , r.network , r.namestring , i.name , r.rid , i.id , d.dtime , d.ifInOctets FROM router AS r INNER JOIN interface AS i ON r.rid = i.rid INNER JOIN 1278993600_1_60 AS d ON i.id = d.id AND dtime BETWEEN 1279027200 AND 1279029000 WHERE r.network = "ITPN" AND i.status = "active" WHERE ...
Is it possible to have a look at what is there inside an index using SQL*Plus? If I have a table like this: Table A ------------------------ rowid | id name 123 | 1 A 124 | 4 G 125 | 2 R 126 | 3 P where id is the primary key, I expect the index to be something like this index on A.id ------------- id ...
A project I have been working on for the past year writes out log files to a network drive every time a task is performed. We currently have about 1300 folders each with a number of files and folders. The important part here is that we have about 3-4 XML files on average within each folder that contain serial numbers and other identifyin...