[insert] Forum Topics

Hi guy's, I am missing something, what on earth is wrong with this script, I can not get it to insert all my values into a table. [CODE] $host="localhost"; // Host name $username="root"; // Mysql username $password="1234"; // Mysql password $db_name="database"; // Database name $tbl_name="input table"; // Table name $que …

i get that error when i try and run through my code. Can any one please tell me what is wrong with my insert statement. It looks correct. [code=c] OleDbConnection connect = new OleDbConnection(); connect = new DBconnect().DbConn(""); string insertStatement = "INSERT INTO Restrict " + "([Company ID], [User Type], …

Hello, I am having a little trouble getting the variable $total to insert into mysql table. I used javascript to get the total that is in the input box. Any help is very much appreciative. Here is site: [url]http://illcomputers.comyr.com/custom.php[/url] Thank You Snippets of Code JavaScript Code [CODE] var mainitems = …

Hi all, I am executing query for SQL Server 2008 like that , [CODE]myQuery= Insert into Employee(id,name)values(' 99 ' ,' Nitin Daphale ');Insert into Employee(id,name)values('77' ,'XYZ');Insert into Employee(id,name)values(' 88 ' ,'ABC');[/CODE] Here am Inserting 3 Records in an Employee table but the problem is, if any statement fails I can't …

Hi, I have two databases (live and staging). Extra columns have been added to various tables within the staging database by another developer while they were extending the websites functionality. Now has come the time to put the new functionality live, which means taking the staging database schema, creating a …

I am having a problem with the SQL INSERT command in VB. I am trying in move data from one table to another. The problem is I am going from a table with duplicates to one with no duplicates. Since there are duplicates the SQL statement bombs. Here is the …

Hi. I'm a new guy, and I'm having trouble with inserting into a database table. I'm designing a backend for a the website of a church camp that my wife is involved in. They have member churches, and I want her to be able to input data into the database …

sql 2000 i have this sql stored procedure i want the last coloumn fAcc_Total to be updated when a record is inserted. the value in the [COLOR="Red"]fBill_Amount[/COLOR] should be add to the value of the [COLOR="Red"]fAcc_Total[/COLOR] in the same time the record is inserted if there is a value in …

Hello , Im struggling lately to insert a variable to a database table. The total columns of the table are 52 :confused: Here is the insert into database script : [CODE]<?php require_once('../Connections/my_connection.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < …

I'm writing an application to catalog a very large number of files (2 million+ files)on a share drive. For each file in the directory tree, I'm adding a record to a mysql database. The share drive is active, in that files will be regularly added; thus the app will need …

Hi, I'm kinda new to the c# programming and I have an assignment to make a simple app for accounting. So, I made a DB in visual studio, made a new project that is connected to that DB. Table B has a column 'FK_TableA'. On a form I have put …

I want to fill a Table quick. I have tried something but its not working. Here is my MSSQL-Script: [code] CREATE FUNCTION [dbo].[fillTable] ( @Amount INT ) RETURNS @Integers TABLE ( [IntValue] INT ) AS BEGIN DECLARE @Counter INT SET @Counter = 0 WHILE @Counter < @Amount BEGIN INSERT INTO …

Hi all I'm trying to learn php by myself I got as far as creating my first data base and table using the following code: [code=php]$con = mysql_connect("localhost","root",""); if (!$con) { die('Could not conect: '.mysql_error()); } //Create database if (mysql_query("CREATE DATABASE FATBYTES",$con)) { echo "Database created"; } else { echo …

Can someone tell me why I am unable to update a table in mysql using php with session data. First of all, I have done some reading around daniweb and Im not sure if i should be using UPDATE or INSERT to update the table. I have session_start(); at the …

I wonder why this does not insert data :-O [CODE=JSP] <%@page contentType="text/html" pageEncoding="UTF-8"%> <%@page import = "java.sql.*" %> <%--@page import = "dbfiles.*" --%> <% //VDbManager mgr = new VDbManager(); String sqlApp = "INSERT INTO application VALUES (NULL, 810, 2010-08-26, 2010-10-27, 30, \"Dummy Leave\", \"Dummy Reason \", \"Applied \")"; Class.forName("com.mysql.jdbc.Driver"); Connection …

Hi, I am having problems inserting data into a table using a stored procedure. When I click the button to insert the data nothing happens at all. I added a [B]server.transfer[/B] after the insert to see if it was falling over before the end of the query/insert. My code behind …

[code] try Dim da As String = "+100acs+" Dim con As SqlConnection = New SqlConnection("Data Source=RAHUL-034890AF0\SERVER2005;Initial Catalog=user_accounts; Integrated Security =True") Dim command As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand("Insert into sales_details (bill_number,product_id,quantity,rate,amount) VALUES ('" + da + " ','" + Ddpproducts.SelectedItem.ToString + " ','" + Textquant.Text + "','" + Ddpproducts.SelectedValue + "','" …

Allo all, I'm using a DataSet to collect a random comparison from a database, and then passing those values to Public Variables, then constructing two Insert Statements (which shows on screen, and is valid). With the [B]two Insert Statements[/B], I'm using two buttons (in an ASP.NET Page) that Call a …

Hi my first insert statment works ok, My problem is that I wish to insert all the selected options passed from the form. into my user_req_opt table. Some items only have 1 option others may have 10 options. [CODE] $sql = "insert into user_requests(rq_id, user_id, code_ref, code_id, cat_id, opt_yn, rq_qty, …

hi guys, im using dreamweaver8, do bear with me I'm a newbie. Im trying to insert multiple rows from a form into the same table in mysql. I mixed some code I saw online with the code generated in dreamweaver and then when I tried running the page I got …

hi i want to insert a textbox value into one column of a table. bt wht i m getting error as: Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near '{'. the code is [CODE]SqlCommand comm = new SqlCommand("insert into Sample {'email_id'} values("+ TextBox1.Text+")", conn);[/CODE] how should i do it if i dont …

Hey i'm writing my own first full website with PHP and MySQL and i've come to a problem. I know i need to optimalize it with some fewer echo's and more elses, but this is what i have now and apart from the problem, it works. On the site at …

Hi I'm doing a project where I need to have people register by entering a username and password. When they click register I want them to be added to the database, but I'm having trouble doing this. Can anyone help? This is my first time using VB. This is the …

this is my code for a simple link list...i cant solve the problem of the while loop.it is only working for "1".and i cant swap two nodes in the list and cant insert nodes in a given position...how can i do those???plz help....[CODE]//Pirate™ #include<stdio.h> #include<string.h> #include<stdlib.h> struct list_element { char …

I have a table in Access with multiple foreign key fields. I would like to populate this table from Excel with SQL. Hardcoding values works fine: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES (x,y,...)[/CODE] Nesting SELECT statements like this fails: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES ( (SELECT f_key_x …

im trying to add a new records to database access but when i click the button submit it say's Syntax error in INSERT INTO statement, OledbException was unhandled da.Update(ds, "MSHS") = syntax error INSERT INTO here's my code [CODE]Public Class StudentRegistrationForm Dim inc As Integer Dim con As New OleDb.OleDbConnection …

please help me how to insert data into database by using grid view here iam using asp.net with vb.net database sqlserver-2005 give me any code or suggestions....... pls help me urgent...........................

I'm trying to get some user data into an INSERT query using the Mysql C API (don't know if this belongs rather in the Mysql forum, let me know...) I have the following code taking some pointers from the Mysql webpage forum, but to no avail: [CODE] #include <mysql.h> #include …

I am a beginning programmer and am having a problem with adding a record to a customer table in a Microsoft Access database. I have worked for hours reading my textbook and troubleshooting to no avail. When I execute this code below the record is not added and I do …

I want insert some rows into mysql, each row shold be like this: [code] <input name="code[]" value="{code item dari data mysql}" /> <input name="name[]" value="{nama dari data mysql}" /> <input name="hrg[]" value="{harga dr mysql}" /> <input name="qty[]" value="{qty diinput sendiri}" /> <input name="subt[]" value="{autocalculated saat mengisi qty}" /> [/code] The …