Hello All, I need a bit of advice regarding my final year project. I dont want any help with code but just on what path I should take. My project based on using triggers to solve business problems. I am not sure, on how I should approach this really. if I had a busines problem, it would have made it easier. But, I have not got a business problem. It just make its really complicated. Can you guys give me some advice, on how I should approach it? Thanks for all your help

Member Avatar
Member Avatar
+0 forum 2

How can I send some data to a MySQL database? I'm using php.

Member Avatar
Member Avatar
+0 forum 5

Hi everybody, I found an error-based sql injection in my webserver.My database doesn't contain any private info. I want to know if its possible to own my server just by using the info in information_shema. Please tell me because i want to know if i have to fix it.I don't want to get hacked! Thanks. I can provide additional info if you need it.

Member Avatar
Member Avatar
+0 forum 2

Hi i have the following code. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New OleDbConnection Dim da As New OleDbDataAdapter Dim ds As New DataSet Dim dsnewrow As DataRow Dim cb As New OleDbCommandBuilder(da) Dim a As String con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\DB.mdb;Jet OLEDB:Database Password=123" con.Open() a = "select * from Login" da = New OleDbDataAdapter(a, con) da.Fill(ds, "Login1") dsnewrow = ds.Tables("Login1").NewRow() ds.Tables("Login1").Rows.Add(dsnewrow) dsnewrow.Item("Lid") = "test" dsnewrow.Item("Name") = Uname2.Text.ToString() dsnewrow.Item("Lps") = psw1.Text.ToString() dsnewrow.Item("Acces1") = Acs.Text.ToString() dsnewrow.Item("Date1") = DTp1.Value.ToString() [COLOR="Red"]da.Update(ds, "Login1")[/COLOR] Uname2.Text = "" psw1.Text = "" Acs.Text = "" DTp1.Value = Today() con.Close() …

Member Avatar
Member Avatar
+0 forum 4

hello :) i wanted to know that how can i move my database here and there..?? i'm working on Sql using some 'xamp' named software.. i have to create few tables, then i need to give this database to my friend..he'll add few more tables in it..then finally, we have to hand over it to another friend, who will link it to some site..but the QUESTIOM IS, how can i give my database to others?? does it contain some files, that i'll have to copy?? or what??

Member Avatar
Member Avatar
+0 forum 4

Hello, I am having trouble inserting data from a XML file into a table in a SQL data base. The worst thing is it isn't coming up with an error but nothing is being inserted into the database Here is the condensed version of the XML code I am using to test with: [CODE] <?xml version="1.0" encoding="UTF-8"?> <propertyList date="2009-01-01-12:30:00" username="xmluser" password="xmlpassword"> <!-- Current listing --> <residential modTime="2009-01-01-12:30:00" status="current"> <agentID>XNWXNW</agentID> <uniqueID>ABCD1234</uniqueID> <authority value="exclusive"/> <underOffer value="no"/> <listingAgent> <name>Mr. John Doe</name> <telephone type="BH">05 1234 5678</telephone> <email>jdoe@somedomain.com.au</email> </listingAgent> <listingAgent> <name>Mrs Jane Dow</name> <telephone type="BH">05 1234 5678</telephone> <email>janedoe@somedomain.com.au</email> </listingAgent> </residential> </propertyList> [/CODE] And the "insert" …

Member Avatar
Member Avatar
+0 forum 21

Hi guys, hope you can help. I'm creating a mixture of an employee scheduling system with elements of a Human Resource Management System for small to medium businesses. I ideally want to create a java application with a database backend, which I'm trying to see if I can apply sql server. I recently got sql server working in my java EE tutorial, but thats an applet and not an application. I'm almost finished with my research, just finishing off some questionaires. But I really need to finish my decide on which languages I'm going to use. Can I get peoples …

Member Avatar
Member Avatar
+0 forum 2

Dear all programmers I’ve search all over Google and have not found an answer. [B]My question is.........[/B] I have two DBF tables called product and ullage. The user enters data from products table into ullage, by searching for product id and adds their count into the ullage table. This part is working The question is how can I display the products table with all the prod_ID, Desc and price with Counts from the ullage table but were there is no count in the ullage table these product will be displayed but with no count number. [B][U]The Tables....[/U][/B] [B]Product table[/B] Prod_ID …

Member Avatar
Member Avatar
+0 forum 4

I had created a registration page for users to sign up an account and a database to store all information such as username and password. I had also created a login page for users to login after registering an account. How do I link the database so that I will know that the particular user had keyed the correct password. protected void Button1_Click(object sender, EventArgs e) { string username = TextBox1.Text; string password = TextBox2.Text; SqlConnection connection = null; SqlCommand command = null; SqlDataReader dataReader = null; try { string connectionString = ConfigurationManager.ConnectionStrings["TestConnectionString"].ConnectionString; connection = new SqlConnection(connectionString); connection.Open(); //prepare sql …

Member Avatar
Member Avatar
+0 forum 2

Hi I am trying open a record from a shelve db I Know that it stops working at `copy = db[opened]` But why please help ASAP #*****START VARIABEL BLOCK***** #file = the database/shelf file #db = the database/shelf object #tapp = to be appended/recorded to the database #keys = a list of all the database's keys #flag = if True = that record/rey already exists, if False = that record/rey does not exist #Name = 1st field #note = 2nd field #strkey=str(key) #*****END VARIABEL BLOCK***** def on_OpenKey_command(self, event): try: global db opened = str(self.components.key.text) copy = db[opened] tapp = [] …

Member Avatar
Member Avatar
+0 forum 4

I need the dates in a specific range.And i want to get the result in java manipulating from a MySQL database.Now how can i do so. Suppose there are 3 days 17.08.2011,18.08.2011 and 19.08.2011 .I want the dates in the range 16.08.2011 to 18.08.2011 .So how can i manipulate it in java code quering from database?

Member Avatar
Member Avatar
+0 forum 1

hi i have a question relating to date. i have a table in a database which has the start date of an employee. what i want to do is i need to know how many years have he been working. so i need to get the current date and substract it with the current date. how can i do this?

Member Avatar
Member Avatar
+0 forum 3

Greetings, I am doing a project that will migrate sybase central to oracle with the used of oracle sql developer, and when im trying to add new connection in sql developer that will connect my sybase when i try the TEST button its status is success but when i retrieving the database in sybase its follow an error that 'jtds000001' is already exist. i dont know what to do.. please help me.. regards this matter, i know you all Specialist can help a beginner like me.. Thanks you so much! Regards, Mike

Member Avatar
Member Avatar
+0 forum 5

I have a form in account.php that is prefilled with the user's current info but can be changed and then when you submit, it updates the database. However, when returned to the page after the update, the prefilled text is not updated. It only updates if you re-log in. At this point I have only messed with updating the username. ACCOUNT.PHP [CODE]<div id="main_middle"> <h1>&nbsp; </h1> <h1>MANAGE YOUR ACCOUNT INFORMATION</h1> <p>&nbsp;</p> username : <form method="post" action="update_check.php"> <input type="text" name="username" value="<?php echo "".$_SESSION['username'].""; ?>" size="40" /> <input name="update data" type="submit" id="update data2" value="save changes"/> </form> <br /> <p>&nbsp;</p> email:<br /> <form method="post" …

Member Avatar
Member Avatar
+0 forum 4

I installed Oracle 11g R2 on my Windows 7 64-bit OS.When i'm trying to login to SQL Plus,i can't.As i remember my Username and password is correct.Is there any method to login without giving username and password? or is there a way to get my username & password?Please help me....

Member Avatar
Member Avatar
+0 forum 4

Hi guys, A group of us are developing an app for the Android phone. The app is used to record down statistics, like how many messages the user has sent, or the amount of time he/she has spent using the phone, etc, mainly using it to help users compare their own stats with others through a server/site, making them more conscious about their own usage. We're having some doubts here. First thing, we have to use a code to read system log files and then save the data on external server. Is that possible to do? If yes, any pointers? …

Member Avatar
Member Avatar
+0 forum 1

What would the diagram look like and what [B]relationships[/B] would there be? It [B]stores[/B] the [B]customers (patients)[/B][B] details [/B]and [B]drug information(prescrip?)[/B]What[B] entities [/B]would there be ? e.g. customer/patient, pharmacist or doctor? or both?

Member Avatar
Member Avatar
+0 forum 1

Hi people, I have a trouble displaying the files that are in my folder. Here, I try to display the name of the files and their description. I succeeded to display their description but not the files ! Please, help me [CODE]include('Cfg/config.inc.php'); mysql_connect($SERVER,$USER,$PWD)or die('Can not connect to the MySQL server <br/>'.mysql_error()); mysql_select_db($DB)or die('Can not select the requested database<br/>'.mysql_error()); $qd="SELECT * FROM downloads"; $rd=mysql_query($qd)or die('Impossible to perform the selection query<br/>'.mysql_query()); echo'<TABLE class="tabledownloads">'; while($rowd=mysql_fetch_assoc($rd)){ echo '<TR>'; echo'<td>'; $dirdown="admin/uploads"; $dossierdown=opendir($dirdown); while($fichierdown=readdir($dossierdown)){ $berkdown=array('.','..','index.php'); $liendown=$dirdown.'/'.$fichierdown; if(file_exists($liendown)&&$rowd['systemfilename']==$fichierdown){ echo '<a href="'.$liendown.'"><font color="blue"><b>'.stripslashes($rowd['userfilename']).'</b></font></a>'; echo'</td>'; } } echo'<td>'; echo stripslashes($rowd['filedescription']); echo'</td>'; echo'</TR>'; } echo'</TABLE>'; ?> [/CODE]

Member Avatar
+0 forum 0

I am using Oracle for the first time.I installed Oracle SQL*PLUS ver 8.As I had to learn this for an exam. But I am facing the following error after I enter it with the system default scott/tiger ... "ORA-12203: TNS:unable to connect to destination" Sorry ,if this question is already asked as I searched, but didnt get. Thanks in advance

Member Avatar
Member Avatar
+0 forum 10

Hi there, and thanks first of all for hitting the link i am a beginner in the database world, and found my self required to draw a conceptual model and an Entity Relational Diagram for a Leave Of Absence system. where the system has the following schema: 1-employee request LOA from his manager, 2- loa must approved (accept or reject)first by the manager where the emp is belong to. 3- HR officer approve the approved (accept or reject) loa request after checking if emp has enough day balance. any help will be very appreciated ! Nader

Member Avatar
Member Avatar
+0 forum 1

Hi All, I have a problem and I dont understand what's happening, because my method usually works. I am querying a bunch of records from a database given a foreign key id. See code as follows [CODE] $castQuery = "SELECT * FROM cast WHERE production_id = '$newID' "; $cresult = mysql_query($castQuery, $conn); $cast = ""; while ($crow = mysql_fetch_row($cresult)) { $real_name = $crow[1]; $stage_name = $crow[2]; $cast = "<p><b>$real_name</b> ~ $stage_name</p>"; } [/CODE] I dont understand why im only getting 1 record. Any help would be appreciated.

Member Avatar
Member Avatar
+0 forum 5

Hi there, I have a question in EncryptByPassPhrase. I am trying to encrypt the source column in the database table PForm. When I run the code it sasys, “Failed to convert parameter value from a String to a Byte[].” the SourcePath column in the database is varBinary(256) type. What is the problem over here. [CODE] public void AddFormDetails(string ID, string SourcePath) { string query = @"Insert into PForm(ID, SourcePath) Values(@id,EncryptByPassPhrase('AdminApplication',@source)"; SqlCommand command = new SqlCommand(query, DB.getConnection()); command.Parameters.Add("@id", SqlDbType.VarChar).Value = ID; command.Parameters.Add("@source", SqlDbType.VarBinary).Value = SourcePath ; db.openConnection(); command.ExecuteNonQuery(); db.closeConnection(); } [/CODE]

Member Avatar
Member Avatar
+0 forum 2

Hi there, I am creating reports in SQL server business intelligent studio and when I deploy it to the report server the report is shown in only on a half a page. How can I make the report height and the width for the report thanksssss

Member Avatar
Member Avatar
+0 forum 2

Hi, I have a windows form application that is designed to monitor payments made within agreed timescales. Once a timescale has passed any payments that are outstanding will get assigned as arrears. What I need to decide is the best way to handle the task that checks if the due date has passed and then updates the related tables. I was simply using a timer control to figure out the time of day but realised that there is no garuantee that a user will run the program which would lead to the updates not happening. So i need a way …

Member Avatar
Member Avatar
+0 forum 1

Ok, I have no idea how to make this becuase I need to be able to update the Name & Password database for the Web or somewhere else. Regards

Member Avatar
Member Avatar
+0 forum 5

hi , i have a field in a table with the datatype as datetime. i wrote a query to get that feild but the thing is i want only the date to be displayed, how can i do that, currently the date and the time is being is displayed, how to i chase the query to only display the date only i ma using MS SQL 2008. and C#.NET thanks can some one help me in this thanks

Member Avatar
Member Avatar
+0 forum 1

hi everybody i need some code for auto inncrement in msaccess database file and in form textbox and if we add any data the number should increment automatically please help meee thanks in advance

Member Avatar
Member Avatar
+0 forum 1

want to build an application that allows a user to build its own form(s). A user can input data into its form and query the data too. the form can be edited after being created and used ( add/remove fields from it ). the form can have fields like: small text box, big text box , single list, check box, drop down menu .... i want to group the fields into tables according to their types... (text boxes will be grouped together in one table, drop down lists in another table and so one ) . I want to design …

Member Avatar
+0 forum 0

Someone mentioned in another thread they had found and downloaded [URL="http://search.cpan.org/~adamk/ORLite-1.45/lib/ORLite.pm"]OrLite[/URL], presumably to consider using it to access data in an SQLite database. Since, to use OrLite you need to have the DBI and DBD::SQLite modules installed on your computer as well, I think you could just use DBI to accomplish whatever you want to do with SQLite without bothering with OrLite. Nevertheless, some people may prefer the OrLite way of doing it. Unfortunately when you search for examples of how to use OrLite you may not find nearly as many as when looking for examples of using DBI, so …

Member Avatar
Member Avatar
+1 forum 1

i need to isnert in database and i have query liike that [CODE]str_attend = "insert into Attendees([Userid],[Attendees_name],[Attendees_telephone],[Attendees_Email] )values (" & userid & " ," & arr(0).ToString() & " , " & arr(1).ToString() & " , " & arr(3).ToString() & " )" [/CODE] all values hold values in insert statment non of of them is null. but it gives me an exception on insert statment .

Member Avatar
Member Avatar
+0 forum 1

The End.