[insert] Forum Topics

I'm making a simple IP logger. I've tested the script, but the database doesn't seem to filling up. It could be a problem with the database format etc, details below. Otherwise, I must have made an newbie oversight in the PHP. Some fresh eyes would be greatly appreciated! id: INT(10), …

This is my first foray into the world of programming. I'm doing a practice project for the consulting firm I work for, and my current objective is to make my submission page textboxes insert the user input into specific tables in my database. Later I'll need to retrieve the data, …

This is my first foray into the world of programming. I'm doing a practice project for the consulting firm I work for, and my current objective is to make my submission page textboxes insert the user input into specific tables in my database. Later I'll need to retrieve the data, …

I get this error message: Insert Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'testing this thing again' at line 2 NOTE: the 'testing this thing again' is $body This is my …

Hello, I'm having some trouble with SQL CE. The below code *should* insert a record into the 'maps' table. (table adapters all set up) sometimes it says cannot insert as breaching primary key constraint, which is fine, but it otherwise fails with cannot insert NULL into iMapId. I have checked …

good, i am having trouble on how to insert record date in my access db. i am using hdate as my field and his data type is short date here is my code [CODE] cmd.CommandText = "INSERT INTO hold ([hdate], des) VALUES (#" & myDate & "#, '" & TextBox1.Text …

Hi, I am trying to generate an sql query to insert several pieces of data, most of which comes from another table, however I have one variable that comes from PHP variables as below: [CODE]insert into scores (AuditID, question_id, available_score, question, question_number, question_section) values ($auditvalue, (SELECT questions.quid, questions.question_value, questions.question, questions.question_number, …

Hi, I am new to mysql and have got a problem. I have managed to INSERT into the database and and check from it (a simple login system) but now after i login i want to copy all the data from that row and throw it into an arraylist. I …

Hello all, I'm using MS Access as my DB for a very simple web site. Everything was running nicely till all of a sudden I can't inset rows into any table in my MS Access database. In my tests I even created a fresh and clean table1 with one number …

Hey all, I've used this site quite a bit as a reference, and couldn't find a solution that worked for me. So I became a member. :) Anyway, I can't get my insert function to...function when I go to add a node. The node is NOT to be just added …

I'm a php noob and I have a feeling that there is a simple solution to my question. I have a php mysql table search that returns a result sucessfully. What I would like to be able to do is select one of the results to be inserted into a …

i have two mysql tables.A java application is working there which picks data and insert into second table.what i want is if there are less than 60 rows in targeted table then java application should stop when there is less than 60 entries only then it should insert data in …

Hello everyone, I have bound a datagridview with a table, And put a checkbox on each row .And an Insert button at the bottom. On clicking the button ,the Checked rows are to be inserted in the table. When I do that it gives an error as 'Can not Insert …

Guyz i have this insert function that is supposed to help me insert data but somehow i dont know how to actullay call it and get it to insert data [CODE] Private Sub btnInsert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnInsert.Click DataAccess.InsertNewRecord(txtName.Text, txtSurname.Text, txtID.Text) End Sub [/CODE] [CODE] …

Every time i try to run this codei get the following error: "'System.Data.DataRow.Protected Friend Sub New(builder As System.Data.DataRowBuilder)' is not accessible in this context because it is 'Protected Friend'. " this is my first time to insert using oledb and the With method. [CODE] Imports System.Data.OleDb Public Class frmAddd Dim …

i have this insert code and its giving errors because there is something wrong with the connection string. [CODE] Dim MyConnection As SqlConnection Dim SqlString As String = "INSERT INTO items_table (item) VALUES ('" & Me.txtItem.Text & "')" 'Dim data_base As String = " Data Source=.\SQLEXPRESS;AttachDbFilename="C:\vb2008\Visual Studio 2008\Projects\morevariables\morevariables\App_Data\test_db.mdf";Integrated Security=True;User Instance=True" …

can someone help me with why this code is not inserting into the database [CODE] Dim MyConnection As SqlConnection Dim sqlstring As String = "INSERT INTO Workers (FName, LName, FullName) VALUES ('" & Me.txtName.Text & "', '" & Me.txtSurname.Text & "', '" & Me.txtFullName.Text & "')" 'Dim data_base As String …

Hi All, Im trying to Insert a new row into a database and refresh the dataset. This is what I have so far: [CODE]void ButtonInsert(object s, EventArgs e) { string connectionString = null; OleDbConnection connection; OleDbCommand cmd = new OleDbCommand(); string sql = null; connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;data source=Book.mdb"; connection = …

i have this insert code that is refusing to work it is giving me error 26: something to do with the network or connection. i am using sql express 2005 and vb.net 2008 any help will be greatly appreciated [CODE]] Dim MyConnection As SqlConnection Dim sqlstring As String = "INSERT …

Ii have been working on a shopping cart, the way my cart works is that for each item in a users cart the data is stored in a database. So if the users has a hat and a glove there are 2 rows in my table, the rows are joined …

Hi, I want to insert a array variable in a another variable. I know how to get it done in php but not in JavaScript. Please advice how should I code the syntax for variable statement ? [CODE] var name[0][0]="tom"; name[0][1]=12; statement="My name is".name[0][0]."and my age is".name[0][1]"; [/CODE] I searched …

Hi, I have a windows form that adds new entries to a dataset via a datagrid using the updateAll method. Im passing in an id from another form and id like to specify this in the sata thats being written to the dataset. So by default the id would already …

Hi, I want to copy a row from a 2d vector in an existing 1d vector. I found a similar tread, which copies into a newly defined vector as such: [CODE]vector< data_type > copyRow( vec2d[3].begin(), vec2d[3].end());[/CODE] Now I want to change this code, so that copyRow already exists. My idea …

please help me it usually gives me error ( it says cant enter the values ) [CODE] <?php $host = "localhost"; $con = mysql_connect("localhost","awah","password") or die ("error to connect to the server"); // contact the table and enter the form mysql_select_db("kigalifinders_clanteam_admin", $con); $query = mysql_query("INSERT INTO contacts(from, subject, message) value('$_POST[email]','$_POST[subject]','$_POST[messgae]')"); …

I've looked at this from every angle, but can see nothing wrong. The MS Access table "LocationLinks" contains only 6 fields. LocationLinkKey - autonumber, primary key. LocationKey - long integer, required, indexed, duplicates OK LocationType - string length 4, not required, not indexed RelatedLocationKey - long integer, required, indexed, duplicates …

Hello, I want to use a JTable for displaying data loaded from a .txt file. The problem is that I don't see any methods for inserting a row. The code NetBeans generates is this: [code=java] jScrollPane1 = new javax.swing.JScrollPane(); tabel = new javax.swing.JTable(); label1 = new javax.swing.JLabel(); jButton1 = new …

Hi everyone, I wrote an INSERT for an insert form but for some reason it wont save the data tot he database. In phpMyadmin the rows are taken up with blank nothings. It seems to work but nothing is being stored. code as follows... [CODE]session_start(); $db_hostname = "localhost"; $db_password = …

Hi, I am using visual basic express 2008 . and i am adding few rows to the database using some stored procedure. it is working fine. after adding the row i am displaying in a grid using dataset . fine.but when i close the program and reopen the program i …

Hello, i'm trying to insert multiplle values into a table.. but it is being stored o in the table.. i've been trying while loop but still no progress.. the system search for user related to its specefic staff concern and then assign a course.. <form id="assign" name="assign" method="post" action="assign_training.php"> <tr><td …

Hello all, This doesn't seem that it should be terribly difficult to do, but of course it is (for me anyway). I own a golf site, and I would like to insert the world rankings, which is in an XML format file into an existing html file. I have applied …