Member Avatar
hi all , Am doing event management project. In jsp page am using javascript date picker. Then i passed that to servlet page by the following code. DateFormat formatter ; formatter = new SimpleDateFormat("dd-MM-yyyy"); Date date=formatter.parse(request.getParameter("date")); now I want to insert date in mysql database , How can I achieve …
by anand01 in Web Development ()
Member Avatar
this is the response i get (1045, "Access denied for user 'point3hu_leo'@'197.253.66.85' (using password: YES)") Press any key to continue . . . from pony.orm import * db = Database() db.bind('mysql',host= 'poin.com',user='pointeo', password = 'lxxxx',db = 'poi_data')
by mcroni in Databases ()
Member Avatar
Hello, how can I improve this form login with error alerts? For example, if the fields are empty, if entered data do not match any user, etc. etc. Right now my form is so, taking advantage of a class: if(isset($_POST['login'])){ //Retrieve the field values from our login form. $username = …
by Marco_4 in Web Development ()
Member Avatar
write a c++ program that asks user to insert 2 numbers
by amanueal in Programming ()
Member Avatar
form: <form> <table> <tr> <th>Subject</th> <th>Description</th> <th>Final Grade</th> <th>Remarks</th> </tr> <!-- You can loop this one, depends on the subjects. Subject must not be encoded. Baka lalagyan ng maling subject. I just base it to your design so naging ganito. --> <tr> <td><input type="text" name="grades[][subject]" id="grades[][subject]" value="" /></td> <td><input type="text" …
by breakzzzz20 in Web Development ()
Member Avatar
I have a database in mysql which contains of four tables (Student, Units, Offering and Enrols_in) and i want to create an enrolment page where students can enrol in units which will be offered in each semester. Student names will be entered in the database and they will use their …
by naithsleeray in Databases ()
Member Avatar
Hi Guys, I am trying to make a webpage using asp.net and SQL server 2008. Just a simple page through which data will be inserted to the database. But I noticed it is taking duplicate records as wel. So I used "Unique" constraint while the respective table and it is …
by Joy_3 in Web Development ()
Member Avatar
I was very tired of searching, but I did not find anything i have a from and its minted textbox and CheckedListBox the CheckedListBox have five choices and i want to insert the Items(more than 1) Checked from the CheckedListBox and the textbox into a table in the database like …
by hhaannyy in Programming ()
Member Avatar
Apparently I don’t know how to insert a row into a MySQL data base using PDP and I would like to know what I am missing This PHP PDO script does not insert data into a database. I would like to know why. It does not error out but the …
by rouse in Databases ()
Member Avatar
#include <iostream> using namespace std; //Linked List: Delete a node at nth position struct Node { int data; Node* next; }; Node* head; //Global void Insert(int data) { //Insert an integer at the end of list Node* temp1 = new Node; temp1->data = data; temp1->next = head; head = temp1; …
by n00b321 in Software Development ()
Member Avatar
Is it possible to select values from 2 columns in order to calculate another column in the database table?
by BabaRoro in Databases ()
Member Avatar
Hello, I have the below case. CREATE TABLE "PRBT"."TM_TABLE_1" ( "NID" NUMBER, "STRNAME" VARCHAR2(240 BYTE) NOT NULL ENABLE, "NORDERCODE" NUMBER NOT NULL ENABLE, "NSTATEID" NUMBER DEFAULT 1 NOT NULL ENABLE, "STRDETAILS" VARCHAR2(256 BYTE) DEFAULT NULL, "STRAUTHOR" VARCHAR2(128 BYTE) NOT NULL ENABLE, "NPICTUREID" NUMBER DEFAULT NULL, "STRLATINNAME" VARCHAR2(512 BYTE), "STRLATINAUTHOR" VARCHAR2(512 …
by fo2sh -4 in Databases ()
Member Avatar
getting syntax error into insert i don't know why :( Private Sub Button1_Click(By Val sender As System.Object, By Val e As System.EventArgs) Handles Button1.Click If txtContact.Text.Trim.Length = 0 Then MessageBox.Show("Enter Contact Number.", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information) Exit Sub End If If ComboBox1.Text.Trim.Length = 0 Then MessageBox.Show("Please Select Agent", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information) …
by Cj_4 in Databases ()
Member Avatar
Hai. i'm beginner in php. Can someone help me to insert the calculated value into database. I'm trying to insert calculated value into database but it doesn't work. This is my code. <?php $ic=$_SESSION['ic']; $query=" SELECT * FROM form WHERE ic='$ic'"; $result=mysql_query($query); $record=mysql_fetch_array($result); $query1=" SELECT * FROM login WHERE userIC='$ic'"; …
by Ayuni_1 in Databases ()
Member Avatar
<?php if (isset($_POST['import'])) { $fname = $_FILES['patientcsv']['name']; echo 'upload file name: ' . $fname . ' '; $chk_ext = explode(".", $fname); if (strtolower(end($chk_ext)) == "csv") { $filename = $_FILES['patientcsv']['tmp_name']; $handle = fopen($filename, "r"); $i = 0; mysql_query("START TRANSACTION"); while (($data = fgetcsv($handle, filesize($fname), ",")) !== FALSE) { if ($i > …
by Mir_1 in Databases ()
Member Avatar
I am trying To display the content of the table selected(Imported from MySql) in a JTable whose Structure is unknown to me . I Have Successfully added columns in Jtable but not Able to add rows which the ResultSet Object Returns. Please Help me Insert The Row DATA . I …
by AkshatGupta in Programming ()
Member Avatar
How to use one button to insert true into column Status and when clicked the second time will update column Status with false This is the table clicked the first time ====================================================== UserName | Status --------------------------------------------------------------- Steve1 | false ---------------------------------------------------------------- This is the table clicked the second time ============================================================ UserName …
by migold in Web Development ()
Member Avatar
how to create text box dynamically at run time in java and access each textbox value to insert in database.
by pawanbishnoi in Software Development ()
Member Avatar
Hello All. I'm trying to loop the following statement with PHPmyAdmin in order to add 1000 entries with the variable "i" incremented for each entry. (data and ip can be static) INSERT INTO 'TABLE'('id', 'data', 'ip') VALUES ([i], [06/03/2016],[192.168.0.1]) It's been 20 years since I've done any coding with loops. …
by Brian_17 in Databases ()
Member Avatar
I use this code to replace word file's some words with vb.net windows application text boxes values. 'use early binding Dim objWordApp As Word.Application = Nothing Try objWordApp = New Word.Application 'Open an existing document. objWordApp.Documents.Open("C/temp/word.docx") 'copy data to clipboard txtFirstName.SelectAll() txtFirstName.Copy() 'find <address> objWordApp.Selection.Find.Execute("<address>") 'copy richtext from clipboard objWordApp.Selection.PasteSpecial(DataType:=Word.WdPasteDataType.wdPasteText) …
by sashiksu in Software Development ()
Member Avatar
Hello. I want to insert data into django db from a function in the **views.py** file. I'm using **linux**, **python 3.4**, **django 1.8.2**, **PyMySQL**
by Niloofar24 15 in Web Development ()
Member Avatar
hii frnds Need Help i am work on vb.net windows application now in my application there are on update button but simply if u update the record then first delete the record then insert that's update there record but i check if E_id and E_code same then msg show data …
by Parth_3 in Programming ()
Member Avatar
Hi!, I am a beginner. I can insert, select & delete the data in a page using a single form but not able to figure out how to do update and pagination??? Any suggestions or source codes??? Pls help
by subrat4u in Web Development ()
Member Avatar
I am learning mongoDB , version 3 and I wanted to create a collection with two fileds, a date field and a descrition field. When I try to insert a document with the below syntax, from the mongo shell, I get an error and do not know how to correct …
by rouse in Databases ()
Member Avatar
i need help. my teacher told me to create a program on java gui that can send everything you input to notepad. then when you input another info in java gui. another notepad file should be made..
by awi in Databases ()
Member Avatar
Impossible to paste code. Insert form not working, giving up
by Fiorentino01^ in Web Development ()
Member Avatar
contiunally getting ORA-00907: missing right parenthesis error when trying to insert data in my star scheme using the code: INSERT INTO account_dim (account_id, account_name) SELECT (acc_seq.nextval, lds_account.acc_name) FROM lds_account; INSERT INTO account_dim (account_id, acount_name) SELECT (acc_seq.nextval, mch_account.acc_name) FROM mch_account; Can anyone make any suggestions?
by Ryan_15 in Databases ()
Member Avatar
Hi everyone, I have this issue, currently am able to save the attachment name in mysql database. However, after saving it doesn't display the attachment name in the form and so unable to open the attachment. Below is the coding. Please advise how to display the attachment name and open …
by Sophia_1 in Web Development ()
Member Avatar
**What is the best way to build a simple & clear web based Suppliers database/list for my Design agency?** Has to: -Be accessable by all my collegue's (20) by webbrowser (Security/account issue?) - Have 'Input Supplier' & 'Search Supplier' Function - Provide multiple categories : Name, Website, Email, Function, Categorie …
by Teun_1 in Databases ()
Member Avatar
i liek this game
by negitron -3 in Game Development ()