6,934 Topics
 | |
| | I am currently producing a system in which I want the user to be able to select the product name from a drop-down menu and when selected I would like the barcode to appear in the barcode field. I would really appreciate any help, however great or small. The current … |
| | I try to create a selection page, where different query are made, depending on selected checkboxes, and textboxes. It works for most the part but I a selection between zipcode ranges and year of birth range (between nbs_zip and nbs_zip2 and between nbs_contact_year and nbs_contact_year2). It works when I have … |
| | I do hope this is the right section (since VBA is so close to VB 6.0). Well here is my dilemma: I am trying to have Access return a customized report. The format I have been asked for it to be output as it the following: Machine type // where …  |
| | How to put parameters within dataadapter? Here's an example of non-parameter query.. [CODE]SqlDataAdapter da = new SqlDataAdapter ("SELECT * FROM Table WHERE column='"+textBox1.Text+"'",con);[/CODE]  |
| | Hey.. i'm making a java program with derby databse usin netbeans.. the problem is that when i crate table usin a sql query,netbeans automatically sort them by name..how can i let netbeans sort them by date of creation so i can switch between tables in order of creation??... thx for … |
| | Can some one please tell me the correct steps to connect a smart device to a sql desktop server which is in another PC in the network or can some one tell me a web site with the correct steps that i can reference we have a cable network(not wireless) … |
| | wat is the problem here [CODE]cmd1 = New OleDbCommand("Update tblParking SET status = 'Available' Where exp_date <='" & Date.Today & "'", cn)[/CODE] i want update the field status to "Available" when exp_date is less then todays date.. wat do i need to do. |
| | good morning guys I have a question that am hoping someone can answer for me I am using vs 2008, and have put the sql database into a program that is being built. the database fields all work fine...I am able to make entries, save it, close it out and … |
| | Hi there, I have a project created in C# visual studio 2008 standard edition and I am using a Microsoft SQl database file. I took my solution project in a filer and tried to run the application, going to the project folder and to the bin folder -> Debug folder … |
| | Can anyone tell me the upload script using mysql and php. Also can we insert images in mysql database? |
| | I'm using VS2005 & SQL Server 2005 which is installed with VS2005. Platform is XP SP2. I've an app that connects to the DB & get some data from it . The app & DB are on the same machine . Suddenly When I run the app. , I've that … |
| | how do i update, delete, add an sql database with c# |
| | I have the strangest problem. First let me state that I am by no means an expert on either Web Applications or SQL. I have however, been delegated this project and have made some progress. First, all the servers for a small office I work in were upgraded to 64 … |
| | Hello friends, Well i have two table one is used for user information while registeration and another table is only used for users profile image. In member list page i want to show users name , location and profile image. I m able to show a name and location but …  |
| | how to insert last id value from one table to another plzzz help me... thnx |
| | Hi everyone, I have a question and I would greatly appreciate any help with it. Here it goes: I have a SQL Server Database that I am trying to display data to a data grid with. However, I have a drop down box and three radio buttons that will allow …  |
| | To view this tutorial with notes at [URL="http://www.effectivewebdesign.co.nz/tutorial.php"]http://www.effectivewebdesign.co.nz/tutorial.php[/URL] yes I am aware this is more php than mysql. howerver I get asked how to do it so often I thought I'd post it here aswell :) |
| | I know, is a very basic question, but I am in the process of re-learning sql stored procedures, and this is what happended: I was practicing with some simple delete / insert routines, when encountered with this: if I ONLY insert records: 1. dog 2. cat 3. t-rex 4. llama … |
| | I have created an ASP.NET website using MS Visual Studio. It has a data source which is a database created using SQL Server.I have to generate high end(quality)reports using the data in this website. However i can only generate low quality reports using the built-in crystal reports template. So i … |
| | Im having a little bit of trouble with an update statement. if any one could take a look at it and help me with what im doing wrong that would be great. [code=c] private void button6_Click(object sender, EventArgs e) // Button6 is OK { ///////If Null///// if ((textBox1.Text.Length == 0) …  |
| | i'm attempting to use a select statement which retrieves products 'LIKE' textbox.text. However, i am given an error and cannot find a solution private void buttonSearch_Click(object sender, EventArgs e) { if (radioButtonCustomerID.Checked == true) { try { sqlConnectionNW.Open(); sqlDataAdapterSearch.SelectCommand = "SELECT * FROM Customers WHERE (CustomerID LIKE'" + textBoxSearch.Text + … |
| | I created a stored procedure in SQL which will accept parameters from a vb.net textbox. I want it to output the count of records. stored proc: [CODE] USE [Traffic] GO /****** Object: StoredProcedure [CENTRAL\TIMOVKP].[spReturnValue] Script Date: 08/02/2010 08:57:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [CENTRAL\TIMOVKP].[spReturnValue] … |
| | Could someone tell me how could setting up index would affect my select statement? I read that it boost performance especially for finding specific values, but how? |
| | Insert Image in sql 2005 and retrive it with simple code. i TRY many solution it is easyly inserted but fetch is not posible image isnot show and even the code is so difficult to understant i want simple code like 1,name 2,photo only that kind of code i like … |
| | I'm looking to write a program that should be capable of holding around 1000 records, each record will contain a varying number of fields and values. Usually, I'd create a list of dictionaries for something like this but wanted to know if that's the right way to go about it. … |
| | Hi. plz tell me how I can connect to an SQL server to an microcontroller or a PC using C language.... Plz reply soon.... |
| | Hi! i have problems one query. $day_result has a value of 1 and 4 $sql3 = "Select * from Venue where idVenue != $day_result"; echo $sql3; if i use for loop for the above it will give the result below Select * from Venue where idVenue != 1 Select * …  |
 | hi friends..I am very new C# so please dont mine if anything is wrong in my code. actually i am doing a very small project in c# i.e Employee Tracking System well i completed my project but when i use image i am getting exception called Argument exception.. Actually my … |
| | I am running a service that queries on regular intervals. I initially set it up so that the connection formed onStart, and closed onStop. This of course leaves a connection open all the time, which isn't what I want. So I moved the open and closed to inside my timer … |
| | Hi newbie here I’m currently making a hotel booking system in mysql/php, but I’m having problems with overlapping dates/double bookings. For example if a user attempted to book room1 from the 1st august to the 5th august, but the room is already booked on the 3rd and unavailable on the … |
| | Hi. I am new to this forum/community and need help to join multiple result sets in SQL. The last time I used SQL was in 2000. The goal is to provide one single data set result from multiple queries. I have included the code from two queries that I have … |
| | how can I transfer my SQl databese (located on PHPADMIN) to sql server? |
| | To access MySql tables from PHP, I use the PHP code and the function below. If I make these changes, would this code work for SQL Server 2008? mysql_fetch_array to mssql_fetch_array mysql_connect to mssql_connect mysql_select_db to mssql_select_db mysql_query to mssql_query PHP code -------------------------------------------------------------------------------- $sql = "SELECT mast_id FROM district_mast WHERE … |
 | [attach=right]14422[/attach]File under oops. The website of The Telegraph newspaper has been defaced by hackers, apparently upset at a cult British television show and the newspaper itself for mocking their country. The 'Romania National Security' hacking group has claimed responsibility for the attack which hit a couple of third party services … |
| | Hi. I am very new to VBA and the task in hand is a tough one to start with. Basically I have requirement of code I can run using Active X in DTS to load data that sits in excel files in a certain folder location into an sql server … |
| | |
| | Hi, i get the following error java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. this is my code [CODE] import java.sql.*; public class DetOrderNum{ public static void main(String[] args){ Connection con=null; ResultSet rs=null; Statement stmt=null; int pkey=0; String itemn="jin"; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:MY-PIZZA","",""); String q="select order_num from Order where …  |
| | Hey team, i'm having a problem with this query, [code] "SELECT * FROM marketingDB WHERE company_name LIKE 'allied' & '*'" [/code] the program ive written runs fine and it doesnt show any problem with the query infact the exact same query works fine on access but when i put it … |
| | NEED HELP~! Does anyone know how to import access data into sql server using vb.net? I want to create a openfiledialog and allow user to choose which access file to be imported into the server. Thank you so much~~ >.< PS. I am just a beginner of vb.net. So would …  |
| | HI this is my code.it uses access database.But givs me this error java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. import java.sql.*; public class DetOrderNum{ public static void main(String[] args){ Connection con=null; ResultSet rs=null; Statement stmt=null; int pkey=0; String mn="jin"; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:MY-PIZZA","",""); String q="select order_num from Order … |
| | I know this is probably a stupid post but I cannot think of how to accomplish this. How do you do the equivilent to an autonumber in a SQL Server table? Please let me know my project is very close to deadline Thanks in advance |
 | 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 … |
| | How to check whether two tables in SQL are the same using vb.net? Would u mind giving me the code? Thank you so much!!! |
| | I've been googling for a few days and have tried all kinds of connection strings, but none have worked so far. I have a webpage on one server (using ASP NOT ASP.NET) trying to connect to a SQL database on another server (SQL 2005 server). I tried connecting using .net … |
| | Hi guys i'm using ASP.net ans SQL server 2005 with stored procedure to do simple search from a table in database.Plz help me out The error i get Function or procedure expects @searchKey which was not supplied. protected void btnSearch_Click(object sender, EventArgs e) { string constring = ConfigurationManager.AppSettings.Get("con").ToString(); SqlConnection conn … |
| | I have alot of tables in database in one of this contains owner_id and another one have relation many to many with that,and that table have dissent_type how i can select dissent_type where owner_id = "" |
| | I have alot of tables in database in one of this contains owner_id and another one have relation many to many with that,and that table have dissent_type how i can select dissent_type where owner_id = ""  |
| | Hi all, lets say for example I have the following code [CODE]char *fname = "John"; char *lname = "Doe"; char *query = "SELECT fname, lname FROM table_name;"[/CODE] The last statement won't work, so my question is how to pass the fname and lname variables to the query? |
| | I am trying to create a C++ program that queries data from an ODBC data source. I am very comfortable with C++ and SQL, im just not sure how to set up an ODBC connection in C++. I have tried searching google and have not been very successful. Im using …  |
| | Hi, I have a table on MySQL server that contains several fields (id, ListingID, Scores),being utilised via a php page. The 'scores' column has the values stored as '1,2,3,4,5,6'. When a rating is added, people select their rating (out of ten) for a particular listing and this is then stored … |
The End.