Hi All, in sqlite SMALLINT datatype is used to store 2 bytes integer but i didn't see any Unsigned SMALLINT type to support the range(0-65535). Can anybody let me know how to achieve the same.

Member Avatar
Member Avatar
+0 forum 1

Hi, I am developing a mobile app for a health care institution. I'd like to get a suggestion on how to approach my database design. There are many user types of this app; residents, nurse, and general-staff. The "resident" has many information that other types don't have; unit_number, food_allergy, emergency_contact, next_kin_name, next_kin_phone, emergency_doctor, nurse_in_charge, medications. The "nurse" has distinct information than others; working days, shift, patients, qualifications, etc. The "general-staff" has; department identifier (clinic, store location) I have put common attributes in one table ("user_table"), such as; id(pk), name, phone no, date of birth, address. *My question is, how do …

Member Avatar
Member Avatar
+0 forum 3

Hi, I am working in a company that utilises many systems with their own databases. For example, the cafe has its own CAFE system with its own database (it could be postgresql). The Health Care system has its own database system (it could be MS SQL). The Transport booking has its own database system. And another system uses No-SQL database. I am faced with a task of producing web-based management reports to allow managers to see key performance indicators on screen. What would be the best way of accomplishing this? I would perform cross database queries of the key performance …

Member Avatar
Member Avatar
+0 forum 4

Ok, I am running php 5.4 and when I got the dreaded Fatal error: Function name must be a string in /home2/mydomain/public_html/session.php on line 3 I was like OH, BOY. Here is the code it is referring to. <?php session_start(); session_register("userid"); session_register("name"); //session_register("ID"); //session_register("ID"); ?> <?php session_start(); session_register("adminid"); session_register("adminname"); //session_register("ID"); //session_register("ID"); ?> Even after I tried changing it to: <?php session_start(); $_SESSION("adminid"); $_SESSION("adminname"); //$_SESSION("ID"); //$_SESSION("ID"); ?> I still get an error. Any help or ideas would be awesome.

Member Avatar
Member Avatar
+0 forum 2

[ATTACH=RIGHT]20145[/ATTACH][B]Building your first DYNAMIC Database application. This is Part One of a four part tutorial on how to install and use your database, Part Two will teach you how to build successful connections and Part Three will teach you how to build database interaction and management of your databases.[/B] There are tons of questions here on VB6 on how to connect to a database, how to add, delete, edit, search data within your database tables etc. This tutorial has been created to serve as a learning curve or to add more knowledge to your current code writing skills. This tutorial …

Member Avatar
Member Avatar
+1 forum 14

Is there are an easier way of serializing a vector attribute of an object in c++ using sqlite3?

Member Avatar
Member Avatar
+0 forum 2

I can serialize an object if it's class definition has attributes. So if I have an object whose class does not have attributes, do I serialize the attributes importedi in it's class definition? For example; suppose I have the following class, #ifndef BREAD_H #define BREAD_H #include "EGGS.h"; #include "FLOUR.h"; class BREAD { public: BREAD();~BREAD(); //lame example std::vector<string> selectIngredient(std::vector<FLOUR>grocery); }; #endif How would I go about serializing attributes defined in the FLOUR.h class if incase I have to? Thanks in advance.

Member Avatar
Member Avatar
+0 forum 2

I Have **"user_chat"** table name his 4 columns "msg_id" Auto Increament "chat_from_id" "chat_to_id" "chat_msgs" SELECT `chat_msgs` from `user_chat` where chat_from_id='2'AND chat_to_id='10' LIMIT 0,10 Also I have used **DESC** using above queary but not worked I want to fetch last **5 recent records** from **"chat_msgs" columns** Suggest me. Thank you

Member Avatar
Member Avatar
+0 forum 4

I'm stuck on this problem any one know the answer. **Write a query that displays the grade of all employees based on the value of the column JOB, as per the table shown below. Order the result according to the grade! ** JOB GRADE PRESIDENT A MANAGER B ANALYST C SALESMAN D CLERK E None of them above O This should be the output JOB G --------- - PRESIDENT A MANAGER B MANAGER B MANAGER B ANALYST C ANALYST C SALESMAN D etc. The database I'm using is EMP and JOB is a column within EMP

Member Avatar
Member Avatar
+0 forum 2

please am new to database management but the question i have a form for my input by new users but i want to get the user name and password from the form to create new priveleges to the database so that when the user log-in the next time his username and password will server as his login details how can i make that work...

Member Avatar
Member Avatar
+0 forum 1

Hi, I have a already designed web page with tables and stuff, but there are challenges for me to insert or include php and inserting the data that is from mysql to the tables in the webpage. I do not know how to do it to maintain the integrity of CSS. I have include the html codes below and if someone could let me know where should i place the php coding to connect to the database and how to display the datas in the table without sacrificing the looks of the page. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" …

Member Avatar
Member Avatar
+0 forum 2

Hi, I may have asked this before but why are Databases not out on their own forum? Instead of under Web Development? It isn't just Web apps that use databases and the amount of How do I get records from <Insert Database Name Here>?, How do I create a stored procedure in <Insert Database Name Here>? How do I set up a new user account in <Insert Database Name Here>?, How do I query for <Insert Characterset Here> words in <Insert Database Name Here>? etc... type questions I see on other forums (VB.net, C#) makes me think it would be …

Member Avatar
Member Avatar
+0 forum 8

According to the fourth annual [Web Application Attack Report](http://www.imperva.com/download.asp?id=419) from Imperva retailers suffer from twice as many SQL injection attacks when compared to other industry sectors. What's more, the United States remains the number one source of all web attacks. Other key findings of the report include the startling revelation that one website was observed to be under attack for 98% of the time, or 176 out of 180 days if you want to be precise. One web application was seen to receive a mind-boggling 94,057 SQL injection requests in a single day which, if you do the math, works …

Member Avatar
Member Avatar
+3 forum 1

I'm not sure if this is the right place to ask , but is this erd valid? Or is it unacceptable? Thank you for any help.

Member Avatar
Member Avatar
+0 forum 2

I have to make a database system that is purely on SQL Server. It's about a diagnostic lab. It should contain at least 40,000 distinct patient records. I have a table named "Patient" which contains an auto-generated ID, Name, DOB, Age and Phone number. Our teacher provided us with a dummy stored procedure which contained 2 temporary tables that has 200 names each and in the end he makes a Cartesian product which is supposed to give 40,000 distinct rows. I have used the same dummy stored procedure and modified it according to our table. But the rows inserted are …

Member Avatar
Member Avatar
+0 forum 1

Good morning Guys, I've got this code currently running: private void button1_Click(object sender, EventArgs e) { SqlDataSourceEnumerator sdse = SqlDataSourceEnumerator.Instance; DataTable table = sdse.GetDataSources(); foreach (DataRow row in table.Rows) { instanceCombobox.Items.Add(row["ServerName"].ToString() + "\\" + row["InstanceName"].ToString()); } Which gives me the Instance and Name of the SQL Server over the Network. I'm now looking to Cycle through available databases on the 'Selected' Instance. Ideally the Databases for the 'Selected' Instance in the 'Top Combo Box' would be in a seperate 'ComboBox. I checked the Databale through debug but the information is not held there so cannot call it. Any help would …

Member Avatar
Member Avatar
+0 forum 2

I am running a script on our production database reffering two tables : our table of users (3700 of them) and the table of quotes that they have made (280000 of them). Quote is the main object in our application, a very large object, for whom many data tables are created and filled. My goal is to clean database from all quotes but those made of a small group of users. I first create a temp table containing ids of those users (it is used else in the script also) and then a cursor that runs through the main table …

Member Avatar
Member Avatar
+0 forum 6

Hey guys, have a quick multiple database connection question I hope will be simple to answer. I've worked with this type of situation several times, but I must be missing something. I have a newspaper website that has 8 databases (news, obituaries, opinion, etc..) which can hold about 7 counties (flagged by a county column variable). I created the seperate databases instead of creating multiple tables on one database, for mass stoarage. I'm trying to create a search-engine to view all past articles based on form input. Maybe it will just be easier to look at the code... Form.php <form …

Member Avatar
Member Avatar
+0 forum 3

Hi, It is possible to make a software with a database such as MS access and make it available for everyone without need of a server or without a need to install the database software and/or make the database from scratch? Thanks Mario

Member Avatar
Member Avatar
+0 forum 1

i have tblStudents and tblDepartments, so which keys a weak entity (student_department) would have ? studentid and departmentid ? is it so ? and both foreign keys will work as a composite primary keys ? is it ?

Member Avatar
Member Avatar
+0 forum 2

when i use sha 512 on password field then it says k pasword field cannot be empty but when i remove sha512 constraint then it works and with any other hash it also works why ? and plz suggest me some good secrity hash etc to apply on password field

Member Avatar
Member Avatar
+0 forum 7

In sql server 2008, i have a store procedure which has insert statement , now i want to insert multiple records at a time into table via EXEC. MY Store Procedure: insert into tblUser(fullname, email, loginID, password, DOB, question, answers,doc,roleid) values (@fullname,@email,@loginID,HASHBYTES('sha512',@password),@dob,@question, @answers, GETDATE(),@roleid ) Now how to insert multiple records via EXEC exec dbo.appReg_sp 'Hunain','smile','fdsaf','password','1999-12-1','asas','sasa',1 ; now what next ?

Member Avatar
Member Avatar
+0 forum 7

i have this page in hard form and i need to make a table for it in DataBase (Sql Serber 2008), i tried alot but couldn't find any way to make table for it in data base. + i have also user table in DB, so userid should b also foreign in it. Check the attached image. IMAGE: ![academicrec1](/attachments/small/3/academicrec1.jpg "align-left")

Member Avatar
Member Avatar
+0 forum 1

Help, I need a free hosting site! I have a website made of PHP that I need to upload to a web server and a VB.net application on my PC, I saw tutorials on how to connect my VB.net application to my database located in the web server with my website, my problem is I can't find a free webhosting site that would allow my remote application to establish a connection to my database residing on their server. I'm just a student thats why I don't have money to pay for webhosting services.

Member Avatar
Member Avatar
+0 forum 2

Hoi At the moment I'm learing Databases. this is some code that I'm using. The question that I have is, can I insert a row without ID. I mean that the database increase the ID number itself. Thanks in advance. command = new OleDbCommand(); command.Connection = connect; command.CommandText = "INSERT INTO Calendar (ID, Datum, Titel, Opmerking) VALUES (@ParaID, @ParaDatum, @ParaTitel, @Opmerking)"; command.Parameters.AddWithValue("@ParaID","ID" ); command.Parameters.AddWithValue("@ParaDatum", Calendar1.SelectedDate.Date.ToShortDateString()); command.Parameters.AddWithValue("@ParaTitel", "dit is een test"); command.Parameters.AddWithValue("@Opmerking", "dit is ook een test");

Member Avatar
Member Avatar
+0 forum 2

Hey experts. I have two database, i want to fetch values from one of the table from one database and then insert that into another table on another databse, server is same. can i do it? if yes please give some suggestions how to make it hapoen. many thanks in advance.

Member Avatar
Member Avatar
+0 forum 4

hoi I would like to learn how to work with databases. does anyone know a good tutorials or sites? because at this moment I know nothing about it. thanks in advance

Member Avatar
Member Avatar
+0 forum 2

I have a jsp page which has post comment box. I have written a servlet which takes a comment from the text area for the comment box and writes the comment to the database and redirects all the comments stored in the database to the page for display(using request dispatcher). The new comment displays along with all the previous comments. I want to have a functionality where the previous comments are displayed on page load by connecting it to the database . How can I accomplish this.

Member Avatar
Member Avatar
+0 forum 1

well i have two questions: 1-hey i was wondering is there a library or namespace in c# for creating databases? like anydbm with python?or anyway to do it? 2-witch faster? getting data from huge database or getting it from like a huge database devided to multi database i mean witch faster getting data from "db" with 20mb size or search in "db1" with 10mbsize and if there is no result search in "db2" with 10mb size? am using ubuntu11.10 with mono IDE

Member Avatar
Member Avatar
+0 forum 7

Ok I need help. I have a couple hundred databases, which are different cities, that I am trying to connect with one query. each city has the same Sports table in it. I want to put the 100 most recent results on one page . The code below gets the following error. `SELECT command denied to user` On godaddy I have the highest hosting you can have without having to handle the server myself. My nightmare would be that I would have to upgrade and take full control over the server. Please help me!!! If I take off the mysql_error() …

Member Avatar
Member Avatar
+0 forum 10

The End.