This is more of a resource question rather than technical one. I am building a website for a client who needs to categorize photos (motorcycles) and I am looking for a database of models/years/production year. If anyone knows where I can find such database please let me know. ...
I need to collect data (text and radio button / dropbox / checkbox selections) on a web form, store it somewhere, then provide the ability for users to display similarly collected data from other users, as well as search, sort, and filter the aggregate data. I can probably handle building the web form via PHP, but I'm not sure how to do...
I'm working on a new application that is basically a "library" type app similar to iPhoto or iTunes, i.e. the user enters data into the app and it handles storage rather than the user storing files himself. [Skip to last para for the meat of the question.] What is different about my approach is that I want the user to define the fields ...
I am using an array which contains the results of a database-query, which is later formatted as html (for a webapplication) or as csv (for import in a spreadsheet). I want to attach information to the array-element which has some additional information about how the data of this element can be used. For instance, array-element-data... ...
I have an ETL process performance problem. I have a table with 4+ billion rows in it. Structure is: id bigint identity(1,1) raw_url varchar(2000) not null md5hash char(32) not null job_control_number int not null Clustered unique index on the id and non clustered unique index on md5hash SQL Server 2008 Enterprise Page level compr...
I'd like to save data from a SQL Server database table to a file, then load it into another database that has the same table already created in it How can I do this? I know there should be some simple way of doing it, but stackoverflowsearch and google aren't yielding good answers (or I'm not asking a good question). ...
I have a datagridview that is bound to a bindingsource which is in turn bound to the an EDM object. I'm importing objects from a CSV file and wish to add these objects to the EDM context and have the new items show up in my datagridview. However, I do not want the new objects committed to the database until the user indicates the data ...
I'm working on a shopping cart that needs to calculate tax rates based on the ship-to county. I don't want to ask the customer for the county but instead I'd like to look up the county by using the address they provided. And to top it off, this should be free. So, does a [free] service like this exist? I couldn't find anything via UPS ...
Does anyone have any wisdom on workflows for data analysis related to custom report writing? The use-case is basically this: Client commissions a report that uses data analysis, e.g. a population estimate and related maps for a water district. The analyst downloads some data, munges the data and saves the result (e.g. adding a column ...
Hello everyone, I have 3 tables, which are each 1:n. an entry in table1 has n entries in table2, and so on. lets call them cars, wheels, and screws for illustration. Screws can be clean(1) or rusty(2) I am joining them together, because I want to count 2 things. First, I want to have rows telling me how many good/bad screws per whee...
Many languages have functions which only process "plaintext", not binary. Does this mean that only characters within the ASCII range will be allowed? Binary is just a series of bytes, isn't it similar to plaintext which is just a series of bytes interpreted as characters? So, can plaintext store the same data formats / protocols as bin...
Hi all, I am having a php file and a mysql database. i need to load the data from my mysql database to the iphone. can anyone help me in this. What is the best way to do that. Thanks in advance. Shibin Moideen A. K ...
I have a client-server application where a .NET client accesses all the data and stored procedures in a SQL Server 2008 database. Is there any way to protect all this data so that only the users I create and authorize can access this specific database? Especially the user 'sa' comes to mind. I don't like him to access all my data. ...
I need to import tabular data into my database. The data is supplied via spreadsheets (mostly Excel files) from multiple parties. The format of each of these files is similar but not the same and various transformations will be necessary to massage the data into the final format suitable for import. Furthermore the input formats are like...
I'm using Visual Studio Web Setup Project to instrument web application install kit. Unfortunately, the database is done by a Database Project created by VSTS Database Edition by my colleague(I'm using VSTS Developer Edition). It seems that VS Web Setup Project does not recognize the output of the DB project, so it can't include the out ...
Hi all, I would say I'm pretty new to this but could someone explain the basics about data types, more specifically Integers, characters, boolean, string and floating-point numbers. Many thanks! ...
Hi community, After having used an application for over 10 years, and been constantly limited by its lack of extensibility, we have decided to rewrite it fully from scratch. Because the new architecture differs from the old application, the database is also different. Here comes the problem: Is there any industrial process for migrating...
Is it possible to add an attachment within the ListInstance when specifying Default records for a list when creating it with a Feature in MOSS? ...
Hi All, I was just wondering if anyone knew of a source of standard ISO data in xml format, such as ISO 3166 (Country codes/names), ISO 4217 (Currency Codes) or ISO 639 (Languages)? If it was in any way 'official' and maintained with any changes to the standards that would be great! Thanks, S UPDATE: I can't use files with non-comm...
I need a list of common first names for people, like "Bill", "Gordon", "Jane", etc. Is there some free list of lots of known names, instead of me having to type them out? Something that I can easily parse with the programme to fill in an array for example? I'm not worried about: Knowing if a name is masculine or feminine (or both) If ...