I want this script to check to see if the same word has been entered if so it should add it to the count not add a duplicate tag. And if the tag entered is a new tag then let it add it to the database. Can some one help me fix this? $tag = mysql_real_escape_string($_POST['tag']); $query = "INSERT INTO tags (tag, count) VALUES ('$tag',...
I have been asked to create a graphical representation of our database, I have looked at tools such as, lucidcharts. Are there any good tools that I can use to graphically represent the database and it's relationships? ...
i have my c# application in c:\program files\app\ folder i am using sqllite database my code working perfectly while logging via windows administrative user, if i change window user account to limited, i couldn't open my database public void OpenDB() { SQConnectionString = "Data Source=" + DBPath +";Pooling=true;FailIfMissing=false"...
what is the best way to store long texts (articles) in a database? it doesnt need to be searchable. i want to allow ppl to read the first chapter of every book in my bookstore. dumping it into a database field makes it difficult to style paragraphs using css.. EDIT: access database ...
Pretty simple question, I know. ...
For instance, I have a movie/item. It opens on Jan 1 2010 and finishes on Jan 10 2010. Do I create an entry for each date that the movie/item occurs, repeating all the data for each date? or do I create two nodes within the movie/item specifying a start date and end date and create an argument to provide all the data as needed? I want t...
According to the Wikipedia article on Google App Engine: The where clause of select statements can perform >, >=, <, <= operations on one column only. Therefore, only simple where clauses can be constructed. What does this mean? ...
A client is receiving a "You don't have permission to read [REPORT NAME]" error message when attempting to launch a report in a MS Access database. When I go to the “Change Owner” tab under Tools > Security > User Groups and Permissions, the owner is <unknown>. If I attempt to change the owner, I get a "You don't have permission to cha...
I have recently been introduced to the new Access 2007 feature which is multivalued fields. My initial impression is that it is a bad idea to make use of multiple values in a single field. Traditionally if you wanted to allow for a record to have several values for a field you would create another two tables and link them with foreign ...
I'm using a GridView and a LinqDataSource to view the Categories table. I set the Gridview to enable sorting. Sorting generally works except when i clicked on the header of the Description column. "An order by expression can only contain non-constant scalars that are order comparable by the server. The expression with type 'NText' is no...
So I've got a large database that I can't hold in memory at once. I've got to loop over every item in a table, process it, and put the processed data into another column in the table. While I'm looping over my cursor, if I try to run an update statement it truncates the recordset (I believe because it's re-purposing the cursor object)....
I have table as shown below. In order to workaround one default now column restriction of MySQL I used the tip as shown here CREATE TABLE IF NOT EXISTS mytable ( id INT NOT NULL AUTO_INCREMENT , create_date TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00' , update_date TIMESTAMP NULL DEFAULT NOW() ON UPDATE NOW() , PRIMARY KEY (`p...
What advantages (if any) does Weblogic 10.0 provide in terms of database connectivity (to any database) over open source or commercial alternatives? Are there any Weblogic specific gotchas with using a Weblogic database connection? I'm a J2/JEE, Weblogic newbie so please excuse the simple questions. ...
So this is the scenario: You have a bunch of data that needs to end up in SQL. It needs to entered by hand. It is not an "enter once and you're done" scenario: it will need to be modified and expanded by humans in an ongoing iterative way. Comments will be associated with entries. It is also useful for data entry people to be able to ...
Hi, I manage a server with around 400+ databases which have the same database schema, i wish to deploy a custom clr/.net user defined function to them all, is there any easy way to do this, or must it be done individually to each database? Best Regards, Wayne ...
Hi all, I came across a CMS known as GetSimple. It uses XML for storing all its internal data. In a way it is using XML as a database. Now could anyone explain me the advantages & disadvantages of using XML as a database. Thanks in Advance. Tanmoy ...
I'm currently using Microsoft Sync Framework and everything is working fine except the SQL triggers which don't appear to fire sometimes. Here is the trigger code generated by the framework. It works 90% of the time but occasionally the CreationDate is NULL after an insert. Could there be some date issue that I'm overlooking? set ANS...
I was about to use Firebird for a project, when someone told that DB2 Express C is also free, and with plethora of tools, and is also mature. I read Firebird is also good for use as enterprise client/server database. Then how does it compare to DB2 Express C? Could the experienced ones shed some light on this. ...
Currently I have a c# silverlight business application. The application is hosted in Asp.net using the ADO.Net entity framework and a domain service class to read/write to/from my sql server database. The structure of the database is as follow. I have three tables. Job, Audit & Image. One Job can have many Audits, and One Image can have...
Hi, do you know any ways how to protect your database in Android? I consider following ways, but don't know whether it is possible to do: access to database has only application owner (which created and serves it) restrict or deny access to database to all applications during the usage session of DB owner application are there any wa...