[insert] Forum Topics

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. …

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) …

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**

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 …

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

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 …

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..

Impossible to paste code. Insert form not working, giving up

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?

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 …

**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 …

i liek this game

Hello, I have three tables in MySQL database which they are: employee, expenses and details. The details table is composite table between the expenses and employee. In the HTML form there is a table that will enter multiple data into details that will referenced with one expenses id. I could …

i want to save data entered into my form into the database but it is telling "column name or number of supplied values does not match table definition" here is my code help please Private Sub BtnSave_Click(sender As Object, e As EventArgs) Handles BtnSave.Click 'Error checking:Personal information Try cmd.CommandType = …

Dear all, I was given a project to write a software that would track contracts. Everything is successful until I read or write the current data from the JTable to the textfile. This also happens when I read the textfile and insert the data into the JTable. The exception I …

the error i get from visual studio is `Number of query values and destination fields are not the same.` below is my insert statement "INSERT INTO tbl_ViewAll(EquipTag, S_Name, S_Function, S_Failure, MC_No, MC_Name, MC_Function)" & "SELECT EquipTag,S_Name,S_Function,S_Failure FROM tbl_System UNION " & "SELECT MC_No,MC_Name,MC_Function FROM tbl_MainComp"

Hello, I am getting this error org.apache.jasper.JasperException: The absolute uri: <requiredURI> cannot be resolved in either web.xml or the jar files deployed with this application. Although the required jar is present in the classpath I am still facing this issue. But if I insert the same jar into web-inf/lib folder …

Hi,i have a code like this in .h file: #pragma once #include "stdafx.h" #include"iostream" using namespace std; // balance factor enum enum BalanceFactor { LH, RH, EH }; // treenode struct template<class T> struct TreeNode { T info; TreeNode<T>* left; TreeNode<T>* right; BalanceFactor bf; }; template<typename ItemType> class TreeType { …

I have a text box , Combo box and a dgv in a form . I want to insert text box input and Combo box selected item into dgv. combo box is bound to database table column. can someone provide me with a link or sample code? Thanks

Hi there, I created a new table and forgot to set the primary key with an auto_increment. I went back and use: `ALTER TABLE table ADD PRIMARY KEY AUTO_INCREMENT (column);` However, now whenever I try to insert a new row of data, I get the error message "Duplicate entry '0' …

so i have 2 tables here CREATE TABLE tblAcctPrd ( strAPCode VARCHAR(50) NOT NULL, datAPStartDate DATE NOT NULL, datAPEndDate DATE NOT NULL, PRIMARY KEY (strAPCode) )Engine=InnoDB; which is the parent table and CREATE TABLE tblEntry ( <----the child table strEntCode VARCHAR(50) NOT NULL, datEntDate DATE NOT NULL, strEntType VARCHAR(50) NOT …

Hi Guys, In my current task , I need to read the read the approximately 10,000 recoreds from database and need to store the same in container.Now i need to select container to store all this records inorder to generate the report.Could you let me know whether i need to …

Hi there, I am having a problem in running my frame at Java Eclipse. It always says unkown source when clicking the button. I would like to insert the dat to the Jtable but it always display like this ` ## This is the error: ## Exception in thread "AWT-EventQueue-0" …

I was transferring large number of files from computer to one of my portable hard disks by copy & paste method when it malfunctioned. Now I cannot use this external drive. There is nothing important on this drive and is not a SATA drive, although is USB 3. Please find …

<?php printf("This is the first line. \n"); printf("This is the second line"); ?> This is the code but it isnt printing in new line.

I have an old sqlite database that I am no longer going to be using but I want to transfer all of my data to my new mySQL database. I have everyone imported and it all looks good but the problem is when I order my one of my columns …

hi, I want to ask about how to declare dropdownlist in vb.net. actually I'm a newbie to this vb.net language. I'm try to insert selected item from dropdownlist into database. but the data is not inserted in the table. and I've try to change the code at dropdownlist area. but …

Hi to all, I have always had this problem where: if I have a datagrid with records like RecID Name 2 Tom 5 Rich 6 Harry To Save I will loop through the rows using the sql IF NOT EXISTS(SELECT * FROM myTable WHERE RecID= dgv.rows(i).cells(0).value say) BEGIN INSERT the …

I had a trusty external hard drive for many years, it was a 500gb Seagate which worked fine up until the other day when the internal port for the mini usb detatched from the board and I was left w/ no way to connect it to my laptop.. Seagate failed …

Hi all. Here is my problem. I'm a newbie to PHP programming. For my project I just need to run 3 Insert statements in a single button click. The concept is I have a registration form. It has parent details and children details. If parents want to register more than …