I have a very simple SQL table that I want to import into Solr but because of the features I want for search I can't determine the best schema. The user will start typing into an input box and after 3 characters it will send the request to the server and pull out the most relevant results returning the top 15 matching id and name. Tab...
I want to fetch all the column names for specific table.. I am using msaccess and C# .net 2008. ...
Hi, In my program I need to access the schema of an Oracle 11g database. I have been trying to get a list of tables using a query like this: SELECT t.TABLE_NAME, t.OWNER FROM ALL_TABLES t WHERE t.DROPPED = 'NO' ORDER BY t.TABLE_NAME The query works and I get back a list of tables. Unfortunately when querying some of the tables using ...
Is there any way to load fixtures that have circular referencing? As an example I have the following fixture: BusinessEntityTeam: Nicole_Team: name: Nicole's Team Manager: [Nicole] Business: [ACMEWidgets] sfGuardUser Nicole: first_name: Nicole last_name: Jones email_address: [email protected] ...
Firstly I am an oracle newbie, and I don't have a local oracle guru to help me. Here is my problem / question I have some SQL scripts which have to be released to a number of Oracle instances. The scripts create stored procedures. The schema in which the stored procedures are created is different from the schema which contains the ...
Hi All, A client provided us with schemas and a wsdl for a service they would like developed. When I jumped on the project, there was already a service implementation in place. When I pull up the svc file in IE, it shows the normal svcutil command etc.. When I drill down and I look at the schemas being imported by the wsdl we're using, I...
I am creating a user content website similar to yelp. Site will support multi language in 15 different languages. Need some advice on storing system content, that is: Page content (all the default page text and menu items) Page attributes (Title bar, meta tags like keywords, description, etc) Email content (Subject, header, footer - ...
Hi I need to distribute a string-value (a wcf-service-address) to a network of clients in the same domain. I figured AD would be a good place to store this kind of information, or is it overkill for only one string-value? To do this it seems I have to add a custom AD-class/schema template. But how? I can't find any good information abo...
Hi everyone, I'm having quite a hard time on constructing my 1st XML Schema. I need it to verify the correctness of an XML document that forms a questionnaire. So here's the section in don't get: I changed the source. The 1st answer refers to this code: <root> <values> <value>Lorem</value> <value>ipsum</value> ...
I have a schema define in my database. Except now everytime I do a sql statement I have to provide the schema ... SELECT * FROM [myschema].table I set the default schema for my user using management studio and also ran the ALTER USER myUser WITH DEFAULT_SCHEMA [myschema] and I still get the invalid object 'table' when writing a query...
Does rake db:schema:dump recreate schema.rb from migrations or the database itself? thanks ...
I've learned scheme and quickly mastered a lot of it, then did a project in it just fine. Literally took me days to finish. I'm now trying to learn common lisp to get a feel for that and now I'm just really really struggling with trying to learn asdf. It seems to be common knowledge how to use it with libraries but I'm baffled. I guess i...
I'm trying to enumerate through the Active Directory schema and don't think I'm seeing all the attributes. Could someone take a look and tell me where I'm going wrong? objRoot = new DirectoryEntry("LDAP://" + serverName + ":" + port + "/RootDSE"); strSchemaNamingContext = objRoot.Properties[ "schemaNamingContext"].Value.ToString(); ob...
Just wondering if anyone knows of a C++ library that provides a single interface for querying database schema (tables, fields, field types), and for a variety of vendors? I know DTL does this to some degree, although I haven't dug into the details of how it does it, or if it makes that info available external to itself. *ODBC is probab...
I want to create different kinds of processes in which agents interact with each other. I want to describe (define, formalize) processes of interaction between agents using a special language. In other words, I want to provide an environment where agents can interact with each other in a certain way and I want to describe the way of inte...
Scenario: I have organization, in org I have departmenst, in depts' I have groups, in groups I have users. I have courses. I can give access to any combination of users/groups/departments/organizations. Each level inherit the access it's parent has (so every course which is available to the organization is also available to all of it's ...
Hi, I've just come across the Star Schema for Report-Aggregation. The first Question that came to my mind is whether or not Doctrine ORM supports such denormalized Tables. As I've seen ist, there are a feww kinky behaiviours in dealing with relations, a Model could not completely know. Any ideas? Is it possible? ...
All, We are evaluating MySql as a lower cost alternative to SQL server for our smaller clients in a shared hosting environment. I am still foggy on how we would migrate some of the particulars such as table/scalar value functions, sql jobs, etc, but I will post specifics in another thread. I do, however, have a fundamental question ab...
I was researching on alternate schema representation mechanisms and came across OASIS CAM. I found it very relevant for my project. Wondering if anyone is using it in some real implementation. ...
Background I am developing a social web app for poets and writers, allowing them to share their poetry, gather feedback, and communicate with other poets. I have very little formal training in database design, but I have been reading books, SO, and online DB design resources in an attempt to ensure performance and scalability without ov...