[sql] Forum Topics

Hello, I need help transforming a current script into on that can loop through some data for me. As you can see I currently have the ItemName and Address commented out "-- Set @ItemName = '95B046125' Set @Address = '195 WELLESLEY ST E'" and then I have to uncomment it …

Afternoon All, I have ran into a problem that i cant get my head around, I have the following code(see below) this all works fine if there is a imgID ='5' but if there isn't a record in the sql table with the imgID 5 then i get the following …

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

Hey everyone, im currently designing a database. i usually design my tables with "LastUpdate" field with a smalldatetime data type for tracking purpose. which is whenever user insert or update a row. there's a trigger that updates that specific field. now, i was thinking to split the information of "created …

I am trying to carry out a synchronisation of two databases one on the server and the other on a local machine so that even when they are not connected on the networkthe local database can carry on accepting data but when the network is back on the local database …

I have an xml file, structure like so: [CODE] <people> <person.1> <fname>brian</fname> <lname>smith</lname> </person.1> <person.11> <fname>joe</fname> <lname>carey</lname> </person.11> </people> [/CODE] I am using openxml to read this file and insert names (and other person information) into a table. [CODE] DECLARE @person xml, @idoc int EXEC sp_xml_preparedocument @idoc OUTPUT, @person INSERT …

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 …

Ok, so I've been looking all over the web to try and solve my problem... I have an SQL 2005 database on a web server which displays information to customers via an asp.net web site which also offers interaction with the data. I also have a Windows .Net application which …

I am making a program on library management but in my program I am getting the error when I am extracting the date from MySQl(my database). Below is the short piece of code where I am getting the error. [CODE] Calendar c1=Calendar.getInstance(); ResultSet rs=stm.executeQuery("Select AccessionNumber,Name,Fine,DueDate from issuer natural join classinfo;"); …

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 …

hi there, i have a machine installed MS server 2008 and in that it has MS SQL express , how can i connect othe MS SQL express from another PC in the network what is the toll that i need to have appriciate a lot thanxxxx

Table name = Contacts. Table attributes = first_name,last_name,email_address,other_email,address,phone,notes. I want to retrieve without repetition(DISTINCT) first_name and address. But, when retrieving these 2 data, i want all the other data(notes,last_name,etc..) associated to this the DISTINCT data to show. Is there any SQL data for this kind of situation?

I am starting a new website.I want a best Login Logout Php mysql script with for get password fearutes.Where i can get it. Please help me

I want to search through an sql table called hardware for a partial serial numbers. I have the following code but there is something wrong with the way i am doing my sql query. hope someone out there can help me. [CODE] Public Function GetDatabysn() As DataView Dim SelectQry = …

Hi everyone! I have a query that take 5-10 minutes to run. And I use this query in ASP.NET Web Application. How can I manage to cancel query? For clarification lets say 2 buttons are on the form,one for starting and other for cancelling the query,is it possible if so …

Hi, i am using c# window application I have create one Login Form. I want that when user put its username and password first it should check in the database and then it should give the out put. i have even create on signup form first it should be register …

Hello, I would ask if there is a possible method that would return a String in JAVA that I can retrieve the SQL code of any table on my embedded JAVA DB in my application. It is like the function of the phpmyadmin where in you can import a certain …

Morning all, Hope you can help. I normally use VB6 for my projects but thought i would look at Visual studio 2010. I have a windows form with a connection to my sql database which is working fine. i want to be to select data and input that data into …

Hi there, How can I write a stored procedure to select a value from a table and return that value?? I have a table Employee, when I send the email as a parameter to the stored procedure, I should get the employee number (it should return the employee number) I …

hi... to all.. i've written the code in expression field... =format(sum(fields!salary.value),"##\,##\,##\,##\,##\,##\,##0.00") the code is for printing the number in this format(12,23,23,34,123.00) now i got an problem i.e if i give 5 digit the it will print ,,,,,12,123.00 the remaining commas are printed.. i dont want to print the extra commas.. …

Hello, I am looking for a means of database interaction in which the database will be stored on a user's machine but with no actual server software running. I have read there is some way to create databases in SQL express and then take the files for use in your …

hi everyone i need your help i want to write a code that gets for me the latest 5 out puts here is my code [CODE] <?php $con = mysql_connect("localhost","awah","pass"); if(!$con) { echo "cant connect to db".mysql_error(); } $select = mysql_select_db("awah_admin"); if(!$select) { echo "cant select db ".mysql_error(); } $query …

'A way to connect to SQL with VB.Net using Classes 'This must be a class on its own Imports System Imports System.IO Imports System.Data Imports System.Data.SqlClient Imports System.Web Public Class frmConn Public Shared Function ConnSQL() As SqlConnection Dim connectionString As String Dim cnn As SqlConnection connectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\App_Data\test_db.mdf;Integrated Security=True;Connect …

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 …

Hi all! I have a program that runs as a large form (Form1) with smaller forms that open inside of it (PeopleBox). It's for friends/contacts - each person gets their own row in the database (PeopleDB). At runtime I'd like it to open a PeopleBox for each person already existing …

I'm trying to set up performance dashboard in SQL Server Management Studio Express. I'm currently running SQL Server 2005 SP3 ('product level') and also have installed the Performance Dashboard add-on. A couple of forums I've seen said that I could access the reporting feature by updating the Management Studio Express …

I am trying to pull data from a table to fill a drop down list. Now, i got the fill part working, but am having an issue passing a variable value to my form post action. Code: $query ="SELECT UniqueIdentifier, LastName, FirstName FROM BrokerMain ORDER BY LastName"; $result = @mssql_query($query); …

Im Writing a c# Code that Takes an Excel Sheet ,creates the Corresponding SQl table and Dumps the data in a new table in SQL. Now My problem is: In the " create table" command , i have to specify the DATATYPE for the column !i.e. CREATE TABLE "table_name" ("column …

Okay.. Currently i already had this code for my registration form [CODE] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.Sql; using System.Data.SqlClient; namespace Thesis { public partial class Registration : Form { Form formParent = null; public Registration(Form par) { …

HI Can anyone tell me that how to configure php.ini For $_FILES['name']['type'] I am trying to upload a flv video and it is uploading successfully but it is not showing me the type. But if i upload a .mp4 extension file it is giving me the type also and can …