2,569 Topics
 | |
| | How do I replace 63 strings in a .sql via php. Im making a multiforum software and I can't figure this out.  |
| | 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] …  |
| | hi.. i'm trying to retrieve the data from database using ssis package.. database name is employee which contains 48 tables and it is around 20GB of memory.. it is a production database.. now what i want is to retrieve the data for each four hours.. i.e i want to execute …  |
| | Hello, I made a PM system but the thing that makes it read isn't working. Can you take a look at it anybody? [code] $postid = $_GET['postid']; mysql_query("UPDATE pm SET read=1 where id=$postid") or die(mysql_error()); [/code] And it gives this error: You have an error in your SQL syntax; check … |
 | Morning, Please a clever person help me, i am using VS2010, I have a form with a button with the following code. [CODE]Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Button1.Click Dim cryRpt As New ReportDocument Dim crtableLogoninfos As … |
| | Morning all, I have the following code that gets a jpg image from sql which works fine. What i would now like to do is save this image as a file on my pc in a temp folder that i can use in a report. i would like to change … |
| | Hello all I am on a windows application form where people can log in and add status ... and it's all online via sql database. What i am looking for is a sql query that Insert into the table the current time,so i can print on the application the time …  |
| | Hello all I am on a windows application form where people can log in and add status ... and it's all online via sql database. What i am looking for is a sql query that Insert into the table the current time,so i can print on the application the time … |
| | 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 … |
| | I am still fairly new to PHP, so I will do the best at explaining what I am trying to do here... I have a database table where I store a bunch of invoices. I am now trying to make a front end to run queries. I don't know how … |
| | 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" …  |
| | hello, I have a simple problem. I need to create a new table "smaller" using the data from an old table "larger" table. When I say smaller I mean it will have the exact structure as the older table but will have only a few records. Now, i know that …  |
 | 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 … |
| | Dear all. I need help regarding on my error.. this is the sample code: [CODE] Private Sub GetDetails(ByVal id As String) Dim conString As String = (ConfigurationManager.ConnectionStrings.Item("ItemListing").ToString) Dim objConnection As New MySqlConnection(conString) objConnection.Open() Dim sdr As MySqlDataReader Dim sSQL As String = " SELECT i.SuppCode,s.SuppName,s.telno,s.Faxno,s.email,s.Salesman,s.Mobileno,s.add1," & _ " i.masterefno, i.invoicerefno,a.remarks, … |
| | |
| | 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? |
| | Hi, I'm new to mySQL and I've got to run a bunch of queries on a database that I've been designing for a hypothetical record company. If anyone could check my queries, I would appreciate it greatly as they don't seem to be returning the correct results and I'm not … |
| | 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 = … |
| | I have an sql table called Stock with two fields called StockID and StockCode. I want the user to select the stockcode from a combo which in turn populates the stockid for that item into a lable on my form. I have already populated the stockcode into the combo but … |
| | 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 …  |
| | Hello Frnds, I have an application developed in ASP.Net(C#) and MS SQL, its working fine and fulfilling the requirements. Now the problem is I have a [I]MS Access Database[/I] from where I have to read some data and feed it into ASP.Net form and then save it to [I]MS SQL … |
| | Hi, everyone this is my first post here and let me tell you my problem I have a C# application, i have SQLServer 2005 installed on my computer my database is there and the program works fine the problem I'm facing is that i need to make an installer for …  |
| | 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 …  |
| | Hey everyone, New to the forums, as this will be my first post. Im having a problem with a tableadapter/tableadapter query. My query is: [CODE]SELECT * FROM subject_assessments WHERE (sa_id = @sa_id)[/CODE] sa_id is a varchar, if that is relevant in any way. My table adapters then look like this: … |
 | 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 … |
| | Hi all, As you will be able to tell i am very new at VB.net. i have the following code that adds three text fields to my sql table. it works if i input numbers i.e the number 1 in all three feilds but as soon as i in input … |
| | 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 … |
| | the problem is that its an undifined varible ($last) intill i type the second word, i [code=php] if($_POST) { $q=$_POST['searchword']; $q = explode(' ', $q); $first = $q[0]; $last = $q[1]; $sql_res=mysqli_query($mysqli, "select * from dogs where firstname like '%$first%' and lastname like '%$last%' order by id LIMIT 5"); while($row=mysqli_fetch_array($sql_res)) … |
| | I cannot get this mysql update query to work. Please help. I am new at this.:) <?PHP session_start(); ?> <?php //it's getting the data from the post fine. I know this part is working. $ud_id=$_POST['ud_id']; $ud_fname=$_POST['ud_fname']; $ud_lname=$_POST['ud_lname']; $ud_type=$_POST['ud_type']; $ud_used=$_POST['ud_used']; $ud_sdate=$_POST['ud_sdate']; $ud_edate=$_POST['ud_edate']; if ($ud_id == "") echo " No record ID … |
| | Hi guys, My group is having a software development project for our academics at a university. The software we want to develop is an inventory system which will be installed in a Local Area Network. We have decided to use Visual Studio C# (2005 or higher) as the front-end while … |
| | 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 All, In my development of an online application, I have to generage the serial no for the available number from the serial number table in sql server. Multiple users will hit the table to generate the serial numbers. So the serial number should not be repeated. I have to … |
| | 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 …  |
| | Hello, I am new to Access and VB, but I have used C# and C++. I am trying to update a whole bunch of records in a table, only one field. For example [CODE] [Employees] [ EmpCode ] [ FirstN ] [ LastN ] [ 019871 ] [ John ] … |
 | I have a web app that when run locally runs as intended. Once published to my server it does not. The issue is related to sql's integrated security. The webservice/sql call is using "domain/machinename" as the login, instead of my active directory credentials. There is no sql security login for …  |
| | 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 folks I need some help! I have two tables the first contains account information, and the second contains flags that records in the account table may have. These are joined by the account?id. One account record may have several flags from the flag table. ie the following select select … |
| | 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 … |
| | PHPMYSQL - How do you perform a double SELECT query or check against multiple fields? Does anyone know how this can be achieved? What i want is from a search page that has multiple search areas such as name / description / functions and be able to type multiple search … |
The End.