I have an array of ID:s, and the ID:s are in this format: Bmw_330ci_89492822 So it's a string! Now, I have this code to find whatever is in that array, in MySQL: ($solr_id_arr is the array I mentioned above, it contains string ID:s) ex: $solr_id_arr[0] outputs Bmw_330ci_89492822 $solr_id_arr_imploded = implode(", ", $solr_id_arr);...
I have a software in PHP and postgres that I use for invoicing. I am running a stock management system that I created. i am trying to create a stock movement page where I can see when a part came in, where it was issued and when and also when it was credited (if it was). I am running 5 tables for the stock. My main one is part2vendor, pa...
I m creating a window application using MS-Access as my database since data volume is not large. I want to create it in accdb format i.e office 2007 then will it work with my application on any machine where there is no MS Office as mdb works on any machine. ...
How can I do this in OO PHP: A form ('in newstudent.php') asks the user to enter his name, course and year. After selecting 'Submit' button, the page will go to 'records.php' records.php - contains a table that displays all the records (columns: name, course, year) when the user selects 'Submit', the new record will be added to the dat...
Does anyone have any thoughts about making Simile read data from a database without using XML? Or is XML definitely the way to go. I'd like to hear about possible alternatives and opinions around what would be the most optimal solution. The data I will be using are basically just coordinates and geographical names, as well as some small...
Hi, I'm looking at a potential piece of work involving a fairly complex data capture and management site and am wondering how best to approach it. I would be using a LAMP architecture. The backend will involve: Mass user creation via user uploaded csv file - I have done this before so am confident about this part. Once registered, us...
I want to add users in same role in more than one database. However the role can/cannot be present in all the database. How can i check if the role exists in database and if it does add users in that role? e.g. IF role exists BEGIN Add user in role END ...
I've been assigned the task of testing our database. It's a test database and we can do anything we want to it and easily roll it back. I've been given this task because we're still in design phase'ish (meaning any changes at any point in time of the project can happen... renaming the Person.FirstName column to [First_Name] and later ren...
I need to update all column names in an Access database of 8 tables. In short, each underscore in a column name should be replaced with a space. Can you recommend a fast method for doing this? ...
I have data that kinda looks like this... Elements Class | Synthetic ID (pk) A | 2 A | 3 B | 4 B | 5 C | 6 C | 7 Elements_Xref ID (pk) | Synthetic ID | Real ID (fk) . | 2 | 77-8F <--- A class . | 3 | 30-7D <--- A class . | 6 | 21-2A <--- ...
I have this code on a wordpress site, in a custom table. The page is here: http://ulsandbox.org/bbtb10/?page_id=183 Code: <h1> 2009 Authors List</h1> <h3> Click on each author to read more about them</h3> <p> </p> <hr align="left" width="75%"> View Categories:<p><a href="#childrens">Childrens</a> | <a href="#fiction">Fiction</a...
In R's DBI package, I'm not finding a facility for using bound variables. I did find a document (the original vignette from 2002) that says about bound variables, "Perhaps the DBI could at some point in the future implement this feature", but it looks like so far that's left undone. What do people in R use for a substitute? Just conca...
I am developing a website that has user profiles, accounts, account settings, inboxes, etc. just like Facebook or LinkedIn and I'm wondering how to set up the mySQL tables for it. Should I create a table for every user for each function (profile, inbox, etc.)? ...
What command do I use on a mysql command line to see all the databases on some database server that I have permissions to? Specifically I am looking for the DBs that I have full CRUD permissions to. ...
My current project uses Visual Studio Team System for Database Professionals GDR2 (aka DataDude). We are the only application using the database that we model using DataDude. My company would like to consider using DataDude across the board on all our projects. However, I am not sure how well this will work with projects that share a ...
Hi, I noticed that now and then my app can't find my database sqlite file anymore. It copies a new one and i am left with an empty database. I also noticed sometimes it switches to a previous database file, and i suddenly see data i filled in another time. I think and hope this has something to do with the iPhone Simulator and not with...
I tested that it is possible for Android to pass newVersion < oldVersion to SQLiteOpenHelper.onUpgrade() method, ie. it wants the application to downgrade its database. I don't want to handle this case, though I would like to notify the user somehow that there exists a newer version of my application (which she apparently had installed...
I'd like some advice designing my database tables for a small project I'm working on. Assuming in this systems I have articles, subarticles, and comments. Each article can have subarticles. Both articles and subarticles can have comments. I considered having an autoincrementing int primary key for each table (i.e. articleId, subarticl...
Hey everyone, I am tweaking a website to make it easier for employees to edit products. Right now, someone has to login to the DB and change prices, and then someone has to change the physical html of the website itself. So I am writing code that pulls all the products off the DB, and displays them on a page which can be edited. I thi...
I have a classifieds website, and it is using MySQL as a database. My goal is to show the number of private, company and total ads in the db with the search-term entered in a text-input inside the form! The Problem: There are two types of ads: Private, and Company. The user may specify which to display, or both, so thats three options....