A client wants to have a lookup field for customer name found in a database as metadata on a Word document in a document library. They have a code which represents a group of customers and one of them should be used as customer name as metadata as well as the customer code inside the document. Since editing the metadata in Word leaves n...
I'm developing a customer service application. When customers submit requests via email, I import the email messages into my SQL Server tickets table (reading the mail messages in MS Exchange using ColdFusion). My application allows reps to send reply emails to these "tickets". I'm looking for the best way to track which emails are rel...
How can I get metadata / constraints (primary key and "null allowed" in particular) for each column in a SQLite v2.8 table using PHP5 (like mysql_fetch_field for MySql)? sqlite_fetch_column_types (OO: $db->fetchColumnTypes) only gets column name and datatype: http://dk.php.net/manual/en/function.sqlite-fetch-column-types.php SQLITE_MAS...
If I can open a connection to an MS Access file in C#, how can I retrieve a list of the different tables that exist in the Access DB (and if possible, any meta-data associated with the tables)? ...
I have several projects that require me to monitor files, and then edit them as they are getting written to disk. I have a feeling that what I am looking for is operationally the same as how anti-virus tools operate. Let me give more details: 1) I need to trap all files saved by Office application, and then add specific company tags to t...
I'm trying to find a query which will return me a list of the foreign keys for a table and the tables and columns they reference. I am half way there with SELECT a.table_name, a.column_name, a.constraint_name, c.owner FROM ALL_CONS_COLUMNS A, ALL_CONSTRAINTS C where A.CONSTRAINT_NAME = C.CONSTRAINT_NAME an...
I am attempting to figure out if a column in oracle is populated from a sequence. My impression of how oracle handles sequencing is that the sequence and column are separate entities and one needs to either manually insert the next sequence value like insert into tbl1 values(someseq.nextval, 'test') or put it into a table trigger. M...
I have an RIA Services Silverlight 3.0 app using an EF model. In the model metadata I've included several Display Name properties that I'd like to use when referring to the model on the client-side (in TextBoxes, etc.. .) I'm using reflection now to get the properties of the model on the client so that if the model changes over time, I ...
Within the property window of a JPEG image, there is a tab called 'Summary'. Within this tab, there is a field called 'Comments' I would like to write some c# code which will add a given string to this field e.g "This is a photo". Does some kind soul out there know how to do this? Many thanks. ...
We allow our uses to alter certain views for reports and what not based on some application field meta data that we keep track of in our application. These fields can be created at run time. I have a standard process in place to alter the views when a field is added or removed. I now need to do this programmatically however, which mea...
I am using VFW unit from JEDI wrapper on WinAPI. The code I am writing is intended to search user drives and detect warez. We do MP3, WMA and some graphic file search. Now we want to detect illegal movies. I want to open AVI file, read some details from it and close it. I have the following code: uses WFV; //from JEDI api wrappers pro...
I have an HTML page containing alot of meta tags and I want to parse them to find certain ones. Here is the code I am using, but it's not picking up any of the tags. $dom = new DOMDocument(); $dom->preserveWhiteSpace = false; $dom->loadHtml($contents); $metaChildren = $dom->getElementsByTagName('meta'); var_dump...
I need to add a delete flag column to all 40 user tables in a database. I could write a script to loop through sys.tables, but I thought I'd check and see if anyone has either a better solution, or pre-created sql for this scenario. ...
I am trying to get metadata about parameters of a stored procedure that is defined in a package using C++ Oracle OCCI. Getting parameter metadata of a standalone proc is straightforward: MetaData meta = connection->getMetaData("MY_PROC"); vector<MetaData> params = meta.getVector(MetaData::ATTR_LIST_ARGUMENTS); However, if I try to que...
Hi all. let's say I have class A and class B. Class A's definition is: /// <summary> /// This is the class documentation. /// </summary> public class A { /// <summary> /// This is the documentation for attribute. /// </summary> public int attribute; ... } I want to access the documentation from class A (ie. those ...
Are there any good .net libraries I can use to read and write tags, people tags, date take, et cetera that are compatible with Windows Live Photo Gallery? ...
Background I am using a legacy database with all kinds of ugly corners. One bit is auditing. There is a table listing tablename/field combinations of fields that should have an audit trail. For example, if there is a row that has "WORKORDER" for the table name and "STATUS" for the fieldname, then I need to add row(s) to the auditing tab...
I need a mechanism for extracting bibliographic metadata from PDF documents, to save people entering it by hand or cut-and-pasting it. At the very least, the title and abstract. The list of authors and their affiliations would be good. Extracting out the references would be amazing. Ideally this would be an open source solution. The ...
Is there an existing XML schema that can be used to describe a generic file format? Something that would have tags that say things like "The file has a header that is x bytes long", "The first element of the header is a 4 byte unsigned integer that represents the length of the file", etc. ? I need a format of this sort and wanted to ma...
What management tools (open source or otherwise) are there to track the location of data, the services that deliver/use that data and the services themselves. If you believe the snake oil a combination of DB, ESB and SOA will deliver anything anywhere, but how do you know what's where. BTW I'm not interested at the WSDL level, I'm thinki...