[insert-into] Forum Topics

hi good day, i am having a problem about my program (VB 6.0) i want to save data from my program to the access database (mS Access 2003) the problem is that when i try to run the program, and click the button, theres an error about insert into syntax …

Hello, can anyone provide me with some sample code? VBA access. I need an insert into statement where form.control.value = some_column and another.form.control.combobox.value = some_column can anyone help? thanks

I have a transaction, there is a method calling in the tran. which makes insertion into a table, after that when i select the row that i have inserted, i find no result how can i solve this problem without changing this structure or what else can i do? Thanks …

Say I have a table like this ID -- Val1 --- Val2 1 4 5 1 7 2 1 5 9 2 9 8 2 1 2 3 9 8 3 9 5 3 7 4 3 5 7 4 7 3 5 7 9 5 4 4 How do …

This is working code $sql = "REPLACE INTO 2_1_journal (Number,RecordDay, RecordMonth) VALUES "; $insertQuery = array(); $insertData = array(); foreach ($_POST['row_id'] as $i => $row_id) { $insertQuery[] = '(?, ?, ?)'; $insertData[] = $row_id; $insertData[] = $_POST['date_day'][$i]; $insertData[] = $_POST['date_month'][$i]; } if (!empty($insertQuery)) { $sql .= implode(', ', $insertQuery); $stmt …

I have been having problems with this code and i cant find out why I am trying to add a new element to an array. it says it goes throu butwhen i check its empty: $sql="UPDATE $title SET arole = CONCAT_WS(',', arole, '$name') WHERE op = '$name'"; if (!mysql_query($sql,$con)) { …

Yo. I am making a project in vb6. The backend is MS Access 2003. Data is entered into the form and stored in the database table. The code: With cnct .BeginTrans .Execute "INSERT INTO Employee_Info (EI_CNIC, EI_FirstName, EI_LastName, EI_Gender, EI_Birthdate, EI_Country, EI_Language, EI_MaritalStat, EI_Education, EI_Designation, EI_Salary, EI_ResdAddress, EI_ResdContact, EI_Cellphone, EI_EmailID, …

Hey all, cant get this very very simple query to work but I have been going 26 hours and my thoughts are numb. Please assist? I have error reporting on and request mysql errors but I'm getting nothing. Contents of config.php $db_host = 'localhost'; //IP of database server (most likely …

#Code for INSERT INTO into database and if fields are null, it will prompt for null fields.#

Struggling to get the following code to work. The code works if I just put an individual table in SELECT FROM, but I can't get anything when I try and do INSERT INTO table and then substitute it in. I am a complete noob at this and I know in …

Hello friends, I am working with jsp and oracle database and The problem is after inserting 3 enteries(rows) through form filling into database next enteries are not going in databse.So please suggest me something.

Hello, Despite much searching, I've hit a wall with trying to get a varying number of records inserted into a database. Here's what I'm trying to do..... I'm building an online sign on site for races at a sailing club. For the sign on page, I want to make it …

i have created a html form page(1) and php page(2) to insert records into a database from the html form, when i insert the records from the html form and press the submit button the records don't get into the database but a page open with the php code i …

[code = c][/code] I am trying to write a program that takes a 10 digit phone number and inserts hyphens between the 3rd and 4th digit and the 6th and 7th digit eg. Enter phone number: 5553459875 Your number is 555-345-9876 I've decided that reading the number as an integer …

I am trying to have a search bar where user will input a string ($var) which after i will search that sting in the field named: "itemname". i will search all the different tables in the database and create a new temporary database named: searchtable. seachtable should contain all the …

[code] Imports System.Data.SqlClient Imports System.Data.SqlClient.SqlDataReader Imports System.Data.SqlClient.SqlConnection Private Sub Button2_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Inherits System.Windows.Forms.Form Dim myConnection As New SqlConnection Dim myCommand As New SqlCommand Dim ds As New DataSet Dim cmdtext As Integer Dim action As String Dim view As DataView Dim dr …

I'm in the middle of a project development, and I'm frustrated with this problem. Im running XAMPP under Ubuntu 10.04 (Lucid Lynx) mySQL version : Ver 14.14 Distribution 5.1.41 The problem is that, mySQL is accepting null values even if the field is declared with the NOT NULL constraint. Example: …