6,934 Topics
 | |
| | 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 … |
| | hey....I have a question...this seems such a trivial question but please help me...I'm trying to use a java variable ex:- int x=request.getParameter(ID) and then use it in an sql query,like, select name,date,tel_no from items where ID=x it doesn't work...im very new to sql and jsp...so please help me get around … |
| | How Can dates be compared in SQL........? eg. startdate=10-10-2010 , end date=10-11-2010 |
 | 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 … |
| | please help me to correct my answer: [B] STUDYCASE:[/B] The Following tables from part of a database held in a relational Database Management System (DBMS). Hotel ([U]HotelNo[/U], HotelName, City) Room ([U]RoomNo[/U], [U]HotelNo[/U], TypeHotel, Price) Booking ([U]HotelNo[/U], [U]GuestNo[/U], DateFrom, DateTo, RoomNo) Guess ([U]GuestNo[/U], GuestName, GuestAddress) Note: Underlined words is primary key … |
| | good morning ... I wanted to ask you, how to make file backup and restore sql server 2000 through visual basic 6.0 application already many forums I visit and ask, but until now there is no single person who can help me Can you help me? your help is much …  |
| | |
| | Hi I have three tables [ATTACH]18183[/ATTACH] Suppliers, Supply and Parts. I want two queries. a) List the name of the part along with the Total Price. b) List the names of the supplier that list both p1(part1) and p2 (part2) |
| | 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)) … |
 | Hi there I want to know how I can save a checkbox value into sql server 2005? The check box is in my windows forms application... Thanks  |
| | I have just written this code o update my MYSQL Server with data from an Arduino Micro controller using Ethernet. Basically I want to pass the variables collected by the Arduino to the Server. Whenever I try to use this script the Values [I]$_POST['Name'][/I] [I]& $_POST['Value'][/I] do not get passed …  |
| | Hai sir! i am kannan please help me insert, update, delete and search coding in VB.Net with access and sql? and way of connect and create access database using in vb.net?  |
| | 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 … |
| | In the code below I've to use Pre-built DatabaseManager which has limited exposed functions. Now I want to fetch resultset of query that gives country names. [CODE] DatabaseManager dbhandler = new DatabaseManager(); String query = "Select country_names from Country_Table;"; Vector vResult = dbHandler.getResult(query); //getResult returns Vector [/CODE] How can I … |
| | Hi I am using vb.net 2008 and sql server 2005 in that one form contains the richtextbox from that richtextbox i am saving the questions in database now i want to change each questions font and size. can anybody help me! |
| | i m unable to handle jquery accordian i want to bind it to ta database coz m showing lateset events, announcements in it i wanted that the user shuld be able to enter the values in a text box thru a admin panel which i shoud make for him n … |
| | Hi Please help with the following. This is my code: [CODE]<%@ Page Language="C#" Debug="true" %> <%@ Import Namespace="System" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Configuration" %> <%@ Import Namespace="System.Xml.Linq" %> <%@ Import Namespace="System.Data.SqlClient"%> <%@ Import Namespace="System.Data.OleDb"%> <html> <head> <title>Session Page 2</title> </head> <body><p>ASP.NET C# session page 2</p> <p>first name: … |
| | hi..is it possible to run SQL query periodically in vb.net? my system should update database B if there is an anamolly happen in database A i just wanna run UPDATE query periodically every 5-10 minutes plz help me |
| | Hi, I have am interesting problem that I cannot think of a solution for. I have an VB.NET application. This Application is permanently resident in memory and minimized to the tray area because we use it very often. The problem comes in when we VPN into a client's site. These … |
| | Hello! I run SQL queries from JAVA program (an example is shown below). My question is: Is it possible to run SQL query, if column names are defined in an array and the array size is not known apriori? Thanks! [CODE] public void setQuery(String query) { try { int rs … |
| | O.K. I've been agonizing over this for some time now, in this website i'm building, every registered user is gonna have some data that he can review add update delete. what would be the best way to store this data? in sql?, so that we have this one huge table … |
| | 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, I am trying to run sql command on unix. this results in the following error "sqlplus: not found" Here is the unix part [CODE] sqlplus id/pass@some_server.com<<eof select sysdate from dual; exit eof [/CODE] The database is on a remote server and. Do I need to enter all the tns … |
| | 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 … |
| | I am trying to write a c# app (windows app) that can import certain data from an excel document into a Sql database table. Can anyone please show me how to get this done? I have attached a screen shot of the sample excel doc am trying to upload...it contains … |
| | Can someone please help me get rid of this "Error loading" message at startup? It is followed by the opeing of my System 32 file. I am using Windows XP on a Sony VAIO. The following is my HijackThis log. Any help will be greatly appreciated. Thanks in advance: Logfile …  |
| | 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, The title of this thread perhaps does not explain my problem correctly. Actually i am developing a financial software for a company.The software is similar to a banking system. The software is being developed using VB 2008 and SQL Server 2008.The company has its branches located at different locations. …  |
| | Hi, I've been using tkinter to write a program that has a root window and many toplevel windows. I was able to create them successfully but my next step was to incorporate mysql with it so it would actually store any data that was entered in the various entry fields. …  |
 | 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 … |
| | am writing an sql statement that can change the username and password but it is not working this is the code on line 19 $sql = "UPDATE login SET username= newusername('$_POST['newusername']'),password=newpassword('$_POST['newpassword']) WHERE username = '$_POST['username']',password='$_POST['password']"; this is the error Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in … |
 | I've managed to put together some code to retrieve data from a sql file. I plan to connect to a sql server that are operated by a database program, that update the registry every 10 sec. Before I try to connect my program to the sql database, I need to … |
| | 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 …  |
| | hi.... in which version of sql server i can get the below two option... 1) performance tools 2)database tuning advisor.. please send me the download site... |
| | Hey. I'd like someone to point me in the right direction. Basically, my work website shows data from a MySQL db. If a new line of data is added in the DB, the user has no way of knowing that it has gone in until they have refreshed. Now, its …  |
| | Hey. I'd like someone to point me in the right direction. Basically, my work website shows data from a MySQL db. If a new line of data is added in the DB, the user has no way of knowing that it has gone in until they have refreshed. Now, its …  |
| | Hello... Can anyone help me...? I have the problem when installing SQl Server 2008 on Vista.. The message is : The performance counter registry hive is corrupted... please I need it Quickly... thanks...... |
| | 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 am new to mssql but C# programmer, can anyone help me on how to merge columns from different tables to a single table in sql for example i've 4 tables and the first table has a,b,c,d columns second table has e,f,g,h thrid table has i, j, k, … |
| | 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 … |
 | Hello all, I have msaccess that I use to insert data into a mysql database on a local in house server. Now what I would like to do is I have the below query [CODE] INSERT INTO User_logins ( GroupWiseID, ConnexLogin, [Password] ) SELECT NewHireIDs.[GW ID], NewHireIDs.[LIC ID], NewHireIDs.[ACD ID] … |
| | 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.